DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_IE_PAYPATH_TAPE

Line 1: package body pay_ie_paypath_tape as

1: package body pay_ie_paypath_tape as
2: /* $Header: pyiepppk.pkb 120.4 2011/01/04 13:36:46 abraghun ship $ */
3: --
4: -- Constants
5: --

Line 6: l_package varchar2(31) := 'pay_ie_paypath_tape.';

2: /* $Header: pyiepppk.pkb 120.4 2011/01/04 13:36:46 abraghun ship $ */
3: --
4: -- Constants
5: --
6: l_package varchar2(31) := 'pay_ie_paypath_tape.';
7: --
8: -- Global Variables
9: --
10: --------------------------------------------------------------------------------+

Line 130: pay_ie_paypath_tape.g_pathid:=l_paypathid;

126: FETCH csr_payrolls into l_paypath_ids;
127: EXIT when csr_payrolls%NOTFOUND;
128:
129: l_paypathid:=l_paypath_ids.org_information8;
130: pay_ie_paypath_tape.g_pathid:=l_paypathid;
131: cnt:=cnt+1;
132:
133: --PayPath process errors when a consolidation set has multiple payrolls, which in turn have multiple Paypath ID's
134: if cnt>=2 then

Line 149: pay_ie_paypath_tape.g_pathid:=l_paypathid;

145: --If no paypath ids defined at BG level and payroll level
146: IF CSR_BG_PAYPATH%NOTFOUND THEN
147:
148: l_paypathid:= ' ';
149: pay_ie_paypath_tape.g_pathid:=l_paypathid;
150: return l_paypathid;
151: END IF;
152: CLOSE CSR_BG_PAYPATH;
153:

Line 154: pay_ie_paypath_tape.g_pathid:=l_bg_pathid.org_information8;

150: return l_paypathid;
151: END IF;
152: CLOSE CSR_BG_PAYPATH;
153:
154: pay_ie_paypath_tape.g_pathid:=l_bg_pathid.org_information8;
155: return l_bg_pathid.org_information8;
156: end if;
157: --If payrolls in the consolidation set all have the same paypath id, then that paypath id is picked up.
158: return l_paypathid;

Line 162: pay_ie_paypath_tape.g_pathid:=l_paypathid;

158: return l_paypathid;
159: EXCEPTION when e_submit_error then
160:
161: l_paypathid:='Error';
162: pay_ie_paypath_tape.g_pathid:=l_paypathid;
163: return l_paypathid;
164: END;
165: ELSE
166: --Payroll name as well as the consolidation set specified as parameter then ,select paypath id specified at the payroll level

Line 179: pay_ie_paypath_tape.g_pathid:=l_bg_pathid.org_information8;

175: --paypath id defined at BG Level
176: OPEN CSR_BG_PAYPATH;
177: FETCH CSR_BG_PAYPATH into l_bg_pathid;
178: CLOSE CSR_BG_PAYPATH;
179: pay_ie_paypath_tape.g_pathid:=l_bg_pathid.org_information8;
180: return l_bg_pathid.org_information8;
181: END IF;
182: --Bug No 3086034 End
183: CLOSE CSR_PAYROLL_PAYPATH;

Line 185: pay_ie_paypath_tape.g_pathid:=l_payroll_pathid.org_information8;

181: END IF;
182: --Bug No 3086034 End
183: CLOSE CSR_PAYROLL_PAYPATH;
184:
185: pay_ie_paypath_tape.g_pathid:=l_payroll_pathid.org_information8;
186: return l_payroll_pathid.org_information8;
187: END IF;
188: END get_paypathid;
189: -- Bug No 3060464 End

Line 479: END pay_ie_paypath_tape;

475:
476: END f_get_paypath_recon_data;
477:
478:
479: END pay_ie_paypath_tape;