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

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 11: /* Insert/Updates into AMW_Process */

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 */
12: /* Insert/Updates into Wf_Process_Activities */
13: /* Updates amw_processes_interface, with error messages */
14: /* Deleting successful production inserts, based on profile */
15: /* */

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 52: type t_process_name IS table of amw_process.name%type INDEX BY BINARY_INTEGER;

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;
54:
55: v_import_func CONSTANT VARCHAR2(30) := 'AMW_DATA_IMPORT';
56:

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 243: e_synch_hierarchy_amw_process Exception;

239: e_no_import_access EXCEPTION;
240: e_invalid_risk_type EXCEPTION;
241: e_inv_parent_prc_hier EXCEPTION;
242: e_process_exist_no_update EXCEPTION;
243: e_synch_hierarchy_amw_process Exception;
244: E_PRC_CODE EXCEPTION;
245: E_INTF_HIER_INV EXCEPTION;
246: E_PRC_APPR_INV EXCEPTION;
247:

Line 248: L_PROCESS_REC AMW_PROCESS_REC;

244: E_PRC_CODE EXCEPTION;
245: E_INTF_HIER_INV EXCEPTION;
246: E_PRC_APPR_INV EXCEPTION;
247:
248: L_PROCESS_REC AMW_PROCESS_REC;
249:
250: l_amw_delt_process_intf VARCHAR2(2);
251: l_process_flag VARCHAR2(1);
252:

Line 289: select count(process_id) into l_count_processes from amw_process_vl;

285: -- Check that User has access to Process Import Functionality
286:
287: ---05.11.2005 npanandi: included the below statement to count
288: ---the initial # of processes in the system, prior to the current upload
289: select count(process_id) into l_count_processes from amw_process_vl;
290: fnd_file.put_line(fnd_file.LOG, '********* Initial # of Processes, prior to this Upload: '||l_count_processes||' *********' );
291: ---05.11.2005 npanandi: ends above statement
292:
293: IF not Check_Function_Security('AMW_ALLOW_PROCESS_CREATION') THEN

Line 338: FROM AMW_PROCESS_VL

334:
335: begin
336: SELECT PROCESS_ID,ITEM_TYPE
337: INTO L_PROCESS_ID,L_PROCESS_ITEM_TYPE
338: FROM AMW_PROCESS_VL
339: WHERE END_DATE IS NULL
340: AND PROCESS_CODE=L_PROCESS_CODE;
341: exception
342: when no_data_found then

Line 349: FROM AMW_PROCESS_VL

345:
346: begin
347: SELECT PROCESS_ID,ITEM_TYPE
348: INTO L_PARENT_PROCESS_ID,L_PARENT_PROCESS_ITEM_TYPE
349: FROM AMW_PROCESS_VL
350: WHERE END_DATE IS NULL
351: AND PROCESS_CODE=L_PARENT_PROCESS_CODE;
352: exception
353: when no_data_found then

Line 413: FROM AMW_PROCESS_VL

409:
410: BEGIN
411: SELECT PROCESS_ID,ITEM_TYPE
412: INTO L_PROCESS_ID,L_PROCESS_ITEM_TYPE
413: FROM AMW_PROCESS_VL
414: WHERE END_DATE IS NULL
415: AND PROCESS_CODE=L_PROCESS_CODE;
416: EXCEPTION
417: when no_data_found then

Line 424: FROM AMW_PROCESS_VL

420:
421: BEGIN
422: SELECT PROCESS_ID,ITEM_TYPE
423: INTO L_PARENT_PROCESS_ID,L_PARENT_PROCESS_ITEM_TYPE
424: FROM AMW_PROCESS_VL
425: WHERE END_DATE IS NULL
426: AND PROCESS_CODE=L_PARENT_PROCESS_CODE;
427: EXCEPTION
428: when no_data_found then

Line 462: INSERT_AMW_PROCESS(

458: lx_return_status := FND_API.G_RET_STS_SUCCESS;
459: LX_MSG_COUNT := NULL;
460: LX_MSG_DATA := NULL;
461:
462: INSERT_AMW_PROCESS(
463: P_PROCESS_REC => L_PROCESS_REC
464: ,X_RETURN_STATUS => LX_RETURN_STATUS
465: ,X_MSG_COUNT => LX_MSG_COUNT
466: ,X_MSG_DATA => LX_MSG_DATA

Line 478: ,'AMW_PROCESS_VL'

474: p_encoded => fnd_api.g_false), 1,100);
475: end if;
476: END LOOP;
477: update_interface_with_error (v_err_msg
478: ,'AMW_PROCESS_VL'
479: ,INSERT_REC.PROCESS_INTERFACE_ID);
480: END IF;
481: END IF;
482:

Line 507: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

503: --- security check during updates
504: /**
505: l_has_access := check_function(
506: p_function => 'AMW_UPD_RL_PROC'
507: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
508: ,p_instance_pk1_value => L_PROCESS_ID
509: ,p_user_id => fnd_global.user_id);
510:
511: IF l_has_access <> 'T' then

Line 514: ,'AMW_PROCESS_VL'

510:
511: IF l_has_access <> 'T' then
512: v_err_msg := 'Cannot update this Process';
513: update_interface_with_error (v_err_msg
514: ,'AMW_PROCESS_VL'
515: ,INSERT_REC.PROCESS_INTERFACE_ID);
516: END IF;
517: **/
518: ---04.22.2005 npanandi: ends security check commenting out

Line 522: UPD_AMW_PROCESS(

518: ---04.22.2005 npanandi: ends security check commenting out
519:
520: ---03.02.2005 npanandi: add check for update depending on access privilege
521: if(l_has_access = 'T')then
522: UPD_AMW_PROCESS(
523: P_PROCESS_REC => L_PROCESS_REC
524: ,X_RETURN_STATUS => LX_RETURN_STATUS
525: ,X_MSG_COUNT => LX_MSG_COUNT
526: ,X_MSG_DATA => LX_MSG_DATA

Line 538: ,'AMW_PROCESS_VL'

534: p_encoded => fnd_api.g_false), 1,100);
535: end if;
536: END LOOP;
537: update_interface_with_error (v_err_msg
538: ,'AMW_PROCESS_VL'
539: ,INSERT_REC.PROCESS_INTERFACE_ID);
540: END IF;
541: end if; ---end of if l_has_access access privilege check
542: END IF;

Line 706: v_table_name := 'AMW_PROCESS';

702: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
703: EXCEPTION
704: WHEN OTHERS THEN
705: v_err_msg := 'unexpected EXCEPTION in create_processes: '||sqlerrm;
706: v_table_name := 'AMW_PROCESS';
707: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
708: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);
709: END;
710: end if; --03.02.2005 npanandi: end of v_error_found check

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 818: when e_synch_hierarchy_amw_process THEN

814: WHEN OTHERS THEN
815: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_PRC_APPR_INV');
816: END;
817:
818: when e_synch_hierarchy_amw_process THEN
819: BEGIN
820: ---rollback;
821: UPDATE amw_processes_interface
822: SET error_flag = 'Y'

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 827: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_synch_hierarchy_amw_process: '||sqlerrm);

823: ,interface_status = v_err_msg
824: WHERE batch_id = p_batch_id;
825: EXCEPTION
826: WHEN OTHERS THEN
827: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_synch_hierarchy_amw_process: '||sqlerrm);
828: END;
829:
830: when e_process_exist_no_update THEN
831: BEGIN

Line 834: v_process_exist_no_update := FND_MESSAGE.GET_STRING('AMW','AMW_PROCESS_EXIST');

830: when e_process_exist_no_update THEN
831: BEGIN
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

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 1293: FROM AMW_PROCESS_VL

1289: IS
1290:
1291: CURSOR c_PROCESS_CODE_EXISTS IS
1292: SELECT 'Y'
1293: FROM AMW_PROCESS_VL
1294: WHERE PROCESS_CODE=p_PARENT_PROCESS_CODE;
1295:
1296: l_CODE_exists VARCHAR2(1);
1297: l_func_excluded VARCHAR2(1);

Line 1322: FROM AMW_PROCESS_VL

1318: CURSOR c_INV_HIER IS
1319: SELECT 'Y'
1320: FROM AMW_PROC_HIERARCHY_DENORM
1321: WHERE PROCESS_ID IN (SELECT PROCESS_ID
1322: FROM AMW_PROCESS_VL
1323: WHERE PROCESS_CODE=p_PARENT_child_CODE)
1324: AND PARENT_CHILD_ID IN (SELECT PROCESS_ID
1325: FROM AMW_PROCESS_VL
1326: WHERE PROCESS_CODE=p_PROCESS_CODE)

Line 1325: FROM AMW_PROCESS_VL

1321: WHERE PROCESS_ID IN (SELECT PROCESS_ID
1322: FROM AMW_PROCESS_VL
1323: WHERE PROCESS_CODE=p_PARENT_child_CODE)
1324: AND PARENT_CHILD_ID IN (SELECT PROCESS_ID
1325: FROM AMW_PROCESS_VL
1326: WHERE PROCESS_CODE=p_PROCESS_CODE)
1327: AND UP_DOWN_IND='U';
1328:
1329: l_INV_HIER_exists VARCHAR2(1);

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 1380: PROCEDURE INSERT_AMW_PROCESS(

1376:
1377: RETURN FALSE;
1378: END PRC_APPR_CHK_FAILS;
1379:
1380: PROCEDURE INSERT_AMW_PROCESS(
1381: P_PROCESS_REC IN AMW_PROCESS_REC
1382: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1383: ,X_MSG_COUNT OUT NOCOPY NUMBER
1384: ,X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1381: P_PROCESS_REC IN AMW_PROCESS_REC

1377: RETURN FALSE;
1378: END PRC_APPR_CHK_FAILS;
1379:
1380: PROCEDURE INSERT_AMW_PROCESS(
1381: P_PROCESS_REC IN AMW_PROCESS_REC
1382: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1383: ,X_MSG_COUNT OUT NOCOPY NUMBER
1384: ,X_MSG_DATA OUT NOCOPY VARCHAR2
1385: )

Line 1409: l_amw_process_owner_col varchar2(30);

1405: ---12.29.2004 npanandi: addition of StdVariation flag
1406: l_standard_variation number;
1407:
1408: ---04.22.2005 npanandi: added vars below for profile option values
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;

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 1430: insert into amw_process (

1426: else
1427: l_standard_variation := P_PROCESS_REC.standard_variation;
1428: end if;
1429:
1430: insert into amw_process (
1431: PROCESS_ID,
1432: ITEM_TYPE,
1433: NAME,
1434: PROCESS_CODE,

Line 1480: insert into amw_process_names_tl (

1476: ---12.29.2004 NPANANDI: ADDED STD VAR d COLS
1477: P_PROCESS_REC.CLASSIFICATION
1478: );
1479:
1480: insert into amw_process_names_tl (
1481: process_id
1482: ,revision_number
1483: ,process_rev_id
1484: ,display_name

Line 1516: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1512: ---04.22.2005 npanandi: commenting out below grants for now
1513: /**
1514: add_owner_privilege(
1515: p_role_name => 'AMW_RL_PROC_OWNER_ROLE'
1516: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1517: ,p_grantee_type => 'P'
1518: ,p_instance_pk1_value => l_process_id
1519: ,p_user_id => FND_GLOBAL.USER_ID);
1520: **/

Line 1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');

1520: **/
1521: ---04.22.2005 npanandi: commented out above grants for now
1522:
1523: ---04.22.2005 npanandi: added below grants bug 4323387
1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1525: if(p_process_rec.process_owner_id is not null) then
1526: add_owner_privilege(
1527: p_role_name => l_amw_process_owner_col
1528: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

Line 1527: p_role_name => l_amw_process_owner_col

1523: ---04.22.2005 npanandi: added below grants bug 4323387
1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1525: if(p_process_rec.process_owner_id is not null) then
1526: add_owner_privilege(
1527: p_role_name => l_amw_process_owner_col
1528: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1529: ,p_grantee_type => 'P'
1530: ,p_instance_pk1_value => l_process_id
1531: ,p_party_id => P_PROCESS_REC.process_owner_id);

Line 1528: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1524: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1525: if(p_process_rec.process_owner_id is not null) then
1526: add_owner_privilege(
1527: p_role_name => l_amw_process_owner_col
1528: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1529: ,p_grantee_type => 'P'
1530: ,p_instance_pk1_value => l_process_id
1531: ,p_party_id => P_PROCESS_REC.process_owner_id);
1532: end if;

Line 1538: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1534: if(p_process_rec.application_owner_id is not null) then
1535: l_amw_application_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_APPL_OWNER_COL'),'AMW_RL_PROC_APPL_OWNER_ROLE');
1536: add_owner_privilege(
1537: p_role_name => l_amw_application_owner_col
1538: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1539: ,p_grantee_type => 'P'
1540: ,p_instance_pk1_value => l_process_id
1541: ,p_party_id => P_PROCESS_REC.application_owner_id);
1542: end if;

Line 1548: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1544: if(p_process_rec.finance_owner_id is not null) then
1545: l_amw_finance_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_FINANCE_OWNER_COL'),'AMW_RL_PROC_FINANCE_OWNER_ROLE');
1546: add_owner_privilege(
1547: p_role_name => l_amw_finance_owner_col
1548: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1549: ,p_grantee_type => 'P'
1550: ,p_instance_pk1_value => l_process_id
1551: ,p_party_id => P_PROCESS_REC.finance_owner_id);
1552: end if;

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 1575: l_attachment_rec.entity_name := 'AMW_PROCESS';

1571: l_attachment_rec.description := 'AUTO: ';
1572: l_attachment_rec.file_name := P_PROCESS_REC.ATTACHMENT_URL;
1573: l_attachment_rec.datatype_id := 5;
1574: l_attachment_rec.seq_num := l_seq_num;
1575: l_attachment_rec.entity_name := 'AMW_PROCESS';
1576: l_attachment_rec.pk1_value := to_char(L_PROCESS_REV_ID);
1577: l_attachment_rec.automatically_added_flag := 'N';
1578: l_attachment_rec.datatype_id := 5;
1579: l_attachment_rec.category_id := 1;

Line 1598: END INSERT_AMW_PROCESS;

1594: x_document_id => LX_DOCUMENT_ID,
1595: x_attached_document_id => LX_ATTACHED_DOCUMENT_ID
1596: );
1597: END IF; --END OF IF ATTACHMENT URL IS NOT NULL
1598: END INSERT_AMW_PROCESS;
1599:
1600: PROCEDURE UPD_AMW_PROCESS(
1601: P_PROCESS_REC IN AMW_PROCESS_REC
1602: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 1600: PROCEDURE UPD_AMW_PROCESS(

1596: );
1597: END IF; --END OF IF ATTACHMENT URL IS NOT NULL
1598: END INSERT_AMW_PROCESS;
1599:
1600: PROCEDURE UPD_AMW_PROCESS(
1601: P_PROCESS_REC IN AMW_PROCESS_REC
1602: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1603: ,X_MSG_COUNT OUT NOCOPY NUMBER
1604: ,X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1601: P_PROCESS_REC IN AMW_PROCESS_REC

1597: END IF; --END OF IF ATTACHMENT URL IS NOT NULL
1598: END INSERT_AMW_PROCESS;
1599:
1600: PROCEDURE UPD_AMW_PROCESS(
1601: P_PROCESS_REC IN AMW_PROCESS_REC
1602: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1603: ,X_MSG_COUNT OUT NOCOPY NUMBER
1604: ,X_MSG_DATA OUT NOCOPY VARCHAR2
1605: )IS

Line 1629: l_amw_process_owner_col varchar2(30);

1625: L_IS_STD_VAR NUMBER;
1626: l_standard_process_flag varchar2(1);
1627:
1628: ---04.22.2005 npanandi: added vars below for profile option values
1629: l_amw_process_owner_col varchar2(30);
1630: l_amw_application_owner_col varchar2(30);
1631: l_amw_finance_owner_col varchar2(30);
1632: l_process_id number;
1633:

Line 1664: from amw_process ap

1660: L_IS_STD_VAR := 0;
1661: begin
1662: select 1
1663: into L_IS_STD_VAR
1664: from amw_process ap
1665: where (select process_id
1666: from amw_process
1667: where process_rev_id = ap.standard_variation) =
1668: (select process_id

Line 1666: from amw_process

1662: select 1
1663: into L_IS_STD_VAR
1664: from amw_process ap
1665: where (select process_id
1666: from amw_process
1667: where process_rev_id = ap.standard_variation) =
1668: (select process_id
1669: from amw_process
1670: where process_rev_id = L_PROCESS_REV_ID)

Line 1669: from amw_process

1665: where (select process_id
1666: from amw_process
1667: where process_rev_id = ap.standard_variation) =
1668: (select process_id
1669: from amw_process
1670: where process_rev_id = L_PROCESS_REV_ID)
1671: and ap.end_date is null;
1672: exception
1673: WHEN NO_DATA_FOUND THEN

Line 1689: UPDATE AMW_PROCESS

1685: if(P_PROCESS_REC.STANDARD_PROCESS_FLAG='Y')then
1686: L_STANDARD_VARIATION := null;
1687: end if;
1688:
1689: UPDATE AMW_PROCESS
1690: SET APPROVAL_STATUS=P_PROCESS_REC.APPROVAL_STATUS
1691: ,SIGNIFICANT_PROCESS_FLAG=P_PROCESS_REC.SIGNIFICANT_PROCESS_FLAG
1692: ---,STANDARD_PROCESS_FLAG=P_PROCESS_REC.STANDARD_PROCESS_FLAG
1693: ,STANDARD_PROCESS_FLAG=l_STANDARD_PROCESS_FLAG

Line 1718: from amw_process

1714:
1715: begin
1716: select classification
1717: into l_classification
1718: from amw_process
1719: where process_id=p_process_rec.process_id
1720: and end_date is null;
1721: --- For bug 4692219
1722: select w.work_type_id into l_classification_new from amw_work_types_b w,

Line 1742: update amw_process

1738: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ l_classification: '||l_classification ); **/
1739:
1740: if ((l_classification is null or (l_classification = l_classification_new)) and p_process_rec.classification is not null) then
1741: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Updating AmwProcess here' ); ***/
1742: update amw_process
1743: set classification = p_process_rec.classification
1744: ,last_update_date = sysdate
1745: ,last_updated_by = g_user_id
1746: ,last_update_login = g_login_id

Line 1754: update AMW_PROCESS_NAMES_TL

1750:
1751: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Am out of the updates' ); ***/
1752: ----7.28.2005 npanandi: end of bug fix for update Classification
1753:
1754: update AMW_PROCESS_NAMES_TL
1755: set DISPLAY_NAME = P_PROCESS_REC.DISPLAY_NAME
1756: ---03.28.2005 npanandi: commented out update on description
1757: ---bug 4241577 fix
1758: ---,DESCRIPTION = P_PROCESS_REC.DESCRIPTION

Line 1773: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');

1769: raise no_data_found;
1770: end if;
1771:
1772: ---04.22.2005 npanandi: added below grants bug 4323387
1773: l_amw_process_owner_col := NVL(fnd_profile.VALUE ('AMW_PROC_IMP_PROC_OWNER_COL'),'AMW_RL_PROC_OWNER_ROLE');
1774: if(p_process_rec.process_owner_id is not null) then
1775: ---04.29.2005 npanandi: check here to see
1776: ---if the role is ProcessOwner Role, then
1777: ---whether to add or to replace

Line 1778: if(l_amw_process_owner_col = 'AMW_RL_PROC_OWNER_ROLE')then

1774: if(p_process_rec.process_owner_id is not null) then
1775: ---04.29.2005 npanandi: check here to see
1776: ---if the role is ProcessOwner Role, then
1777: ---whether to add or to replace
1778: if(l_amw_process_owner_col = 'AMW_RL_PROC_OWNER_ROLE')then
1779: pre_process_role_grant(
1780: p_role_name => l_amw_process_owner_col
1781: ,p_pk1_value => l_process_id);
1782: end if;

Line 1780: p_role_name => l_amw_process_owner_col

1776: ---if the role is ProcessOwner Role, then
1777: ---whether to add or to replace
1778: if(l_amw_process_owner_col = 'AMW_RL_PROC_OWNER_ROLE')then
1779: pre_process_role_grant(
1780: p_role_name => l_amw_process_owner_col
1781: ,p_pk1_value => l_process_id);
1782: end if;
1783: add_owner_privilege(
1784: p_role_name => l_amw_process_owner_col

Line 1784: p_role_name => l_amw_process_owner_col

1780: p_role_name => l_amw_process_owner_col
1781: ,p_pk1_value => l_process_id);
1782: end if;
1783: add_owner_privilege(
1784: p_role_name => l_amw_process_owner_col
1785: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1786: ,p_grantee_type => 'P'
1787: ,p_instance_pk1_value => l_process_id
1788: ,p_party_id => P_PROCESS_REC.process_owner_id);

Line 1785: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1781: ,p_pk1_value => l_process_id);
1782: end if;
1783: add_owner_privilege(
1784: p_role_name => l_amw_process_owner_col
1785: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1786: ,p_grantee_type => 'P'
1787: ,p_instance_pk1_value => l_process_id
1788: ,p_party_id => P_PROCESS_REC.process_owner_id);
1789: end if;

Line 1803: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1799: ,p_pk1_value => l_process_id);
1800: end if;
1801: add_owner_privilege(
1802: p_role_name => l_amw_application_owner_col
1803: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1804: ,p_grantee_type => 'P'
1805: ,p_instance_pk1_value => l_process_id
1806: ,p_party_id => P_PROCESS_REC.application_owner_id);
1807: end if;

Line 1821: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'

1817: ,p_pk1_value => l_process_id);
1818: end if;
1819: add_owner_privilege(
1820: p_role_name => l_amw_finance_owner_col
1821: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1822: ,p_grantee_type => 'P'
1823: ,p_instance_pk1_value => l_process_id
1824: ,p_party_id => P_PROCESS_REC.finance_owner_id);
1825: end if;

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

Line 1847: l_attachment_rec.entity_name := 'AMW_PROCESS';

1843: l_attachment_rec.description := 'AUTO: ';
1844: l_attachment_rec.file_name := P_PROCESS_REC.ATTACHMENT_URL;
1845: l_attachment_rec.datatype_id := 5;
1846: l_attachment_rec.seq_num := l_seq_num;
1847: l_attachment_rec.entity_name := 'AMW_PROCESS';
1848: l_attachment_rec.pk1_value := to_char(L_PROCESS_REV_ID);
1849: l_attachment_rec.automatically_added_flag := 'N';
1850: l_attachment_rec.datatype_id := 5;
1851: l_attachment_rec.category_id := 1;

Line 1872: END UPD_AMW_PROCESS;

1868: );
1869:
1870: END IF; --END OF IF ATTACHMENT URL IS NOT NULL
1871:
1872: END UPD_AMW_PROCESS;
1873:
1874: ---
1875: ---03.02.2005 npanandi: add Process Owner privilege here for data security
1876: ---