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 PAY_COST_ALLOCATION_KEYFLEX

Line 39: -- When required this procedure updates the PAY_COST_ALLOCATION_KEYFLEX

35: -- ------------------------------------------------------------------
36: -- {Start Of Comments}
37: --
38: -- Description:
39: -- When required this procedure updates the PAY_COST_ALLOCATION_KEYFLEX
40: -- table after the flexfield segments have been inserted to keep
41: -- the concatenated segment string up-to-date.
42: --
43: -- Prerequisites:

Line 44: -- A row must exist in the PAY_COST_ALLOCATION_KEYFLEX table for the

40: -- table after the flexfield segments have been inserted to keep
41: -- the concatenated segment string up-to-date.
42: --
43: -- Prerequisites:
44: -- A row must exist in the PAY_COST_ALLOCATION_KEYFLEX table for the
45: -- given cost_allocation_keyflex_id.
46: --
47: -- In Parameters:
48: -- Name Reqd Type Description

Line 70: FROM PAY_COST_ALLOCATION_KEYFLEX

66: ) is
67: --
68: CURSOR csr_chk_cost is
69: SELECT null
70: FROM PAY_COST_ALLOCATION_KEYFLEX
71: where cost_allocation_keyflex_id = p_cost_alloc_keyflex_id
72: and (concatenated_segments <> p_concat_segments
73: or concatenated_segments is null);
74: --

Line 86: FROM PAY_COST_ALLOCATION_KEYFLEX

82: PRAGMA AUTONOMOUS_TRANSACTION;
83: --
84: CURSOR csr_cost_lock is
85: SELECT null
86: FROM PAY_COST_ALLOCATION_KEYFLEX
87: where cost_allocation_keyflex_id = p_cost_alloc_keyflex_id
88: for update nowait;
89: --
90: l_exists varchar2(30);

Line 120: update PAY_COST_ALLOCATION_KEYFLEX

116: --
117: -- Lock obtained by this transaction, updating the concatenated
118: -- segment string should be performed.
119: --
120: update PAY_COST_ALLOCATION_KEYFLEX
121: set concatenated_segments = p_concat_segments
122: where cost_allocation_keyflex_id = p_cost_alloc_keyflex_id
123: and (concatenated_segments <> p_concat_segments
124: or concatenated_segments is null);

Line 547: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_cost_concat_segments_in;

543: l_scl_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
544: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
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;

Line 548: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_susp_concat_segments_in;

544: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
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;

Line 573: from pay_cost_allocation_keyflex pca

569:
570: --Cursor for checking whether the given Cost Keyflex id is there or not
571: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is
572: select pca.cost_allocation_keyflex_id
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

Line 633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

629: --
630: close csr_cost_alloc_exists;
631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
634: fnd_message.raise_error;
635: --
636: end if;
637: close csr_cost_alloc_exists;

Line 654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

650: --
651: close csr_cost_alloc_exists;
652: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
655: fnd_message.raise_error;
656: --
657: end if;
658: close csr_cost_alloc_exists;

Line 1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

1739: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;
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;

Line 1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;
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;

Line 1777: from pay_cost_allocation_keyflex pca

1773: --Cursor for checking whether the given Cost Keyflex id is there or not.
1774: --
1775: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is
1776: select pca.cost_allocation_keyflex_id
1777: from pay_cost_allocation_keyflex pca
1778: where pca.cost_allocation_keyflex_id = c_cost_allocation_keyflex_id;
1779:
1780: --
1781: --Cursor for checking whether the given Soft coding Keyflex id is there or not.

Line 1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1905: --
1906: close csr_cost_alloc_exists;
1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1910: fnd_message.raise_error;
1911: --
1912: end if;
1913: close csr_cost_alloc_exists;

Line 1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1925: --
1926: close csr_cost_alloc_exists;
1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1930: fnd_message.raise_error;
1931: --
1932: end if;
1933: close csr_cost_alloc_exists;

Line 3013: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%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

Line 3014: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%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:

Line 3235: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%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

Line 3236: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%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