eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_DETAILS

Line 261: FROM igs_as_doc_details dtls,

257: item_number,
258: item_status,
259: recip_inst_name,
260: recip_pers_name
261: FROM igs_as_doc_details dtls,
262: igs_lookups_view lkup
263: WHERE dtls.document_sub_type = lkup.lookup_code
264: AND lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
265: AND order_number = p_order_number

Line 329: FROM igs_as_doc_details dtls,

325: || ' '
326: || recip_state
327: || ', '
328: || recip_country addr
329: FROM igs_as_doc_details dtls,
330: igs_lookups_view lkup
331: WHERE dtls.document_sub_type = lkup.lookup_code
332: AND lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
333: AND item_number = p_item_number

Line 424: FROM igs_as_doc_details doc,

420: AND ltfp.person_id = cp_person_id;
421: --
422: CURSOR cur_num_stu_ords (cp_item_number IN NUMBER) IS
423: SELECT NVL (SUM (doc.num_of_copies), 0)
424: FROM igs_as_doc_details doc,
425: igs_as_order_hdr hdr
426: WHERE doc.person_id = p_person_id
427: AND doc.plan_id IS NULL
428: AND doc.item_number < cp_item_number

Line 441: FROM igs_as_doc_details

437: AND NVL (hdr.request_type, 'W') <> 'B';
438: --
439: CURSOR cur_ttl_itm_chrgd_und_free IS
440: SELECT NVL (SUM (num_of_copies), 0)
441: FROM igs_as_doc_details
442: WHERE person_id = p_person_id
443: AND item_number <> NVL (p_item_number, -1)
444: AND plan_id IN (SELECT plan_id
445: FROM igs_as_servic_plan

Line 471: l_doc_type igs_as_doc_details.document_type%TYPE;

467: l_num_stu_ords NUMBER := 0;
468: l_start_at NUMBER := 0;
469: l_temp_var NUMBER := 0;
470: l_diff_in_range NUMBER := 0;
471: l_doc_type igs_as_doc_details.document_type%TYPE;
472: l_ttl_itm_chrgd_und_free NUMBER;
473: l_num_free_cops NUMBER;
474: l_diff_free_ofr_and_avail NUMBER;
475: BEGIN

Line 1010: FROM igs_as_doc_details

1006: cur_order c_order%ROWTYPE;
1007: CURSOR c_doc IS
1008: SELECT SUM (NVL (overridden_document_fee, doc_fee_per_copy)),
1009: SUM (NVL (overridden_doc_delivery_fee, delivery_fee))
1010: FROM igs_as_doc_details
1011: WHERE order_number = p_order_number;
1012: --
1013: -- Variables
1014: --

Line 1015: lndocfeepercopy igs_as_doc_details.doc_fee_per_copy%TYPE;

1011: WHERE order_number = p_order_number;
1012: --
1013: -- Variables
1014: --
1015: lndocfeepercopy igs_as_doc_details.doc_fee_per_copy%TYPE;
1016: lndeliveryfee igs_as_doc_details.delivery_fee%TYPE;
1017: l_new_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
1018: l_dummy_plan_id igs_as_doc_details.plan_id%TYPE;
1019: --

Line 1016: lndeliveryfee igs_as_doc_details.delivery_fee%TYPE;

1012: --
1013: -- Variables
1014: --
1015: lndocfeepercopy igs_as_doc_details.doc_fee_per_copy%TYPE;
1016: lndeliveryfee igs_as_doc_details.delivery_fee%TYPE;
1017: l_new_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
1018: l_dummy_plan_id igs_as_doc_details.plan_id%TYPE;
1019: --
1020: BEGIN

Line 1017: l_new_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;

1013: -- Variables
1014: --
1015: lndocfeepercopy igs_as_doc_details.doc_fee_per_copy%TYPE;
1016: lndeliveryfee igs_as_doc_details.delivery_fee%TYPE;
1017: l_new_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
1018: l_dummy_plan_id igs_as_doc_details.plan_id%TYPE;
1019: --
1020: BEGIN
1021: --

Line 1018: l_dummy_plan_id igs_as_doc_details.plan_id%TYPE;

1014: --
1015: lndocfeepercopy igs_as_doc_details.doc_fee_per_copy%TYPE;
1016: lndeliveryfee igs_as_doc_details.delivery_fee%TYPE;
1017: l_new_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
1018: l_dummy_plan_id igs_as_doc_details.plan_id%TYPE;
1019: --
1020: BEGIN
1021: --
1022: OPEN c_order;

Line 1259: FROM igs_as_doc_details

1255: ) AS
1256: --
1257: CURSOR c_items IS
1258: SELECT ROWID
1259: FROM igs_as_doc_details
1260: WHERE order_number = p_order_number;
1261: --
1262: CURSOR c_order IS
1263: SELECT ROWID

Line 1270: igs_as_doc_details_pkg.delete_row (

1266: BEGIN
1267: -- Delete items first
1268: FOR c_items_rec IN c_items LOOP
1269: EXIT WHEN c_items%NOTFOUND;
1270: igs_as_doc_details_pkg.delete_row (
1271: x_rowid => c_items_rec.ROWID,
1272: x_msg_count => p_msg_count,
1273: x_msg_data => p_msg_data,
1274: x_return_status => p_return_status

Line 1555: l_item_number igs_as_doc_details.item_number%TYPE;

1551: SELECT dfs.amount amount
1552: FROM igs_as_doc_fee_stup dfs
1553: WHERE dfs.document_type = 'LIFE_TIME_TRANS';
1554: -- Variables
1555: l_item_number igs_as_doc_details.item_number%TYPE;
1556: l_doc_fee igs_as_order_hdr.order_fee%TYPE;
1557: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1558: l_itm_row_id VARCHAR2 (25);
1559: l_fmnt_row_id VARCHAR2 (25);

Line 1570: SELECT igs_as_doc_details_s.NEXTVAL

1566: OPEN c_deliv_type;
1567: FETCH c_deliv_type INTO ldeliv_type;
1568: CLOSE c_deliv_type;
1569: --
1570: SELECT igs_as_doc_details_s.NEXTVAL
1571: INTO l_item_number
1572: FROM DUAL;
1573: --
1574: OPEN cur_doc_setup;

Line 1578: igs_as_doc_details_pkg.insert_row (

1574: OPEN cur_doc_setup;
1575: FETCH cur_doc_setup INTO l_lifetime_fee;
1576: CLOSE cur_doc_setup;
1577: -- Inserting an Item
1578: igs_as_doc_details_pkg.insert_row (
1579: x_rowid => l_itm_row_id,
1580: x_order_number => p_order_number,
1581: x_document_type => 'TRANSCRIPT',
1582: x_document_sub_type => 'LIFE_TIME_TRANS',

Line 1753: FROM igs_as_doc_details dtl

1749: -- To select all items for an order
1750: CURSOR c_order_item (cp_order_number IN NUMBER, cp_item_number IN NUMBER) IS
1751: SELECT dtl.ROWID row_id,
1752: dtl.*
1753: FROM igs_as_doc_details dtl
1754: WHERE order_number = cp_order_number
1755: AND document_type = 'TRANSCRIPT'
1756: AND document_sub_type <> 'LIFE_TIME_TRANS'
1757: AND item_status = 'INCOMPLETE';

Line 1769: l_item_number igs_as_doc_details.item_number%TYPE;

1765: c_doc_fee_pmnt_rec c_doc_fee_pmnt_record%ROWTYPE;
1766: c_order_item_rec c_order_item%ROWTYPE;
1767: -- Variables
1768: l_order_number igs_as_order_hdr.order_number%TYPE;
1769: l_item_number igs_as_doc_details.item_number%TYPE;
1770: l_doc_fee igs_as_order_hdr.order_fee%TYPE;
1771: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1772: l_itm_row_id VARCHAR2 (25);
1773: l_fmnt_row_id VARCHAR2 (25);

Line 1807: igs_as_doc_details_pkg.update_row (

1803: LOOP
1804: FETCH c_order_item INTO c_order_item_rec;
1805: EXIT WHEN c_order_item%NOTFOUND;
1806: -- Update all items for the current order with doc_fee = 0
1807: igs_as_doc_details_pkg.update_row (
1808: x_rowid => c_order_item_rec.row_id,
1809: x_order_number => c_order_item_rec.order_number,
1810: x_document_type => c_order_item_rec.document_type,
1811: x_document_sub_type => c_order_item_rec.document_sub_type,

Line 1940: FROM igs_as_doc_details

1936: SELECT NVL (SUM (doc_fee_per_copy), 0),
1937: NVL (SUM (delivery_fee), 0)
1938: INTO l_doc_fee,
1939: l_delivery_fee
1940: FROM igs_as_doc_details
1941: WHERE order_number = l_order_number;
1942: -- Update the order for the above items
1943: igs_as_order_hdr_pkg.update_row (
1944: x_msg_count => l_msg_count,

Line 2156: FROM igs_as_doc_details l,

2152: l.document_type,
2153: l.num_of_copies,
2154: l.delivery_method_type,
2155: l.programs_on_file
2156: FROM igs_as_doc_details l,
2157: igs_as_order_hdr h
2158: WHERE h.person_id = p_person_id
2159: AND l.item_status = 'INCOMPLETE'
2160: AND l.order_number = h.order_number

Line 2170: FROM igs_as_doc_details l,

2166: l.document_type,
2167: l.num_of_copies,
2168: l.delivery_method_type,
2169: l.programs_on_file
2170: FROM igs_as_doc_details l,
2171: igs_as_order_hdr h
2172: WHERE h.person_id = p_person_id
2173: AND l.item_status = 'INCOMPLETE'
2174: AND l.order_number = h.order_number

Line 2187: FROM igs_as_doc_details l

2183: -- Cursor for updating the item
2184: CURSOR cur_itm_dtls_upd (cp_item_number NUMBER) IS
2185: SELECT l.ROWID AS row_id,
2186: l.*
2187: FROM igs_as_doc_details l
2188: WHERE l.item_number = cp_item_number;
2189: rec_dtls cur_itm_dtls_upd%ROWTYPE;
2190: -- Cursor to get the plan Details:
2191: CURSOR cur_plan IS

Line 2268: -- Make a Call to the update row fro igs_as_doc_details

2264: BEGIN
2265: OPEN cur_itm_dtls_upd (p_item_number);
2266: FETCH cur_itm_dtls_upd INTO rec_dtls;
2267: CLOSE cur_itm_dtls_upd;
2268: -- Make a Call to the update row fro igs_as_doc_details
2269: igs_as_doc_details_pkg.update_row (
2270: x_rowid => rec_dtls.row_id,
2271: x_order_number => rec_dtls.order_number,
2272: x_document_type => rec_dtls.document_type,

Line 2269: igs_as_doc_details_pkg.update_row (

2265: OPEN cur_itm_dtls_upd (p_item_number);
2266: FETCH cur_itm_dtls_upd INTO rec_dtls;
2267: CLOSE cur_itm_dtls_upd;
2268: -- Make a Call to the update row fro igs_as_doc_details
2269: igs_as_doc_details_pkg.update_row (
2270: x_rowid => rec_dtls.row_id,
2271: x_order_number => rec_dtls.order_number,
2272: x_document_type => rec_dtls.document_type,
2273: x_document_sub_type => rec_dtls.document_sub_type,

Line 2627: FROM igs_as_doc_details

2623: -- Delete allowed only if the item is
2624: -- not in completed state
2625: CURSOR c_chk_del_allwed IS
2626: SELECT COUNT (*)
2627: FROM igs_as_doc_details
2628: WHERE item_number = p_item_number
2629: AND item_status = 'PROCESSED';
2630: CURSOR c_items IS
2631: SELECT ROWID

Line 2632: FROM igs_as_doc_details

2628: WHERE item_number = p_item_number
2629: AND item_status = 'PROCESSED';
2630: CURSOR c_items IS
2631: SELECT ROWID
2632: FROM igs_as_doc_details
2633: WHERE item_number = p_item_number;
2634: -- Record types
2635: c_items_rec c_items%ROWTYPE;
2636: l_count NUMBER;

Line 2650: igs_as_doc_details_pkg.delete_row (

2646: RAISE fnd_api.g_exc_error;
2647: END IF;
2648: -- Delete all the items in this order
2649: FOR c_items_rec IN c_items LOOP
2650: igs_as_doc_details_pkg.delete_row (
2651: x_rowid => c_items_rec.ROWID,
2652: x_return_status => p_return_status,
2653: x_msg_data => p_msg_data,
2654: x_msg_count => p_msg_count

Line 2692: p_trans_type IN igs_as_doc_details.document_type%TYPE,

2688: p_prog_vers IN VARCHAR2,
2689: p_printer_name IN VARCHAR2,
2690: p_schedule_date IN DATE,
2691: p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
2692: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2693: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2694: p_incl_ind IN VARCHAR2,
2695: p_num_copies IN NUMBER,
2696: p_admin_person_id IN hz_parties.party_id%TYPE,

Line 2693: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,

2689: p_printer_name IN VARCHAR2,
2690: p_schedule_date IN DATE,
2691: p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
2692: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2693: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2694: p_incl_ind IN VARCHAR2,
2695: p_num_copies IN NUMBER,
2696: p_admin_person_id IN hz_parties.party_id%TYPE,
2697: p_order_desc IN igs_as_order_hdr.order_description%TYPE,

Line 2698: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE,

2694: p_incl_ind IN VARCHAR2,
2695: p_num_copies IN NUMBER,
2696: p_admin_person_id IN hz_parties.party_id%TYPE,
2697: p_order_desc IN igs_as_order_hdr.order_description%TYPE,
2698: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE,
2699: p_effbuff OUT NOCOPY VARCHAR2,
2700: p_status OUT NOCOPY VARCHAR2
2701: ) AS
2702: l_req_id NUMBER;

Line 2737: p_item_numbers IN igs_as_doc_details.item_number%TYPE,

2733: PROCEDURE submit_print_request (
2734: p_errbuf OUT NOCOPY VARCHAR2,
2735: p_retcode OUT NOCOPY VARCHAR2,
2736: p_order_number IN igs_as_order_hdr.order_number%TYPE,
2737: p_item_numbers IN igs_as_doc_details.item_number%TYPE,
2738: p_printer_name IN VARCHAR2,
2739: p_schedule_date IN DATE
2740: ) AS
2741: CURSOR cur_document_type (cp_order_number IN igs_as_order_hdr.order_number%TYPE) IS

Line 2743: FROM igs_as_doc_details

2739: p_schedule_date IN DATE
2740: ) AS
2741: CURSOR cur_document_type (cp_order_number IN igs_as_order_hdr.order_number%TYPE) IS
2742: SELECT document_type
2743: FROM igs_as_doc_details
2744: WHERE order_number = cp_order_number;
2745: rec_document_type cur_document_type%ROWTYPE;
2746: l_msg_count NUMBER (10);
2747: l_msg_data VARCHAR2 (2000);

Line 2750: l_order_number igs_as_doc_details.order_number%TYPE;

2746: l_msg_count NUMBER (10);
2747: l_msg_data VARCHAR2 (2000);
2748: l_return_status VARCHAR2 (2);
2749: l_rowid VARCHAR2 (30) := NULL;
2750: l_order_number igs_as_doc_details.order_number%TYPE;
2751: l_item_number igs_as_doc_details.item_number%TYPE;
2752: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2753: l_printer_options_ret BOOLEAN;
2754: l_req_id NUMBER;

Line 2751: l_item_number igs_as_doc_details.item_number%TYPE;

2747: l_msg_data VARCHAR2 (2000);
2748: l_return_status VARCHAR2 (2);
2749: l_rowid VARCHAR2 (30) := NULL;
2750: l_order_number igs_as_doc_details.order_number%TYPE;
2751: l_item_number igs_as_doc_details.item_number%TYPE;
2752: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2753: l_printer_options_ret BOOLEAN;
2754: l_req_id NUMBER;
2755: l_oss_country_cd VARCHAR2 (10) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');

Line 2752: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;

2748: l_return_status VARCHAR2 (2);
2749: l_rowid VARCHAR2 (30) := NULL;
2750: l_order_number igs_as_doc_details.order_number%TYPE;
2751: l_item_number igs_as_doc_details.item_number%TYPE;
2752: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2753: l_printer_options_ret BOOLEAN;
2754: l_req_id NUMBER;
2755: l_oss_country_cd VARCHAR2 (10) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
2756: l_rep_name VARCHAR2 (10);

Line 2941: p_trans_type IN igs_as_doc_details.document_type%TYPE,

2937: p_prog_vers IN VARCHAR2,
2938: p_printer_name IN VARCHAR2,
2939: p_schedule_date IN DATE,
2940: p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
2941: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2942: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2943: p_incl_ind IN VARCHAR2,
2944: p_num_copies IN NUMBER,
2945: p_admin_person_id IN hz_parties.party_id%TYPE,

Line 2942: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,

2938: p_printer_name IN VARCHAR2,
2939: p_schedule_date IN DATE,
2940: p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
2941: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2942: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2943: p_incl_ind IN VARCHAR2,
2944: p_num_copies IN NUMBER,
2945: p_admin_person_id IN hz_parties.party_id%TYPE,
2946: p_order_desc IN igs_as_order_hdr.order_description%TYPE,

Line 2947: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE

2943: p_incl_ind IN VARCHAR2,
2944: p_num_copies IN NUMBER,
2945: p_admin_person_id IN hz_parties.party_id%TYPE,
2946: p_order_desc IN igs_as_order_hdr.order_description%TYPE,
2947: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE
2948: ) AS
2949: l_person_id VARCHAR2 (15);
2950: l_prog_cd VARCHAR2 (10);
2951: l_prog_ver NUMBER (10);

Line 2960: l_order_number igs_as_doc_details.order_number%TYPE;

2956: l_msg_count NUMBER (10);
2957: l_msg_data VARCHAR2 (2000);
2958: l_return_status VARCHAR2 (2);
2959: l_rowid VARCHAR2 (30) := NULL;
2960: l_order_number igs_as_doc_details.order_number%TYPE;
2961: l_item_number igs_as_doc_details.item_number%TYPE;
2962: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2963: l_printer_options_ret BOOLEAN;
2964: l_req_id NUMBER;

Line 2961: l_item_number igs_as_doc_details.item_number%TYPE;

2957: l_msg_data VARCHAR2 (2000);
2958: l_return_status VARCHAR2 (2);
2959: l_rowid VARCHAR2 (30) := NULL;
2960: l_order_number igs_as_doc_details.order_number%TYPE;
2961: l_item_number igs_as_doc_details.item_number%TYPE;
2962: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2963: l_printer_options_ret BOOLEAN;
2964: l_req_id NUMBER;
2965: l_oss_country_cd VARCHAR2 (10);

Line 2962: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;

2958: l_return_status VARCHAR2 (2);
2959: l_rowid VARCHAR2 (30) := NULL;
2960: l_order_number igs_as_doc_details.order_number%TYPE;
2961: l_item_number igs_as_doc_details.item_number%TYPE;
2962: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2963: l_printer_options_ret BOOLEAN;
2964: l_req_id NUMBER;
2965: l_oss_country_cd VARCHAR2 (10);
2966: l_rep_name VARCHAR2 (10);

Line 3080: igs_as_doc_details_pkg.insert_row (

3076: l_programs_on_file := 'ALL';
3077: ELSE
3078: l_programs_on_file := l_prog_cd;
3079: END IF;
3080: igs_as_doc_details_pkg.insert_row (
3081: x_rowid => l_rowid,
3082: x_order_number => l_order_number,
3083: x_document_type => 'TRANSCRIPT',
3084: x_document_sub_type => p_trans_type,

Line 3355: FROM igs_as_doc_details

3351: FUNCTION is_order_del_alwd (p_order_number NUMBER)
3352: RETURN VARCHAR2 IS
3353: CURSOR c_chk_itm_count IS
3354: SELECT COUNT (*)
3355: FROM igs_as_doc_details
3356: WHERE order_number = p_order_number
3357: AND item_status = 'PROCESSED';
3358: l_ret_value VARCHAR2 (1);
3359: l_count NUMBER (10);