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_PAYROLL_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 184: -- When required this procedure updates the HR_SOFT_CODING_KEYFLEX

180: -- ------------------------------------------------------------------
181: -- {Start Of Comments}
182: --
183: -- Description:
184: -- When required this procedure updates the HR_SOFT_CODING_KEYFLEX
185: -- table after the flexfield segments have been inserted to keep
186: -- the concatenated segment string up-to-date.
187: --
188: -- Prerequisites:

Line 189: -- A row must exist in the HR_SOFT_CODING_KEYFLEX table for the

185: -- table after the flexfield segments have been inserted to keep
186: -- the concatenated segment string up-to-date.
187: --
188: -- Prerequisites:
189: -- A row must exist in the HR_SOFT_CODING_KEYFLEX table for the
190: -- given soft_coding_keyflex_id.
191: --
192: -- In Parameters:
193: -- Name Reqd Type Description

Line 215: FROM HR_SOFT_CODING_KEYFLEX

211: ) is
212: --
213: CURSOR csr_chk_soft is
214: SELECT null
215: FROM HR_SOFT_CODING_KEYFLEX
216: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
217: and (concatenated_segments <> p_concat_segments
218: or concatenated_segments is null);
219: --

Line 231: FROM HR_SOFT_CODING_KEYFLEX

227: PRAGMA AUTONOMOUS_TRANSACTION;
228: --
229: CURSOR csr_soft_lock is
230: SELECT null
231: FROM HR_SOFT_CODING_KEYFLEX
232: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
233: for update nowait;
234: --
235: l_exists varchar2(30);

Line 265: update HR_SOFT_CODING_KEYFLEX

261: --
262: -- Lock obtained by this transaction, updating the concatenated
263: -- segment string should be performed.
264: --
265: update HR_SOFT_CODING_KEYFLEX
266: set concatenated_segments = p_concat_segments
267: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
268: and (concatenated_segments <> p_concat_segments
269: or concatenated_segments is null);

Line 549: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE := p_scl_concat_segments_in;

545: l_legislation_code varchar2(150);
546:
547: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_cost_concat_segments_in;
548: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_susp_concat_segments_in;
549: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE := p_scl_concat_segments_in;
550:
551: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
552: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;

Line 577: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is

573: from pay_cost_allocation_keyflex pca
574: where pca.cost_allocation_keyflex_id = c_cost_allocation_keyflex_id;
575:
576: --Cursor for checking whether the given Soft coding Keyflex id is there or not.
577: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is
578: select scl.soft_coding_keyflex_id
579: from HR_SOFT_CODING_KEYFLEX scl
580: where scl.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
581:

Line 579: from HR_SOFT_CODING_KEYFLEX scl

575:
576: --Cursor for checking whether the given Soft coding Keyflex id is there or not.
577: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is
578: select scl.soft_coding_keyflex_id
579: from HR_SOFT_CODING_KEYFLEX scl
580: where scl.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
581:
582: begin
583:

Line 675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');

671: --
672: close csr_soft_coding_exists;
673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
676: fnd_message.raise_error;
677: --
678: end if;
679: close csr_soft_coding_exists;

Line 1745: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

1741: l_legislation_code varchar2(150);
1742:
1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1745: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1746:
1747: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
1748: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
1749: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;

Line 1783: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is

1779:
1780: --
1781: --Cursor for checking whether the given Soft coding Keyflex id is there or not.
1782: --
1783: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is
1784: select scl.soft_coding_keyflex_id
1785: from HR_SOFT_CODING_KEYFLEX scl
1786: where scl.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
1787:

Line 1785: from HR_SOFT_CODING_KEYFLEX scl

1781: --Cursor for checking whether the given Soft coding Keyflex id is there or not.
1782: --
1783: cursor csr_soft_coding_exists(c_soft_coding_keyflex_id HR_SOFT_CODING_KEYFLEX.SOFT_CODING_KEYFLEX_ID%TYPE) is
1784: select scl.soft_coding_keyflex_id
1785: from HR_SOFT_CODING_KEYFLEX scl
1786: where scl.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
1787:
1788: --
1789: --Cursor for getting the business group id from the payroll id.

Line 1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');

1947: --
1948: close csr_soft_coding_exists;
1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1952: fnd_message.raise_error;
1953: --
1954: end if;
1955: close csr_soft_coding_exists;

Line 3015: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

3011: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3012:
3013: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3014: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3015: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
3016:
3017: begin
3018:
3019: --Get the business group id from the consolidation set id.

Line 3237: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

3233: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3234:
3235: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3236: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3237: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
3238:
3239: cursor csr_get_BG is
3240: select business_group_id
3241: from PAY_ALL_PAYROLLS_F