APPS.PAY_COST_ALLOCATION_API dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 17: -- When required this procedure updates the pay_cost_allocation_keyflex table

13: -- ----------------------------------------------------------------------------
14: -- {Start Of Comments}
15: --
16: -- Description:
17: -- When required this procedure updates the pay_cost_allocation_keyflex table
18: -- after the flexfield segments have been inserted to keep the concatenated
19: -- segment string up-to-date.
20: --
21: -- Prerequisites:

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

18: -- after the flexfield segments have been inserted to keep the concatenated
19: -- segment string up-to-date.
20: --
21: -- Prerequisites:
22: -- A row must exist in the pay_cost_allocation_keyflex table for the
23: -- given cost_allocation_keyflex_id.
24: --
25: -- In Parameters:
26: -- Name Reqd Type Description

Line 48: FROM pay_cost_allocation_keyflex

44: ) is
45: --
46: CURSOR csr_chk_cak is
47: SELECT null
48: FROM pay_cost_allocation_keyflex
49: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
50: and (concatenated_segments <> p_concatenated_segments
51: or concatenated_segments is null);
52: --

Line 64: FROM pay_cost_allocation_keyflex

60: PRAGMA AUTONOMOUS_TRANSACTION;
61: --
62: CURSOR csr_cak_lock is
63: SELECT null
64: FROM pay_cost_allocation_keyflex
65: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
66: for update nowait;
67: --
68: l_exists varchar2(30);

Line 98: update pay_cost_allocation_keyflex

94: --
95: -- Lock obtained by this transaction, updating the concatenated
96: -- segment string should be performed.
97: --
98: update pay_cost_allocation_keyflex
99: set concatenated_segments = p_concatenated_segments
100: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
101: and (concatenated_segments <> p_concatenated_segments
102: or concatenated_segments is null);

Line 397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;

393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
398: --
399: cursor csr_cost_structure is
400: select pbg.cost_allocation_structure
401: from per_business_groups pbg

Line 530: -- Set CONCATENATED_SEGMENTS column in pay_cost_allocation_keyflex

526: ,p_ccid => l_cost_allocation_keyflex_id
527: ,p_concat_segments_out => l_combination_name
528: );
529: --
530: -- Set CONCATENATED_SEGMENTS column in pay_cost_allocation_keyflex
531: -- bug 2620309
532: --
533: -- The update of the concatenated_segments column is executed
534: -- in a separate procedure. (Bug #3177656)

Line 806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;

802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
807: --
808: cursor csr_cost_structure(p_bg_id number) is
809: select pbg.cost_allocation_structure
810: from per_business_groups pbg

Line 853: from pay_cost_allocation_keyflex pca,

849: pca.segment27,
850: pca.segment28,
851: pca.segment29,
852: pca.segment30
853: from pay_cost_allocation_keyflex pca,
854: pay_cost_allocations_f pac
855: where pac.cost_allocation_id = p_cost_Allocation_id
856: and p_effective_date between pac.effective_start_date
857: and pac.effective_end_date

Line 1042: -- Set CONCATENATED_SEGMENTS column in pay_cost_allocation_keyflex

1038: ,p_concat_segments_in => p_concat_segments
1039: ,p_concat_segments_out => l_combination_name
1040: );
1041: --
1042: -- Set CONCATENATED_SEGMENTS column in pay_cost_allocation_keyflex
1043: -- bug 2620309
1044: --
1045: -- The update of the concatenated_segments column is executed
1046: -- in a separate procedure. (Bug #3177656)