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 1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;

1290: l_project_manager pa_project_lists_v.person_name%TYPE;
1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;

Line 1295: l_action_request pa_ci_actions_v.comment_text%TYPE;

1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;

Line 1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;

1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;

Line 1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;

1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1301: --FP.M.IB1 Sanity

Line 1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;

1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1301: --FP.M.IB1 Sanity
1302: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;

Line 1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;

1295: l_action_request pa_ci_actions_v.comment_text%TYPE;
1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1301: --FP.M.IB1 Sanity
1302: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1303:

Line 1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;

1296: l_action_requestor pa_ci_actions_v.create_name%TYPE;
1297: l_action_date_required pa_ci_actions_v.date_required%TYPE;
1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1301: --FP.M.IB1 Sanity
1302: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1303:
1304:

Line 1302: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;

1298: l_assign_party_id pa_ci_actions_v.assign_party_id%TYPE;
1299: l_create_party_id pa_ci_actions_v.create_party_id%TYPE;
1300: l_action_status_code pa_ci_actions_v.status_code%TYPE;
1301: --FP.M.IB1 Sanity
1302: l_action_closure_comment pa_ci_actions_v.cancel_comment%TYPE;
1303:
1304:
1305: l_role varchar2(30) := NULL;
1306: l_role_users varchar2(30000) := NULL;

Line 1320: l_action_type pa_ci_actions_v.action_type%TYPE;

1316: l_ci_owner_id pa_control_items.owner_id%TYPE;
1317: l_ci_owner_name VARCHAR2(2000);
1318: l_ci_status_code pa_control_items.status_code%TYPE;
1319: l_ci_status_name VARCHAR2(2000);
1320: l_action_type pa_ci_actions_v.action_type%TYPE;
1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;

Line 1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;

1317: l_ci_owner_name VARCHAR2(2000);
1318: l_ci_status_code pa_control_items.status_code%TYPE;
1319: l_ci_status_name VARCHAR2(2000);
1320: l_action_type pa_ci_actions_v.action_type%TYPE;
1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;

Line 1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;

1318: l_ci_status_code pa_control_items.status_code%TYPE;
1319: l_ci_status_name VARCHAR2(2000);
1320: l_action_type pa_ci_actions_v.action_type%TYPE;
1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901

Line 1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;

1319: l_ci_status_name VARCHAR2(2000);
1320: l_action_type pa_ci_actions_v.action_type%TYPE;
1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1327:

Line 1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;

1320: l_action_type pa_ci_actions_v.action_type%TYPE;
1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1327:
1328: -- This cursor gets the info about the control item.

Line 1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;

1321: l_action_type_code pa_ci_actions_v.action_type_code%TYPE;
1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1327:
1328: -- This cursor gets the info about the control item.
1329: CURSOR get_ci_info

Line 1384: from pa_ci_actions_v

1380: last_update_date,
1381: status_meaning,
1382: sign_off_required_flag,
1383: sign_off_required_flag_meaning--FP.M.IB1 Sanity
1384: from pa_ci_actions_v
1385: where ci_action_id = c_action_id;
1386:
1387: --Bug 4923945 Begining of Code changes.
1388: --This Cursor is added for the bug# 3691192 to get Ci Owner and Ci Status