DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on ENG_PARENT_CHILD_EVENTS_TEMP

Line 1017: FROM eng_parent_child_events_temp;

1013: , event_name
1014: , event_key
1015: , erecord_id
1016: , event_status
1017: FROM eng_parent_child_events_temp;
1018:
1019: l_erecord_id NUMBER;
1020: l_parent_child_count NUMBER;
1021: l_return_status VARCHAR2(2);

Line 1074: DELETE FROM eng_parent_child_events_temp

1070: RAISE SEND_ACKN_ERROR;
1071: END IF;
1072: END IF;
1073:
1074: DELETE FROM eng_parent_child_events_temp
1075: WHERE erecord_id = my_events.erecord_id
1076: AND parent_erecord_id = my_events.parent_erecord_id;
1077:
1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;

Line 1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;

1074: DELETE FROM eng_parent_child_events_temp
1075: WHERE erecord_id = my_events.erecord_id
1076: AND parent_erecord_id = my_events.parent_erecord_id;
1077:
1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1080: END LOOP;
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1082:

Line 1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);

1075: WHERE erecord_id = my_events.erecord_id
1076: AND parent_erecord_id = my_events.parent_erecord_id;
1077:
1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1080: END LOOP;
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1082:
1083: EXCEPTION

Line 3780: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

3776:
3777: -- Keep the eRecord id :
3778: IF (NVL(l_event.erecord_id, -1) > 0)
3779: THEN
3780: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
3781: , parent_event_key, parent_erecord_id
3782: , event_name, event_key, erecord_id
3783: , event_status)
3784: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)

Line 7768: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

7764:
7765: -- Keep the eRecord id :
7766: IF (NVL(l_event.erecord_id, -1) > 0)
7767: THEN
7768: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
7769: , parent_event_key, parent_erecord_id
7770: , event_name, event_key, erecord_id
7771: , event_status)
7772: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)

Line 7903: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

7899:
7900: -- Keep the eRecord id :
7901: IF (NVL(l_event.erecord_id, -1) > 0)
7902: THEN
7903: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
7904: , parent_event_key, parent_erecord_id
7905: , event_name, event_key, erecord_id
7906: , event_status)
7907: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)