APPS.PAY_IN_SOE dependencies on PAY_IN_SOE

Line 1: PACKAGE BODY pay_in_soe AS

1: PACKAGE BODY pay_in_soe AS
2: /* $Header: pyinsoe.pkb 120.21.12020000.3 2013/03/11 09:59:32 anchhetr ship $ */
3: TYPE clob_tab_type IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
4:
5: g_clob clob_tab_type;

Line 11: g_package CONSTANT VARCHAR2(100) := 'pay_in_soe.';

7: g_clob_cnt NUMBER;
8: g_fetch_clob_cnt NUMBER;
9: g_chunk_size NUMBER;
10: g_business_group_id NUMBER;
11: g_package CONSTANT VARCHAR2(100) := 'pay_in_soe.';
12: g_debug BOOLEAN;
13:
14: --------------------------------------------------------------------------
15: -- --

Line 1612: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr

1608: ,peaiv.action_information8 ptn
1609: ,peaiv.action_information24 pf_number
1610: ,peaiv.action_information6 esi_number
1611: ,peaiv.action_information1 emp_name
1612: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr
1613: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr
1614: ,peaiv.action_information23 pay_month
1615: ,peaiv.action_information30 er_location
1616: ,peaiv.action_information17 job

Line 1613: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr

1609: ,peaiv.action_information24 pf_number
1610: ,peaiv.action_information6 esi_number
1611: ,peaiv.action_information1 emp_name
1612: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr
1613: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr
1614: ,peaiv.action_information23 pay_month
1615: ,peaiv.action_information30 er_location
1616: ,peaiv.action_information17 job
1617: ,peaiv.action_information19 position

Line 2014: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr

2010: ,peaiv.action_information8 ptn
2011: ,peaiv.action_information24 pf_number
2012: ,peaiv.action_information6 esi_number
2013: ,peaiv.action_information1 emp_name
2014: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr
2015: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr
2016: ,peaiv.action_information23 pay_month
2017: ,peaiv.action_information30 er_location
2018: ,peaiv.action_information17 job

Line 2015: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr

2011: ,peaiv.action_information24 pf_number
2012: ,peaiv.action_information6 esi_number
2013: ,peaiv.action_information1 emp_name
2014: ,pay_in_soe.get_emp_email(peaiv.action_context_id) email_addr
2015: ,pay_in_soe.get_emp_address(paf.person_id,:end_date) emp_addr
2016: ,peaiv.action_information23 pay_month
2017: ,peaiv.action_information30 er_location
2018: ,peaiv.action_information17 job
2019: ,peaiv.action_information19 position

Line 2273: END pay_in_soe;

2269: g_clob_cnt := 0;
2270: g_fetch_clob_cnt := 0;
2271: g_chunk_size := 500;
2272: --
2273: END pay_in_soe;