168:
169: END IF;
170:
171: --Bug 4539462 DBI logging
172: AP_DBI_PKG.Maintain_DBI_Summary
173: (p_table_name => 'AP_HOLDS',
174: p_operation => 'I',
175: p_key_value1 => X_invoice_id,
176: p_calling_sequence => current_calling_sequence);
476: X_WF_Status)
477: WHERE rowid = X_Rowid;
478:
479: --Bug 4539462 DBI logging
480: AP_DBI_PKG.Maintain_DBI_Summary
481: (p_table_name => 'AP_HOLDS',
482: p_operation => 'U',
483: p_key_value1 => X_invoice_id,
484: p_calling_sequence => current_calling_sequence);
604: Raise NO_DATA_FOUND;
605: end if;
606:
607: --Bug 4539462 DBI logging
608: AP_DBI_PKG.Maintain_DBI_Summary
609: (p_table_name => 'AP_HOLDS',
610: p_operation => 'D',
611: p_key_value1 => l_invoice_id,
612: p_calling_sequence => current_calling_sequence);
766: END IF;
767: END IF;
768:
769: --Bug 4539462 DBI logging
770: AP_DBI_PKG.Maintain_DBI_Summary
771: (p_table_name => 'AP_HOLDS',
772: p_operation => 'I',
773: p_key_value1 => X_invoice_id,
774: p_calling_sequence => current_calling_sequence);
861: AND release_lookup_code IS NULL
862: AND hold_lookup_code = X_hold_lookup_code;
863:
864: --Bug 4539462 DBI logging
865: AP_DBI_PKG.Maintain_DBI_Summary
866: (p_table_name => 'AP_HOLDS',
867: p_operation => 'U',
868: p_key_value1 => X_invoice_id,
869: p_calling_sequence => current_calling_sequence);
1009: 'DIST ACCT INVALID', 'ERV ACCT INVALID', 'LIAB ACCT INVALID')
1010: AND H.release_lookup_code is null;
1011:
1012: --Bug 4539462 DBI logging
1013: AP_DBI_PKG.Maintain_DBI_Summary
1014: (p_table_name => 'AP_HOLDS',
1015: p_operation => 'U',
1016: p_key_value1 => X_invoice_id,
1017: p_calling_sequence => current_calling_sequence);