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.IGF_SL_GEN dependencies on IGF_SL_DL_FILE_TYPE

Line 518: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,

514:
515:
516:
517:
518: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
519: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
520: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
521: p_return_type VARCHAR2)
522: RETURN VARCHAR2

Line 519: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,

515:
516:
517:
518: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
519: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
520: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
521: p_return_type VARCHAR2)
522: RETURN VARCHAR2
523: AS

Line 520: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,

516:
517:
518: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
519: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
520: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
521: p_return_type VARCHAR2)
522: RETURN VARCHAR2
523: AS
524: /*************************************************************

Line 534: l_message_class igf_sl_dl_file_type.message_class%TYPE;

530: Who When What
531:
532: (reverse chronological order - newest change first)
533: ***************************************************************/
534: l_message_class igf_sl_dl_file_type.message_class%TYPE;
535: l_batch_type igf_sl_dl_file_type.batch_type%TYPE;
536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;
538:

Line 535: l_batch_type igf_sl_dl_file_type.batch_type%TYPE;

531:
532: (reverse chronological order - newest change first)
533: ***************************************************************/
534: l_message_class igf_sl_dl_file_type.message_class%TYPE;
535: l_batch_type igf_sl_dl_file_type.batch_type%TYPE;
536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;
538:
539: CURSOR c_file_type IS

Line 536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;

532: (reverse chronological order - newest change first)
533: ***************************************************************/
534: l_message_class igf_sl_dl_file_type.message_class%TYPE;
535: l_batch_type igf_sl_dl_file_type.batch_type%TYPE;
536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;
538:
539: CURSOR c_file_type IS
540: SELECT message_class, batch_type, cycle_year, rec_length FROM igf_sl_dl_file_type

Line 537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;

533: ***************************************************************/
534: l_message_class igf_sl_dl_file_type.message_class%TYPE;
535: l_batch_type igf_sl_dl_file_type.batch_type%TYPE;
536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;
538:
539: CURSOR c_file_type IS
540: SELECT message_class, batch_type, cycle_year, rec_length FROM igf_sl_dl_file_type
541: WHERE dl_version = p_dl_version

Line 540: SELECT message_class, batch_type, cycle_year, rec_length FROM igf_sl_dl_file_type

536: l_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
537: l_rec_length igf_sl_dl_file_type.rec_length%TYPE;
538:
539: CURSOR c_file_type IS
540: SELECT message_class, batch_type, cycle_year, rec_length FROM igf_sl_dl_file_type
541: WHERE dl_version = p_dl_version
542: AND dl_file_type = p_dl_file_type
543: AND dl_loan_catg = p_dl_loan_catg;
544: BEGIN

Line 568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,

564: END get_dl_file_type;
565:
566:
567:
568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)

Line 569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,

565:
566:
567:
568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
573: AS

Line 570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,

566:
567:
568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
573: AS
574: /*************************************************************

Line 571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,

567:
568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
573: AS
574: /*************************************************************
575: Created By : venagara

Line 572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)

568: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
569: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
570: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
571: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
572: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
573: AS
574: /*************************************************************
575: Created By : venagara
576: Date Created On : 2000/11/20

Line 584: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;

580: Who When What
581:
582: (reverse chronological order - newest change first)
583: ***************************************************************/
584: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
585: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
586: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
587:
588: CURSOR c_file_type IS

Line 585: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;

581:
582: (reverse chronological order - newest change first)
583: ***************************************************************/
584: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
585: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
586: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
587:
588: CURSOR c_file_type IS
589: SELECT dl_version, dl_file_type, dl_loan_catg FROM igf_sl_dl_file_type

Line 586: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;

582: (reverse chronological order - newest change first)
583: ***************************************************************/
584: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
585: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
586: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
587:
588: CURSOR c_file_type IS
589: SELECT dl_version, dl_file_type, dl_loan_catg FROM igf_sl_dl_file_type
590: WHERE message_class = p_message_class

Line 589: SELECT dl_version, dl_file_type, dl_loan_catg FROM igf_sl_dl_file_type

585: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
586: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
587:
588: CURSOR c_file_type IS
589: SELECT dl_version, dl_file_type, dl_loan_catg FROM igf_sl_dl_file_type
590: WHERE message_class = p_message_class
591: AND batch_type = p_batch_type;
592: BEGIN
593: OPEN c_file_type;

Line 608: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,

604:
605: END get_dl_batch_details;
606:
607:
608: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
609: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
610: p_return_type VARCHAR2)
611: RETURN VARCHAR2
612: AS

Line 609: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,

605: END get_dl_batch_details;
606:
607:
608: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
609: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
610: p_return_type VARCHAR2)
611: RETURN VARCHAR2
612: AS
613: /*************************************************************