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

Line 32: pa_ci_types_b cib,

28: s.project_system_status_code,
29: cib.ci_type_class_code,
30: ci.record_version_number
31: FROM pa_control_items ci,
32: pa_ci_types_b cib,
33: (select project_status_code,
34: project_system_status_code
35: from pa_project_statuses
36: where status_type = 'CONTROL_ITEM') s

Line 114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;

110: l_status_code pa_ci_impacts.status_code%TYPE := null;
111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;

Line 116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;

112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;
119: l_impact_description1 pa_ci_impacts.description%type;
120:

Line 1273: from pa_ci_types_b

1269: cursor get_ci_type_attrs(p_ci_type_id NUMBER) is
1270: select ci_type_class_code,
1271: auto_number_flag,
1272: source_attrs_enabled_flag
1273: from pa_ci_types_b
1274: where ci_type_id = p_ci_type_id;
1275:
1276: /*pa_ci_security_pkg.check_create_ci will check if the current project type and role played by user are allowed
1277: to create the control item of this type. Also it will check for project authority.*/

Line 1287: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;

1283: and trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate);
1284:
1285:
1286: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1287: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1288: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1289: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1290:
1291:

Line 1288: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;

1284:
1285:
1286: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1287: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1288: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1289: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1290:
1291:
1292: l_msg_count NUMBER := 0;

Line 1289: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;

1285:
1286: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1287: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1288: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1289: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1290:
1291:
1292: l_msg_count NUMBER := 0;
1293: l_data VARCHAR2(2000);

Line 1300: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;

1296: l_module_name VARCHAR2(200);
1297: l_check_create_ci VARCHAR2(1);
1298: l_project_id pa_projects_all.project_id%type;
1299: l_ini_proj_id pa_projects_all.project_id%type;
1300: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1301: l_any_err_occured_flg VARCHAR2(1);
1302:
1303: begin
1304: -- initialize the return status to success

Line 1661: ,pa_ci_types_b typ

1657: cursor validate_clsfcation_code(p_classification_code number)
1658: is
1659: select cat.class_code_id code
1660: from pa_class_codes cat
1661: ,pa_ci_types_b typ
1662: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1663: and typ.ci_type_id = p_ci_type_id
1664: and cat.class_category = typ.classification_category
1665: and cat.class_code_id = p_classification_code;

Line 1671: ,pa_ci_types_b typ

1667: cursor validate_reason_code(p_reason_code number)
1668: is
1669: select cat.class_code_id code
1670: from pa_class_codes cat
1671: ,pa_ci_types_b typ
1672: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1673: and typ.ci_type_id = p_ci_type_id
1674: and cat.class_category = typ.reason_category
1675: and cat.class_code_id = p_reason_code;

Line 1701: ,pa_ci_types_b typ

1697: cursor validate_resolution_code(p_resolution_code number)
1698: is
1699: select cat.class_code_id code
1700: from pa_class_codes cat
1701: ,pa_ci_types_b typ
1702: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1703: and typ.ci_type_id= p_ci_type_id
1704: and cat.class_category=typ.resolution_category
1705: and cat.class_code_id = p_resolution_code;