DBA Data[Home] [Help]

APPS.IGF_GR_RFMS_DISB_ORIG dependencies on IGF_GR_RFMS_BATCH

Line 132: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS

128: FOR UPDATE OF disb_ack_act_status NOWAIT;
129: rec_rfms_disb cur_rfms_disb%ROWTYPE;
130:
131: PROCEDURE upd_rfms_disb(p_rec_disb_orig cur_rfms_disb%ROWTYPE,
132: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS
133:
134: ------------------------------------------------------------------------------
135: --
136: -- Created By : sjadhav

Line 188: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE)

184:
185: PROCEDURE prepare_data
186: ( p_rfms_rec IN cur_rfms_disb%ROWTYPE,
187: p_num_of_records IN OUT NOCOPY NUMBER,
188: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE)
189: IS
190: ------------------------------------------------------------------------------
191: --
192: -- Created By : sjadhav

Line 539: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

535: l_trailer VARCHAR2(1000);
536: l_num_of_rec NUMBER DEFAULT 0;
537: l_amount_total NUMBER DEFAULT 0;
538:
539: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;
540: l_batch_id VARCHAR2(60);
541: l_running_orig_id VARCHAR2(30);
542: l_last_disb_rec VARCHAR2(1);
543: l_valid_rec BOOLEAN;

Line 800: CURSOR cur_gr_rfmb_disb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)

796: lv_message fnd_new_messages.message_name%TYPE;
797: SYSTEM_STATUS VARCHAR2(20);
798: ----Bug #2938258
799:
800: CURSOR cur_gr_rfmb_disb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)
801: IS
802: SELECT
803: rfmb_id
804: FROM

Line 805: igf_gr_rfms_batch

801: IS
802: SELECT
803: rfmb_id
804: FROM
805: igf_gr_rfms_batch
806: WHERE batch_id = p_batch_id;
807:
808: cur_get_rfmb_disb cur_gr_rfmb_disb%ROWTYPE;
809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

Line 809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

805: igf_gr_rfms_batch
806: WHERE batch_id = p_batch_id;
807:
808: cur_get_rfmb_disb cur_gr_rfmb_disb%ROWTYPE;
809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;
810: --end -Bug #2938258
811: BEGIN
812:
813: igf_gr_gen.process_pell_ack (g_ver_num,