eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_IN_ETW_STRUCT

Line 25: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec

21: -- OUT : p_template_id NUMBER --
22: -- RETURN : N/A --
23: --------------------------------------------------------------------------
24: FUNCTION get_exclusion_rule_id
25: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec
26: ,p_exclusion_tag IN VARCHAR2
27: )
28: RETURN NUMBER
29: IS

Line 81: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec

77: -- OUT : p_template_id NUMBER --
78: -- RETURN : N/A --
79: --------------------------------------------------------------------------
80: FUNCTION get_iv_id
81: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec
82: ,p_input_value IN VARCHAR2
83: )
84: RETURN NUMBER
85: IS

Line 131: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec

127: -- OUT : p_template_id NUMBER --
128: -- RETURN : N/A --
129: --------------------------------------------------------------------------
130: FUNCTION get_aet_id
131: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec
132: ,p_element_name IN VARCHAR2
133: )
134: RETURN NUMBER
135: IS

Line 181: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec

177: -- OUT : p_template_id NUMBER --
178: -- RETURN : N/A --
179: --------------------------------------------------------------------------
180: FUNCTION get_aiv_id
181: (p_template_rec IN pay_in_etw_struct.t_template_setup_rec
182: ,p_element_id IN NUMBER
183: ,p_input_value IN VARCHAR2
184: )
185: RETURN NUMBER

Line 249: FOR i IN 1..pay_in_etw_struct.g_formula_obj.COUNT

245:
246: BEGIN
247: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
248:
249: FOR i IN 1..pay_in_etw_struct.g_formula_obj.COUNT
250: LOOP
251:
252: IF pay_in_etw_struct.g_formula_obj(i).NAME = p_formula_name
253: THEN

Line 252: IF pay_in_etw_struct.g_formula_obj(i).NAME = p_formula_name

248:
249: FOR i IN 1..pay_in_etw_struct.g_formula_obj.COUNT
250: LOOP
251:
252: IF pay_in_etw_struct.g_formula_obj(i).NAME = p_formula_name
253: THEN
254: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,20);
255:
256: RETURN pay_in_etw_struct.g_formula_obj(i).text;

Line 256: RETURN pay_in_etw_struct.g_formula_obj(i).text;

252: IF pay_in_etw_struct.g_formula_obj(i).NAME = p_formula_name
253: THEN
254: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,20);
255:
256: RETURN pay_in_etw_struct.g_formula_obj(i).text;
257: END IF;
258:
259: END LOOP;
260: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,30);

Line 411: ,p_template_rec OUT NOCOPY pay_in_etw_struct.t_template_setup_rec

407: -- RETURN : N/A --
408: --------------------------------------------------------------------------
409: PROCEDURE get_template
410: (p_template_name IN VARCHAR2
411: ,p_template_rec OUT NOCOPY pay_in_etw_struct.t_template_setup_rec
412: )
413: IS
414: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_template';
415: l_message VARCHAR2(1000);

Line 420: FOR i IN 1..pay_in_etw_struct.g_template_obj.COUNT

416:
417: BEGIN
418: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
419:
420: FOR i IN 1..pay_in_etw_struct.g_template_obj.COUNT
421: LOOP
422:
423: IF pay_in_etw_struct.g_template_obj(i).template_name = p_template_name THEN
424:

Line 423: IF pay_in_etw_struct.g_template_obj(i).template_name = p_template_name THEN

419:
420: FOR i IN 1..pay_in_etw_struct.g_template_obj.COUNT
421: LOOP
422:
423: IF pay_in_etw_struct.g_template_obj(i).template_name = p_template_name THEN
424:
425: pay_in_utils.set_location(g_debug,l_procedure,20);
426:
427: p_template_rec := pay_in_etw_struct.g_template_obj(i);

Line 427: p_template_rec := pay_in_etw_struct.g_template_obj(i);

423: IF pay_in_etw_struct.g_template_obj(i).template_name = p_template_name THEN
424:
425: pay_in_utils.set_location(g_debug,l_procedure,20);
426:
427: p_template_rec := pay_in_etw_struct.g_template_obj(i);
428:
429: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
430:
431: RETURN ;

Line 478: l_template_rec pay_in_etw_struct.t_template_setup_rec;

474: l_template_exists VARCHAR2(1);
475: l_template_id pay_element_templates.template_id%TYPE;
476: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
477: l_object_version_number NUMBER ;
478: l_template_rec pay_in_etw_struct.t_template_setup_rec;
479: l_sequence NUMBER;
480: l_db_items_flag VARCHAR2(1);
481: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%TYPE ;
482: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 499: WHERE template_type = pay_in_etw_struct.g_template_type

495: BEGIN
496: SELECT 'Y', template_id
497: INTO l_template_exists, l_template_id
498: FROM pay_element_templates
499: WHERE template_type = pay_in_etw_struct.g_template_type
500: AND legislation_code = pay_in_etw_struct.g_legislation_code
501: AND template_name = p_template_name;
502: EXCEPTION
503: WHEN OTHERS THEN

Line 500: AND legislation_code = pay_in_etw_struct.g_legislation_code

496: SELECT 'Y', template_id
497: INTO l_template_exists, l_template_id
498: FROM pay_element_templates
499: WHERE template_type = pay_in_etw_struct.g_template_type
500: AND legislation_code = pay_in_etw_struct.g_legislation_code
501: AND template_name = p_template_name;
502: EXCEPTION
503: WHEN OTHERS THEN
504: NULL;

Line 539: WHERE currency_code = pay_in_etw_struct.g_currency_code;

535:
536: SELECT enabled_flag
537: INTO l_enabled_flag
538: FROM fnd_currencies
539: WHERE currency_code = pay_in_etw_struct.g_currency_code;
540:
541: UPDATE fnd_currencies
542: SET enabled_flag = 'Y'
543: WHERE currency_code = pay_in_etw_struct.g_currency_code

Line 543: WHERE currency_code = pay_in_etw_struct.g_currency_code

539: WHERE currency_code = pay_in_etw_struct.g_currency_code;
540:
541: UPDATE fnd_currencies
542: SET enabled_flag = 'Y'
543: WHERE currency_code = pay_in_etw_struct.g_currency_code
544: AND enabled_flag <> 'Y';
545:
546: pay_in_utils.set_location(g_debug,l_procedure,40);
547:

Line 548: pay_in_etw_struct.init_code;

544: AND enabled_flag <> 'Y';
545:
546: pay_in_utils.set_location(g_debug,l_procedure,40);
547:
548: pay_in_etw_struct.init_code;
549: pay_in_etw_struct.init_formula;
550:
551: pay_in_utils.set_location(g_debug,l_procedure,50);
552:

Line 549: pay_in_etw_struct.init_formula;

545:
546: pay_in_utils.set_location(g_debug,l_procedure,40);
547:
548: pay_in_etw_struct.init_code;
549: pay_in_etw_struct.init_formula;
550:
551: pay_in_utils.set_location(g_debug,l_procedure,50);
552:
553: get_template

Line 571: ,p_template_type => pay_in_etw_struct.g_template_type

567: pay_in_utils.set_location(g_debug,l_procedure,60);
568: pay_etm_ins.ins
569: (p_template_id => l_template_rec.template_id
570: ,p_effective_date => l_effective_date
571: ,p_template_type => pay_in_etw_struct.g_template_type
572: ,p_template_name => l_template_rec.template_name
573: ,p_base_processing_priority => l_template_rec.priority
574: ,p_max_base_name_length => pay_in_etw_struct.g_max_length
575: ,p_version_number => 1

Line 574: ,p_max_base_name_length => pay_in_etw_struct.g_max_length

570: ,p_effective_date => l_effective_date
571: ,p_template_type => pay_in_etw_struct.g_template_type
572: ,p_template_name => l_template_rec.template_name
573: ,p_base_processing_priority => l_template_rec.priority
574: ,p_max_base_name_length => pay_in_etw_struct.g_max_length
575: ,p_version_number => 1
576: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
577: ,p_object_version_number => l_object_version_number
578: );

Line 576: ,p_legislation_code => pay_in_etw_struct.g_legislation_code

572: ,p_template_name => l_template_rec.template_name
573: ,p_base_processing_priority => l_template_rec.priority
574: ,p_max_base_name_length => pay_in_etw_struct.g_max_length
575: ,p_version_number => 1
576: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
577: ,p_object_version_number => l_object_version_number
578: );
579:
580: --

Line 606: WHERE template_type = pay_in_etw_struct.g_template_type

602:
603: SELECT formula_id, object_version_number
604: INTO l_template_rec.uf_setup.formula_id, l_object_version_number
605: FROM pay_shadow_formulas
606: WHERE template_type = pay_in_etw_struct.g_template_type
607: AND legislation_code= pay_in_etw_struct.g_legislation_code
608: AND formula_name = l_template_rec.uf_setup.formula_name;
609:
610: pay_sf_upd.upd

Line 607: AND legislation_code= pay_in_etw_struct.g_legislation_code

603: SELECT formula_id, object_version_number
604: INTO l_template_rec.uf_setup.formula_id, l_object_version_number
605: FROM pay_shadow_formulas
606: WHERE template_type = pay_in_etw_struct.g_template_type
607: AND legislation_code= pay_in_etw_struct.g_legislation_code
608: AND formula_name = l_template_rec.uf_setup.formula_name;
609:
610: pay_sf_upd.upd
611: (p_formula_id => l_template_rec.uf_setup.formula_id

Line 623: ,p_template_type => pay_in_etw_struct.g_template_type

619: WHEN NO_DATA_FOUND THEN
620: pay_in_utils.set_location(g_debug,l_procedure,90);
621: pay_sf_ins.ins
622: (p_formula_id => l_template_rec.uf_setup.formula_id
623: ,p_template_type => pay_in_etw_struct.g_template_type
624: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
625: ,p_formula_name => l_template_rec.uf_setup.formula_name
626: ,p_description => l_template_rec.uf_setup.description
627: ,p_formula_text => get_text(l_template_rec.uf_setup.formula_name)

Line 624: ,p_legislation_code => pay_in_etw_struct.g_legislation_code

620: pay_in_utils.set_location(g_debug,l_procedure,90);
621: pay_sf_ins.ins
622: (p_formula_id => l_template_rec.uf_setup.formula_id
623: ,p_template_type => pay_in_etw_struct.g_template_type
624: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
625: ,p_formula_name => l_template_rec.uf_setup.formula_name
626: ,p_description => l_template_rec.uf_setup.description
627: ,p_formula_text => get_text(l_template_rec.uf_setup.formula_name)
628: ,p_object_version_number => l_object_version_number

Line 649: ,p_input_currency_code => pay_in_etw_struct.g_currency_code

645: ,p_reporting_name => null
646: ,p_relative_processing_priority => 0
647: ,p_processing_type => 'R'
648: ,p_classification_name => l_template_rec.category
649: ,p_input_currency_code => pay_in_etw_struct.g_currency_code
650: ,p_output_currency_code => pay_in_etw_struct.g_currency_code
651: ,p_multiple_entries_allowed_fla => 'N'
652: ,p_post_termination_rule => 'F'
653: ,p_process_in_run_flag => 'Y'

Line 650: ,p_output_currency_code => pay_in_etw_struct.g_currency_code

646: ,p_relative_processing_priority => 0
647: ,p_processing_type => 'R'
648: ,p_classification_name => l_template_rec.category
649: ,p_input_currency_code => pay_in_etw_struct.g_currency_code
650: ,p_output_currency_code => pay_in_etw_struct.g_currency_code
651: ,p_multiple_entries_allowed_fla => 'N'
652: ,p_post_termination_rule => 'F'
653: ,p_process_in_run_flag => 'Y'
654: ,p_additional_entry_allowed_fla => 'N'

Line 753: WHERE template_type = pay_in_etw_struct.g_template_type

749:
750: SELECT formula_id, object_version_number
751: INTO l_template_rec.ae_setup(i).uf_setup.formula_id, l_object_version_number
752: FROM pay_shadow_formulas
753: WHERE template_type = pay_in_etw_struct.g_template_type
754: AND legislation_code= pay_in_etw_struct.g_legislation_code
755: AND formula_name = l_template_rec.ae_setup(i).uf_setup.formula_name;
756:
757: pay_in_utils.set_location(g_debug,l_procedure,150);

Line 754: AND legislation_code= pay_in_etw_struct.g_legislation_code

750: SELECT formula_id, object_version_number
751: INTO l_template_rec.ae_setup(i).uf_setup.formula_id, l_object_version_number
752: FROM pay_shadow_formulas
753: WHERE template_type = pay_in_etw_struct.g_template_type
754: AND legislation_code= pay_in_etw_struct.g_legislation_code
755: AND formula_name = l_template_rec.ae_setup(i).uf_setup.formula_name;
756:
757: pay_in_utils.set_location(g_debug,l_procedure,150);
758:

Line 773: ,p_template_type => pay_in_etw_struct.g_template_type

769: pay_in_utils.set_location(g_debug,l_procedure,160);
770:
771: pay_sf_ins.ins
772: (p_formula_id => l_template_rec.ae_setup(i).uf_setup.formula_id
773: ,p_template_type => pay_in_etw_struct.g_template_type
774: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
775: ,p_formula_name => l_template_rec.ae_setup(i).uf_setup.formula_name
776: ,p_description => l_template_rec.ae_setup(i).uf_setup.description
777: ,p_formula_text => get_text(l_template_rec.ae_setup(i).uf_setup.formula_name)

Line 774: ,p_legislation_code => pay_in_etw_struct.g_legislation_code

770:
771: pay_sf_ins.ins
772: (p_formula_id => l_template_rec.ae_setup(i).uf_setup.formula_id
773: ,p_template_type => pay_in_etw_struct.g_template_type
774: ,p_legislation_code => pay_in_etw_struct.g_legislation_code
775: ,p_formula_name => l_template_rec.ae_setup(i).uf_setup.formula_name
776: ,p_description => l_template_rec.ae_setup(i).uf_setup.description
777: ,p_formula_text => get_text(l_template_rec.ae_setup(i).uf_setup.formula_name)
778: ,p_object_version_number => l_object_version_number

Line 801: ,p_input_currency_code => pay_in_etw_struct.g_currency_code

797: ,p_reporting_name => NULL --Fix for bug 5718112
798: ,p_relative_processing_priority => l_template_rec.ae_setup(i).priority
799: ,p_processing_type => 'N'
800: ,p_classification_name => l_template_rec.ae_setup(i).classification
801: ,p_input_currency_code => pay_in_etw_struct.g_currency_code
802: ,p_output_currency_code => pay_in_etw_struct.g_currency_code
803: ,p_multiple_entries_allowed_fla => 'N'
804: ,p_post_termination_rule => 'F'
805: ,p_process_in_run_flag => 'Y'

Line 802: ,p_output_currency_code => pay_in_etw_struct.g_currency_code

798: ,p_relative_processing_priority => l_template_rec.ae_setup(i).priority
799: ,p_processing_type => 'N'
800: ,p_classification_name => l_template_rec.ae_setup(i).classification
801: ,p_input_currency_code => pay_in_etw_struct.g_currency_code
802: ,p_output_currency_code => pay_in_etw_struct.g_currency_code
803: ,p_multiple_entries_allowed_fla => 'N'
804: ,p_post_termination_rule => 'F'
805: ,p_process_in_run_flag => 'Y'
806: ,p_additional_entry_allowed_fla => 'N'

Line 1023: WHERE currency_code = pay_in_etw_struct.g_currency_code;

1019: pay_in_utils.set_location(g_debug,l_procedure,340);
1020:
1021: UPDATE fnd_currencies
1022: SET enabled_flag = l_enabled_flag
1023: WHERE currency_code = pay_in_etw_struct.g_currency_code;
1024:
1025: --
1026: -- PAY_ELE_TMPLT_CLASS_USAGES row.
1027: --

Line 1073: WHERE legislation_code = pay_in_etw_struct.g_legislation_code

1069:
1070: SELECT classification_id
1071: INTO l_classification_id
1072: FROM pay_element_classifications
1073: WHERE legislation_code = pay_in_etw_struct.g_legislation_code
1074: AND classification_name = p_classification;
1075:
1076: pay_in_utils.set_location(g_debug,l_procedure,20);
1077: SELECT count(*)

Line 1149: AND pec.legislation_code = pay_in_etw_struct.g_legislation_code

1145: WHERE petcu.classification_id = pec.classification_id
1146: AND petcu.template_id = pet.template_id
1147: AND pet.template_name = p_template_name
1148: AND pec.classification_name = p_classification
1149: AND pec.legislation_code = pay_in_etw_struct.g_legislation_code
1150: AND pet.legislation_code = pay_in_etw_struct.g_legislation_code);
1151:
1152: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1153: EXCEPTION

Line 1150: AND pet.legislation_code = pay_in_etw_struct.g_legislation_code);

1146: AND petcu.template_id = pet.template_id
1147: AND pet.template_name = p_template_name
1148: AND pec.classification_name = p_classification
1149: AND pec.legislation_code = pay_in_etw_struct.g_legislation_code
1150: AND pet.legislation_code = pay_in_etw_struct.g_legislation_code);
1151:
1152: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN

Line 1357: pay_in_etw_struct.g_legislation_code||' ');

1353: IF l_template_obj.configuration_info_category <> 'IN Other Perquisites'
1354: THEN
1355: l_template_obj.configuration_information1 :=
1356: REPLACE(l_template_obj.configuration_info_category,
1357: pay_in_etw_struct.g_legislation_code||' ');
1358: l_template_obj.configuration_information3 := REPLACE(l_template_obj.configuration_information3
1359: , 'N', 'ALL');
1360: END IF ;
1361:

Line 1538: l_template_rec pay_in_etw_struct.t_template_setup_rec;

1534:
1535: l_element csr_set%ROWTYPE ;
1536:
1537: l_template pay_etm_shd.g_rec_type;
1538: l_template_rec pay_in_etw_struct.t_template_setup_rec;
1539:
1540: CURSOR csr_alwn_details (p_allowance_name IN VARCHAR2)
1541: IS
1542: SELECT catg.allowance_name

Line 1666: , p_element_information_category => UPPER(pay_in_etw_struct.g_legislation_code||'_'||

1662: p_effective_date => l_element.effective_start_date
1663: , p_datetrack_update_mode => hr_api.g_correction
1664: , p_element_type_id => l_element.element_type_id
1665: , p_object_version_number => l_element.object_version_number
1666: , p_element_information_category => UPPER(pay_in_etw_struct.g_legislation_code||'_'||
1667: l_element.classification_name)
1668: , p_element_information1 => l_alwn_details.allowance_name
1669: , p_element_information2 => l_alwn_details.category_code
1670: , p_element_information3 => l_alwn_details.exemption_amount

Line 1723: , p_element_information_category => UPPER(pay_in_etw_struct.g_legislation_code||'_'||

1719: p_effective_date => l_element.effective_start_date
1720: , p_datetrack_update_mode => hr_api.g_correction
1721: , p_element_type_id => l_element.element_type_id
1722: , p_object_version_number => l_element.object_version_number
1723: , p_element_information_category => UPPER(pay_in_etw_struct.g_legislation_code||'_'||
1724: l_element.classification_name)
1725: , p_element_information1 => l_template.configuration_information1
1726: , p_element_information6 => l_template.configuration_information3
1727: , p_effective_start_date => l_et_start_date

Line 1849: pay_in_etw_struct.init_code;

1845:
1846: END IF ;
1847:
1848: pay_in_utils.set_location(g_debug,l_procedure,60);
1849: pay_in_etw_struct.init_code;
1850:
1851: pay_in_utils.set_location(g_debug,l_procedure,70);
1852: get_template
1853: (p_template_name => l_template.template_name