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.AMW_LOAD_PROC_DATA dependencies on FND_ATTACHED_DOCUMENTS

Line 1558: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;

1554:
1555:
1556: ---if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL AND not (TRIM(P_PROCESS_REC.ATTACHMENT_URL)='')) THEN
1557: if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL) THEN
1558: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;
1559: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;
1560: BEGIN
1561: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;
1562: EXCEPTION

Line 1561: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;

1557: if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL) THEN
1558: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;
1559: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;
1560: BEGIN
1561: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;
1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: L_SEQ_NUM := 0;
1565: WHEN OTHERS THEN

Line 1830: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;

1826: ---04.22.2005 npanandi: ends bug 4323387 fix
1827:
1828: ---if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL AND not (TRIM(P_PROCESS_REC.ATTACHMENT_URL)='')) THEN
1829: if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL) THEN
1830: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;
1831: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;
1832: BEGIN
1833: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;
1834: EXCEPTION

Line 1833: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;

1829: if(P_PROCESS_REC.ATTACHMENT_URL IS NOT NULL) THEN
1830: --SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL INTO L_ATTACHED_DOCUMENT_ID FROM DUAL;
1831: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;
1832: BEGIN
1833: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROCESS' AND PK1_VALUE=l_process_rev_id;
1834: EXCEPTION
1835: WHEN NO_DATA_FOUND THEN
1836: L_SEQ_NUM := 0;
1837: WHEN OTHERS THEN