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 1128: ,p_action_id In pa_ci_actions.ci_action_id%TYPE

1124: PROCEDURE START_NOTIFICATION_WF
1125: ( p_item_type In VARCHAR2
1126: ,p_process_name In VARCHAR2
1127: ,p_ci_id In pa_control_items.ci_id%TYPE
1128: ,p_action_id In pa_ci_actions.ci_action_id%TYPE
1129: ,x_item_key Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1130: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1131: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
1132: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1363: ,p_action_id In pa_ci_actions.ci_action_id%TYPE

1359: PROCEDURE set_workflow_attributes
1360: ( p_item_type In VARCHAR2
1361: ,p_process_name In VARCHAR2
1362: ,p_ci_id In pa_control_items.ci_id%TYPE
1363: ,p_action_id In pa_ci_actions.ci_action_id%TYPE
1364: ,p_item_key In NUMBER
1365: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1366: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
1367: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1476: FROM pa_project_lists_v
1477: WHERE project_id = l_project_id;
1478:
1479: --This cursor gets the info about the action.
1480: CURSOR cur_ci_action_info(c_action_id pa_ci_actions.ci_action_id%TYPE)
1481: IS
1482: select ci_action_number,
1483: date_required,
1484: create_name,

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

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

1563: where ci_comment_id =
1564: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1565:
1566: -- This cursor gets the partyid of all the people involved in the hierarchy
1567: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1568: Is
1569: select PA_UTILS.get_party_id(created_by) party_id
1570: from pa_ci_actions
1571: start with ci_action_id = c_action_id

Line 1570: from pa_ci_actions

1566: -- This cursor gets the partyid of all the people involved in the hierarchy
1567: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1568: Is
1569: select PA_UTILS.get_party_id(created_by) party_id
1570: from pa_ci_actions
1571: start with ci_action_id = c_action_id
1572: connect by prior source_ci_action_id = ci_action_id;
1573:
1574: -- Added the cursor for bug 4049901

Line 2228: from pa_ci_actions

2224: IS
2225:
2226: Cursor check_record_changed(p_ci_action_id number,p_record_version_number number) IS
2227: select rowid
2228: from pa_ci_actions
2229: where ci_action_id = p_ci_action_id
2230: and record_version_number = p_record_version_number
2231: for update;
2232:

Line 2236: from pa_ci_actions

2232:
2233: Cursor ci_action(p_ci_action_id number) IS
2234: select ci_id, type_code, assigned_to, date_required,
2235: sign_off_required_flag, source_ci_action_id, created_by, creation_date
2236: from pa_ci_actions
2237: where ci_action_id = p_ci_action_id;
2238:
2239: l_party_id number;
2240: l_created_by number;

Line 2283: from pa_ci_actions

2279: and rownum = 1;
2280: -- Bug#12859815 start.
2281: Cursor check_action_closed is
2282: SELECT status_code into l_action_status_code
2283: from pa_ci_actions
2284: where ci_action_id = l_ci_action_id;
2285:
2286: BEGIN
2287: -- Initialize the Error Stack

Line 2381: PA_CI_ACTIONS_PKG.UPDATE_ROW(

2377: --Fetching the fnd user_id for the action asignee to update who columns
2378: OPEN get_fnd_usr( l_assign_party_id);
2379: FETCH get_fnd_usr INTO l_fnd_usr_id;
2380: CLOSE get_fnd_usr;
2381: PA_CI_ACTIONS_PKG.UPDATE_ROW(
2382: P_CI_ACTION_ID => l_ci_action_id,
2383: P_CI_ID => l_ci_id,
2384: P_STATUS_CODE => l_action_status_code,
2385: P_TYPE_CODE => l_type_code,

Line 2405: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

2401: THEN
2402: if (l_comment_text IS NULL) THEN
2403: l_comment_text := ' ';
2404: end if;
2405: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2406: p_api_version => 1.0,
2407: p_init_msg_list => fnd_api.g_true,
2408: p_commit => FND_API.g_false,
2409: p_validate_only => FND_API.g_false,

Line 2497: from pa_ci_actions

2493:
2494: Cursor ci_action(p_ci_action_id number) IS
2495: select ci_id, type_code, assigned_to, date_required,
2496: sign_off_required_flag, source_ci_action_id, created_by, creation_date
2497: from pa_ci_actions
2498: where ci_action_id = p_ci_action_id;
2499:
2500: -- Added the cursor for bug# 3877985 Issue# 2
2501: CURSOR get_fnd_usr( p_party_id NUMBER) IS

Line 2619: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

2615: OPEN is_comment_inserted_cur(l_ci_action_id);
2616: FETCH is_comment_inserted_cur into l_num_var;
2617: IF is_comment_inserted_cur%NOTFOUND THEN
2618: CLOSE is_comment_inserted_cur;
2619: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
2620: p_api_version => 1.0,
2621: p_init_msg_list => fnd_api.g_true,
2622: p_commit => FND_API.g_false,
2623: p_validate_only => FND_API.g_false,