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.XNP_CORE dependencies on XNP_SV_EVENT_HISTORY

Line 1038: -- Create a history record for the status event change XNP_SV_EVENT_HISTORY table

1034: soa.last_update_date = sysdate
1035: WHERE soa.sv_soa_id = l_sv_soa_id(i)
1036: AND soa.status_type_code <> p_new_status_type_code;
1037:
1038: -- Create a history record for the status event change XNP_SV_EVENT_HISTORY table
1039:
1040: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
1041:
1042: INSERT INTO XNP_SV_EVENT_HISTORY

Line 1042: INSERT INTO XNP_SV_EVENT_HISTORY

1038: -- Create a history record for the status event change XNP_SV_EVENT_HISTORY table
1039:
1040: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
1041:
1042: INSERT INTO XNP_SV_EVENT_HISTORY
1043: (sv_event_history_id ,
1044: sv_soa_id ,
1045: event_code ,
1046: event_type ,

Line 1055: (XNP_SV_EVENT_HISTORY_S.nextval,

1051: last_updated_by ,
1052: last_update_date
1053: )
1054: VALUES
1055: (XNP_SV_EVENT_HISTORY_S.nextval,
1056: l_sv_soa_id(i) ,
1057: l_sv_event_code(i) ,
1058: 'STATUS_CHANGE' ,
1059: sysdate ,

Line 2549: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table

2545: soa.last_update_date = sysdate
2546: WHERE soa.sv_soa_id = l_sv_soa_id(i)
2547: AND soa.status_type_code <> p_new_status_type_code;
2548:
2549: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table
2550:
2551: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2552:
2553: INSERT INTO XNP_SV_EVENT_HISTORY

Line 2553: INSERT INTO XNP_SV_EVENT_HISTORY

2549: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table
2550:
2551: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2552:
2553: INSERT INTO XNP_SV_EVENT_HISTORY
2554: (sv_event_history_id ,
2555: sv_soa_id ,
2556: event_code ,
2557: event_type ,

Line 2566: (XNP_SV_EVENT_HISTORY_S.nextval,

2562: last_updated_by ,
2563: last_update_date
2564: )
2565: VALUES
2566: (XNP_SV_EVENT_HISTORY_S.nextval,
2567: l_sv_soa_id(i) ,
2568: l_sv_event_code(i) ,
2569: 'STATUS_CHANGE' ,
2570: sysdate ,

Line 2910: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table

2906: soa.last_update_date = sysdate
2907: WHERE soa.sv_soa_id = l_sv_soa_id(i)
2908: RETURNING soa.status_type_code BULK COLLECT INTO l_sv_event_code;
2909:
2910: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table
2911:
2912: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2913:
2914: INSERT INTO XNP_SV_EVENT_HISTORY

Line 2914: INSERT INTO XNP_SV_EVENT_HISTORY

2910: -- Create a history record for the status change event in XNP_SV_EVENT_HISTORY table
2911:
2912: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2913:
2914: INSERT INTO XNP_SV_EVENT_HISTORY
2915: (sv_event_history_id ,
2916: sv_soa_id ,
2917: event_code ,
2918: event_type ,

Line 2927: (XNP_SV_EVENT_HISTORY_S.nextval,

2923: last_updated_by ,
2924: last_update_date
2925: )
2926: VALUES
2927: (XNP_SV_EVENT_HISTORY_S.nextval,
2928: l_sv_soa_id(i) ,
2929: l_sv_event_code(i) ,
2930: 'STATUS_CHANGE' ,
2931: sysdate ,