APPS.IGS_AS_DOCUMENTS_API dependencies on IGS_AS_ORDER_HDR

Line 32: FROM igs_as_order_hdr ord

28: --
29: CURSOR cur_completed_orders IS
30: SELECT ord.ROWID row_id,
31: ord.*
32: FROM igs_as_order_hdr ord
33: WHERE order_status = 'INPROCESS'
34: AND NOT EXISTS ( SELECT item_number
35: FROM igs_as_doc_details itm
36: WHERE ord.order_number = itm.order_number

Line 234: igs_as_order_hdr_pkg.update_row (

230: l_return_status := NULL;
231: l_msg_data := NULL;
232: l_msg_count := NULL;
233: -- Update the Order Status, Date of Completion for the Request in the OSS Order Table.
234: igs_as_order_hdr_pkg.update_row (
235: x_mode => 'R',
236: x_rowid => completed_orders_rec.row_id,
237: x_order_number => completed_orders_rec.order_number,
238: x_order_status => 'COMPLETED',

Line 329: FROM igs_as_order_hdr ord

325: *******************************************************************************/
326: CURSOR cur_order_hdr IS
327: SELECT ord.ROWID row_id,
328: ord.*
329: FROM igs_as_order_hdr ord
330: WHERE order_number = p_order_number;
331: --
332: order_hdr_rec cur_order_hdr%ROWTYPE;
333: --

Line 363: l_person_id igs_as_order_hdr.person_id%TYPE;

359: rec_ord_int_dupl_doc cur_ord_int_dupl_doc%ROWTYPE;
360: l_return_status VARCHAR2 (1);
361: l_msg_count NUMBER;
362: l_msg_data VARCHAR2 (2000);
363: l_person_id igs_as_order_hdr.person_id%TYPE;
364: lv_rowid VARCHAR2 (25);
365: l_create_interface_item BOOLEAN;
366: BEGIN
367: --Initialize message list if p_init_msg_list is set to TRUE.

Line 378: igs_as_order_hdr_pkg.update_row (

374: AND p_plan_id IS NULL THEN
375: IF (cur_order_hdr%FOUND) THEN
376: l_person_id := order_hdr_rec.person_id; -- Need the var to pass to the recal procdure
377: --Update the Order status to 'In Process' and other order details.
378: igs_as_order_hdr_pkg.update_row (
379: x_mode => 'R',
380: x_rowid => order_hdr_rec.row_id,
381: x_order_number => order_hdr_rec.order_number,
382: x_order_status => 'INPROCESS',