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_CONTROL_ITEMS_WORKFLOW dependencies on PA_CI_ACTIONS_V

Line 1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;

1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;

Line 1398: l_action_request pa_ci_actions_v.comment_text%TYPE;

1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;

Line 1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;

1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;

Line 1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;

1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1404: --FP.M.IB1 Sanity

Line 1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;

1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1404: --FP.M.IB1 Sanity
1405: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;

Line 1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;

1398: l_action_request pa_ci_actions_v.comment_text%TYPE;
1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1404: --FP.M.IB1 Sanity
1405: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1406:

Line 1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;

1399: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1400: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1404: --FP.M.IB1 Sanity
1405: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1406:
1407:

Line 1405: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;

1401: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1402: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1403: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1404: --FP.M.IB1 Sanity
1405: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1406:
1407:
1408: l_role varchar2(30) := NULL;
1409: l_role_users varchar2(30000) := NULL;

Line 1423: l_action_type pa_ci_actions_v.action_type%TYPE;

1419: l_ci_owner_id pa_control_items.owner_id%TYPE;
1420: l_ci_owner_name VARCHAR2(2000);
1421: l_ci_status_code pa_control_items.status_code%TYPE;
1422: l_ci_status_name VARCHAR2(2000);
1423: l_action_type pa_ci_actions_v.action_type%TYPE;
1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;

Line 1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;

1420: l_ci_owner_name VARCHAR2(2000);
1421: l_ci_status_code pa_control_items.status_code%TYPE;
1422: l_ci_status_name VARCHAR2(2000);
1423: l_action_type pa_ci_actions_v.action_type%TYPE;
1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;

Line 1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;

1421: l_ci_status_code pa_control_items.status_code%TYPE;
1422: l_ci_status_name VARCHAR2(2000);
1423: l_action_type pa_ci_actions_v.action_type%TYPE;
1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901

Line 1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;

1422: l_ci_status_name VARCHAR2(2000);
1423: l_action_type pa_ci_actions_v.action_type%TYPE;
1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347

Line 1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;

1423: l_action_type pa_ci_actions_v.action_type%TYPE;
1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;

Line 1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;

1424: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;
1432: -- Bug#12553936 start

Line 1497: from pa_ci_actions_v

1493: last_update_date,
1494: status_meaning,
1495: sign_off_required_flag,
1496: sign_off_required_flag_meaning--FP.M.IB1 Sanity
1497: from pa_ci_actions_v
1498: where ci_action_id = c_action_id;
1499:
1500: --Bug 4923945 Begining of Code changes.
1501: --This Cursor is added for the bug# 3691192 to get Ci Owner and Ci Status