APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_LOCKBOXES

Line 32: g_v_gl_date_source igs_fi_lockboxes.gl_date_source_code%TYPE;

28: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
29: g_v_label_lb_name igs_lookup_values.meaning%TYPE;
30: g_v_noval CONSTANT VARCHAR2(10) := 'NOVALUE';
31: g_n_retcode NUMBER(1) := 0;
32: g_v_gl_date_source igs_fi_lockboxes.gl_date_source_code%TYPE;
33: g_v_user_supp_dt CONSTANT VARCHAR2(30) := 'USER_SUPPLIED_DATE';
34: g_v_deposit_date CONSTANT VARCHAR2(30) := 'DEPOSIT_DATE';
35: g_v_imp_date CONSTANT VARCHAR2(30) := 'IMPORT_DATE';
36: g_v_currency_cd igs_fi_control.currency_cd%TYPE;

Line 215: FROM igs_fi_lockboxes

211: ***************************************************************** */
212: CURSOR cur_lockbox(cp_lockbox_name VARCHAR2,
213: cp_ind_yn VARCHAR2) IS
214: SELECT gl_date_source_code
215: FROM igs_fi_lockboxes
216: WHERE lockbox_name = cp_lockbox_name
217: AND closed_flag = cp_ind_yn;
218:
219: l_b_val_parm BOOLEAN;

Line 405: FUNCTION get_record_type_meaning(p_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,

401:
402: RETURN l_v_desc;
403: END get_fee_period;
404:
405: FUNCTION get_record_type_meaning(p_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
406: p_v_record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) RETURN VARCHAR2 AS
407: /******************************************************************
408: Created By : Amit Gairola
409: Date Created By : 12-Jun-2003

Line 416: CURSOR cur_rc_type(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,

412: Known limitations,enhancements,remarks:
413: Change History
414: Who When What
415: ***************************************************************** */
416: CURSOR cur_rc_type(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
417: cp_rec_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) IS
418: SELECT record_type_code
419: FROM igs_fi_lb_rec_types
420: WHERE lockbox_name = cp_lockbox_name

Line 434: FUNCTION populate_lb_interface(p_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) RETURN BOOLEAN AS

430:
431: RETURN NVL(l_v_rc_type, g_v_noval);
432: END get_record_type_meaning;
433:
434: FUNCTION populate_lb_interface(p_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) RETURN BOOLEAN AS
435: /******************************************************************
436: Created By : Amit Gairola
437: Date Created By : 12-Jun-2003
438: Purpose : Function for populating the global PL/SQL interface table

Line 2393: CURSOR cur_lb_crt(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) IS

2389: SELECT party_id person_id
2390: FROM hz_parties
2391: WHERE party_number = cp_party_number;
2392:
2393: CURSOR cur_lb_crt(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) IS
2394: SELECT default_credit_type_id
2395: FROM igs_fi_lockboxes
2396: WHERE lockbox_name = cp_lockbox_name;
2397:

Line 2395: FROM igs_fi_lockboxes

2391: WHERE party_number = cp_party_number;
2392:
2393: CURSOR cur_lb_crt(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE) IS
2394: SELECT default_credit_type_id
2395: FROM igs_fi_lockboxes
2396: WHERE lockbox_name = cp_lockbox_name;
2397:
2398: CURSOR cur_fcmap(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
2399: cp_bank_cd igs_fi_lb_fcis.bank_cd%TYPE) IS

Line 2398: CURSOR cur_fcmap(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,

2394: SELECT default_credit_type_id
2395: FROM igs_fi_lockboxes
2396: WHERE lockbox_name = cp_lockbox_name;
2397:
2398: CURSOR cur_fcmap(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
2399: cp_bank_cd igs_fi_lb_fcis.bank_cd%TYPE) IS
2400: SELECT fee_cal_type,
2401: fee_ci_sequence_number
2402: FROM igs_fi_lb_fcis

Line 4257: PROCEDURE populate_err_rec( p_v_lockbox_name IN igs_fi_lockboxes.lockbox_name%TYPE,

4253: END IF;
4254: END IF;
4255: END valtype2_and_import_rects;
4256:
4257: PROCEDURE populate_err_rec( p_v_lockbox_name IN igs_fi_lockboxes.lockbox_name%TYPE,
4258: p_t_err_rec_tab OUT NOCOPY lb_receipt_tab) AS
4259:
4260: /******************************************************************
4261: Created By : Shirish Tatikonda

Line 4269: CURSOR cur_err_rec( cp_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE ) IS

4265: Known limitations,enhancements,remarks:
4266: Change History
4267: Who When What
4268: ***************************************************************** */
4269: CURSOR cur_err_rec( cp_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE ) IS
4270: SELECT ROWID row_id, lre.*
4271: FROM igs_fi_lb_rect_errs lre
4272: WHERE lockbox_name = cp_v_lockbox_name
4273: FOR UPDATE NOWAIT;