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_DB_DL_RECONC dependencies on IGF_SL_DL_BATCH

Line 21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

17: INV_HDR_OR_TLR EXCEPTION;
18: INVALID_FILE EXCEPTION;
19: INV_TRL_NUM EXCEPTION;
20:
21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;
24:
25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,

Line 22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,

18: INVALID_FILE EXCEPTION;
19: INV_TRL_NUM EXCEPTION;
20:
21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;
24:
25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,

Line 23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;

19: INV_TRL_NUM EXCEPTION;
20:
21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;
24:
25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;

Line 29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;
28:
29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
30: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
31: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN AS
32: /***************************************************************
33: Created By : smvk

Line 30: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,

26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;
28:
29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
30: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
31: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN AS
32: /***************************************************************
33: Created By : smvk
34: Date Created By : 18-Feb-2003

Line 31: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN AS

27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;
28:
29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
30: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
31: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN AS
32: /***************************************************************
33: Created By : smvk
34: Date Created By : 18-Feb-2003
35: Purpose : Returns TRUE if there exist a valid header for given file type. otherwise returns FALSE

Line 160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;

156: l_fetch_count NUMBER(20) := 0;
157: l_processed_count NUMBER(20) :=0;
158:
159: -- Variables to hold the value derive from header
160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;

Line 161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;

157: l_processed_count NUMBER(20) :=0;
158:
159: -- Variables to hold the value derive from header
160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
165:

Line 162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;

158:
159: -- Variables to hold the value derive from header
160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
165:
166: -- Variables to hold the value derive from trailer

Line 163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;

159: -- Variables to hold the value derive from header
160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
165:
166: -- Variables to hold the value derive from trailer
167: l_n_last_lort_id NUMBER ;

Line 164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;

160: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
161: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
162: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
163: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
164: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
165:
166: -- Variables to hold the value derive from trailer
167: l_n_last_lort_id NUMBER ;
168: l_n_rec_num NUMBER;

Line 359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;

355: l_fetch_count NUMBER(20) := 0;
356: l_processed_count NUMBER(20) :=0;
357:
358: -- Variables to hold the value derive from header
359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;

Line 360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;

356: l_processed_count NUMBER(20) :=0;
357:
358: -- Variables to hold the value derive from header
359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
364:

Line 361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;

357:
358: -- Variables to hold the value derive from header
359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
364:
365: -- Variables to hold the value derive from trailer

Line 362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;

358: -- Variables to hold the value derive from header
359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
364:
365: -- Variables to hold the value derive from trailer
366: l_n_last_lort_id NUMBER ;

Line 363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;

359: l_c_batch_id igf_sl_dl_batch.batch_id%TYPE;
360: l_c_message_class igf_sl_dl_batch.message_class%TYPE;
361: l_d_bth_creation_date igf_sl_dl_batch.bth_creation_date%TYPE;
362: l_c_rej_code igf_sl_dl_batch.batch_rej_code%TYPE;
363: l_c_batch_type igf_sl_dl_batch.batch_type%TYPE;
364:
365: -- Variables to hold the value derive from trailer
366: l_n_last_lort_id NUMBER ;
367: l_n_rec_num NUMBER;