APPS.IGS_AS_DOC_DETAILS_PKG dependencies on IGS_AS_DOC_DLVY_TYP

Line 450: /* ELSIF NOT igs_as_doc_dlvy_typ_pkg.get_pk_For_validation (

446: IF (((old_references.delivery_method_type = new_references.delivery_method_type))
447: OR ((new_references.delivery_method_type IS NULL))
448: ) THEN
449: NULL;
450: /* ELSIF NOT igs_as_doc_dlvy_typ_pkg.get_pk_For_validation (
451: new_references.delivery_method_type
452: ) THEN
453: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
454: FND_MSG_PUB.ADD;

Line 525: PROCEDURE get_fk_igs_as_doc_dlvy_typ (x_delivery_method_type IN VARCHAR2) AS

521: RETURN (FALSE);
522: END IF;
523: END get_pk_for_validation;
524:
525: PROCEDURE get_fk_igs_as_doc_dlvy_typ (x_delivery_method_type IN VARCHAR2) AS
526: /*
527: || Created By : manu.srinivasan
528: || Created On : 28-JAN-2002
529: || Purpose : Validates the Foreign Keys for the table.

Line 551: END get_fk_igs_as_doc_dlvy_typ;

547: RAISE fnd_api.g_exc_error;
548: RETURN;
549: END IF;
550: CLOSE cur_rowid;
551: END get_fk_igs_as_doc_dlvy_typ;
552: --
553: --
554: --
555: PROCEDURE get_fk_igs_ca_inst (x_cal_type IN VARCHAR2, x_sequence_number IN NUMBER) AS

Line 2668: FROM igs_as_doc_dlvy_typ

2664: WHERE lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
2665: AND lkup.lookup_code = cp_document_sub_type;
2666: CURSOR cur_delivery_method (cp_delivery_method_type IN VARCHAR2) IS
2667: SELECT description
2668: FROM igs_as_doc_dlvy_typ
2669: WHERE delivery_method_type = cp_delivery_method_type;
2670: rec_document_type cur_document_type%ROWTYPE;
2671: rec_document_sub_type cur_document_sub_type%ROWTYPE;
2672: rec_delivery_method cur_delivery_method%ROWTYPE;