APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_ACTION_SET_LINES

Line 19: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
16:
17: PROCEDURE Validate_Action_Set_Line (
18: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
19: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
20: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
21: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: ) IS
23:

Line 58: l_pub_to_org_line_id pa_action_set_lines.action_set_line_id%TYPE := NULL;

54:
55: l_start_date pa_project_assignments.start_date%TYPE := NULL;
56: l_adv_action_set_status_code pa_action_sets.status_code%TYPE := NULL;
57: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE := NULL;
58: l_pub_to_org_line_id pa_action_set_lines.action_set_line_id%TYPE := NULL;
59: l_action_code_tbl varchar_tbl;
60: l_condition_code_tbl varchar_tbl;
61: l_condition_attribute1_tbl varchar_tbl;
62: l_condition_attribute2_tbl varchar_tbl;

Line 92: FROM pa_action_set_lines

88:
89: --cursor to get pending and complete action lines
90: CURSOR get_action_lines IS
91: SELECT action_code
92: FROM pa_action_set_lines
93: WHERE action_set_id = p_action_set_id
94: AND (status_code = 'PENDING'
95: OR status_code = 'UPDATE_PENDING'
96: OR status_code = 'COMPLETE');

Line 101: FROM pa_action_set_lines

97:
98: --cursor to get pending and complete action lines
99: CURSOR get_undeleted_action_lines IS
100: SELECT action_code
101: FROM pa_action_set_lines
102: WHERE action_set_id = p_action_set_id
103: AND line_deleted_flag = 'N';
104:
105: --cursor to check if validation is needed

Line 108: FROM pa_action_set_lines

104:
105: --cursor to check if validation is needed
106: CURSOR check_esc_to_next_lvl_exists IS
107: SELECT 'T'
108: FROM pa_action_set_lines
109: WHERE action_set_id = p_action_set_id
110: AND action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL'
111: AND (status_code = 'PENDING'
112: OR status_code = 'UPDATE_PENDING'

Line 121: FROM pa_action_set_lines

117: --the first Escalate to next level action line for
118: --requirement's action set
119: CURSOR check_pub_to_org_exists IS
120: SELECT action_set_line_id
121: FROM pa_action_set_lines
122: WHERE action_set_id = p_action_set_id
123: AND rownum = 1
124: AND action_code = 'ADVERTISEMENT_PUB_TO_START_ORG'
125: AND (status_code = 'PENDING'

Line 130: FROM pa_action_set_lines

126: OR status_code = 'UPDATE_PENDING'
127: OR status_code = 'COMPLETE')
128: AND action_set_line_number < (
129: SELECT MIN(action_set_line_number)
130: FROM pa_action_set_lines
131: WHERE action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL'
132: AND action_set_id = p_action_set_id
133: AND (status_code = 'PENDING'
134: OR status_code = 'UPDATE_PENDING'

Line 141: FROM pa_action_set_lines

137: --cursor to check if a Publish to Organizations action line exist before
138: --the first Escalate to next level action line for action set template
139: CURSOR check_pub_to_org_in_template IS
140: SELECT action_set_line_id
141: FROM pa_action_set_lines
142: WHERE action_set_id = p_action_set_id
143: AND rownum = 1
144: AND action_code = 'ADVERTISEMENT_PUB_TO_START_ORG'
145: AND action_set_line_number < (

Line 147: FROM pa_action_set_lines

143: AND rownum = 1
144: AND action_code = 'ADVERTISEMENT_PUB_TO_START_ORG'
145: AND action_set_line_number < (
146: SELECT MIN(action_set_line_number)
147: FROM pa_action_set_lines
148: WHERE action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL'
149: AND action_set_id = p_action_set_id);
150:
151: BEGIN

Line 266: FROM pa_action_set_lines asl,

262: -- lines with action codes equal Publish to Organizations or
263: -- Escalate to next level order by line number
264: SELECT aslc.condition_code, aslc.condition_attribute1, aslc.condition_attribute2
265: BULK COLLECT INTO l_condition_code_tbl, l_condition_attribute1_tbl, l_condition_attribute2_tbl
266: FROM pa_action_set_lines asl,
267: pa_action_set_line_cond aslc
268: WHERE asl.action_set_id = p_action_set_id
269: AND asl.action_set_line_id = aslc.action_set_line_id
270: AND (asl.action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL'

Line 354: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

350: ----------------------------------------------------------------------
351: PROCEDURE Perform_Action_Set_Line (
352: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
353: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
354: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
355: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
356: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619
357: , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
358: ) IS

Line 695: FROM pa_action_set_lines asl,

691:
692: -- get all completed action lines whose conditions are no longer met
693: SELECT asl.action_set_line_id, 'UPDATE_PENDING', aslc.condition_date, aslc.action_set_line_condition_id
694: BULK COLLECT INTO l_action_set_line_id_tbl, l_action_status_code_tbl, l_condition_date_tbl, l_action_line_cond_id_tbl
695: FROM pa_action_set_lines asl,
696: pa_action_set_line_cond aslc
697: WHERE asl.action_set_id = l_action_set_id
698: AND asl.status_code = 'COMPLETE'
699: AND asl.action_set_line_id = aslc.action_set_line_id

Line 735: FROM pa_action_set_lines asl,

731: -- is no longer met
732: -- These lines will be in REVERSED status with deleted_flag <> 'Y'
733: SELECT asl.action_set_line_id, 'PENDING', aslc.condition_date, aslc.action_set_line_condition_id
734: BULK COLLECT INTO l_action_set_line_id_tbl, l_action_status_code_tbl, l_condition_date_tbl, l_action_line_cond_id_tbl
735: FROM pa_action_set_lines asl,
736: pa_action_set_line_cond aslc
737: WHERE asl.action_set_id = l_action_set_id
738: AND asl.status_code = 'REVERSED'
739: AND nvl(asl.line_deleted_flag, 'N') = 'N'