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 AMW_PROCESS_S

Line 7: /* Reads the amw_processes_interface table */

3: /*****************************************************************************/
4: /*****************************************************************************/
5: /*****************************************************************************/
6: /* Major Functionality of the followIng procedure includes: */
7: /* Reads the amw_processes_interface table */
8: /* following tables: */
9: /* INSERTS ARE DONE AGAINST THE FOLLOWING TABLES */
10: /* Insert into Wf_Activities_B and Wf_Activities_Tl */
11: /* Insert/Updates into AMW_Process */

Line 13: /* Updates amw_processes_interface, with error messages */

9: /* INSERTS ARE DONE AGAINST THE FOLLOWING TABLES */
10: /* Insert into Wf_Activities_B and Wf_Activities_Tl */
11: /* Insert/Updates into AMW_Process */
12: /* Insert/Updates into Wf_Process_Activities */
13: /* Updates amw_processes_interface, with error messages */
14: /* Deleting successful production inserts, based on profile */
15: /* */
16: /*****************************************************************************/
17: --

Line 34: v_parent_process_code amw_processes_interface.PARENT_PROCESS_CODE%type;

30: v_err_msg VARCHAR2 (2000);
31: v_table_name VARCHAR2 (240);
32: v_interface_hierarchy_error NUMBER := 0;
33: V_PARENT_PROCESS_CODE_COUNTER NUMBER := 0;
34: v_parent_process_code amw_processes_interface.PARENT_PROCESS_CODE%type;
35:
36: V_INTF_HIERARCHY_INV VARCHAR2(1);
37: v_counter number := 0;
38:

Line 40: amw_processes_interface.parent_process_name%type INDEX BY BINARY_INTEGER;

36: V_INTF_HIERARCHY_INV VARCHAR2(1);
37: v_counter number := 0;
38:
39: type t_parent_process_NAME IS table of
40: amw_processes_interface.parent_process_name%type INDEX BY BINARY_INTEGER;
41: v_parent_process_name t_parent_process_name;
42:
43: /**
44: type t_parent_process_CODE IS table of

Line 45: amw_processes_interfacE.PARENT_PROCESS_CODE%type INDEX BY BINARY_INTEGER;

41: v_parent_process_name t_parent_process_name;
42:
43: /**
44: type t_parent_process_CODE IS table of
45: amw_processes_interfacE.PARENT_PROCESS_CODE%type INDEX BY BINARY_INTEGER;
46: v_parent_process_CODE t_parent_process_CODE;
47:
48: TYPE t_parent_process_CODE IS VARRAY(500) OF
49: amw_processes_interfacE.PARENT_PROCESS_CODE%type;

Line 49: amw_processes_interfacE.PARENT_PROCESS_CODE%type;

45: amw_processes_interfacE.PARENT_PROCESS_CODE%type INDEX BY BINARY_INTEGER;
46: v_parent_process_CODE t_parent_process_CODE;
47:
48: TYPE t_parent_process_CODE IS VARRAY(500) OF
49: amw_processes_interfacE.PARENT_PROCESS_CODE%type;
50: v_parent_process_CODE t_parent_process_CODE;
51: */
52: type t_process_name IS table of amw_process.name%type INDEX BY BINARY_INTEGER;
53: v_process_name t_process_name;

Line 75: from amw_processes_interface

71: RETURN Boolean
72: IS
73: Cursor c_new_parents Is
74: select parent_process_name,process_interface_id,PARENT_PROCESS_CODE
75: from amw_processes_interface
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

Line 98: from amw_processes_interface

94: --If not, this is not acceptable -- so shout, kick f!
95: BEGIN
96: select count(1)
97: into l_process_name
98: from amw_processes_interface
99: where batch_id=p_batch_id
100: and process_display_name = l_parent_name.parent_process_name
101: AND PROCESS_CODE IN (
102: SELECT PARENT_PROCESS_CODE

Line 103: FROM AMW_PROCESSES_INTERFACE

99: where batch_id=p_batch_id
100: and process_display_name = l_parent_name.parent_process_name
101: AND PROCESS_CODE IN (
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: );

Line 154: FROM AMW_PROCESSES_INTERFACE

150: ,PROCESS_CODE
151: ,PROCESS_SEQUENCE_NUMBER
152: ,PARENT_PROCESS_CODE
153: ,ATTACHMENT_URL
154: FROM AMW_PROCESSES_INTERFACE
155: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
156: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
157: AND processed_flag IS NULL
158: AND error_flag IS NULL

Line 189: FROM AMW_PROCESSES_INTERFACE

185: ---04.22.2005 npanandi: added 3 owner columns below
186: ,process_owner_id
187: ,finance_owner_id
188: ,application_owner_id
189: FROM AMW_PROCESSES_INTERFACE
190: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
191: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
192: AND processed_flag IS NULL
193: AND error_flag IS NULL

Line 210: FROM AMW_PROCESSES_INTERFACE

206: ,PROCESS_TYPE
207: ,PROCESS_CODE
208: ,NVL(PROCESS_SEQUENCE_NUMBER,-100) AS PROCESS_SEQUENCE_NUMBER
209: ,PARENT_PROCESS_CODE
210: FROM AMW_PROCESSES_INTERFACE
211: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
212: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
213: AND processed_flag IS NULL
214: AND error_flag IS NULL

Line 232: FROM AMW_PROCESSES_INTERFACE

228: ,PROCESS_CODE
229: ,NVL(PROCESS_SEQUENCE_NUMBER,-100) AS PROCESS_SEQUENCE_NUMBER
230: ,PARENT_PROCESS_CODE
231: ,NVL(APPROVAL_STATUS,'D') AS APPROVAL_STATUS
232: FROM AMW_PROCESSES_INTERFACE
233: WHERE CREATED_BY=DECODE(p_user_id, NULL, created_by, p_user_id)
234: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
235: AND processed_flag IS NULL
236: AND error_flag IS NULL

Line 747: UPDATE amw_processes_interface

743: END IF;
744:
745: IF UPPER (l_amw_delt_process_intf) <> 'Y' THEN
746: BEGIN
747: UPDATE amw_processes_interface
748: SET processed_flag = l_process_flag
749: ,last_update_date = SYSDATE
750: ,last_updated_by = v_user_id
751: WHERE batch_id = p_batch_id;

Line 759: DELETE FROM amw_processes_interface WHERE batch_id = p_batch_id;

755: END;
756: ELSE
757: IF NOT v_error_found THEN
758: BEGIN
759: DELETE FROM amw_processes_interface WHERE batch_id = p_batch_id;
760: EXCEPTION
761: WHEN OTHERS THEN
762: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM,1, 200));
763: END;

Line 786: UPDATE AMW_PROCESSES_INTERFACE

782:
783: EXCEPTION
784: WHEN E_INTF_HIER_INV THEN
785: BEGIN
786: UPDATE AMW_PROCESSES_INTERFACE
787: SET ERROR_FLAG='Y'
788: ,INTERFACE_STATUS='Upwards Interface hierarchy defined for this Process is Invalid'
789: WHERE PROCESS_INTERFACE_ID=V_INTERFACE_ID;
790: EXCEPTION

Line 797: UPDATE AMW_PROCESSES_INTERFACE

793: END;
794:
795: WHEN E_PRC_CODE THEN
796: BEGIN
797: UPDATE AMW_PROCESSES_INTERFACE
798: SET ERROR_FLAG='Y'
799: ,INTERFACE_STATUS='Please enter valid Process Code for this new Process'
800: WHERE PROCESS_INTERFACE_ID=L_INTF_ID;
801: EXCEPTION

Line 808: UPDATE AMW_PROCESSES_INTERFACE

804: END;
805:
806: WHEN E_PRC_APPR_INV THEN
807: BEGIN
808: UPDATE AMW_PROCESSES_INTERFACE
809: SET ERROR_FLAG='Y'
810: ,INTERFACE_STATUS='Process Approval status is Draft for Process(es)
811: below this Process in the Risk Library'
812: WHERE PROCESS_INTERFACE_ID=L_INTF_ID;

Line 821: UPDATE amw_processes_interface

817:
818: when e_synch_hierarchy_amw_process THEN
819: BEGIN
820: ---rollback;
821: UPDATE amw_processes_interface
822: SET error_flag = 'Y'
823: ,interface_status = v_err_msg
824: WHERE batch_id = p_batch_id;
825: EXCEPTION

Line 836: UPDATE amw_processes_interface

832: ---rollback;
833: IF v_process_exist_no_update is null THEN
834: v_process_exist_no_update := FND_MESSAGE.GET_STRING('AMW','AMW_PROCESS_EXIST');
835: END IF;
836: UPDATE amw_processes_interface
837: SET error_flag = 'Y'
838: ,interface_status = v_process_exist_no_update
839: WHERE batch_id = p_batch_id;
840: EXCEPTION

Line 851: UPDATE amw_processes_interface

847: BEGIN
848: IF v_invalid_hierarchy_msg is null THEN
849: v_invalid_hierarchy_msg := FND_MESSAGE.GET_STRING('AMW','AMW_INVALID_HIERARCHY');
850: END IF;
851: UPDATE amw_processes_interface
852: SET error_flag = 'Y'
853: ,interface_status = v_invalid_hierarchy_msg
854: WHERE batch_id = p_batch_id;
855: ----and (not process_interface_id = v_interface_id);

Line 858: UPDATE amw_processes_interface

854: WHERE batch_id = p_batch_id;
855: ----and (not process_interface_id = v_interface_id);
856:
857: ---usability handling
858: UPDATE amw_processes_interface
859: SET error_flag = 'Y'
860: ---,interface_status = 'Invalid hierarchy FOR this row'
861: ,interface_status = v_err_msg
862: WHERE batch_id = p_batch_id

Line 876: UPDATE amw_processes_interface

872: ---rollback;
873: IF v_no_import_privilege_msg is null THEN
874: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW','AMW_NO_IMPORT_ACCESS');
875: END IF;
876: UPDATE amw_processes_interface
877: SET error_flag = 'Y'
878: ,interface_status = v_no_import_privilege_msg
879: WHERE batch_id = p_batch_id;
880: EXCEPTION

Line 899: from amw_processes_interface api

895: IS
896: L_INTF_ID NUMBER;
897: BEGIN
898: SELECT COUNT(*) INTO L_INTF_ID
899: from amw_processes_interface api
900: where (api.revise_process_flag='R'
901: or API.REVISE_PROCESS_FLAG IS NULL)
902: and api.process_code is null
903: and api.batch_id=P_BATCH_ID

Line 910: from amw_processes_interface api

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
910: from amw_processes_interface api
911: where (api.revise_process_flag='R'
912: or API.REVISE_PROCESS_FLAG IS NULL)
913: and api.process_code is null
914: and api.batch_id=P_BATCH_ID

Line 937: FROM AMW_PROCESSES_INTERFACE

933: ,PROCESS_DISPLAY_NAME
934: ,REVISE_PROCESS_FLAG
935: ,PARENT_PROCESS_CODE
936: ,PARENT_PROCESS_NAME
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);

Line 949: from amw_processes_interface api

945: cursor c_get_null_processes is
946: select process_interface_id
947: ,parent_process_name
948: ,revise_process_flag
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

Line 962: from amw_processes_interface api

958: cursor c_get_null_procs is
959: select process_interface_id
960: ,process_display_name
961: ,revise_process_flag
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

Line 985: UPDATE AMW_PROCESSES_INTERFACE

981: L_PRC_CODE := NVL(AMW_RL_HIERARCHY_PKG.get_process_code(),'AUTO: ');
982: --SET THE PROCESS CODE FOR THE ROW WITH
983: --NEW PROCESS NAME AND NULL PROCESS CODE
984: BEGIN
985: UPDATE AMW_PROCESSES_INTERFACE
986: SET PROCESS_CODE=L_PRC_CODE
987: WHERE PROCESS_INTERFACE_ID=L_INTF_ID
988: AND BATCH_ID=P_BATCH_ID;
989: EXCEPTION

Line 1002: UPDATE AMW_PROCESSES_INTERFACE

998: --PARENT PROCESS FOR THE SAME UPL SPRDSHEET,
999: --AND SET THE PARENT PRC CODE FOR THIS ROW
1000: --TO BE THE PROCESS CODE FOR THE ABOVE ROW
1001: BEGIN
1002: UPDATE AMW_PROCESSES_INTERFACE
1003: SET PARENT_PROCESS_CODE=L_PRC_CODE
1004: WHERE BATCH_ID=P_BATCH_ID
1005: AND PARENT_PROCESS_NAME=L_DISP_NAME;
1006: EXCEPTION

Line 1026: update amw_processes_interface

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
1027: set parent_process_code = l_process_code
1028: ,last_update_date = sysdate
1029: where process_interface_id = c.process_interface_id
1030: and batch_id = p_batch_id;

Line 1054: update amw_processes_interface

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
1055: set process_code = l_process_code
1056: ,last_update_date = sysdate
1057: where process_interface_id = c1.process_interface_id
1058: and batch_id = p_batch_id;

Line 1076: ---Finding the upwards hierarchy in Amw_Processes_Interface table

1072: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');
1073: END POPULATE_INTF_TBL;
1074:
1075: ---
1076: ---Finding the upwards hierarchy in Amw_Processes_Interface table
1077: ---
1078: PROCEDURE FIND_PARENT_PROCESS_V(P_PROCESS_CODE IN VARCHAR2
1079: ,P_PARENT_PROCESS_CODE IN VARCHAR2
1080: ,P_BATCH_ID IN NUMBER)

Line 1085: FROM AMW_PROCESSES_INTERFACE

1081: IS
1082: CURSOR C_PRNT_PRC_CODE IS
1083: SELECT PARENT_PROCESS_CODE
1084: ,PROCESS_INTERFACE_ID
1085: FROM AMW_PROCESSES_INTERFACE
1086: WHERE PROCESS_CODE=P_PARENT_PROCESS_CODE
1087: AND BATCH_ID=P_BATCH_ID;
1088: BEGIN
1089: --check to see if this process_code exists in application

Line 1139: from amw_processes_interface

1135: is
1136: cursor ct (l_process_display_name in VARCHAR2) is
1137: select parent_process_name
1138: ,process_interface_id
1139: from amw_processes_interface
1140: where process_display_name = p_process_display_name
1141: and batch_id = p_batch_id;
1142:
1143: ct_rec ct%rowtype;

Line 1191: l_interface_status amw_processes_interface.interface_status%TYPE;

1187: ,p_table_name IN VARCHAR2
1188: ,p_interface_id IN NUMBER
1189: )
1190: IS
1191: l_interface_status amw_processes_interface.interface_status%TYPE;
1192: BEGIN
1193: ----commenting this rollback FOR now
1194: ROLLBACK; -- rollback any inserts done during the current LOOP process
1195: v_error_found := TRUE;

Line 1199: FROM amw_processes_interface

1195: v_error_found := TRUE;
1196: BEGIN
1197: SELECT interface_status
1198: INTO l_interface_status
1199: FROM amw_processes_interface
1200: WHERE process_interface_id = p_interface_id;
1201: EXCEPTION
1202: WHEN OTHERS
1203: THEN

Line 1213: UPDATE amw_processes_interface

1209: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1210: END;
1211:
1212: BEGIN
1213: UPDATE amw_processes_interface
1214: SET interface_status =
1215: l_interface_status
1216: -- || 'Error Msg: '
1217: || p_err_msg

Line 1355: ,AMW_PROCESSES_INTERFACE API

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)
1359: AND APHD.PARENT_CHILD_ID NOT IN (SELECT ALRV.PROCESS_ID

Line 1361: ,AMW_PROCESSES_INTERFACE API

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
1365: AND API.APPROVAL_STATUS='A');

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;