DBA Data[Home] [Help]

APPS.IGS_AS_DOC_DETAILS_PKG dependencies on IGS_AS_DUP_DOCS

Line 2770: FROM igs_as_dup_docs dd

2766: DECLARE
2767: CURSOR cur_hist_update_needed (cp_order_number IN NUMBER, cp_item_number IN NUMBER) IS
2768: SELECT dd.ROWID,
2769: dd.*
2770: FROM igs_as_dup_docs dd
2771: WHERE dd.order_number = cp_order_number
2772: AND dd.item_number = cp_item_number
2773: AND dd.fulfilled_by IS NULL;
2774: BEGIN

Line 2776: igs_as_dup_docs_pkg.update_row (

2772: AND dd.item_number = cp_item_number
2773: AND dd.fulfilled_by IS NULL;
2774: BEGIN
2775: FOR rec_hist_update_needed IN cur_hist_update_needed (new_references.order_number, new_references.item_number) LOOP
2776: igs_as_dup_docs_pkg.update_row (
2777: x_rowid => rec_hist_update_needed.ROWID,
2778: x_order_number => rec_hist_update_needed.order_number,
2779: x_item_number => rec_hist_update_needed.item_number,
2780: x_requested_by => rec_hist_update_needed.requested_by,