APPS.IGS_AS_DOC_DETAILS_PKG dependencies on IGS_AS_ORDER_HDR

Line 487: ELSIF NOT igs_as_order_hdr_pkg.get_pk_for_validation (new_references.order_number) THEN

483: IF (((old_references.order_number = new_references.order_number))
484: OR ((new_references.order_number IS NULL))
485: ) THEN
486: NULL;
487: ELSIF NOT igs_as_order_hdr_pkg.get_pk_for_validation (new_references.order_number) THEN
488: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
489: fnd_msg_pub.ADD;
490: RAISE fnd_api.g_exc_error;
491: END IF;

Line 590: PROCEDURE get_fk_igs_as_order_hdr (x_order_number IN NUMBER) AS

586: END get_fk_igs_ca_inst;
587: --
588: --
589: --
590: PROCEDURE get_fk_igs_as_order_hdr (x_order_number IN NUMBER) AS
591: /*
592: || Created By : manu.srinivasan
593: || Created On : 28-JAN-2002
594: || Purpose : Validates the Foreign Keys for the table.

Line 616: END get_fk_igs_as_order_hdr;

612: RAISE fnd_api.g_exc_error;
613: RETURN;
614: END IF;
615: CLOSE cur_rowid;
616: END get_fk_igs_as_order_hdr;
617: --
618: --
619: --
620: PROCEDURE before_dml (

Line 755: FROM igs_as_order_hdr

751: */
752: CURSOR c_pers IS
753: SELECT person_id,
754: request_type
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

Line 762: l_person_id igs_as_order_hdr.person_id%TYPE;

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

Line 767: l_request_type igs_as_order_hdr.request_type%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;
771: CURSOR cur_doc_and_deliv_fee IS