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 DUAL

Line 1413: select amw_process_s.nextval into l_process_id from dual;

1409: l_amw_process_owner_col varchar2(30);
1410: l_amw_application_owner_col varchar2(30);
1411: l_amw_finance_owner_col varchar2(30);
1412: BEGIN
1413: select amw_process_s.nextval into l_process_id from dual;
1414: select amw_process_s.nextval into l_process_rev_id from dual;
1415:
1416: --npanandi 12.01.2004: Name column is not null in fin115p2 hence adding below
1417: if(P_PROCESS_REC.name is null or trim(P_PROCESS_REC.name) = '') then

Line 1414: select amw_process_s.nextval into l_process_rev_id from dual;

1410: l_amw_application_owner_col varchar2(30);
1411: l_amw_finance_owner_col varchar2(30);
1412: BEGIN
1413: select amw_process_s.nextval into l_process_id from dual;
1414: select amw_process_s.nextval into l_process_rev_id from dual;
1415:
1416: --npanandi 12.01.2004: Name column is not null in fin115p2 hence adding below
1417: if(P_PROCESS_REC.name is null or trim(P_PROCESS_REC.name) = '') then
1418: select amw_process_name_s.nextval into l_process_name from dual;

Line 1418: select amw_process_name_s.nextval into l_process_name from dual;

1414: select amw_process_s.nextval into l_process_rev_id from dual;
1415:
1416: --npanandi 12.01.2004: Name column is not null in fin115p2 hence adding below
1417: if(P_PROCESS_REC.name is null or trim(P_PROCESS_REC.name) = '') then
1418: select amw_process_name_s.nextval into l_process_name from dual;
1419: else
1420: l_process_name := P_PROCESS_REC.name;
1421: end if;
1422:

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 1559: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;

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
1563: WHEN NO_DATA_FOUND 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 1831: --SELECT fnd_documents_s.nextval INTO L_DOCUMENT_ID FROM DUAL;

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
1835: WHEN NO_DATA_FOUND THEN