DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PQP_UTILITIES

Line 244: l_config_values PQP_UTILITIES.t_config_values;

240: FUNCTION get_hours_worked(
241: p_assignment_id NUMBER)
242: RETURN VARCHAR2
243: IS
244: l_config_values PQP_UTILITIES.t_config_values;
245: g_bon_bal_type_id NUMBER;
246: l_source_name VARCHAR2(100);
247: l_context_name VARCHAR2(100);
248: l_column_name VARCHAR2(100);

Line 331: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_HOURS_WORKED' ,

327: -- Configuration values
328: if l_hours_worked is null then
329: hr_utility.trace('in config ');
330: -- Use below API to get the config values for the given context in the business group
331: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_HOURS_WORKED' ,
332: p_business_group_id => g_business_group_id ,
333: p_legislation_code => g_legislation_code ,
334: p_tab_config_values => l_config_values );
335:

Line 504: l_config_values PQP_UTILITIES.t_config_values;

500: FUNCTION get_periods_covered(
501: p_assignment_id NUMBER)
502: RETURN VARCHAR2
503: IS
504: l_config_values PQP_UTILITIES.t_config_values;
505: g_bon_bal_type_id NUMBER;
506: l_source_name VARCHAR2(100);
507: l_context_name VARCHAR2(100);
508: l_column_name VARCHAR2(100);

Line 551: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PERIODS_COVERED' ,

547: if l_periods_covered is null then
548: hr_utility.trace('in config ');
549:
550: -- Use below API to get the config values for the given context in the business group
551: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PERIODS_COVERED' ,
552: p_business_group_id => g_business_group_id ,
553: p_legislation_code => g_legislation_code ,
554: p_tab_config_values => l_config_values );
555:

Line 658: l_config_values PQP_UTILITIES.t_config_values;

654: FUNCTION get_irregular_payment(
655: p_assignment_id NUMBER)
656: RETURN VARCHAR2
657: IS
658: l_config_values PQP_UTILITIES.t_config_values;
659: g_bon_bal_type_id NUMBER;
660: l_source_name VARCHAR2(100);
661: l_context_name VARCHAR2(100);
662: l_column_name VARCHAR2(100);

Line 705: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_IRREGULAR_PAYMENT' ,

701: if l_irregular_payment is null then
702: hr_utility.trace('in config ');
703:
704: -- Use below API to get the config values for the given context in the business group
705: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_IRREGULAR_PAYMENT' ,
706: p_business_group_id => g_business_group_id ,
707: p_legislation_code => g_legislation_code ,
708: p_tab_config_values => l_config_values );
709:

Line 814: l_config_values PQP_UTILITIES.t_config_values;

810: FUNCTION get_oneoff_payment(
811: p_assignment_id NUMBER)
812: RETURN VARCHAR2
813: IS
814: l_config_values PQP_UTILITIES.t_config_values;
815: g_bon_bal_type_id NUMBER;
816: l_source_name VARCHAR2(100);
817: l_context_name VARCHAR2(100);
818: l_column_name VARCHAR2(100);

Line 861: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONEOFF_PAYMENT' ,

857: if l_oneoff_payment is null then
858: hr_utility.trace('in config ');
859:
860: -- Use below API to get the config values for the given context in the business group
861: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONEOFF_PAYMENT' ,
862: p_business_group_id => g_business_group_id ,
863: p_legislation_code => g_legislation_code ,
864: p_tab_config_values => l_config_values );
865:

Line 967: l_config_values PQP_UTILITIES.t_config_values;

963: FUNCTION get_payment_non_indiv(
964: p_assignment_id NUMBER)
965: RETURN VARCHAR2
966: IS
967: l_config_values PQP_UTILITIES.t_config_values;
968: g_bon_bal_type_id NUMBER;
969: l_source_name VARCHAR2(100);
970: l_context_name VARCHAR2(100);
971: l_column_name VARCHAR2(100);

Line 1003: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PAY_NON_INDIV_IND' ,

999: if l_pay_non_indiv_ind is null then
1000: hr_utility.trace('in config ');
1001:
1002: -- Use below API to get the config values for the given context in the business group
1003: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PAY_NON_INDIV_IND' ,
1004: p_business_group_id => g_business_group_id ,
1005: p_legislation_code => g_legislation_code ,
1006: p_tab_config_values => l_config_values );
1007:

Line 1109: l_config_values PQP_UTILITIES.t_config_values;

1105: FUNCTION get_onstrike_indicator(
1106: p_assignment_id NUMBER)
1107: RETURN VARCHAR2
1108: IS
1109: l_config_values PQP_UTILITIES.t_config_values;
1110: g_bon_bal_type_id NUMBER;
1111: l_source_name VARCHAR2(100);
1112: l_context_name VARCHAR2(100);
1113: l_column_name VARCHAR2(100);

Line 1145: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONSTRIKE_INDICATOR' ,

1141: if l_onstrike_ind is null then
1142: hr_utility.trace('in config ');
1143:
1144: -- Use below API to get the config values for the given context in the business group
1145: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONSTRIKE_INDICATOR' ,
1146: p_business_group_id => g_business_group_id ,
1147: p_legislation_code => g_legislation_code ,
1148: p_tab_config_values => l_config_values );
1149:

Line 1251: l_config_values PQP_UTILITIES.t_config_values;

1247: FUNCTION get_unpaid_absence(
1248: p_assignment_id NUMBER)
1249: RETURN VARCHAR2
1250: IS
1251: l_config_values PQP_UTILITIES.t_config_values;
1252: g_bon_bal_type_id NUMBER;
1253: l_source_name VARCHAR2(100);
1254: l_context_name VARCHAR2(100);
1255: l_column_name VARCHAR2(100);

Line 1286: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONSTRIKE_INDICATOR' ,

1282: if l_unpaid_absence_ind is null then
1283: hr_utility.trace('in config ');
1284:
1285: -- Use below API to get the config values for the given context in the business group
1286: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_ONSTRIKE_INDICATOR' ,
1287: p_business_group_id => g_business_group_id ,
1288: p_legislation_code => g_legislation_code ,
1289: p_tab_config_values => l_config_values );
1290:

Line 1391: l_config_values PQP_UTILITIES.t_config_values;

1387: FUNCTION get_passport_number(
1388: p_person_id VARCHAR2)
1389: RETURN VARCHAR2
1390: IS
1391: l_config_values PQP_UTILITIES.t_config_values;
1392: g_bon_bal_type_id NUMBER;
1393: l_source_name VARCHAR2(100);
1394: l_context_name VARCHAR2(100);
1395: l_column_name VARCHAR2(100);

Line 1440: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PASSPORT_NO' ,

1436: close csr_per_start_date;
1437:
1438: hr_utility.trace('l_effective_date in get_oneoff_payment : ' || l_effective_date);
1439: -- Use below API to get the config values for the given context in the business group
1440: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PASSPORT_NO' ,
1441: p_business_group_id => g_business_group_id ,
1442: p_legislation_code => g_legislation_code ,
1443: p_tab_config_values => l_config_values );
1444: