DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;

35: g_entitlement_UDT_id pay_user_tables.user_table_id%TYPE;
36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
37:
38: -- Cache for PQP_GB_GET_ABSENCE_SSP
39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;
40: --g_ssp_correction_element_id pay_element_types_f.element_type_id%TYPE;
41: --g_max_ssp_period NUMBER(11,5);
42: --c_ssp_eit_context CONSTANT
43: -- pay_element_types_f.element_information_category%TYPE:=

Line 40: --g_ssp_correction_element_id pay_element_types_f.element_type_id%TYPE;

36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
37:
38: -- Cache for PQP_GB_GET_ABSENCE_SSP
39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;
40: --g_ssp_correction_element_id pay_element_types_f.element_type_id%TYPE;
41: --g_max_ssp_period NUMBER(11,5);
42: --c_ssp_eit_context CONSTANT
43: -- pay_element_types_f.element_information_category%TYPE:=
44: -- 'GB_SSP NON PAYMENT';

Line 43: -- pay_element_types_f.element_information_category%TYPE:=

39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;
40: --g_ssp_correction_element_id pay_element_types_f.element_type_id%TYPE;
41: --g_max_ssp_period NUMBER(11,5);
42: --c_ssp_eit_context CONSTANT
43: -- pay_element_types_f.element_information_category%TYPE:=
44: -- 'GB_SSP NON PAYMENT';
45: --
46: --g_pattern_id_for_bg hr_patterns.pattern_id%TYPE;
47: --g_input_value_ids_ele1 t_input_value_ids; -- IVs of ssp_element

Line 62: g_ssp_element_type_id pay_element_types_f.element_type_id%TYPE;

58:
59:
60: -- Cache for get_absence_ssp
61: g_ssp_business_group_id hr_all_organization_units.business_group_id%TYPE;
62: g_ssp_element_type_id pay_element_types_f.element_type_id%TYPE;
63: g_ssp_input_values t_input_value_ids;
64: g_ssp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
65: g_ssp_retro_input_values t_input_value_ids;
66: g_ssp_element_links t_element_links;

Line 64: g_ssp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;

60: -- Cache for get_absence_ssp
61: g_ssp_business_group_id hr_all_organization_units.business_group_id%TYPE;
62: g_ssp_element_type_id pay_element_types_f.element_type_id%TYPE;
63: g_ssp_input_values t_input_value_ids;
64: g_ssp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
65: g_ssp_retro_input_values t_input_value_ids;
66: g_ssp_element_links t_element_links;
67: g_ssp_retro_element_links t_element_links;
68:

Line 70: g_smp_element_type_id pay_element_types_f.element_type_id%TYPE;

66: g_ssp_element_links t_element_links;
67: g_ssp_retro_element_links t_element_links;
68:
69: -- Cache for get_absence_smp
70: g_smp_element_type_id pay_element_types_f.element_type_id%TYPE;
71: g_smp_input_values t_input_value_ids;
72: g_smp_element_links t_element_links;
73: g_smp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
74: g_smp_retro_input_values t_input_value_ids;

Line 73: g_smp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;

69: -- Cache for get_absence_smp
70: g_smp_element_type_id pay_element_types_f.element_type_id%TYPE;
71: g_smp_input_values t_input_value_ids;
72: g_smp_element_links t_element_links;
73: g_smp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
74: g_smp_retro_input_values t_input_value_ids;
75: g_smp_retro_element_links t_element_links;
76: g_smp_business_group_id hr_all_organization_units.business_group_id%TYPE;
77: g_absence_category VARCHAR2(30);

Line 208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE

204: g_entitlement_UDT_id := NULL;--pay_user_tables.user_table_id%TYPE
205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE
206:
207: -- Cache for PQP_GB_GET_ABSENCE_SSP
208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
209: --g_ssp_correction_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
210: --g_max_ssp_period := NULL;--NUMBER(11,5)
211: --c_ssp_eit_context CONSTANT -- Constants donot need to be NULLed
212: -- pay_element_types_f.element_information_category%TYPE:=

Line 209: --g_ssp_correction_element_id := NULL;--pay_element_types_f.element_type_id%TYPE

205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE
206:
207: -- Cache for PQP_GB_GET_ABSENCE_SSP
208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
209: --g_ssp_correction_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
210: --g_max_ssp_period := NULL;--NUMBER(11,5)
211: --c_ssp_eit_context CONSTANT -- Constants donot need to be NULLed
212: -- pay_element_types_f.element_information_category%TYPE:=
213: -- 'GB_SSP NON PAYMENT'

Line 212: -- pay_element_types_f.element_information_category%TYPE:=

208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
209: --g_ssp_correction_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
210: --g_max_ssp_period := NULL;--NUMBER(11,5)
211: --c_ssp_eit_context CONSTANT -- Constants donot need to be NULLed
212: -- pay_element_types_f.element_information_category%TYPE:=
213: -- 'GB_SSP NON PAYMENT'
214: --g_pattern_id_for_bg := NULL;--hr_patterns.pattern_id%TYPE
215: --g_input_value_ids_ele1.DELETE; --t_input_value_ids; -- IVs of ssp_element
216: --g_input_value_ids_ele2.DELETE; --t_input_value_ids; -- IVs of ssp_correction_element

Line 231: g_ssp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

227:
228: -- Cache for get_absence_ssp
229: g_ssp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;
230:
231: g_ssp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
232: g_ssp_input_values.DELETE; --t_input_value_ids;
233: g_ssp_element_links.DELETE; --t_element_links;
234:
235: g_ssp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

Line 235: g_ssp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

231: g_ssp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
232: g_ssp_input_values.DELETE; --t_input_value_ids;
233: g_ssp_element_links.DELETE; --t_element_links;
234:
235: g_ssp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
236: g_ssp_retro_input_values.DELETE; --t_input_value_ids;
237: g_ssp_retro_element_links.DELETE; --t_element_links;
238:
239: -- Cache for get_absence_smp

Line 242: g_smp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

238:
239: -- Cache for get_absence_smp
240: g_smp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;
241:
242: g_smp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
243: g_smp_input_values.DELETE; --t_input_value_ids;
244: g_smp_element_links.DELETE; --t_element_links;
245:
246: g_smp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

Line 246: g_smp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;

242: g_smp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
243: g_smp_input_values.DELETE; --t_input_value_ids;
244: g_smp_element_links.DELETE; --t_element_links;
245:
246: g_smp_retro_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
247: g_smp_retro_input_values.DELETE; --t_input_value_ids;
248: g_smp_retro_element_links.DELETE; --t_element_links;
249: g_absence_category :=NULL;
250: END clear_cache;

Line 886: -- l_element_type_id pay_element_types_f.element_type_id%TYPE ;

882: ,p_error_msg OUT NOCOPY VARCHAR2
883: )
884: RETURN NUMBER
885: IS
886: -- l_element_type_id pay_element_types_f.element_type_id%TYPE ;
887: l_retval NUMBER;
888: l_proc_step NUMBER(38,10):=0;
889: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
890: l_proc_name VARCHAR2(61):=

Line 889: l_element_type_id pay_element_types_f.element_type_id%TYPE ;

885: IS
886: -- l_element_type_id pay_element_types_f.element_type_id%TYPE ;
887: l_retval NUMBER;
888: l_proc_step NUMBER(38,10):=0;
889: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
890: l_proc_name VARCHAR2(61):=
891: g_package_name||'pqp_get_plan_extra_info';
892: BEGIN
893: IF g_debug THEN

Line 8734: pay_element_types_f.element_name%TYPE:='Statutory Sick Pay';

8730: )
8731: IS
8732:
8733: c_ssp_element_name CONSTANT
8734: pay_element_types_f.element_name%TYPE:='Statutory Sick Pay';
8735: l_ssp_element_type_id g_ssp_element_type_id%TYPE;
8736: l_ssp_input_values g_ssp_input_values%TYPE;
8737: l_ssp_element_links g_ssp_element_links%TYPE;
8738:

Line 8740: pay_element_types_f.element_name%TYPE:='SSP Corrections';

8736: l_ssp_input_values g_ssp_input_values%TYPE;
8737: l_ssp_element_links g_ssp_element_links%TYPE;
8738:
8739: c_ssp_retro_element_name CONSTANT
8740: pay_element_types_f.element_name%TYPE:='SSP Corrections';
8741: l_ssp_retro_element_type_id g_ssp_retro_element_type_id%TYPE;
8742: l_ssp_retro_input_values g_ssp_retro_input_values%TYPE;
8743: l_ssp_retro_element_links g_ssp_retro_element_links%TYPE;
8744:

Line 9543: pay_element_types_f.element_name%TYPE:='Statutory Maternity Pay';

9539: l_absence csr_absence_details%ROWTYPE;
9540: l_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
9541:
9542: c_smp_element_name CONSTANT
9543: pay_element_types_f.element_name%TYPE:='Statutory Maternity Pay';
9544: c_sap_element_name CONSTANT
9545: pay_element_types_f.element_name%TYPE:='Statutory Adoption Pay';
9546: c_spa_element_name CONSTANT
9547: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Adoption';

Line 9545: pay_element_types_f.element_name%TYPE:='Statutory Adoption Pay';

9541:
9542: c_smp_element_name CONSTANT
9543: pay_element_types_f.element_name%TYPE:='Statutory Maternity Pay';
9544: c_sap_element_name CONSTANT
9545: pay_element_types_f.element_name%TYPE:='Statutory Adoption Pay';
9546: c_spa_element_name CONSTANT
9547: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Adoption';
9548: c_spb_element_name CONSTANT
9549: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Birth';

Line 9547: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Adoption';

9543: pay_element_types_f.element_name%TYPE:='Statutory Maternity Pay';
9544: c_sap_element_name CONSTANT
9545: pay_element_types_f.element_name%TYPE:='Statutory Adoption Pay';
9546: c_spa_element_name CONSTANT
9547: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Adoption';
9548: c_spb_element_name CONSTANT
9549: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Birth';
9550:
9551: c_aspa_element_name CONSTANT

Line 9549: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Birth';

9545: pay_element_types_f.element_name%TYPE:='Statutory Adoption Pay';
9546: c_spa_element_name CONSTANT
9547: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Adoption';
9548: c_spb_element_name CONSTANT
9549: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Birth';
9550:
9551: c_aspa_element_name CONSTANT
9552: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Adoption';
9553: c_aspb_element_name CONSTANT

Line 9552: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Adoption';

9548: c_spb_element_name CONSTANT
9549: pay_element_types_f.element_name%TYPE:='Statutory Paternity Pay Birth';
9550:
9551: c_aspa_element_name CONSTANT
9552: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Adoption';
9553: c_aspb_element_name CONSTANT
9554: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Birth';
9555:
9556:

Line 9554: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Birth';

9550:
9551: c_aspa_element_name CONSTANT
9552: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Adoption';
9553: c_aspb_element_name CONSTANT
9554: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Birth';
9555:
9556:
9557: l_statutory_element_name pay_element_types_f.element_name%TYPE ;
9558: l_smp_element_type_id g_smp_element_type_id%TYPE;

Line 9557: l_statutory_element_name pay_element_types_f.element_name%TYPE ;

9553: c_aspb_element_name CONSTANT
9554: pay_element_types_f.element_name%TYPE:='Additional Statutory Paternity Pay Birth';
9555:
9556:
9557: l_statutory_element_name pay_element_types_f.element_name%TYPE ;
9558: l_smp_element_type_id g_smp_element_type_id%TYPE;
9559: l_smp_input_values g_smp_input_values%TYPE;
9560: l_smp_element_links g_smp_element_links%TYPE;
9561:

Line 9563: pay_element_types_f.element_name%TYPE:='SMP Corrections';

9559: l_smp_input_values g_smp_input_values%TYPE;
9560: l_smp_element_links g_smp_element_links%TYPE;
9561:
9562: c_smp_retro_element_name CONSTANT
9563: pay_element_types_f.element_name%TYPE:='SMP Corrections';
9564: c_sap_retro_element_name CONSTANT
9565: pay_element_types_f.element_name%TYPE:='SAP Corrections';
9566: c_spa_retro_element_name CONSTANT
9567: pay_element_types_f.element_name%TYPE:='SPP Adoption Corrections';

Line 9565: pay_element_types_f.element_name%TYPE:='SAP Corrections';

9561:
9562: c_smp_retro_element_name CONSTANT
9563: pay_element_types_f.element_name%TYPE:='SMP Corrections';
9564: c_sap_retro_element_name CONSTANT
9565: pay_element_types_f.element_name%TYPE:='SAP Corrections';
9566: c_spa_retro_element_name CONSTANT
9567: pay_element_types_f.element_name%TYPE:='SPP Adoption Corrections';
9568: c_spb_retro_element_name CONSTANT
9569: pay_element_types_f.element_name%TYPE:='SPP Birth Corrections';

Line 9567: pay_element_types_f.element_name%TYPE:='SPP Adoption Corrections';

9563: pay_element_types_f.element_name%TYPE:='SMP Corrections';
9564: c_sap_retro_element_name CONSTANT
9565: pay_element_types_f.element_name%TYPE:='SAP Corrections';
9566: c_spa_retro_element_name CONSTANT
9567: pay_element_types_f.element_name%TYPE:='SPP Adoption Corrections';
9568: c_spb_retro_element_name CONSTANT
9569: pay_element_types_f.element_name%TYPE:='SPP Birth Corrections';
9570:
9571: c_aspa_retro_element_name CONSTANT

Line 9569: pay_element_types_f.element_name%TYPE:='SPP Birth Corrections';

9565: pay_element_types_f.element_name%TYPE:='SAP Corrections';
9566: c_spa_retro_element_name CONSTANT
9567: pay_element_types_f.element_name%TYPE:='SPP Adoption Corrections';
9568: c_spb_retro_element_name CONSTANT
9569: pay_element_types_f.element_name%TYPE:='SPP Birth Corrections';
9570:
9571: c_aspa_retro_element_name CONSTANT
9572: pay_element_types_f.element_name%TYPE:='ASPP Adoption Corrections';
9573: c_aspb_retro_element_name CONSTANT

Line 9572: pay_element_types_f.element_name%TYPE:='ASPP Adoption Corrections';

9568: c_spb_retro_element_name CONSTANT
9569: pay_element_types_f.element_name%TYPE:='SPP Birth Corrections';
9570:
9571: c_aspa_retro_element_name CONSTANT
9572: pay_element_types_f.element_name%TYPE:='ASPP Adoption Corrections';
9573: c_aspb_retro_element_name CONSTANT
9574: pay_element_types_f.element_name%TYPE:='ASPP Birth Corrections';
9575:
9576: l_statutory_retro_element_name pay_element_types_f.element_name%TYPE ;

Line 9574: pay_element_types_f.element_name%TYPE:='ASPP Birth Corrections';

9570:
9571: c_aspa_retro_element_name CONSTANT
9572: pay_element_types_f.element_name%TYPE:='ASPP Adoption Corrections';
9573: c_aspb_retro_element_name CONSTANT
9574: pay_element_types_f.element_name%TYPE:='ASPP Birth Corrections';
9575:
9576: l_statutory_retro_element_name pay_element_types_f.element_name%TYPE ;
9577: l_smp_retro_element_type_id g_smp_retro_element_type_id%TYPE;
9578: l_smp_retro_input_values g_smp_retro_input_values%TYPE;

Line 9576: l_statutory_retro_element_name pay_element_types_f.element_name%TYPE ;

9572: pay_element_types_f.element_name%TYPE:='ASPP Adoption Corrections';
9573: c_aspb_retro_element_name CONSTANT
9574: pay_element_types_f.element_name%TYPE:='ASPP Birth Corrections';
9575:
9576: l_statutory_retro_element_name pay_element_types_f.element_name%TYPE ;
9577: l_smp_retro_element_type_id g_smp_retro_element_type_id%TYPE;
9578: l_smp_retro_input_values g_smp_retro_input_values%TYPE;
9579: l_smp_retro_element_links g_smp_retro_element_links%TYPE;
9580: