DBA Data[Home] [Help]

APPS.PAY_NO_TAX_TABLE_UPLOAD dependencies on PAY_RANGE_API

Line 182: pay_range_api.delete_range(l_RANGE_ID,l_Ran_OBJECT_VERSION_NUMBER);

178: OPEN csr_RANGE_ID(l_RANGE_TABLE_ID);
179: LOOP
180: FETCH csr_RANGE_ID into l_RANGE_ID,l_Ran_OBJECT_VERSION_NUMBER;
181: EXIT WHEN csr_RANGE_ID%NOTFOUND;
182: pay_range_api.delete_range(l_RANGE_ID,l_Ran_OBJECT_VERSION_NUMBER);
183: END LOOP;
184: CLOSE csr_RANGE_ID;
185:
186: pay_range_table_api.delete_range_table(l_RANGE_TABLE_ID,l_Prf_OBJECT_VERSION_NUMBER);

Line 564: pay_range_api.create_range

560: if (l_max_range_id <> l_range_id) then
561:
562: -- Calculates the HIGH_BAND values by looking a record forward
563: select decode(low_band-1,-1,99999,low_band-1) into l_high_band from PAY_RANGE_TEMP where range_id=l_range_id+1;
564: pay_range_api.create_range
565: (
566: P_RANGE_TABLE_ID => l_pay_f_range_table_id
567: ,P_LOW_BAND => l_low_band
568: ,P_HIGH_BAND => l_high_band

Line 576: pay_range_api.create_range

572: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
573: ,P_RANGE_ID => l_dummy_range_table_id
574: );
575: else
576: pay_range_api.create_range
577: (
578: P_RANGE_TABLE_ID => l_pay_f_range_table_id
579: ,P_LOW_BAND => l_low_band
580: ,P_HIGH_BAND => 99999

Line 655: Pay_range_api.Update_range

651: LOOP
652: EXIT WHEN csr_child_end_date%NOTFOUND;
653: FETCH csr_child_end_date into l_Range_id,l_object_version_number;
654:
655: Pay_range_api.Update_range
656: (
657: P_RANGE_TABLE_ID => p_RANGE_TABLE_ID
658: ,P_EFFECTIVE_END_DATE => p_effective_start_date - 1
659: ,P_OBJECT_VERSION_NUMBER => l_object_version_number