APPS.AMW_LOAD_PROC_DATA dependencies on AMW_PROCESS_VL

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 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 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 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 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);