DBA Data[Home] [Help]

APPS.AMW_CREATE_LINES_PKG dependencies on ENG_CHANGE_ORDER_TYPES

Line 391: from eng_change_order_types ecot

387: /*select ecot.change_order_type_id
388: ,ESE.SUBJECT_ID
389: INTO L_LINE_TYPE_ID
390: ,L_CHANGE_SUBJECT_ID
391: from eng_change_order_types ecot
392: ,eng_subject_entities ese
393: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
394: and ecot.SUBJECT_ID=ese.subject_id
395: AND ESE.ENTITY_NAME='AMW_LINE_PROCESS_ETTY'

Line 460: from eng_change_order_types ecot

456: /*select ecot.change_order_type_id
457: ,ESE.SUBJECT_ID
458: INTO L_DELETE_LINE_TYPE_ID
459: ,L_DELETE_CHANGE_SUBJECT_ID
460: from eng_change_order_types ecot
461: ,eng_subject_entities ese
462: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
463: and ecot.SUBJECT_ID=ese.subject_id
464: AND ESE.ENTITY_NAME='AMW_LINE_DEL_PROCESS_ETTY'

Line 505: from eng_change_order_types ecot

501: /*select ecot.change_order_type_id
502: ,ESE.SUBJECT_ID
503: INTO L_LINE_TYPE_ID
504: ,L_CHANGE_SUBJECT_ID
505: from eng_change_order_types ecot
506: ,eng_subject_entities ese
507: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
508: and ecot.SUBJECT_ID=ese.subject_id
509: AND ESE.ENTITY_NAME='AMW_LINE_RISK_ETTY'

Line 620: from eng_change_order_types ecot

616: select ecot.change_order_type_id
617: ,ESE.SUBJECT_ID
618: INTO L_LINE_TYPE_ID
619: ,L_CHANGE_SUBJECT_ID
620: from eng_change_order_types ecot
621: ,eng_subject_entities ese
622: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
623: and ecot.SUBJECT_ID=ese.subject_id
624: AND ESE.ENTITY_NAME='AMW_LINE_CTRL_ETTY'

Line 637: from eng_change_order_types ecot

633: select ecot.change_order_type_id
634: ,ESE.SUBJECT_ID
635: INTO L_DELETE_LINE_TYPE_ID
636: ,L_DELETE_CHANGE_SUBJECT_ID
637: from eng_change_order_types ecot
638: ,eng_subject_entities ese
639: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
640: and ecot.SUBJECT_ID=ese.subject_id
641: AND ESE.ENTITY_NAME='AMW_LINE_DEL_CTRL_ETTY'

Line 1160: from eng_change_order_types ecot

1156: select ecot.change_order_type_id
1157: ,ESE.SUBJECT_ID
1158: INTO L_LINE_TYPE_ID
1159: ,L_CHANGE_SUBJECT_ID
1160: from eng_change_order_types ecot
1161: ,eng_subject_entities ese
1162: where ecot.change_mgmt_type_code='AMW_PROCESS_ORG_APPROVAL'
1163: and ecot.SUBJECT_ID=ese.subject_id
1164: AND ESE.ENTITY_NAME='AMW_ORG_LINE_CTRL_ETTY'

Line 1177: from eng_change_order_types ecot

1173: select ecot.change_order_type_id
1174: ,ESE.SUBJECT_ID
1175: INTO L_DELETE_LINE_TYPE_ID
1176: ,L_DELETE_CHANGE_SUBJECT_ID
1177: from eng_change_order_types ecot
1178: ,eng_subject_entities ese
1179: where ecot.change_mgmt_type_code='AMW_PROCESS_ORG_APPROVAL'
1180: and ecot.SUBJECT_ID=ese.subject_id
1181: AND ESE.ENTITY_NAME='AMW_ORG_LINE_DEL_CTRL_ETTY'

Line 1400: from eng_change_order_types ecot

1396: L_LINE_TYPE_ID number;
1397: BEGIN
1398: select ecot.change_order_type_id
1399: INTO L_LINE_TYPE_ID
1400: from eng_change_order_types ecot
1401: ,eng_subject_entities ese
1402: where ecot.change_mgmt_type_code=p_change_mgmt_type_code
1403: and ecot.SUBJECT_ID=ese.subject_id
1404: AND ESE.ENTITY_NAME=p_entity_name