Program scope

The EXECUTE_HIERARCHY_PREPARE program determines the scope as follows:

• If the HIERARCHY_ID and TABLE_NAME or HIERARCHY_NAME and TABLE_NAME parameters are specified, hierarchy links are prepared with matching hierarchy and table values for records with the Active status in SZ_HIERARCHY_TABLE.
• If the HIERARCHY_ID or HIERARCHY_NAME parameter is specified and the TABLE_NAME parameter is not specified, hierarchy links are prepared with matching hierarchy value for records with the Active status in SZ_HIERARCHY_TABLE.
• If the TABLE_NAME parameter is specified and the HIERARCHY_ID and HIERARCHY_TABLE parameters are not specified, hierarchy links are prepared with matching table values for records with the Active status in SZ_HIERARCHY_TABLE.
• If the HIERARCHY_ID, HIERARCHY_NAME, or TABLE_NAME parameters are not specified, hierarchy links are prepared for all hierarchy table links with the Active status in SZ_HIERARCHY_TABLE and each hierarchy with the Active status in SZ_HIERARCHY.
  Note: If the Source parameter is specified, the SOURCE filter is applied to the table. Else, all the records are processed.
• If the Profile Table Name field is specified for the base level of a hierarchy, a hierarchy-table link must exist between the current hierarchy and specified profile table. If the SZ_HIERARCHY_LEVEL.profile_table_name field is populated for a base level and there are no Active hierarchy-table records in the SZ_HIERARCHY_TABLE for the current hierarchy and the specified profile table; the warning message is logged, and the program continues with the next hierarchy table link in scope.

The program validates all the hierarchy table links in scope. Else an error message is displayed.