APPS.AP_CANCEL_PKG dependencies on AP_HOLDS

Line 588: FROM AP_HOLDS AH,

584: ORDER BY line_type_lookup_code;
585:
586: CURSOR Tax_Holds_Cur IS
587: SELECT AH.hold_lookup_code
588: FROM AP_HOLDS AH,
589: AP_HOLD_CODES AHC
590: WHERE AH.invoice_id = P_invoice_id
591: AND AH.hold_lookup_code = AHC.hold_lookup_code
592: AND AH.release_lookup_code IS NULL

Line 1173: FROM ap_holds AH

1169:
1170: BEGIN
1171: SELECT count(*)
1172: INTO l_holds_count
1173: FROM ap_holds AH
1174: ,ap_hold_codes AHC
1175: WHERE AH.invoice_id = P_invoice_id
1176: AND AH.hold_lookup_code = AHC.hold_lookup_code
1177: AND AH.release_lookup_code IS NULL

Line 1199: FROM ap_holds AH

1195: l_debug_info := 'Check if invoice has any tax holds';
1196:
1197: SELECT count(*)
1198: INTO l_tax_holds_count
1199: FROM ap_holds AH
1200: ,ap_hold_codes AHC
1201: WHERE AH.invoice_id = P_invoice_id
1202: AND AH.hold_lookup_code = AHC.hold_lookup_code
1203: AND AH.release_lookup_code IS NULL

Line 1305: FROM ap_holds

1301: l_curr_calling_sequence);
1302:
1303: -- Bug 9691312 : Begin
1304: FOR c_wf_status IN ( SELECT hold_id
1305: FROM ap_holds
1306: WHERE invoice_id = p_invoice_id
1307: AND release_lookup_code IS NULL
1308: AND wf_status IN ( 'STARTED', 'NEGOTIATE' )
1309: )

Line 1315: UPDATE ap_holds

1311: AP_WORKFLOW_PKG.abort_holds_workflow( c_wf_status.hold_id ) ;
1312: END LOOP ;
1313: -- Bug 9691312 : End
1314:
1315: UPDATE ap_holds
1316: SET release_lookup_code = 'APPROVED'
1317: ,release_reason = ( SELECT description
1318: FROM ap_hold_codes
1319: WHERE hold_lookup_code = 'APPROVED')

Line 1336: (p_table_name => 'AP_HOLDS',

1332: p_key_value1 => P_Invoice_id,
1333: p_calling_sequence => l_curr_calling_sequence);
1334:
1335: AP_DBI_PKG.Maintain_DBI_Summary
1336: (p_table_name => 'AP_HOLDS',
1337: p_operation => 'U',
1338: p_key_value1 => P_Invoice_id,
1339: p_calling_sequence => l_curr_calling_sequence);
1340: