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

Line 1028: ,p_action_id In pa_ci_actions.ci_action_id%TYPE

1024: PROCEDURE START_NOTIFICATION_WF
1025: ( p_item_type In VARCHAR2
1026: ,p_process_name In VARCHAR2
1027: ,p_ci_id In pa_control_items.ci_id%TYPE
1028: ,p_action_id In pa_ci_actions.ci_action_id%TYPE
1029: ,x_item_key Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1030: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1031: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
1032: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1260: ,p_action_id In pa_ci_actions.ci_action_id%TYPE

1256: PROCEDURE set_workflow_attributes
1257: ( p_item_type In VARCHAR2
1258: ,p_process_name In VARCHAR2
1259: ,p_ci_id In pa_control_items.ci_id%TYPE
1260: ,p_action_id In pa_ci_actions.ci_action_id%TYPE
1261: ,p_item_key In NUMBER
1262: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1263: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
1264: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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 1367: CURSOR cur_ci_action_info(c_action_id pa_ci_actions.ci_action_id%TYPE)

1363: FROM pa_project_lists_v
1364: WHERE project_id = l_project_id;
1365:
1366: --This cursor gets the info about the action.
1367: CURSOR cur_ci_action_info(c_action_id pa_ci_actions.ci_action_id%TYPE)
1368: IS
1369: select ci_action_number,
1370: date_required,
1371: create_name,

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

Line 1454: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)

1450: where ci_comment_id =
1451: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1452:
1453: -- This cursor gets the partyid of all the people involved in the hierarchy
1454: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1455: Is
1456: select PA_UTILS.get_party_id(created_by) party_id
1457: from pa_ci_actions
1458: start with ci_action_id = c_action_id

Line 1457: from pa_ci_actions

1453: -- This cursor gets the partyid of all the people involved in the hierarchy
1454: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1455: Is
1456: select PA_UTILS.get_party_id(created_by) party_id
1457: from pa_ci_actions
1458: start with ci_action_id = c_action_id
1459: connect by prior source_ci_action_id = ci_action_id;
1460:
1461: -- Added the cursor for bug 4049901

Line 2025: from pa_ci_actions

2021: IS
2022:
2023: Cursor check_record_changed(p_ci_action_id number,p_record_version_number number) IS
2024: select rowid
2025: from pa_ci_actions
2026: where ci_action_id = p_ci_action_id
2027: and record_version_number = p_record_version_number
2028: for update;
2029:

Line 2033: from pa_ci_actions

2029:
2030: Cursor ci_action(p_ci_action_id number) IS
2031: select ci_id, type_code, assigned_to, date_required,
2032: sign_off_required_flag, source_ci_action_id, created_by, creation_date
2033: from pa_ci_actions
2034: where ci_action_id = p_ci_action_id;
2035:
2036: l_party_id number;
2037: l_created_by number;

Line 2158: PA_CI_ACTIONS_PKG.UPDATE_ROW(

2154: --Fetching the fnd user_id for the action asignee to update who columns
2155: OPEN get_fnd_usr( l_assign_party_id);
2156: FETCH get_fnd_usr INTO l_fnd_usr_id;
2157: CLOSE get_fnd_usr;
2158: PA_CI_ACTIONS_PKG.UPDATE_ROW(
2159: P_CI_ACTION_ID => l_ci_action_id,
2160: P_CI_ID => l_ci_id,
2161: P_STATUS_CODE => 'CI_ACTION_CLOSED',
2162: P_TYPE_CODE => l_type_code,

Line 2179: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

2175:
2176: if (l_comment_text IS NULL) THEN
2177: l_comment_text := ' ';
2178: end if;
2179: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2180: p_api_version => 1.0,
2181: p_init_msg_list => fnd_api.g_true,
2182: p_commit => FND_API.g_false,
2183: p_validate_only => FND_API.g_false,

Line 2254: from pa_ci_actions

2250:
2251: Cursor ci_action(p_ci_action_id number) IS
2252: select ci_id, type_code, assigned_to, date_required,
2253: sign_off_required_flag, source_ci_action_id, created_by, creation_date
2254: from pa_ci_actions
2255: where ci_action_id = p_ci_action_id;
2256:
2257: -- Added the cursor for bug# 3877985 Issue# 2
2258: CURSOR get_fnd_usr( p_party_id NUMBER) IS

Line 2376: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

2372: OPEN is_comment_inserted_cur(l_ci_action_id);
2373: FETCH is_comment_inserted_cur into l_num_var;
2374: IF is_comment_inserted_cur%NOTFOUND THEN
2375: CLOSE is_comment_inserted_cur;
2376: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2377: p_api_version => 1.0,
2378: p_init_msg_list => fnd_api.g_true,
2379: p_commit => FND_API.g_false,
2380: p_validate_only => FND_API.g_false,