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

Line 80: from amw_LATEST_REVISIONS_v);

76: where batch_id=p_batch_id
77: --WORKAROUND FOR NULL CODES ...
78: and NVL(parent_process_CODE,'-1234567890') not in (
79: select PROCESS_CODE
80: from amw_LATEST_REVISIONS_v);
81:
82: l_func_exists NUMBER := 1;
83: l_parent_name c_new_parents%rowtype;
84: l_process_name NUMBER := 0;

Line 106: FROM AMW_LATEST_REVISIONS_v)

102: SELECT PARENT_PROCESS_CODE
103: FROM AMW_PROCESSES_INTERFACE
104: WHERE BATCH_ID=P_BATCH_ID
105: AND PARENT_PROCESS_CODE NOT IN (SELECT PROCESS_CODE
106: FROM AMW_LATEST_REVISIONS_v)
107: );
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN
110: NULL;

Line 584: FROM AMW_LATEST_REVISIONS_v

580: L_PROCESS_SEQUENCE_NUMBER := INSERT_LINKS.PROCESS_SEQUENCE_NUMBER;
581: BEGIN
582: SELECT PROCESS_ID,ITEM_TYPE
583: INTO L_PROCESS_ID,L_PROCESS_ITEM_TYPE
584: FROM AMW_LATEST_REVISIONS_v
585: WHERE PROCESS_CODE=L_PROCESS_CODE;
586: EXCEPTION
587: when no_data_found then
588: null;

Line 594: FROM AMW_LATEST_REVISIONS_v

590:
591: BEGIN
592: SELECT PROCESS_ID,ITEM_TYPE
593: INTO L_PARENT_PROCESS_ID,L_PARENT_PROCESS_ITEM_TYPE
594: FROM AMW_LATEST_REVISIONS_v
595: WHERE PROCESS_CODE=L_PARENT_PROCESS_CODE;
596: EXCEPTION
597: when no_data_found then
598: null;

Line 679: FROM AMW_LATEST_REVISIONS_v

675: ---05.11.2005 npanandi: added approval_status below
676: ---for use in call to WebADIApprove procedure
677: SELECT PROCESS_ID,ITEM_TYPE,approval_status,display_name
678: INTO L_PROCESS_ID,L_PROCESS_ITEM_TYPE,l_db_proc_appr_status,l_db_process_display_name
679: FROM AMW_LATEST_REVISIONS_v
680: WHERE PROCESS_CODE=L_PROCESS_CODE;
681: EXCEPTION
682: when no_data_found then
683: null;

Line 905: from amw_latest_revisions_v

901: or API.REVISE_PROCESS_FLAG IS NULL)
902: and api.process_code is null
903: and api.batch_id=P_BATCH_ID
904: and exists (select 1
905: from amw_latest_revisions_v
906: where display_name=api.process_display_name);
907:
908: IF(L_INTF_ID <> 0) THEN
909: SELECT PROCESS_INTERFACE_ID INTO L_INTF_ID

Line 916: from amw_latest_revisions_v

912: or API.REVISE_PROCESS_FLAG IS NULL)
913: and api.process_code is null
914: and api.batch_id=P_BATCH_ID
915: and exists (select 1
916: from amw_latest_revisions_v
917: where display_name=api.process_display_name)
918: AND ROWNUM <=1;
919:
920: END IF;

Line 941: FROM AMW_LATEST_REVISIONS_v);

937: FROM AMW_PROCESSES_INTERFACE
938: WHERE BATCH_ID=P_BATCH_ID
939: AND PROCESS_CODE IS NULL
940: AND PROCESS_DISPLAY_NAME NOT IN (SELECT DISPLAY_NAME
941: FROM AMW_LATEST_REVISIONS_v);
942:
943: ---04.22.2005 npanandi: get all existing parent processes
944: ---with null parent process codes
945: cursor c_get_null_processes is

Line 953: from amw_latest_revisions_v

949: from amw_processes_interface api
950: where batch_id = p_batch_id
951: and parent_process_code is null
952: and exists (select 1
953: from amw_latest_revisions_v
954: where display_name = api.parent_process_name);
955:
956: ---05.12.2005 npanandi: get all existing processes
957: ---with null process codes

Line 966: from amw_latest_revisions_v

962: from amw_processes_interface api
963: where batch_id = p_batch_id
964: and process_code is null
965: and exists (select 1
966: from amw_latest_revisions_v
967: where display_name = api.process_display_name);
968: L_INTF_ID NUMBER;
969: L_PRC_CODE VARCHAR2(80);
970: L_DISP_NAME VARCHAR2(80);

Line 1022: from amw_latest_revisions_v

1018: l_process_code := null;
1019: begin
1020: select process_code
1021: into l_process_code
1022: from amw_latest_revisions_v
1023: where display_name = c.parent_process_name;
1024:
1025: ---do the update of the interface table here
1026: update amw_processes_interface

Line 1050: from amw_latest_revisions_v

1046: l_process_code := null;
1047: begin
1048: select process_code
1049: into l_process_code
1050: from amw_latest_revisions_v
1051: where display_name = c1.process_display_name;
1052:
1053: ---do the update of the interface table here
1054: update amw_processes_interface

Line 1349: FROM AMW_LATEST_REVISIONS_V ALRV

1345:
1346: IS
1347: CURSOR C_INV_APPR IS
1348: SELECT distinct 'Y'
1349: FROM AMW_LATEST_REVISIONS_V ALRV
1350: ,AMW_PROC_HIERARCHY_DENORM APHD
1351: WHERE APHD.UP_DOWN_IND='D'
1352: AND ALRV.PROCESS_ID=APHD.PARENT_CHILD_ID
1353: AND APHD.PROCESS_ID IN (SELECT ALRV.PROCESS_ID

Line 1354: FROM AMW_LATEST_REVISIONS_V ALRV

1350: ,AMW_PROC_HIERARCHY_DENORM APHD
1351: WHERE APHD.UP_DOWN_IND='D'
1352: AND ALRV.PROCESS_ID=APHD.PARENT_CHILD_ID
1353: AND APHD.PROCESS_ID IN (SELECT ALRV.PROCESS_ID
1354: FROM AMW_LATEST_REVISIONS_V ALRV
1355: ,AMW_PROCESSES_INTERFACE API
1356: WHERE API.PROCESS_INTERFACE_ID=P_PROCESS_INTERFACE_ID
1357: AND API.PROCESS_CODE=ALRV.PROCESS_CODE
1358: AND API.PROCESS_DISPLAY_NAME=ALRV.display_name)

Line 1360: FROM AMW_LATEST_REVISIONS_V ALRV

1356: WHERE API.PROCESS_INTERFACE_ID=P_PROCESS_INTERFACE_ID
1357: AND API.PROCESS_CODE=ALRV.PROCESS_CODE
1358: AND API.PROCESS_DISPLAY_NAME=ALRV.display_name)
1359: AND APHD.PARENT_CHILD_ID NOT IN (SELECT ALRV.PROCESS_ID
1360: FROM AMW_LATEST_REVISIONS_V ALRV
1361: ,AMW_PROCESSES_INTERFACE API
1362: WHERE API.BATCH_ID=P_BATCH_ID
1363: AND API.PROCESS_CODE=ALRV.PROCESS_CODE
1364: AND API.PROCESS_DISPLAY_NAME=ALRV.display_name

Line 1648: FROM AMW_LATEST_REVISIONS_v

1644: ---04.26.2005 npanandi: added process_id in below SQL query
1645: ---to get processId for grants
1646: SELECT PROCESS_REV_ID,process_id
1647: INTO L_PROCESS_REV_ID,l_process_id
1648: FROM AMW_LATEST_REVISIONS_v
1649: WHERE PROCESS_ID=P_PROCESS_REC.PROCESS_ID;
1650: EXCEPTION
1651: WHEN NO_DATA_FOUND THEN
1652: NULL;