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_API_PUB dependencies on PA_CI_TYPES_B

Line 30: pa_ci_types_b cib,

26: s.project_system_status_code,
27: cib.ci_type_class_code,
28: ci.record_version_number
29: FROM pa_control_items ci,
30: pa_ci_types_b cib,
31: (select
32: project_status_code,
33: project_system_status_code
34: from pa_project_statuses

Line 62: FROM pa_control_items pci, pa_ci_types_b pcit

58: or CHANGE_ORDER) for a particular Control Item.
59: */
60: CURSOR Get_CI_Type_Class_Code (c_Ci_Id NUMBER) IS
61: SELECT pcit.ci_type_class_code
62: FROM pa_control_items pci, pa_ci_types_b pcit
63: WHERE pci.ci_id = c_Ci_Id
64: AND pcit.ci_type_id = pci.ci_type_id;
65:
66: /*Procedure to add workplan impact*/

Line 1624: pa_ci_types_b typ

1620: cat.class_category class_category,
1621: cat.class_code description,
1622: cat.class_code_id code
1623: from pa_class_codes cat,
1624: pa_ci_types_b typ
1625: where trunc(sysdate) between cat.start_date_active and
1626: nvl(cat.end_date_active,trunc(sysdate))
1627: and typ.ci_type_id=c_ci_type_id
1628: and cat.class_category=typ.resolution_category

Line 1637: pa_ci_types_b cit,

1633: SELECT cit.ci_type_class_code,
1634: cit.approval_required_flag,
1635: s.next_allowable_status_flag
1636: FROM pa_control_items c,
1637: pa_ci_types_b cit,
1638: pa_project_statuses s
1639: WHERE c.ci_id = p_ci_id
1640: AND c.status_code = s.project_status_code
1641: AND c.ci_type_id =cit.ci_type_id

Line 1720: l_citypeclasscode pa_ci_types_b.ci_type_class_Code%TYPE;

1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:
1718: l_projectid pa_control_items.project_id%TYPE;
1719: l_proj_status_code pa_project_statuses.project_system_status_code%TYPE;
1720: l_citypeclasscode pa_ci_types_b.ci_type_class_Code%TYPE;
1721:
1722: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
1723: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
1724: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

Line 1724: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

1720: l_citypeclasscode pa_ci_types_b.ci_type_class_Code%TYPE;
1721:
1722: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
1723: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
1724: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
1725: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
1726:
1727: l_enforce_security VARCHAR2(1) := 'Y';
1728: l_start_wf VARCHAR2(1) := 'Y';

Line 1725: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;

1721:
1722: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
1723: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
1724: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
1725: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
1726:
1727: l_enforce_security VARCHAR2(1) := 'Y';
1728: l_start_wf VARCHAR2(1) := 'Y';
1729: l_num_of_actions NUMBER;

Line 2412: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;

2408:
2409: l_module_name VARCHAR2(200);
2410:
2411:
2412: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
2413: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
2414: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
2415:
2416: l_msg_count NUMBER := 0;

Line 2413: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;

2409: l_module_name VARCHAR2(200);
2410:
2411:
2412: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
2413: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
2414: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
2415:
2416: l_msg_count NUMBER := 0;
2417: l_data VARCHAR2(2000);

Line 2414: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;

2410:
2411:
2412: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
2413: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
2414: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
2415:
2416: l_msg_count NUMBER := 0;
2417: l_data VARCHAR2(2000);
2418: l_msg_data VARCHAR2(2000);

Line 2424: l_ci_type_id pa_ci_types_b.ci_type_id%type;

2420:
2421: l_project_id pa_projects_all.project_id%type;
2422: l_project_name pa_projects_all.name%type;
2423: l_project_number pa_projects_all.segment1%type;
2424: l_ci_type_id pa_ci_types_b.ci_type_id%type;
2425: l_summary pa_control_items.summary%type;
2426: l_ci_number pa_control_items.ci_number%type;
2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;

Line 3047: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;

3043:
3044: l_module_name VARCHAR2(200);
3045:
3046:
3047: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3048: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3049: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3050:
3051: l_msg_count NUMBER := 0;

Line 3048: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;

3044: l_module_name VARCHAR2(200);
3045:
3046:
3047: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3048: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3049: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3050:
3051: l_msg_count NUMBER := 0;
3052: l_data VARCHAR2(2000);

Line 3049: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;

3045:
3046:
3047: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3048: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3049: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3050:
3051: l_msg_count NUMBER := 0;
3052: l_data VARCHAR2(2000);
3053: l_msg_data VARCHAR2(2000);

Line 3059: l_ci_type_id pa_ci_types_b.ci_type_id%type;

3055:
3056: l_project_id pa_projects_all.project_id%type;
3057: l_project_name pa_projects_all.name%type;
3058: l_project_number pa_projects_all.segment1%type;
3059: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3060: l_summary pa_control_items.summary%type;
3061: l_ci_number pa_control_items.ci_number%type;
3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;

Line 3682: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;

3678:
3679: l_module_name VARCHAR2(200);
3680:
3681:
3682: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3683: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3684: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3685:
3686: l_msg_count NUMBER := 0;

Line 3683: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;

3679: l_module_name VARCHAR2(200);
3680:
3681:
3682: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3683: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3684: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3685:
3686: l_msg_count NUMBER := 0;
3687: l_data VARCHAR2(2000);

Line 3684: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;

3680:
3681:
3682: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
3683: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
3684: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
3685:
3686: l_msg_count NUMBER := 0;
3687: l_data VARCHAR2(2000);
3688: l_msg_data VARCHAR2(2000);

Line 3694: l_ci_type_id pa_ci_types_b.ci_type_id%type;

3690:
3691: l_project_id pa_projects_all.project_id%type;
3692: l_project_name pa_projects_all.name%type;
3693: l_project_number pa_projects_all.segment1%type;
3694: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3695: l_summary pa_control_items.summary%type;
3696: l_ci_number pa_control_items.ci_number%type;
3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;

Line 6667: pa_ci_types_b typ

6663:
6664: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
6665: SELECT cat.class_code_id
6666: FROM pa_class_codes cat,
6667: pa_ci_types_b typ
6668: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6669: AND typ.ci_type_id = p_ci_type_id
6670: AND cat.class_category = typ.classification_category
6671: AND cat.class_code_id = p_class_code_id;

Line 6676: pa_ci_types_b typ

6672:
6673: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
6674: SELECT cat.class_code_id
6675: FROM pa_class_codes cat,
6676: pa_ci_types_b typ
6677: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6678: AND typ.ci_type_id = p_ci_type_id
6679: AND cat.class_category = typ.reason_category
6680: AND cat.class_code_id = p_reason_code_id;

Line 6685: pa_ci_types_b typ

6681:
6682: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
6683: SELECT cat.class_code_id
6684: FROM pa_class_codes cat,
6685: pa_ci_types_b typ
6686: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6687: AND typ.ci_type_id = p_ci_type_id
6688: AND cat.class_category = typ.resolution_category
6689: AND cat.class_code_id = p_resolution_code_id;

Line 6693: FROM pa_ci_types_b type,

6689: AND cat.class_code_id = p_resolution_code_id;
6690:
6691: CURSOR c_auto_num IS
6692: SELECT type.auto_number_flag
6693: FROM pa_ci_types_b type,
6694: pa_control_items ci
6695: WHERE ci.ci_id = p_ci_id
6696: AND ci.ci_type_id = type.ci_type_id;
6697:

Line 6711: pa_ci_types_b cit,

6707: SELECT cit.ci_type_class_code,
6708: cit.approval_required_flag,
6709: s.next_allowable_status_flag
6710: FROM pa_control_items c,
6711: pa_ci_types_b cit,
6712: pa_project_statuses s
6713: WHERE c.ci_id = p_ci_id
6714: AND c.status_code = s.project_status_code
6715: AND c.ci_type_id =cit.ci_type_id

Line 6755: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

6751: l_auto_numbers VARCHAR2(1);
6752: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
6753: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
6754: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
6755: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
6756: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
6757: l_resolution_check VARCHAR2(10) := 'AMG';
6758: l_resolution_req VARCHAR2(10) := 'N';
6759: l_resolution_req_cls VARCHAR2(10) := 'N';

Line 6756: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;

6752: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
6753: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
6754: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
6755: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
6756: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
6757: l_resolution_check VARCHAR2(10) := 'AMG';
6758: l_resolution_req VARCHAR2(10) := 'N';
6759: l_resolution_req_cls VARCHAR2(10) := 'N';
6760: l_to_status_flag VARCHAR2(10) := 'Y';

Line 7927: pa_ci_types_b typ

7923:
7924: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
7925: SELECT cat.class_code_id
7926: FROM pa_class_codes cat,
7927: pa_ci_types_b typ
7928: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7929: AND typ.ci_type_id = p_ci_type_id
7930: AND cat.class_category = typ.classification_category
7931: AND cat.class_code_id = p_class_code_id;

Line 7936: pa_ci_types_b typ

7932:
7933: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
7934: SELECT cat.class_code_id
7935: FROM pa_class_codes cat,
7936: pa_ci_types_b typ
7937: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7938: AND typ.ci_type_id = p_ci_type_id
7939: AND cat.class_category = typ.reason_category
7940: AND cat.class_code_id = p_reason_code_id;

Line 7945: pa_ci_types_b typ

7941:
7942: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
7943: SELECT cat.class_code_id
7944: FROM pa_class_codes cat,
7945: pa_ci_types_b typ
7946: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7947: AND typ.ci_type_id = p_ci_type_id
7948: AND cat.class_category = typ.resolution_category
7949: AND cat.class_code_id = p_resolution_code_id;

Line 7953: FROM pa_ci_types_b type,

7949: AND cat.class_code_id = p_resolution_code_id;
7950:
7951: CURSOR c_auto_num IS
7952: SELECT type.auto_number_flag
7953: FROM pa_ci_types_b type,
7954: pa_control_items ci
7955: WHERE ci.ci_id = p_ci_id
7956: AND ci.ci_type_id = type.ci_type_id;
7957:

Line 7971: pa_ci_types_b cit,

7967: SELECT cit.ci_type_class_code,
7968: cit.approval_required_flag,
7969: s.next_allowable_status_flag
7970: FROM pa_control_items c,
7971: pa_ci_types_b cit,
7972: pa_project_statuses s
7973: WHERE c.ci_id = p_ci_id
7974: AND c.status_code = s.project_status_code
7975: AND c.ci_type_id =cit.ci_type_id

Line 8015: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

8011: l_auto_numbers VARCHAR2(1);
8012: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
8013: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
8014: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
8015: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
8016: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
8017: l_resolution_check VARCHAR2(10) := 'AMG';
8018: l_resolution_req VARCHAR2(10) := 'N';
8019: l_resolution_req_cls VARCHAR2(10) := 'N';

Line 8016: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;

8012: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
8013: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
8014: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
8015: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
8016: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
8017: l_resolution_check VARCHAR2(10) := 'AMG';
8018: l_resolution_req VARCHAR2(10) := 'N';
8019: l_resolution_req_cls VARCHAR2(10) := 'N';
8020: l_to_status_flag VARCHAR2(10) := 'Y';

Line 9184: pa_ci_types_b typ

9180:
9181: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
9182: SELECT cat.class_code_id
9183: FROM pa_class_codes cat,
9184: pa_ci_types_b typ
9185: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9186: AND typ.ci_type_id = p_ci_type_id
9187: AND cat.class_category = typ.classification_category
9188: AND cat.class_code_id = p_class_code_id;

Line 9193: pa_ci_types_b typ

9189:
9190: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
9191: SELECT cat.class_code_id
9192: FROM pa_class_codes cat,
9193: pa_ci_types_b typ
9194: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9195: AND typ.ci_type_id = p_ci_type_id
9196: AND cat.class_category = typ.reason_category
9197: AND cat.class_code_id = p_reason_code_id;

Line 9202: pa_ci_types_b typ

9198:
9199: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
9200: SELECT cat.class_code_id
9201: FROM pa_class_codes cat,
9202: pa_ci_types_b typ
9203: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9204: AND typ.ci_type_id = p_ci_type_id
9205: AND cat.class_category = typ.resolution_category
9206: AND cat.class_code_id = p_resolution_code_id;

Line 9210: FROM pa_ci_types_b type,

9206: AND cat.class_code_id = p_resolution_code_id;
9207:
9208: CURSOR c_auto_num IS
9209: SELECT type.auto_number_flag
9210: FROM pa_ci_types_b type,
9211: pa_control_items ci
9212: WHERE ci.ci_id = p_ci_id
9213: AND ci.ci_type_id = type.ci_type_id;
9214:

Line 9228: pa_ci_types_b cit,

9224: SELECT cit.ci_type_class_code,
9225: cit.approval_required_flag,
9226: s.next_allowable_status_flag
9227: FROM pa_control_items c,
9228: pa_ci_types_b cit,
9229: pa_project_statuses s
9230: WHERE c.ci_id = p_ci_id
9231: AND c.status_code = s.project_status_code
9232: AND c.ci_type_id =cit.ci_type_id

Line 9272: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

9268: l_auto_numbers VARCHAR2(1);
9269: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
9270: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
9271: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
9272: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
9273: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
9274: l_resolution_check VARCHAR2(10) := 'AMG';
9275: l_resolution_req VARCHAR2(10) := 'N';
9276: l_resolution_req_cls VARCHAR2(10) := 'N';

Line 9273: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;

9269: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;
9270: l_new_system_status pa_project_statuses.project_system_status_code%TYPE;
9271: l_next_allow_status_flag pa_project_statuses.next_allowable_status_flag%TYPE;
9272: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
9273: l_approval_required_flag pa_ci_types_b.approval_required_flag%TYPE;
9274: l_resolution_check VARCHAR2(10) := 'AMG';
9275: l_resolution_req VARCHAR2(10) := 'N';
9276: l_resolution_req_cls VARCHAR2(10) := 'N';
9277: l_to_status_flag VARCHAR2(10) := 'Y';