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 1256: from pa_ci_types_b

1252: cursor get_ci_type_attrs(p_ci_type_id NUMBER) is
1253: select ci_type_class_code,
1254: auto_number_flag,
1255: source_attrs_enabled_flag
1256: from pa_ci_types_b
1257: where ci_type_id = p_ci_type_id;
1258:
1259: /*pa_ci_security_pkg.check_create_ci will check if the current project type and role played by user are allowed
1260: to create the control item of this type. Also it will check for project authority.*/

Line 1270: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;

1266: and trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate);
1267:
1268:
1269: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1270: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1271: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1272: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1273:
1274:

Line 1271: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;

1267:
1268:
1269: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1270: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1271: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1272: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1273:
1274:
1275: l_msg_count NUMBER := 0;

Line 1272: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;

1268:
1269: l_ci_type_attrs_rec get_ci_type_attrs%rowtype;
1270: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%type;
1271: l_auto_number_flag pa_ci_types_b.auto_number_flag%type;
1272: l_source_attrs_enabled_flag pa_ci_types_b.source_attrs_enabled_flag%type;
1273:
1274:
1275: l_msg_count NUMBER := 0;
1276: l_data VARCHAR2(2000);

Line 1283: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;

1279: l_module_name VARCHAR2(200);
1280: l_check_create_ci VARCHAR2(1);
1281: l_project_id pa_projects_all.project_id%type;
1282: l_ini_proj_id pa_projects_all.project_id%type;
1283: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1284: l_any_err_occured_flg VARCHAR2(1);
1285:
1286: begin
1287: -- initialize the return status to success

Line 1644: ,pa_ci_types_b typ

1640: cursor validate_clsfcation_code(p_classification_code number)
1641: is
1642: select cat.class_code_id code
1643: from pa_class_codes cat
1644: ,pa_ci_types_b typ
1645: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1646: and typ.ci_type_id = p_ci_type_id
1647: and cat.class_category = typ.classification_category
1648: and cat.class_code_id = p_classification_code;

Line 1654: ,pa_ci_types_b typ

1650: cursor validate_reason_code(p_reason_code number)
1651: is
1652: select cat.class_code_id code
1653: from pa_class_codes cat
1654: ,pa_ci_types_b typ
1655: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1656: and typ.ci_type_id = p_ci_type_id
1657: and cat.class_category = typ.reason_category
1658: and cat.class_code_id = p_reason_code;

Line 1684: ,pa_ci_types_b typ

1680: cursor validate_resolution_code(p_resolution_code number)
1681: is
1682: select cat.class_code_id code
1683: from pa_class_codes cat
1684: ,pa_ci_types_b typ
1685: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1686: and typ.ci_type_id= p_ci_type_id
1687: and cat.class_category=typ.resolution_category
1688: and cat.class_code_id = p_resolution_code;