APPS.HR_ORGANIZATION_API dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 20: -- This procedure updates the pay_cost_allocation_keyflex table after the

16: -- ----------------------------------------------------------------------------
17: -- {Start Of Comments}
18: --
19: -- Description:
20: -- This procedure updates the pay_cost_allocation_keyflex table after the
21: -- flexfield segments have been inserted to keep the concatenated segment
22: -- field up to date.
23: --
24: -- Prerequisites:

Line 25: -- A row must exist in the pay_cost_allocation_keyflex table for

21: -- flexfield segments have been inserted to keep the concatenated segment
22: -- field up to date.
23: --
24: -- Prerequisites:
25: -- A row must exist in the pay_cost_allocation_keyflex table for
26: -- p_cost_allocation_keyflex_id
27: --
28: -- In Parameters:
29: -- Name Reqd Type Description

Line 53: FROM pay_cost_allocation_keyflex

49: ) is
50: --
51: CURSOR csr_chk_cost is
52: SELECT null
53: FROM pay_cost_allocation_keyflex
54: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
55: and (concatenated_segments <> p_cost_name
56: or concatenated_segments is null);
57: --

Line 69: FROM pay_cost_allocation_keyflex

65: PRAGMA AUTONOMOUS_TRANSACTION;
66: --
67: CURSOR csr_cost_lock is
68: SELECT null
69: FROM pay_cost_allocation_keyflex
70: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
71: for update nowait;
72: --
73: l_exists varchar2(30);

Line 103: update pay_cost_allocation_keyflex

99: --
100: -- Lock obtained by this transaction, updating the concatenated
101: -- segment string should be performed.
102: --
103: update pay_cost_allocation_keyflex
104: set concatenated_segments = p_cost_name
105: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
106: and (concatenated_segments <> p_cost_name
107: or concatenated_segments is null);

Line 460: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;

456: --
457: -- Declare local variables
458: --
459: l_flex_num fnd_id_flex_segments.id_flex_num%Type;
460: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
461: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type;
462: l_date_from date;
463: l_effective_date date;
464: --

Line 1513: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;

1509: l_api_updating boolean;
1510: l_flex_num fnd_id_flex_segments.id_flex_num%Type;
1511: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type
1512: := p_cost_allocation_keyflex_id;
1513: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1514: l_old_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1515: l_business_group_id per_all_assignments_f.business_group_id%Type;
1516: --
1517: -- bug 3039046 new variables for derived values where key flex id is known.

Line 1514: l_old_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;

1510: l_flex_num fnd_id_flex_segments.id_flex_num%Type;
1511: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type
1512: := p_cost_allocation_keyflex_id;
1513: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1514: l_old_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1515: l_business_group_id per_all_assignments_f.business_group_id%Type;
1516: --
1517: -- bug 3039046 new variables for derived values where key flex id is known.
1518: --

Line 1582: from pay_cost_allocation_keyflex

1578: segment27,
1579: segment28,
1580: segment29,
1581: segment30
1582: from pay_cost_allocation_keyflex
1583: where cost_allocation_keyflex_id = l_cost_alloc_key_id;
1584: --
1585: --
1586: cursor csr_cost_idsel is

Line 1593: l_old_conc_segs pay_cost_allocation_keyflex.concatenated_segments%Type;

1589: where bus.business_group_id = l_business_group_id;
1590: --
1591: -- Start of 3187772
1592: l_old_cost_segments c_cost_segments%rowtype;
1593: l_old_conc_segs pay_cost_allocation_keyflex.concatenated_segments%Type;
1594: -- End of 3187772
1595: --
1596: BEGIN
1597:

Line 1599: -- a value then get segment values from pay_cost_allocation_keyflex.

1595: --
1596: BEGIN
1597:
1598: -- Bug 3039046 - if p_cost_allocation_keyflex_id enters with
1599: -- a value then get segment values from pay_cost_allocation_keyflex.
1600: --
1601: hr_utility.set_location(l_proc, 1);
1602:
1603: l_old_cost_name := p_concat_segments;