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.CSM_HA_EVENT_PKG dependencies on FND_DOCUMENTS

Line 1460: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE > l_last_run_date

1456: IF G_HA_START_TIME > l_last_run_date THEN
1457: l_last_run_date:= G_HA_START_TIME;
1458: END IF;
1459:
1460: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE > l_last_run_date
1461: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1462: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1463: AND OBJECT_NAME='FND_DOCUMENTS'
1464: AND PK_VALUE=to_char(a.DOCUMENT_ID)

Line 1463: AND OBJECT_NAME='FND_DOCUMENTS'

1459:
1460: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE > l_last_run_date
1461: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1462: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1463: AND OBJECT_NAME='FND_DOCUMENTS'
1464: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1465: AND DML_TYPE='I'))
1466: LOOP
1467: l_PK_NAME_LIST(1):='DOCUMENT_ID'; l_PK_TYPE_LIST(1):='NUMBER'; l_pk_value_list(1):= to_char(rec.DOCUMENT_ID);

Line 1468: CSM_HA_EVENT_PKG.TRACK_HA_RECORD('FND_DOCUMENTS',l_PK_NAME_LIST,l_PK_TYPE_LIST,l_pk_value_list,'I');

1464: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1465: AND DML_TYPE='I'))
1466: LOOP
1467: l_PK_NAME_LIST(1):='DOCUMENT_ID'; l_PK_TYPE_LIST(1):='NUMBER'; l_pk_value_list(1):= to_char(rec.DOCUMENT_ID);
1468: CSM_HA_EVENT_PKG.TRACK_HA_RECORD('FND_DOCUMENTS',l_PK_NAME_LIST,l_PK_TYPE_LIST,l_pk_value_list,'I');
1469: END LOOP;
1470:
1471: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE < l_last_run_date
1472: AND LAST_UPDATE_DATE > l_last_run_date

Line 1471: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE < l_last_run_date

1467: l_PK_NAME_LIST(1):='DOCUMENT_ID'; l_PK_TYPE_LIST(1):='NUMBER'; l_pk_value_list(1):= to_char(rec.DOCUMENT_ID);
1468: CSM_HA_EVENT_PKG.TRACK_HA_RECORD('FND_DOCUMENTS',l_PK_NAME_LIST,l_PK_TYPE_LIST,l_pk_value_list,'I');
1469: END LOOP;
1470:
1471: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE < l_last_run_date
1472: AND LAST_UPDATE_DATE > l_last_run_date
1473: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1474: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1475: AND OBJECT_NAME='FND_DOCUMENTS'

Line 1475: AND OBJECT_NAME='FND_DOCUMENTS'

1471: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE < l_last_run_date
1472: AND LAST_UPDATE_DATE > l_last_run_date
1473: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1474: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1475: AND OBJECT_NAME='FND_DOCUMENTS'
1476: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1477: AND DML_TYPE='U'))
1478: LOOP
1479: l_PK_NAME_LIST(1):='DOCUMENT_ID'; l_PK_TYPE_LIST(1):='NUMBER'; l_pk_value_list(1):= to_char(rec.DOCUMENT_ID);

Line 1480: CSM_HA_EVENT_PKG.TRACK_HA_RECORD('FND_DOCUMENTS',l_PK_NAME_LIST,l_PK_TYPE_LIST,l_pk_value_list,'U');

1476: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1477: AND DML_TYPE='U'))
1478: LOOP
1479: l_PK_NAME_LIST(1):='DOCUMENT_ID'; l_PK_TYPE_LIST(1):='NUMBER'; l_pk_value_list(1):= to_char(rec.DOCUMENT_ID);
1480: CSM_HA_EVENT_PKG.TRACK_HA_RECORD('FND_DOCUMENTS',l_PK_NAME_LIST,l_PK_TYPE_LIST,l_pk_value_list,'U');
1481: END LOOP;
1482:
1483: IF(G_IS_END_TRACKING_CALL) THEN
1484: COMMIT;