eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 55: l_start_date pa_project_assignments.start_date%TYPE := NULL;

51: INDEX BY BINARY_INTEGER;
52: TYPE date_tbl IS TABLE OF DATE
53: INDEX BY BINARY_INTEGER;
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;

Line 84: FROM pa_project_assignments pa,

80: CURSOR get_req_action_set_info IS
81: SELECT pa.start_date,
82: ast.status_code,
83: ast.actual_start_date
84: FROM pa_project_assignments pa,
85: pa_action_sets ast
86: WHERE pa.assignment_id = ast.object_id
87: AND ast.action_set_id = p_action_set_id;
88:

Line 368: l_object_id pa_project_assignments.assignment_id%TYPE;

364: TYPE date_tbl IS TABLE OF DATE
365: INDEX BY BINARY_INTEGER;
366:
367: l_msg_index_out NUMBER;
368: l_object_id pa_project_assignments.assignment_id%TYPE;
369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;

Line 369: l_project_id pa_project_assignments.project_id%TYPE;

365: INDEX BY BINARY_INTEGER;
366:
367: l_msg_index_out NUMBER;
368: l_object_id pa_project_assignments.assignment_id%TYPE;
369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;

Line 370: l_start_date pa_project_assignments.start_date%TYPE;

366:
367: l_msg_index_out NUMBER;
368: l_object_id pa_project_assignments.assignment_id%TYPE;
369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
374: l_return_status VARCHAR2(1);

Line 371: l_record_version_number pa_project_assignments.record_version_number%TYPE;

367: l_msg_index_out NUMBER;
368: l_object_id pa_project_assignments.assignment_id%TYPE;
369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
374: l_return_status VARCHAR2(1);
375:

Line 382: FROM pa_project_assignments pa,

378: SELECT pa.assignment_id,
379: pa.project_id,
380: pa.start_date,
381: pa.record_version_number
382: FROM pa_project_assignments pa,
383: pa_action_sets ast
384: WHERE pa.assignment_id = ast.object_id
385: AND ast.action_set_id = p_action_set_line_rec.action_set_id;
386:

Line 622: l_project_id pa_project_assignments.project_id%TYPE;

618:
619: l_return_status VARCHAR2(1);
620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(2000);
622: l_project_id pa_project_assignments.project_id%TYPE;
623: l_start_date pa_project_assignments.start_date%TYPE;
624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
626: l_action_set_id pa_action_sets.action_set_id%TYPE;

Line 623: l_start_date pa_project_assignments.start_date%TYPE;

619: l_return_status VARCHAR2(1);
620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(2000);
622: l_project_id pa_project_assignments.project_id%TYPE;
623: l_start_date pa_project_assignments.start_date%TYPE;
624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
626: l_action_set_id pa_action_sets.action_set_id%TYPE;
627: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

Line 642: FROM pa_project_assignments pa,

638: ast.status_code,
639: ast.actual_start_date,
640: ast.action_set_id,
641: ast.action_set_template_flag
642: FROM pa_project_assignments pa,
643: pa_action_sets ast
644: WHERE pa.assignment_id = p_object_id
645: AND ast.object_id = p_object_id
646: AND ast.object_type = p_object_type

Line 830: FROM pa_project_assignments asgn,

826: ELSE
827:
828: SELECT proj.start_adv_action_set_flag
829: INTO l_action_set_start_flag
830: FROM pa_project_assignments asgn,
831: pa_projects_all proj
832: WHERE asgn.assignment_id = p_object_id
833: AND asgn.project_id = proj.project_id;
834: