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.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_ENTITIES_V

Line 284: l_wf_item_type OE_PC_ENTITIES_V.WF_ITEM_TYPE%TYPE;

280: l_vc_pk_list varchar2(1000);
281: l_rs_pk_list varchar2(1000);
282: l_concatenated_itemkey_columns varchar2(1000);
283:
284: l_wf_item_type OE_PC_ENTITIES_V.WF_ITEM_TYPE%TYPE;
285:
286: CURSOR C_VTBL IS
287: SELECT application_id, db_object_name, db_object_type,
288: wf_item_type, itemkey_column1, itemkey_column2,

Line 290: FROM OE_PC_ENTITIES_V

286: CURSOR C_VTBL IS
287: SELECT application_id, db_object_name, db_object_type,
288: wf_item_type, itemkey_column1, itemkey_column2,
289: itemkey_column3,itemkey_column4, itemkey_delimiter
290: FROM OE_PC_ENTITIES_V
291: where entity_id = p_validation_entity_id;
292:
293: CURSOR C_VTBL1 IS
294: SELECT e.application_id, e.db_object_name, e.db_object_type,

Line 297: FROM OE_PC_ENTITIES_V e, OE_AK_OBJ_WF_ITEMS wf

293: CURSOR C_VTBL1 IS
294: SELECT e.application_id, e.db_object_name, e.db_object_type,
295: wf.itemkey_column1, wf.itemkey_column2,
296: wf.itemkey_column3,wf.itemkey_column4, wf.itemkey_delimiter
297: FROM OE_PC_ENTITIES_V e, OE_AK_OBJ_WF_ITEMS wf
298: where e.entity_id = p_validation_entity_id
299: and wf.database_object_name(+) = e.db_object_name
300: and (l_wf_item_type IS NULL
301: or wf.item_type = l_wf_item_type);

Line 305: FROM OE_PC_ENTITIES_V

301: or wf.item_type = l_wf_item_type);
302:
303: CURSOR C_DTBL IS
304: SELECT application_id, db_object_name, db_object_type
305: FROM OE_PC_ENTITIES_V
306: where entity_id = p_entity_id;
307:
308: CURSOR C_VTMPLT IS
309: SELECT validation_type, activity_name, activity_status_code, activity_result_code, wf_item_type

Line 391: l_driver_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;

387: --the foreign key may be on either of the entities, if you treat
388: --the problem as generic) to navigate to the HEADER.
389: ------------------------------------------------------------------------
390: l_driver_appln_id number;
391: l_driver_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
392: l_driver_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
393: l_driver_entity_fk_flag varchar2(1) := 'N';
394:
395: l_validation_appln_id number;

Line 392: l_driver_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;

388: --the problem as generic) to navigate to the HEADER.
389: ------------------------------------------------------------------------
390: l_driver_appln_id number;
391: l_driver_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
392: l_driver_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
393: l_driver_entity_fk_flag varchar2(1) := 'N';
394:
395: l_validation_appln_id number;
396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;

Line 396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;

392: l_driver_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
393: l_driver_entity_fk_flag varchar2(1) := 'N';
394:
395: l_validation_appln_id number;
396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;

Line 397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;

393: l_driver_entity_fk_flag varchar2(1) := 'N';
394:
395: l_validation_appln_id number;
396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;

Line 398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;

394:
395: l_validation_appln_id number;
396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;
402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;

Line 399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;

395: l_validation_appln_id number;
396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;
402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;
403: l_pk_record_set_flag OE_PC_RSETS.pk_record_set_flag%TYPE;

Line 400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;

396: l_validation_db_object_name OE_PC_ENTITIES_V.db_object_name%TYPE;
397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;
402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;
403: l_pk_record_set_flag OE_PC_RSETS.pk_record_set_flag%TYPE;
404: l_validation_type OE_PC_VTMPLTS.VALIDATION_TYPE%TYPE;

Line 401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;

397: l_validation_db_object_type OE_PC_ENTITIES_V.db_object_type%TYPE;
398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;
402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;
403: l_pk_record_set_flag OE_PC_RSETS.pk_record_set_flag%TYPE;
404: l_validation_type OE_PC_VTMPLTS.VALIDATION_TYPE%TYPE;
405: l_wf_activity_name OE_PC_VTMPLTS.ACTIVITY_NAME%TYPE;

Line 402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;

398: l_itemkey_column1 OE_PC_ENTITIES_V.ITEMKEY_COLUMN1%TYPE;
399: l_itemkey_column2 OE_PC_ENTITIES_V.ITEMKEY_COLUMN2%TYPE;
400: l_itemkey_column3 OE_PC_ENTITIES_V.ITEMKEY_COLUMN3%TYPE;
401: l_itemkey_column4 OE_PC_ENTITIES_V.ITEMKEY_COLUMN4%TYPE;
402: l_itemkey_delimiter OE_PC_ENTITIES_V.ITEMKEY_DELIMITER%TYPE;
403: l_pk_record_set_flag OE_PC_RSETS.pk_record_set_flag%TYPE;
404: l_validation_type OE_PC_VTMPLTS.VALIDATION_TYPE%TYPE;
405: l_wf_activity_name OE_PC_VTMPLTS.ACTIVITY_NAME%TYPE;
406: l_wf_activity_status_code OE_PC_VTMPLTS.ACTIVITY_STATUS_CODE%TYPE;