APPS.IGF_SL_GEN dependencies on IGF_SL_CL_FILE_TYPE

Line 623: l_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;

619: Who When What
620:
621: (reverse chronological order - newest change first)
622: ***************************************************************/
623: l_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
624: l_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
625:
626: CURSOR c_file_type IS
627: SELECT file_ident_code, file_ident_name FROM igf_sl_cl_file_type

Line 624: l_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;

620:
621: (reverse chronological order - newest change first)
622: ***************************************************************/
623: l_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
624: l_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
625:
626: CURSOR c_file_type IS
627: SELECT file_ident_code, file_ident_name FROM igf_sl_cl_file_type
628: WHERE cl_version = p_cl_version

Line 627: SELECT file_ident_code, file_ident_name FROM igf_sl_cl_file_type

623: l_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
624: l_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
625:
626: CURSOR c_file_type IS
627: SELECT file_ident_code, file_ident_name FROM igf_sl_cl_file_type
628: WHERE cl_version = p_cl_version
629: AND cl_file_type = p_cl_file_type;
630: BEGIN
631: OPEN c_file_type;

Line 648: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,

644: RETURN NULL;
645:
646: END get_cl_file_type;
647:
648: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,
649: p_file_ident_name IN igf_sl_cl_file_type.file_ident_name%TYPE,
650: p_cl_version OUT NOCOPY igf_sl_cl_file_type.cl_version%TYPE,
651: p_cl_file_type OUT NOCOPY igf_sl_cl_file_type.cl_file_type%TYPE)
652: AS

Line 649: p_file_ident_name IN igf_sl_cl_file_type.file_ident_name%TYPE,

645:
646: END get_cl_file_type;
647:
648: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,
649: p_file_ident_name IN igf_sl_cl_file_type.file_ident_name%TYPE,
650: p_cl_version OUT NOCOPY igf_sl_cl_file_type.cl_version%TYPE,
651: p_cl_file_type OUT NOCOPY igf_sl_cl_file_type.cl_file_type%TYPE)
652: AS
653: /*************************************************************

Line 650: p_cl_version OUT NOCOPY igf_sl_cl_file_type.cl_version%TYPE,

646: END get_cl_file_type;
647:
648: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,
649: p_file_ident_name IN igf_sl_cl_file_type.file_ident_name%TYPE,
650: p_cl_version OUT NOCOPY igf_sl_cl_file_type.cl_version%TYPE,
651: p_cl_file_type OUT NOCOPY igf_sl_cl_file_type.cl_file_type%TYPE)
652: AS
653: /*************************************************************
654: Created By : venagara

Line 651: p_cl_file_type OUT NOCOPY igf_sl_cl_file_type.cl_file_type%TYPE)

647:
648: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,
649: p_file_ident_name IN igf_sl_cl_file_type.file_ident_name%TYPE,
650: p_cl_version OUT NOCOPY igf_sl_cl_file_type.cl_version%TYPE,
651: p_cl_file_type OUT NOCOPY igf_sl_cl_file_type.cl_file_type%TYPE)
652: AS
653: /*************************************************************
654: Created By : venagara
655: Date Created On : 2000/11/20

Line 663: l_cl_version igf_sl_cl_file_type.cl_version%TYPE;

659: Who When What
660:
661: (reverse chronological order - newest change first)
662: ***************************************************************/
663: l_cl_version igf_sl_cl_file_type.cl_version%TYPE;
664: l_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
665:
666: CURSOR c_file_type IS
667: SELECT cl_version, cl_file_type FROM igf_sl_cl_file_type

Line 664: l_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;

660:
661: (reverse chronological order - newest change first)
662: ***************************************************************/
663: l_cl_version igf_sl_cl_file_type.cl_version%TYPE;
664: l_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
665:
666: CURSOR c_file_type IS
667: SELECT cl_version, cl_file_type FROM igf_sl_cl_file_type
668: WHERE file_ident_code = p_file_ident_code

Line 667: SELECT cl_version, cl_file_type FROM igf_sl_cl_file_type

663: l_cl_version igf_sl_cl_file_type.cl_version%TYPE;
664: l_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
665:
666: CURSOR c_file_type IS
667: SELECT cl_version, cl_file_type FROM igf_sl_cl_file_type
668: WHERE file_ident_code = p_file_ident_code
669: AND file_ident_name = p_file_ident_name;
670: BEGIN
671: OPEN c_file_type;