[Home] [Help]
385: l_num_of_actions NUMBER;
386: l_status VARCHAR2(30);
387: -- #Bug#13683760 changes start.
388: cursor c_get_working_status_code (p_ci_id NUMBER) is
389: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci
390: where ci.ci_id = p_ci_id and ci.ci_type_id = pc.ci_type_id
391: and ps.project_status_code=pc.project_status_code
392: and ps.project_system_status_code =pc.project_system_status_code
393: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;
393: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;
394: -- #Bug#13683760 changes end.
395: cursor c_status(p_ci_id NUMBER, p_item_type VARCHAR2) is
396: SELECT wf_failure_status_code
397: FROM pa_project_statuses ps,
398: pa_control_items ci
399: WHERE ci.ci_id = p_ci_id
400: and ci.status_code = ps.project_status_code
401: and ps.status_type = 'CONTROL_ITEM'
537: l_num_of_actions NUMBER;
538:
539: cursor c_status(p_ci_id NUMBER, p_item_type VARCHAR2) is
540: SELECT wf_success_status_code
541: FROM pa_project_statuses ps,
542: pa_control_items ci
543: WHERE ci.ci_id = p_ci_id
544: and ci.status_code = ps.project_status_code
545: and ps.status_type = 'CONTROL_ITEM'
556: l_user_id fnd_user.user_id%type;
557: -- End for Bug 6053648
558: -- #Bug#13683760 changes start.
559: cursor c_get_working_status_code (p_ci_id NUMBER) is
560: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci
561: where ci.ci_id = p_ci_id and ci.ci_type_id = pc.ci_type_id
562: and ps.project_status_code=pc.project_status_code
563: and ps.project_system_status_code =pc.project_system_status_code
564: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;
1505: pps.project_status_name,
1506: pci.owner_id,
1507: hzp.party_name
1508: from pa_control_items pci,
1509: pa_project_statuses pps,
1510: hz_parties hzp
1511: where pci.ci_id = p_ci_id AND
1512: pci.status_code=pps.project_status_code AND
1513: hzp.party_id = pci.owner_id;