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_PVT dependencies on PA_PROJECT_STATUSES

Line 87: From PA_PROJECT_STATUSES

83:
84: l_system_number_id NUMBER(15) := NULL;
85: cursor c_system_stat is
86: Select project_system_status_code
87: From PA_PROJECT_STATUSES
88: Where project_status_code = p_status_code;
89: cp_stat_code c_system_stat%ROWTYPE;
90:
91: cursor c_item_type is

Line 99: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;

95: Where ci_type_id = p_ci_type_id;
96:
97: cp_type c_item_type%ROWTYPE;
98: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
99: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
100: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
101:
102: API_ERROR EXCEPTION;
103: l_auto_number VARCHAR2(1);

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

96:
97: cp_type c_item_type%ROWTYPE;
98: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
99: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
100: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
101:
102: API_ERROR EXCEPTION;
103: l_auto_number VARCHAR2(1);
104: l_type_start_date DATE;

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

474:
475: l_as_of_date DATE := sysdate;
476: l_status_code pa_control_items.status_code%TYPE;
477: l_new_status_code pa_control_items.status_code%TYPE; /* Bug#5676037: Code changes for AMG APIs */
478: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
479: l_auto_numbers VARCHAR2(1) := 'N';
480: l_ci_number pa_control_items.ci_number%TYPE := NULL;
481:
482: --bug 3297238

Line 765: l_status_code pa_project_statuses.project_system_status_code%type;

761: ,x_msg_count OUT NOCOPY NUMBER
762: ,x_msg_data OUT NOCOPY VARCHAR2
763:
764: ) is
765: l_status_code pa_project_statuses.project_system_status_code%type;
766: cursor valid_ci is
767: select pps.project_system_status_code --status_code
768: from pa_control_items ci
769: ,pa_project_statuses pps

Line 769: ,pa_project_statuses pps

765: l_status_code pa_project_statuses.project_system_status_code%type;
766: cursor valid_ci is
767: select pps.project_system_status_code --status_code
768: from pa_control_items ci
769: ,pa_project_statuses pps
770: where ci.ci_id = p_ci_id
771: and ci.status_code = pps.project_status_code;
772: begin
773:

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

998: l_from_type_id NUMBER;
999: l_relationship_id NUMBER;
1000: l_commit VARCHAR2(1) := 'N';
1001: copy_from_row pa_control_items%ROWTYPE;
1002: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1003: l_str number;
1004: l_str1 number;
1005: x_ci_number VARCHAR2(50);
1006:

Line 1045: SELECT distinct ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1041: where pcc1.class_code_id = p_reason);
1042: --Bug#13475251 start.
1043: cursor c_get_status(l_code PA_CONTROL_ITEMS.STATUS_CODE%type)
1044: is
1045: SELECT distinct ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1046: and ps.project_system_status_code =pc.project_system_status_code and ci_type_id = p_ci_type_id
1047: and ps.starting_status_flag = 'Y'
1048: and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code = l_code
1049: ;

Line 1131: -- select distinct count(*) into l_str from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1127:
1128: end if;
1129:
1130: -- Bug#13475251 Changes start.
1131: -- select distinct count(*) into l_str from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1132: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1133: -- and ps.starting_status_flag = 'Y'
1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';
1135: -- if l_str = 1 then

Line 1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';
1135: -- if l_str = 1 then
1136: -- l_ci_system_status := 'CI_DRAFT';
1137: -- else
1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1139: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1140: -- and ps.starting_status_flag = 'Y'
1141: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_WORKING';
1142: -- if l_str1 = 1 then

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

1360:
1361: CURSOR check_params is
1362: SELECT pci.ci_type_id, pctb.ci_type_class_code,
1363: pci.project_id, pps.project_system_status_code
1364: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps
1365: WHERE pci.ci_id = l_ci_id
1366: and pci.ci_type_id = pctb.ci_type_id
1367: and pci.status_code = pps.project_status_code(+);
1368:

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

1715: CURSOR c_curr_item
1716: is
1717: SELECT * FROM pa_control_items
1718: WHERE ci_id = p_ci_id;
1719: l_curr_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1720: l_new_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1721: l_closed_date pa_control_items.date_closed%TYPE;
1722: l_closed_by pa_control_items.closed_by_id%TYPE;
1723: l_ci_number pa_control_items.ci_number%TYPE;

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

1716: is
1717: SELECT * FROM pa_control_items
1718: WHERE ci_id = p_ci_id;
1719: l_curr_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1720: l_new_system_status_code pa_project_statuses.project_system_status_code%TYPE := NULL;
1721: l_closed_date pa_control_items.date_closed%TYPE;
1722: l_closed_by pa_control_items.closed_by_id%TYPE;
1723: l_ci_number pa_control_items.ci_number%TYPE;
1724: l_ci_number_num NUMBER(15) := NULL;

Line 2605: l_status_code pa_project_statuses.project_system_status_code%type;

2601: ,x_msg_count OUT NOCOPY NUMBER
2602: ,x_msg_data OUT NOCOPY VARCHAR2
2603:
2604: ) is
2605: l_status_code pa_project_statuses.project_system_status_code%type;
2606: cursor valid_ci is
2607: select pps.project_system_status_code --status_code
2608: from pa_control_items ci
2609: ,pa_project_statuses pps

Line 2609: ,pa_project_statuses pps

2605: l_status_code pa_project_statuses.project_system_status_code%type;
2606: cursor valid_ci is
2607: select pps.project_system_status_code --status_code
2608: from pa_control_items ci
2609: ,pa_project_statuses pps
2610: where ci.ci_id = p_ci_id
2611: and ci.status_code = pps.project_status_code;
2612:
2613: CURSOR curr_row is