APPS.IGS_AS_PROD_DOC dependencies on IGS_AS_ORD_ITM_INT

Line 101: FROM igs_as_ord_itm_int

97: hold_for_grade_chg,
98: creation_date,
99: hold_degree_expected,
100: programs_on_file
101: FROM igs_as_ord_itm_int
102: WHERE item_number = p_item_number;
103: rec_cur_ord_itm_int cur_ord_itm_int%ROWTYPE;
104:
105: -- To determine if there exists a Transcript Hold for the student.

Line 114: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE) IS

110:
111: -- To determine if the student has a pending transcript hold.
112: --ijeddy, bug 3410409.
113: CURSOR cur_hold_eft (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
114: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE) IS
115: SELECT 'X'
116: FROM igs_pe_persenc_effct
117: WHERE person_id = cp_person_id AND
118: s_encmb_effect_type IN (cst_trans_blk,cst_trans_blk1,cst_trans_blk2,cst_trans_blk3) AND

Line 156: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE)IS

152: rec_cur_as_suaoa cur_as_suaoa%ROWTYPE;
153:
154: -- Cursor to check if the user has requested to 'Hold for Grade Change'.
155: CURSOR cur_chn_grd_req (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
156: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE)IS
157: SELECT 'X'
158: FROM igs_as_chn_grd_req
159: WHERE person_id = cp_person_id AND
160: current_status = cst_in_progress AND

Line 166: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,

162: rec_cur_chn_grd_req cur_chn_grd_req%ROWTYPE;
163:
164: -- For Program centric Mode- Check if the program attempt status is 'COMPLETED' (for all the programs if program is not selected).
165: CURSOR cur_ps_att (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
166: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
167: cp_course_cd igs_en_sca_v.course_cd%TYPE)IS
168: SELECT 'X'
169: FROM igs_en_stdnt_ps_att_all
170: WHERE person_id = cp_person_id AND

Line 177: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,

173: rec_cur_ps_att cur_ps_att%ROWTYPE;
174:
175: -- For Career centric Mode- Check if the program attempt status is 'COMPLETED' (under all the career if career is not selected).
176: CURSOR cur_en_sca (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
177: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
178: cp_course_type igs_en_sca_v.course_type%TYPE)IS
179: SELECT 'X'
180: FROM igs_en_sca_v
181: WHERE person_id = cp_person_id AND

Line 367: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

363: */
364: --
365: -- Cursor to get the user_name corresponding to the person_id
366: --
367: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
368: SELECT user_name
369: FROM fnd_user
370: WHERE person_party_id = cp_person_id;
371: --

Line 558: FROM igs_as_ord_itm_int aoii

554: CURSOR c_person_id (cp_date_produced IN VARCHAR2) IS
555: SELECT aoii.order_number order_number,
556: aoii.item_number item_number,
557: aoii.person_id person_id
558: FROM igs_as_ord_itm_int aoii
559: WHERE fnd_date.date_to_canonical(aoii.date_produced) = cp_date_produced
560: AND aoii.item_status = 'PROCESSED';
561: --
562: -- Cursor to get the oracle applications user_name corresponding to the person_id

Line 564: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

560: AND aoii.item_status = 'PROCESSED';
561: --
562: -- Cursor to get the oracle applications user_name corresponding to the person_id
563: --
564: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
565: SELECT user_name
566: FROM fnd_user
567: WHERE person_party_id = cp_person_id;
568: --

Line 682: (IGS_AS_ORD_ITM_INT.ITEM_STATUS) to PROCESSED and

678: /******************************************************************
679: Created By : Sameer Manglm
680: Date Created By : 22-AUG-2002
681: Purpose : Update Order Docs interface table with the item status
682: (IGS_AS_ORD_ITM_INT.ITEM_STATUS) to PROCESSED and
683: the line item status (IGS_AS_DOC_DETAILS.ITEM_STATUS)
684: to PROCESSED. Also if all the items are processed,
685: update the Order status (IGS_AS_ORDER_HDR.ORDER_STATUS)
686: to COMPLETED.

Line 695: CURSOR c_ord_itm_int (cp_item_number igs_as_ord_itm_int.item_number%TYPE) IS

691: PRAGMA AUTONOMOUS_TRANSACTION;
692: --
693: -- Cursor to check the existence of a record in Order Item Interface Table
694: --
695: CURSOR c_ord_itm_int (cp_item_number igs_as_ord_itm_int.item_number%TYPE) IS
696: SELECT 'x'
697: FROM igs_as_ord_itm_int aoii
698: WHERE aoii.item_number = cp_item_number;
699: --

Line 697: FROM igs_as_ord_itm_int aoii

693: -- Cursor to check the existence of a record in Order Item Interface Table
694: --
695: CURSOR c_ord_itm_int (cp_item_number igs_as_ord_itm_int.item_number%TYPE) IS
696: SELECT 'x'
697: FROM igs_as_ord_itm_int aoii
698: WHERE aoii.item_number = cp_item_number;
699: --
700: -- Cursor to fetch the records from Order Item Interface Table.
701: -- Discontinue automatic posting of Completion for documents having Missing Academic Records

Line 727: -- Update igs_as_ord_itm_int with item_status = PROCESSED and date_produced to sysdate

723: l_msg_count NUMBER;
724: --
725: BEGIN
726: --
727: -- Update igs_as_ord_itm_int with item_status = PROCESSED and date_produced to sysdate
728: -- Discontinue automatic posting of Completion for documents having Missing Academic Records
729: --
730: FOR rec_ord_itm_int IN c_ord_itm_int (p_item_number)
731: LOOP

Line 732: UPDATE igs_as_ord_itm_int

728: -- Discontinue automatic posting of Completion for documents having Missing Academic Records
729: --
730: FOR rec_ord_itm_int IN c_ord_itm_int (p_item_number)
731: LOOP
732: UPDATE igs_as_ord_itm_int
733: SET item_status = 'PROCESSED',
734: date_produced = SYSDATE
735: WHERE item_number = p_item_number
736: AND NVL (missing_acad_record_data_ind, 'N') = 'N';