APPS.AP_CANCEL_PKG dependencies on AP_HOLDS

Line 575: FROM AP_HOLDS AH,

571: ORDER BY line_type_lookup_code;
572:
573: CURSOR Tax_Holds_Cur IS
574: SELECT AH.hold_lookup_code
575: FROM AP_HOLDS AH,
576: AP_HOLD_CODES AHC
577: WHERE AH.invoice_id = P_invoice_id
578: AND AH.hold_lookup_code = AHC.hold_lookup_code
579: AND AH.release_lookup_code IS NULL

Line 990: FROM ap_holds AH

986: BEGIN
987:
988: SELECT count(*)
989: INTO l_chk_encum
990: FROM ap_holds AH
991: ,ap_hold_codes AHC
992: WHERE AH.invoice_id = P_invoice_id
993: AND AH.hold_lookup_code = AHC.hold_lookup_code
994: AND AH.release_lookup_code IS NULL

Line 1059: FROM ap_holds AH

1055:
1056: BEGIN
1057: SELECT count(*)
1058: INTO l_holds_count
1059: FROM ap_holds AH
1060: ,ap_hold_codes AHC
1061: WHERE AH.invoice_id = P_invoice_id
1062: AND AH.hold_lookup_code = AHC.hold_lookup_code
1063: AND AH.release_lookup_code IS NULL

Line 1085: FROM ap_holds AH

1081: l_debug_info := 'Check if invoice has any tax holds';
1082:
1083: SELECT count(*)
1084: INTO l_tax_holds_count
1085: FROM ap_holds AH
1086: ,ap_hold_codes AHC
1087: WHERE AH.invoice_id = P_invoice_id
1088: AND AH.hold_lookup_code = AHC.hold_lookup_code
1089: AND AH.release_lookup_code IS NULL

Line 1155: UPDATE ap_holds

1151: ,last_updated_by = P_last_updated_by
1152: ,last_update_date = sysdate
1153: WHERE invoice_id = P_invoice_id;
1154:
1155: UPDATE ap_holds
1156: SET release_lookup_code = 'APPROVED'
1157: ,release_reason = ( SELECT description
1158: FROM ap_hold_codes
1159: WHERE hold_lookup_code = 'APPROVED')

Line 1176: (p_table_name => 'AP_HOLDS',

1172: p_key_value1 => P_Invoice_id,
1173: p_calling_sequence => l_curr_calling_sequence);
1174:
1175: AP_DBI_PKG.Maintain_DBI_Summary
1176: (p_table_name => 'AP_HOLDS',
1177: p_operation => 'U',
1178: p_key_value1 => P_Invoice_id,
1179: p_calling_sequence => l_curr_calling_sequence);
1180: