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_VTMPLTS

Line 127: oe_pc_vtmplts vt,

123: CURSOR C_VTMPLTCOLS IS
124: SELECT vc.column_name, attr.data_type, vc.validation_op, vc.value_string
125: , decode(attr.state_attribute_flag,NULL,1,'Y',0,'N',1) state_attribute
126: FROM oe_pc_vtmplt_cols vc,
127: oe_pc_vtmplts vt,
128: oe_pc_attributes_v attr
129: WHERE vc.validation_tmplt_id = p_validation_tmplt_id
130: AND vc.validation_tmplt_id = vt.validation_tmplt_id
131: AND attr.entity_id = vt.entity_id

Line 310: FROM oe_pc_vtmplts

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
310: FROM oe_pc_vtmplts
311: WHERE validation_tmplt_id = p_validation_tmplt_id
312: and (validation_type = 'WF'
313: OR validation_type = 'TBL');
314:

Line 323: oe_pc_vtmplts vt,

319: CURSOR C_VTMPLTCOLS IS
320: SELECT vc.column_name, attr.data_type, vc.validation_op, vc.value_string
321: , decode(attr.state_attribute_flag,NULL,1,'Y',0,'N',1) state_attribute
322: FROM oe_pc_vtmplt_cols vc,
323: oe_pc_vtmplts vt,
324: oe_pc_attributes_v attr
325: WHERE vc.validation_tmplt_id = p_validation_tmplt_id
326: AND vc.validation_tmplt_id = vt.validation_tmplt_id
327: AND attr.entity_id = vt.entity_id

Line 404: l_validation_type OE_PC_VTMPLTS.VALIDATION_TYPE%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;
407: l_wf_activity_result_code OE_PC_VTMPLTS.ACTIVITY_RESULT_CODE%TYPE;
408: l_value_string VARCHAR2(240);

Line 405: l_wf_activity_name OE_PC_VTMPLTS.ACTIVITY_NAME%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;
407: l_wf_activity_result_code OE_PC_VTMPLTS.ACTIVITY_RESULT_CODE%TYPE;
408: l_value_string VARCHAR2(240);
409: l_ve_condn_sql VARCHAR2(240);

Line 406: l_wf_activity_status_code OE_PC_VTMPLTS.ACTIVITY_STATUS_CODE%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;
407: l_wf_activity_result_code OE_PC_VTMPLTS.ACTIVITY_RESULT_CODE%TYPE;
408: l_value_string VARCHAR2(240);
409: l_ve_condn_sql VARCHAR2(240);
410: from_char NUMBER;

Line 407: l_wf_activity_result_code OE_PC_VTMPLTS.ACTIVITY_RESULT_CODE%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;
407: l_wf_activity_result_code OE_PC_VTMPLTS.ACTIVITY_RESULT_CODE%TYPE;
408: l_value_string VARCHAR2(240);
409: l_ve_condn_sql VARCHAR2(240);
410: from_char NUMBER;
411: found_char NUMBER;