APPS.AMW_LOAD_CTRL_DATA dependencies on AMW_CTRL_INTERFACE

Line 254: FROM amw_ctrl_interface

250: ,CTRL_PURPOSE29
251: ,CTRL_PURPOSE30
252: ---NPANANDI 12.13.2004: ADDED BELOW FOR CTRL CLASSIFICATION ENH.
253: ,CLASSIFICATION
254: FROM amw_ctrl_interface
255: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
256: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
257: AND process_flag IS NULL
258: AND error_flag IS NULL;

Line 661: UPDATE amw_ctrl_interface

657: END IF;
658:
659: IF UPPER (l_amw_delt_ctrl_intf) <> 'Y' THEN
660: BEGIN
661: UPDATE amw_ctrl_interface
662: SET process_flag = l_process_flag
663: ,last_update_date = SYSDATE
664: ,last_updated_by = v_user_id
665: WHERE batch_id = p_batch_id;

Line 674: DELETE FROM amw_ctrl_interface

670: END;
671: ELSE
672: IF NOT v_error_found THEN
673: BEGIN
674: DELETE FROM amw_ctrl_interface
675: WHERE batch_id = p_batch_id;
676:
677: EXCEPTION
678: WHEN OTHERS THEN

Line 693: UPDATE amw_ctrl_interface

689: BEGIN
690: IF v_invalid_requestor_msg is null THEN
691: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
692: END IF;
693: UPDATE amw_ctrl_interface
694: SET error_flag = 'Y'
695: ,interface_status = v_invalid_requestor_msg
696: WHERE batch_id = p_batch_id;
697: EXCEPTION

Line 710: UPDATE amw_ctrl_interface

706: fnd_file.put_line (fnd_file.LOG,'1 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
707: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
708: fnd_file.put_line (fnd_file.LOG,'2 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
709: END IF;
710: UPDATE amw_ctrl_interface
711: SET error_flag = 'Y'
712: ,interface_status = v_no_import_privilege_msg
713: WHERE batch_id = p_batch_id;
714: fnd_file.put_line (fnd_file.LOG,'updated the Intf table');

Line 1372: l_interface_status amw_ctrl_interface.interface_status%TYPE;

1368: ,p_table_name IN VARCHAR2
1369: ,p_interface_id IN NUMBER
1370: )
1371: IS
1372: l_interface_status amw_ctrl_interface.interface_status%TYPE;
1373: BEGIN
1374: ROLLBACK; -- rollback any inserts done during the current loop process
1375: v_error_found := TRUE;
1376:

Line 1380: FROM amw_ctrl_interface

1376:
1377: BEGIN
1378: SELECT interface_status
1379: INTO l_interface_status
1380: FROM amw_ctrl_interface
1381: WHERE ctrl_interface_id = p_interface_id;
1382: EXCEPTION
1383: WHEN OTHERS
1384: THEN

Line 1394: UPDATE amw_ctrl_interface

1390: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1391: END;
1392:
1393: BEGIN
1394: UPDATE amw_ctrl_interface
1395: SET interface_status =
1396: l_interface_status
1397: -- || 'Error Msg: '
1398: || p_err_msg