APPS.AMW_LOAD_AP_DATA dependencies on AMW_AUDIT_PROCEDURES_B

Line 171: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl

167: AND rownum = 1;
168:
169: CURSOR c_ap_exists (c_ap_name IN VARCHAR2) IS
170: SELECT b.audit_procedure_id, b.approval_status
171: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl
172: WHERE tl.name = c_ap_name
173: AND tl.language = USERENV('LANG')
174: AND tl.audit_procedure_rev_id = b.audit_procedure_rev_id
175: AND b.latest_revision_flag='Y';

Line 191: From amw_audit_procedures_b

187: AND b.audit_procedure_id = c_ap_id;
188:
189: CURSOR c_get_from_rev_num(c_audit_procedure_rev_id in number) is
190: Select audit_procedure_rev_num
191: From amw_audit_procedures_b
192: Where audit_procedure_rev_id = c_audit_procedure_rev_id;
193:
194: lx_step_rec c_step_exists%rowtype;
195:

Line 349: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl

345: lx_audit_procedure_id := null; ---setting this to NULL to avoid conflict with value from previous loop
346: begin
347: SELECT b.audit_procedure_id
348: into lx_audit_procedure_id
349: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl
350: WHERE tl.name = ap_rec.ap_name
351: AND tl.language = USERENV('LANG')
352: AND tl.audit_procedure_rev_id = b.audit_procedure_rev_id
353: AND b.latest_revision_flag='Y';

Line 565: ,p_table_name => 'AMW_AUDIT_PROCEDURES_B'

561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INVALID AP UPLOAD STATUS FOUND' );
562: L_ERR_MSG := 'Multiple Approval Statuses found for this Procedure in this Upload';
563: update_interface_with_error(
564: p_ERR_MSG => L_ERR_MSG
565: ,p_table_name => 'AMW_AUDIT_PROCEDURES_B'
566: ,P_INTERFACE_ID => V_INTERFACE_ID);
567: EXCEPTION
568: WHEN OTHERS THEN
569: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INV_AP_UPL_STATUSES: '||sqlerrm);