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.

[Home] [Help]

APPS.ENGPKIMP dependencies on ENG_PARENT_CHILD_EVENTS_TEMP

Line 945: FROM eng_parent_child_events_temp;

941: , event_name
942: , event_key
943: , erecord_id
944: , event_status
945: FROM eng_parent_child_events_temp;
946:
947: l_erecord_id NUMBER;
948: l_parent_child_count NUMBER;
949: l_return_status VARCHAR2(2);

Line 1002: DELETE FROM eng_parent_child_events_temp

998: RAISE SEND_ACKN_ERROR;
999: END IF;
1000: END IF;
1001:
1002: DELETE FROM eng_parent_child_events_temp
1003: WHERE erecord_id = my_events.erecord_id
1004: AND parent_erecord_id = my_events.parent_erecord_id;
1005:
1006: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;

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

1002: DELETE FROM eng_parent_child_events_temp
1003: WHERE erecord_id = my_events.erecord_id
1004: AND parent_erecord_id = my_events.parent_erecord_id;
1005:
1006: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1007: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1008: END LOOP;
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1010:

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

1003: WHERE erecord_id = my_events.erecord_id
1004: AND parent_erecord_id = my_events.parent_erecord_id;
1005:
1006: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1007: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1008: END LOOP;
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1010:
1011: EXCEPTION

Line 3536: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

3532:
3533: -- Keep the eRecord id :
3534: IF (NVL(l_event.erecord_id, -1) > 0)
3535: THEN
3536: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
3537: , parent_event_key, parent_erecord_id
3538: , event_name, event_key, erecord_id
3539: , event_status)
3540: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)

Line 7445: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

7441:
7442: -- Keep the eRecord id :
7443: IF (NVL(l_event.erecord_id, -1) > 0)
7444: THEN
7445: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
7446: , parent_event_key, parent_erecord_id
7447: , event_name, event_key, erecord_id
7448: , event_status)
7449: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)

Line 7580: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name

7576:
7577: -- Keep the eRecord id :
7578: IF (NVL(l_event.erecord_id, -1) > 0)
7579: THEN
7580: INSERT INTO ENG_PARENT_CHILD_EVENTS_TEMP(parent_event_name
7581: , parent_event_key, parent_erecord_id
7582: , event_name, event_key, erecord_id
7583: , event_status)
7584: VALUES ( 'oracle.apps.eng.ecoImplement', TO_CHAR(item.change_id)