APPS.PA_PROJ_STAT_ACTSET dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 113: FROM pa_object_page_layouts l

109: ,l.object_id project_id
110: ,p.project_status_code proj_status_code
111: ,l.effective_from effective_from
112: ,l.effective_to effective_to
113: FROM pa_object_page_layouts l
114: ,pa_projects_all p
115: WHERE l.object_page_layout_id = cp_layout_id
116: AND l.object_id = p.project_id;
117:

Line 122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;

118: cp_rpt_info c_report_info%ROWTYPE;
119:
120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';
121: l_project_id pa_projects_all.project_id%TYPE;
122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;
123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;
124: l_project_status pa_projects_all.project_status_code%TYPE;
125: l_action_performed VARCHAR2(1) := 'N';
126: l_return_status VARCHAR2(1);

Line 123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;

119:
120: l_api_name VARCHAR2(30) := 'PA_PROJ_STAT_ACTSET';
121: l_project_id pa_projects_all.project_id%TYPE;
122: l_report_type_id pa_object_page_layouts.object_page_layout_id%TYPE;
123: l_report_date pa_object_page_layouts.next_reporting_date%TYPE;
124: l_project_status pa_projects_all.project_status_code%TYPE;
125: l_action_performed VARCHAR2(1) := 'N';
126: l_return_status VARCHAR2(1);
127: l_msg_count NUMBER;

Line 305: p_report_date IN pa_object_page_layouts.next_reporting_date%TYPE

301: END project_dates_valid;
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

Line 445: FROM pa_object_page_layouts lt

441: /*
442: SELECT lt.object_page_layout_id object_page_layout_id
443: ,ast.action_set_id action_set_id
444: ,lt.report_type_id report_type_id
445: FROM pa_object_page_layouts lt
446: ,pa_action_sets ast
447: WHERE ast.object_type = 'PA_PROJ_STATUS_REPORTS'
448: AND lt.page_type_code = 'PPR'
449: AND lt.object_id = p_project_id_from --c_proj_id_from

Line 456: FROM pa_object_page_layouts lt

452: SELECT lt.object_page_layout_id object_page_layout_id
453: ,pa_action_set_utils.get_action_set_id
454: ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) action_set_id
455: ,lt.report_type_id report_type_id
456: FROM pa_object_page_layouts lt
457: WHERE lt.page_type_code = 'PPR'
458: AND lt.object_id = p_project_id_from
459: and pa_action_set_utils.get_action_set_id
460: ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) is not null;

Line 466: FROM pa_object_page_layouts

462:
463: Cursor c_new_proj_layout_ids(c_proj_id_to NUMBER, rep_type_id NUMBER)
464: is
465: SELECT object_page_layout_id
466: FROM pa_object_page_layouts
467: WHERE object_id = c_proj_id_to
468: AND object_type = 'PA_PROJECTS'
469: AND report_type_id = rep_type_id
470: AND page_type_code = 'PPR';