APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_DETAILS_PKG

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