APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_PROJECT_STATUSES

Line 74: From PA_PROJECT_STATUSES

70:
71: l_system_number_id NUMBER(15) := NULL;
72: cursor c_system_stat is
73: Select project_system_status_code
74: From PA_PROJECT_STATUSES
75: Where project_status_code = p_status_code;
76: cp_stat_code c_system_stat%ROWTYPE;
77:
78: cursor c_item_type is

Line 86: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;

82: Where ci_type_id = p_ci_type_id;
83:
84: cp_type c_item_type%ROWTYPE;
85: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
86: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
87: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
88:
89: API_ERROR EXCEPTION;
90: l_auto_number VARCHAR2(1);

Line 87: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';

83:
84: cp_type c_item_type%ROWTYPE;
85: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
86: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
87: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
88:
89: API_ERROR EXCEPTION;
90: l_auto_number VARCHAR2(1);
91: l_type_start_date DATE;

Line 439: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;

435:
436: l_as_of_date DATE := sysdate;
437: l_status_code pa_control_items.status_code%TYPE;
438: l_new_status_code pa_control_items.status_code%TYPE; /* Bug#5676037: Code changes for AMG APIs */
439: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
440: l_auto_numbers VARCHAR2(1) := 'N';
441: l_ci_number pa_control_items.ci_number%TYPE := NULL;
442:
443: --bug 3297238

Line 689: l_status_code pa_project_statuses.project_system_status_code%type;

685: ,x_msg_count OUT NOCOPY NUMBER
686: ,x_msg_data OUT NOCOPY VARCHAR2
687:
688: ) is
689: l_status_code pa_project_statuses.project_system_status_code%type;
690: cursor valid_ci is
691: select pps.project_system_status_code --status_code
692: from pa_control_items ci
693: ,pa_project_statuses pps

Line 693: ,pa_project_statuses pps

689: l_status_code pa_project_statuses.project_system_status_code%type;
690: cursor valid_ci is
691: select pps.project_system_status_code --status_code
692: from pa_control_items ci
693: ,pa_project_statuses pps
694: where ci.ci_id = p_ci_id
695: and ci.status_code = pps.project_status_code;
696: begin
697:

Line 1231: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps

1227:
1228: CURSOR check_params is
1229: SELECT pci.ci_type_id, pctb.ci_type_class_code,
1230: pci.project_id, pps.project_system_status_code
1231: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps
1232: WHERE pci.ci_id = l_ci_id
1233: and pci.ci_type_id = pctb.ci_type_id
1234: and pci.status_code = pps.project_status_code(+);
1235:

Line 1570: l_curr_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;

1566: CURSOR c_curr_item
1567: is
1568: SELECT * FROM pa_control_items
1569: WHERE ci_id = p_ci_id;
1570: l_curr_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1571: l_new_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1572: l_closed_date pa_control_items.date_closed%TYPE;
1573: l_closed_by pa_control_items.closed_by_id%TYPE;
1574: l_ci_number pa_control_items.ci_number%TYPE;

Line 1571: l_new_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;

1567: is
1568: SELECT * FROM pa_control_items
1569: WHERE ci_id = p_ci_id;
1570: l_curr_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1571: l_new_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1572: l_closed_date pa_control_items.date_closed%TYPE;
1573: l_closed_by pa_control_items.closed_by_id%TYPE;
1574: l_ci_number pa_control_items.ci_number%TYPE;
1575: l_ci_number_num NUMBER(15) := NULL;