DBA Data[Home] [Help]

APPS.PA_TASK_PROG_ACTSET dependencies on PA_ACTION_SET_LINES

Line 42: FROM pa_action_set_lines line,

38: SELECT line.action_set_line_id,
39: cond.action_set_line_condition_id
40: BULK COLLECT INTO l_line_id_tbl,
41: l_line_cond_id_tbl
42: FROM pa_action_set_lines line,
43: pa_action_set_line_cond cond
44: WHERE line.action_set_id = p_action_set_id
45: AND line.action_set_line_id = cond.action_set_line_id;
46: --FORALL loop_cnt IN l_line_id_tbl.FIRST .. l_line_id_tbl.LAST

Line 91: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

87: /*===================================================================================*/
88: PROCEDURE perform_action_set_line(
89: p_action_set_type_code IN VARCHAR2 := 'PA_TASK_PROGRESS'
90: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
91: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
92: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
93: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
94: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
95: IS