APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_EVENT_GROUP_USAGES

Line 1084: -- This procedure uploads a single row into pay_event_group_usages

1080: -- |------------------------------< load_egu_row >----------------------------|
1081: -- ----------------------------------------------------------------------------
1082: --
1083: -- Description:
1084: -- This procedure uploads a single row into pay_event_group_usages
1085: -- table if the row being uploaded is not already present in the table.
1086: --
1087: -- ----------------------------------------------------------------------------
1088: PROCEDURE load_egu_row

Line 1103: l_business_group_id pay_event_group_usages.business_group_id%type;

1099: l_proc varchar2(72) := g_package||'load_egu_row';
1100: l_exists varchar2 (1);
1101: l_event_group_id pay_event_groups.event_group_id%type;
1102: l_element_set_id pay_element_sets.element_set_id%type;
1103: l_business_group_id pay_event_group_usages.business_group_id%type;
1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;
1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;

Line 1104: l_legislation_code pay_event_group_usages.legislation_code%type;

1100: l_exists varchar2 (1);
1101: l_event_group_id pay_event_groups.event_group_id%type;
1102: l_element_set_id pay_element_sets.element_set_id%type;
1103: l_business_group_id pay_event_group_usages.business_group_id%type;
1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;
1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;
1108: l_ovn pay_event_group_usages.object_version_number%type;

Line 1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;

1103: l_business_group_id pay_event_group_usages.business_group_id%type;
1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;
1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;
1108: l_ovn pay_event_group_usages.object_version_number%type;
1109: --
1110: cursor csr_exists is
1111: select null

Line 1108: l_ovn pay_event_group_usages.object_version_number%type;

1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;
1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;
1108: l_ovn pay_event_group_usages.object_version_number%type;
1109: --
1110: cursor csr_exists is
1111: select null
1112: from pay_event_group_usages egu

Line 1112: from pay_event_group_usages egu

1108: l_ovn pay_event_group_usages.object_version_number%type;
1109: --
1110: cursor csr_exists is
1111: select null
1112: from pay_event_group_usages egu
1113: where egu.event_group_id = l_event_group_id
1114: and egu.element_set_id = l_element_set_id
1115: and ( l_business_group_id is null
1116: or ( l_business_group_id is not null and l_business_group_id = egu.business_group_id )