APPS.PA_PROJ_STAT_ACTSET dependencies on PA_ACTION_SET_LINES

Line 46: FROM pa_action_set_lines line,

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

Line 101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

97: -----------------------------------------------------------------------------------------*/
98: PROCEDURE perform_action_set_line(
99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
104: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
105:

Line 306: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

302:
303:
304: FUNCTION ok_to_perform_action (
305: p_report_date IN pa_object_page_layouts.next_reporting_date%TYPE
306: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
307: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
308: ) return BOOLEAN
309: IS
310: l_condition_date DATE := TRUNC(sysdate);

Line 353: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

349:
350:
351: PROCEDURE validate_action_set_line (
352: p_action_set_type_code IN VARCHAR2 := 'PA_PROJ_STATUS_REPORT'
353: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
354: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
355: , x_return_status OUT NOCOPY VARCHAR2
356: ) IS
357:

Line 378: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

374: p_project_id IN NUMBER
375: ,p_report_type_id IN NUMBER
376: ,p_layout_id IN NUMBER
377: ,p_action_set_type_code IN VARCHAR2
378: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
379: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
380: ,x_action_performed OUT NOCOPY VARCHAR2
381: ,x_return_status OUT NOCOPY VARCHAR2
382: ,x_msg_count OUT NOCOPY NUMBER