DBA Data[Home] [Help]

APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_DL_PNOTE_RESP_PKG

Line 338: igf_sl_dl_pnote_resp_pkg.insert_row (

334: l_c_elec_mpn_ind := 'P';
335: ELSE
336: l_c_elec_mpn_ind := SUBSTR(orec.record_data,190,1);
337: END IF;
338: igf_sl_dl_pnote_resp_pkg.insert_row (
339: x_rowid => lv_rowid,
340: x_dlpnr_id => l_dlpnr_id,
341: x_dbth_id => l_dbth_id,
342: x_pnote_ack_date => TO_DATE(RTRIM(SUBSTR(orec.record_data, 1,8)),'YYYYMMDD'),

Line 388: igf_sl_dl_pnote_resp_pkg.insert_row (

384: l_c_elec_mpn_ind := 'P';
385: ELSE
386: l_c_elec_mpn_ind := SUBSTR(orec.record_data,190,1);
387: END IF;
388: igf_sl_dl_pnote_resp_pkg.insert_row (
389: x_rowid => lv_rowid,
390: x_dlpnr_id => l_dlpnr_id,
391: x_dbth_id => l_dbth_id,
392: x_pnote_ack_date => TO_DATE(RTRIM(SUBSTR(orec.record_data, 1,8)),'YYYYMMDD'),

Line 899: igf_sl_dl_pnote_resp_pkg.update_row (

895: BEGIN
896:
897: FOR tbh_cur IN c_tbh_cur LOOP
898:
899: igf_sl_dl_pnote_resp_pkg.update_row (
900: x_mode => 'R',
901: x_rowid => tbh_cur.row_id,
902: x_dlpnr_id => tbh_cur.dlpnr_id,
903: x_dbth_id => tbh_cur.dbth_id,