APPS.AMW_LOAD_KEY_ACC_DATA dependencies on AMW_KEY_ACC_INTERFACE

Line 108: FROM amw_key_acc_interface

104: ,natural_account_acc_id
105: ,processed_flag
106: ,error_flag
107: ,interface_status
108: FROM amw_key_acc_interface
109: WHERE created_by = DECODE (p_user_id, NULL, created_by, p_user_id)
110: AND batch_id = DECODE (p_batch_id, NULL, batch_id, p_batch_id)
111: AND processed_flag IS NULL
112: AND error_flag IS NULL;

Line 351: UPDATE amw_key_acc_interface

347: END IF;
348:
349: IF UPPER (l_amw_delt_key_acc_intf) <> 'Y' THEN
350: BEGIN
351: UPDATE amw_key_acc_interface
352: SET processed_flag = l_process_flag
353: ,last_update_date = SYSDATE
354: ,last_updated_by = v_user_id
355: WHERE batch_id = p_batch_id;

Line 363: DELETE FROM amw_key_acc_interface WHERE batch_id = p_batch_id;

359: END;
360: ELSE
361: IF NOT v_error_found THEN
362: BEGIN
363: DELETE FROM amw_key_acc_interface WHERE batch_id = p_batch_id;
364: EXCEPTION
365: WHEN OTHERS THEN
366: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));
367: END;

Line 380: UPDATE amw_key_acc_interface

376: BEGIN
377: IF v_invalid_requestor_msg is null THEN
378: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
379: END IF;
380: UPDATE amw_key_acc_interface
381: SET error_flag = 'Y'
382: ,interface_status = v_invalid_requestor_msg
383: WHERE batch_id = p_batch_id;
384: EXCEPTION

Line 397: UPDATE amw_key_acc_interface

393: BEGIN
394: IF v_no_import_privilege_msg is null THEN
395: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
396: END IF;
397: UPDATE amw_key_acc_interface
398: SET error_flag = 'Y'
399: ,interface_status = v_no_import_privilege_msg
400: WHERE batch_id = p_batch_id;
401: EXCEPTION

Line 496: l_interface_status amw_key_acc_interface.interface_status%TYPE;

492: ,p_table_name IN VARCHAR2
493: ,p_interface_id IN NUMBER
494: )
495: IS
496: l_interface_status amw_key_acc_interface.interface_status%TYPE;
497: BEGIN
498: ROLLBACK; -- rollback any inserts done during the current loop process
499: v_error_found := TRUE;
500:

Line 504: FROM amw_key_acc_interface

500:
501: BEGIN
502: SELECT interface_status
503: INTO l_interface_status
504: FROM amw_key_acc_interface
505: WHERE key_acc_interface_id = p_interface_id;
506: EXCEPTION
507: WHEN OTHERS
508: THEN

Line 518: UPDATE amw_key_acc_interface

514: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
515: END;
516:
517: BEGIN
518: UPDATE amw_key_acc_interface
519: SET interface_status =
520: l_interface_status
521: -- || 'Error Msg: '
522: || p_err_msg