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.

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_ORDER_HDR

Line 425: igs_as_order_hdr hdr

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
429: AND doc.document_type =

Line 706: CURSOR c_ord (cp_order_number igs_as_order_hdr.order_number%TYPE) IS

702: -- and raised error when order not found, sysdate
703: -- not in the ftci start end date aliases
704: -- swaghmar 22-Aug-2005 Bug 4506599
705: ------------------------------------------------------------------------------
706: CURSOR c_ord (cp_order_number igs_as_order_hdr.order_number%TYPE) IS
707: SELECT (ord.delivery_fee + ord.order_fee) total_amount,
708: ord.*,
709: ord.ROWID row_id
710: FROM igs_as_order_hdr ord

Line 710: FROM igs_as_order_hdr ord

706: CURSOR c_ord (cp_order_number igs_as_order_hdr.order_number%TYPE) IS
707: SELECT (ord.delivery_fee + ord.order_fee) total_amount,
708: ord.*,
709: ord.ROWID row_id
710: FROM igs_as_order_hdr ord
711: WHERE order_number = cp_order_number;
712:
713: CURSOR c_inv(cp_inv igs_as_order_hdr.invoice_id%TYPE) IS
714: SELECT invoice_amount_due

Line 713: CURSOR c_inv(cp_inv igs_as_order_hdr.invoice_id%TYPE) IS

709: ord.ROWID row_id
710: FROM igs_as_order_hdr ord
711: WHERE order_number = cp_order_number;
712:
713: CURSOR c_inv(cp_inv igs_as_order_hdr.invoice_id%TYPE) IS
714: SELECT invoice_amount_due
715: FROM igs_fi_inv_int_all
716: WHERE invoice_id = cp_inv;
717:

Line 846: igs_as_order_hdr_pkg.update_row (

842: --
843: -- update the Order header table with the Invoice id returned by the create_charge api
844: --
845: FOR order_hdr_rec IN c_ord (p_order_number) LOOP
846: igs_as_order_hdr_pkg.update_row (
847: x_mode => 'R',
848: x_rowid => order_hdr_rec.row_id,
849: x_order_number => order_hdr_rec.order_number,
850: x_order_status => order_hdr_rec.order_status,

Line 1004: FROM igs_as_order_hdr hdr

1000: ) AS
1001: CURSOR c_order IS
1002: SELECT ROWID row_id,
1003: hdr.*
1004: FROM igs_as_order_hdr hdr
1005: WHERE order_number = p_order_number;
1006: cur_order c_order%ROWTYPE;
1007: CURSOR c_doc IS
1008: SELECT SUM (NVL (overridden_document_fee, doc_fee_per_copy)),

Line 1034: igs_as_order_hdr_pkg.update_row (

1030: --
1031: -- Once all the information are available make a call to the update row of the order
1032: -- header table.
1033: --
1034: igs_as_order_hdr_pkg.update_row (
1035: x_msg_count => p_msg_count,
1036: x_msg_data => p_msg_data,
1037: x_return_status => p_return_status,
1038: x_rowid => cur_order.row_id,

Line 1251: p_order_number IN igs_as_order_hdr.order_number%TYPE,

1247: --
1248: -- Added by msrinivi acc to bug 2318474 to delete items along with order
1249: --
1250: PROCEDURE delete_order_and_items (
1251: p_order_number IN igs_as_order_hdr.order_number%TYPE,
1252: p_msg_count OUT NOCOPY NUMBER,
1253: p_msg_data OUT NOCOPY VARCHAR2,
1254: p_return_status OUT NOCOPY VARCHAR2
1255: ) AS

Line 1264: FROM igs_as_order_hdr

1260: WHERE order_number = p_order_number;
1261: --
1262: CURSOR c_order IS
1263: SELECT ROWID
1264: FROM igs_as_order_hdr
1265: WHERE order_number = p_order_number;
1266: BEGIN
1267: -- Delete items first
1268: FOR c_items_rec IN c_items LOOP

Line 1284: igs_as_order_hdr_pkg.delete_row (

1280: IF p_return_status IS NULL
1281: OR p_return_status = fnd_api.g_ret_sts_success THEN
1282: FOR c_order_rec IN c_order LOOP
1283: EXIT WHEN c_order%NOTFOUND;
1284: igs_as_order_hdr_pkg.delete_row (
1285: x_rowid => c_order_rec.ROWID,
1286: x_msg_count => p_msg_count,
1287: x_msg_data => p_msg_data,
1288: x_return_status => p_return_status

Line 1556: l_doc_fee igs_as_order_hdr.order_fee%TYPE;

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);
1560: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;

Line 1557: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;

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);
1560: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1561: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');

Line 1744: FROM igs_as_order_hdr ord

1740: -- To select all orders for a person
1741: CURSOR c_order IS
1742: SELECT ord.ROWID row_id,
1743: ord.*
1744: FROM igs_as_order_hdr ord
1745: WHERE person_id = p_person_id
1746: AND order_status = 'INCOMPLETE';
1747: --
1748: c_order_rec c_order%ROWTYPE;

Line 1768: l_order_number igs_as_order_hdr.order_number%TYPE;

1764: WHERE person_id = p_person_id;
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);

Line 1770: l_doc_fee igs_as_order_hdr.order_fee%TYPE;

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);
1774: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;

Line 1771: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;

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);
1774: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1775: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');

Line 1943: igs_as_order_hdr_pkg.update_row (

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,
1945: x_msg_data => l_msg_data,
1946: x_return_status => l_return_status,
1947: x_rowid => c_order_rec.row_id,

Line 2157: igs_as_order_hdr h

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
2161: AND l.plan_id = p_plan_id;

Line 2171: igs_as_order_hdr h

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
2175: AND l.plan_id IS NULL;

Line 2180: FROM igs_as_order_hdr o

2176: -- Cursor to get the order details so that it can be updated..
2177: CURSOR cur_order (cp_order_number NUMBER) IS
2178: SELECT o.ROWID row_id,
2179: o.*
2180: FROM igs_as_order_hdr o
2181: WHERE order_number = cp_order_number;
2182: order_rec cur_order%ROWTYPE;
2183: -- Cursor for updating the item
2184: CURSOR cur_itm_dtls_upd (cp_item_number NUMBER) IS

Line 2224: -- Make a Call to the update row fro igs_as_order_hdr

2220: BEGIN
2221: OPEN cur_order (p_order_number);
2222: FETCH cur_order INTO order_rec;
2223: CLOSE cur_order;
2224: -- Make a Call to the update row fro igs_as_order_hdr
2225: igs_as_order_hdr_pkg.update_row (
2226: x_msg_count => ln_msg_count,
2227: x_msg_data => lv_msg_data,
2228: x_return_status => lv_return_status,

Line 2225: igs_as_order_hdr_pkg.update_row (

2221: OPEN cur_order (p_order_number);
2222: FETCH cur_order INTO order_rec;
2223: CLOSE cur_order;
2224: -- Make a Call to the update row fro igs_as_order_hdr
2225: igs_as_order_hdr_pkg.update_row (
2226: x_msg_count => ln_msg_count,
2227: x_msg_data => lv_msg_data,
2228: x_return_status => lv_return_status,
2229: x_rowid => order_rec.row_id,

Line 2637: l_rowid igs_as_order_hdr_v.row_id%TYPE;

2633: WHERE item_number = p_item_number;
2634: -- Record types
2635: c_items_rec c_items%ROWTYPE;
2636: l_count NUMBER;
2637: l_rowid igs_as_order_hdr_v.row_id%TYPE;
2638: BEGIN
2639: fnd_msg_pub.initialize;
2640: OPEN c_chk_del_allwed;
2641: FETCH c_chk_del_allwed INTO l_count;

Line 2697: p_order_desc IN igs_as_order_hdr.order_description%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,
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

Line 2736: p_order_number IN igs_as_order_hdr.order_number%TYPE,

2732:
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

Line 2741: CURSOR cur_document_type (cp_order_number IN igs_as_order_hdr.order_number%TYPE) IS

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
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;

Line 2946: p_order_desc IN igs_as_order_hdr.order_description%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,
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);

Line 3018: igs_as_order_hdr_pkg.insert_row (

3014: --Only addr1 and country will have NA
3015: --Create Order Here
3016: errbuf := '0';
3017: --ijeddy, Bug 3129712, put the nvl to country instead of county.
3018: igs_as_order_hdr_pkg.insert_row (
3019: x_msg_count => l_msg_count,
3020: x_msg_data => l_msg_data,
3021: x_return_status => l_return_status,
3022: x_rowid => l_rowid,