APPS.FV_IPAC dependencies on FV_IPAC_BILLING_ID_S

Line 680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;

676: BEGIN
677: v_trx_excl_flag := 'N';
678: v_trx_proc_flag := 'N';
679: l_module_name := g_module_name || 'insert_trx_rec';
680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
681: INSERT
682: INTO fv_ipac_trx_all
683: (
684: set_of_books_id,

Line 1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;

1243: del_exception_recs;
1244: get_bal_seg_name;
1245:
1246: --get the start of billing Id
1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1248: FOR trx_select_rec IN trx_select
1249: LOOP -- trx_select
1250: init_vars;
1251: v_receipt_method_id := trx_select_rec.receipt_method_id;

Line 1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;

1337: init_vars;
1338: END LOOP; -- detail_select
1339: END LOOP; -- trx_SELECT
1340: --get the end of billing id
1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1342: -- To create REC line equal to a detail lines for each transaction
1343: -- equalize_rec_lines;
1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1345: -- FOR each distibution line of a transaction

Line 2004: fv_ipac_billing_id_s.NEXTVAL,

2000: VALUES
2001: (
2002: v_set_of_books_id,
2003: v_org_id,
2004: fv_ipac_billing_id_s.NEXTVAL,
2005: l_amount,
2006: nvl(trx_receipt_rec.cnt_nm,-99),
2007: trx_receipt_rec.trx_number,
2008: trx_receipt_rec.trx_date,

Line 2073: fv_ipac_billing_id_s.NEXTVAL,

2069: VALUES
2070: (
2071: v_set_of_books_id,
2072: v_org_id,
2073: fv_ipac_billing_id_s.NEXTVAL,
2074: trx_receipt_rec.amount,
2075: '-99',
2076: trx_receipt_rec.trx_number,
2077: trx_receipt_rec.trx_date,

Line 2333: fv_ipac_billing_id_s.NEXTVAL,

2329: VALUES
2330: (
2331: v_set_of_books_id,
2332: v_org_id,
2333: fv_ipac_billing_id_s.NEXTVAL,
2334: trx_receipt_rec.amount,
2335: '-99',
2336: trx_receipt_rec.trx_number,
2337: trx_receipt_rec.trx_date,