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_DOC_DETAILS_PKG dependencies on IGS_AS_DOC_DETAILS

Line 1: PACKAGE BODY igs_as_doc_details_pkg AS

1: PACKAGE BODY igs_as_doc_details_pkg AS
2: /* $Header: IGSDI71B.pls 115.11 2004/01/16 08:40:31 kdande noship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_doc_details%ROWTYPE;
5: new_references igs_as_doc_details%ROWTYPE;

Line 4: old_references igs_as_doc_details%ROWTYPE;

1: PACKAGE BODY igs_as_doc_details_pkg AS
2: /* $Header: IGSDI71B.pls 115.11 2004/01/16 08:40:31 kdande noship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_doc_details%ROWTYPE;
5: new_references igs_as_doc_details%ROWTYPE;
6: --
7: --
8: --

Line 5: new_references igs_as_doc_details%ROWTYPE;

1: PACKAGE BODY igs_as_doc_details_pkg AS
2: /* $Header: IGSDI71B.pls 115.11 2004/01/16 08:40:31 kdande noship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_doc_details%ROWTYPE;
5: new_references igs_as_doc_details%ROWTYPE;
6: --
7: --
8: --
9: PROCEDURE update_fees_of_remaining_items (

Line 20: FROM igs_as_doc_details doc

16: --
17: CURSOR cur_items_to_be_processed IS
18: SELECT doc.ROWID,
19: doc.*
20: FROM igs_as_doc_details doc
21: WHERE doc.person_id = x_person_id
22: AND doc.document_type = x_document_type
23: AND doc.document_sub_type = x_document_sub_type
24: AND doc.item_status = 'INCOMPLETE'

Line 32: igs_as_doc_details_pkg.update_row (

28: l_msg_data VARCHAR2 (2000);
29: l_msg_count NUMBER;
30: BEGIN
31: FOR rec_items_to_be_processed IN cur_items_to_be_processed LOOP
32: igs_as_doc_details_pkg.update_row (
33: x_rowid => rec_items_to_be_processed.ROWID,
34: x_order_number => rec_items_to_be_processed.order_number,
35: x_document_type => rec_items_to_be_processed.document_type,
36: x_document_sub_type => rec_items_to_be_processed.document_sub_type,

Line 290: FROM igs_as_doc_details

286: || (reverse chronological order - newest change first)
287: */
288: CURSOR cur_old_ref_values IS
289: SELECT *
290: FROM igs_as_doc_details
291: WHERE ROWID = x_rowid;
292: BEGIN
293: l_rowid := x_rowid;
294: -- Code for setting the Old and New Reference Values.

Line 509: FROM igs_as_doc_details

505: || (reverse chronological order - newest change first)
506: */
507: CURSOR cur_rowid IS
508: SELECT ROWID
509: FROM igs_as_doc_details
510: WHERE item_number = x_item_number
511: FOR UPDATE NOWAIT;
512: lv_rowid cur_rowid%ROWTYPE;
513: BEGIN

Line 537: FROM igs_as_doc_details

533: || (reverse chronological order - newest change first)
534: */
535: CURSOR cur_rowid IS
536: SELECT ROWID
537: FROM igs_as_doc_details
538: WHERE ((delivery_method_type = x_delivery_method_type));
539: lv_rowid cur_rowid%ROWTYPE;
540: BEGIN
541: OPEN cur_rowid;

Line 567: FROM igs_as_doc_details

563: || (reverse chronological order - newest change first)
564: */
565: CURSOR cur_rowid IS
566: SELECT ROWID
567: FROM igs_as_doc_details
568: WHERE ((fgrade_cal_type = x_cal_type)
569: AND (fgrade_seq_num = x_sequence_number)
570: )
571: OR ((deghold_cal_type = x_cal_type)

Line 602: FROM igs_as_doc_details

598: || (reverse chronological order - newest change first)
599: */
600: CURSOR cur_rowid IS
601: SELECT ROWID
602: FROM igs_as_doc_details
603: WHERE ((order_number = x_order_number));
604: lv_rowid cur_rowid%ROWTYPE;
605: BEGIN
606: OPEN cur_rowid;

Line 759: FROM igs_as_doc_details

755: FROM igs_as_order_hdr
756: WHERE order_number = x_order_number;
757: CURSOR c_trans_fee IS
758: SELECT COUNT (*)
759: FROM igs_as_doc_details
760: WHERE order_number = x_order_number
761: AND document_sub_type = 'LIFE_TIME_TRANS';
762: l_person_id igs_as_order_hdr.person_id%TYPE;
763: l_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;

Line 763: l_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;

759: FROM igs_as_doc_details
760: WHERE order_number = x_order_number
761: AND document_sub_type = 'LIFE_TIME_TRANS';
762: l_person_id igs_as_order_hdr.person_id%TYPE;
763: l_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
764: l_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
765: l_num_lft_in_order NUMBER;
766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;

Line 764: l_delivery_fee igs_as_doc_details.delivery_fee%TYPE;

760: WHERE order_number = x_order_number
761: AND document_sub_type = 'LIFE_TIME_TRANS';
762: l_person_id igs_as_order_hdr.person_id%TYPE;
763: l_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
764: l_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
765: l_num_lft_in_order NUMBER;
766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;
768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;

Line 766: l_plan_id igs_as_doc_details.plan_id%TYPE;

762: l_person_id igs_as_order_hdr.person_id%TYPE;
763: l_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
764: l_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
765: l_num_lft_in_order NUMBER;
766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;
768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;

Line 768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;

764: l_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
765: l_num_lft_in_order NUMBER;
766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;
768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;
771: CURSOR cur_doc_and_deliv_fee IS
772: SELECT num_of_copies

Line 769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;

765: l_num_lft_in_order NUMBER;
766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;
768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;
771: CURSOR cur_doc_and_deliv_fee IS
772: SELECT num_of_copies
773: FROM igs_as_doc_details

Line 770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;

766: l_plan_id igs_as_doc_details.plan_id%TYPE;
767: l_request_type igs_as_order_hdr.request_type%TYPE;
768: l_old_doc_fee igs_as_doc_details.doc_fee_per_copy%TYPE;
769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;
771: CURSOR cur_doc_and_deliv_fee IS
772: SELECT num_of_copies
773: FROM igs_as_doc_details
774: WHERE item_number = NVL (x_item_number, -1);

Line 773: FROM igs_as_doc_details

769: l_old_delivery_fee igs_as_doc_details.delivery_fee%TYPE;
770: l_old_num_of_copies igs_as_doc_details.num_of_copies%TYPE;
771: CURSOR cur_doc_and_deliv_fee IS
772: SELECT num_of_copies
773: FROM igs_as_doc_details
774: WHERE item_number = NVL (x_item_number, -1);
775: BEGIN
776: l_plan_id := x_plan_id;
777: OPEN c_pers;

Line 1080: FROM igs_as_doc_details

1076: || (reverse chronological order - newest change first)
1077: */
1078: CURSOR c IS
1079: SELECT ROWID
1080: FROM igs_as_doc_details
1081: WHERE item_number = x_item_number;
1082: CURSOR c_other_items_in_order IS
1083: SELECT a.*,
1084: a.ROWID

Line 1085: FROM igs_as_doc_details a

1081: WHERE item_number = x_item_number;
1082: CURSOR c_other_items_in_order IS
1083: SELECT a.*,
1084: a.ROWID
1085: FROM igs_as_doc_details a
1086: WHERE order_number = x_order_number
1087: AND item_number <> x_item_number
1088: AND document_type = 'TRANSCRIPT';
1089: x_last_update_date DATE;

Line 1128: SELECT igs_as_doc_details_s.NEXTVAL

1124: fnd_msg_pub.ADD;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;
1127: IF x_item_number IS NULL THEN
1128: SELECT igs_as_doc_details_s.NEXTVAL
1129: INTO x_item_number
1130: FROM DUAL;
1131: END IF;
1132: before_dml (

Line 1254: INSERT INTO igs_as_doc_details

1250: x_plan_id => x_plan_id,
1251: x_produced_by => x_produced_by,
1252: x_person_id => x_person_id
1253: );
1254: INSERT INTO igs_as_doc_details
1255: (order_number, document_type, document_sub_type,
1256: item_number, item_status, date_produced,
1257: incl_curr_course, num_of_copies, comments,
1258: recip_pers_name, recip_inst_name, recip_addr_line_1,

Line 1646: FROM igs_as_doc_details

1642: doc_purpose_code,
1643: plan_id,
1644: produced_by,
1645: person_id
1646: FROM igs_as_doc_details
1647: WHERE ROWID = x_rowid
1648: FOR UPDATE NOWAIT;
1649: tlinfo c1%ROWTYPE;
1650: BEGIN

Line 2516: UPDATE igs_as_doc_details

2512: ELSE
2513: x_program_update_date := SYSDATE;
2514: END IF;
2515: END IF;
2516: UPDATE igs_as_doc_details
2517: SET order_number = new_references.order_number,
2518: document_type = new_references.document_type,
2519: document_sub_type = new_references.document_sub_type,
2520: item_status = new_references.item_status,

Line 2943: FROM igs_as_doc_details

2939: || (reverse chronological order - newest change first)
2940: */
2941: CURSOR c1 IS
2942: SELECT ROWID
2943: FROM igs_as_doc_details
2944: WHERE item_number = x_item_number;
2945: l_return_status VARCHAR2 (10);
2946: l_msg_data VARCHAR2 (2000);
2947: l_msg_count NUMBER (10);

Line 3216: p_order_number igs_as_doc_details.order_number%TYPE,

3212: || Who When What
3213: || (reverse chronological order - newest change first)
3214: */
3215: CURSOR c_items_for_this_order (
3216: p_order_number igs_as_doc_details.order_number%TYPE,
3217: p_item_number igs_as_doc_details.item_number%TYPE
3218: ) IS
3219: SELECT a.*,
3220: a.ROWID

Line 3217: p_item_number igs_as_doc_details.item_number%TYPE

3213: || (reverse chronological order - newest change first)
3214: */
3215: CURSOR c_items_for_this_order (
3216: p_order_number igs_as_doc_details.order_number%TYPE,
3217: p_item_number igs_as_doc_details.item_number%TYPE
3218: ) IS
3219: SELECT a.*,
3220: a.ROWID
3221: FROM igs_as_doc_details a

Line 3221: FROM igs_as_doc_details a

3217: p_item_number igs_as_doc_details.item_number%TYPE
3218: ) IS
3219: SELECT a.*,
3220: a.ROWID
3221: FROM igs_as_doc_details a
3222: WHERE order_number = p_order_number
3223: AND item_number <> p_item_number;
3224: l_rowid VARCHAR2 (26);
3225: BEGIN

Line 3228: DELETE FROM igs_as_doc_details

3224: l_rowid VARCHAR2 (26);
3225: BEGIN
3226: fnd_msg_pub.initialize;
3227: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
3228: DELETE FROM igs_as_doc_details
3229: WHERE ROWID = x_rowid;
3230: IF (SQL%NOTFOUND) THEN
3231: RAISE NO_DATA_FOUND;
3232: END IF;

Line 3296: END igs_as_doc_details_pkg;

3292: fnd_msg_pub.ADD;
3293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3294: RETURN;
3295: END delete_row;
3296: END igs_as_doc_details_pkg;