APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_INTERAGENCY_FUNDS

Line 23: -- variables used by "Update FV_INTERAGENCY_FUNDS Table" process

19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;
20: g_enter VARCHAR2(10);
21: g_exit VARCHAR2(10);
22:
23: -- variables used by "Update FV_INTERAGENCY_FUNDS Table" process
24: parm_inv_creation_date_low DATE;
25: parm_inv_creation_date_high DATE;
26: g_err_buf VARCHAR2(1024);
27: g_err_code NUMBER(15);

Line 68: --* Purpose : Inserts record into fv_interagency_funds table *--

64:
65: --****************************************************************************************--
66: --* Name : insert_ia_recs *--
67: --* Type : Procedure *--
68: --* Purpose : Inserts record into fv_interagency_funds table *--
69: --* Parameters : inv_id *--
70: --* : inv_num *--
71: --* : ven_id *--
72: --* : ven_name *--

Line 76: --* Tables Used : fv_interagency_funds INSERT *--

72: --* : ven_name *--
73: --* Global Vars : g_module_name *--
74: --* Called from : upd_ia_main *--
75: --* Calls : fv_utility.log_mesg *--
76: --* Tables Used : fv_interagency_funds INSERT *--
77: --* Logic : Inserts record into fv_interagency_funds table *--
78: --****************************************************************************************--
79: PROCEDURE insert_ia_recs
80: (

Line 77: --* Logic : Inserts record into fv_interagency_funds table *--

73: --* Global Vars : g_module_name *--
74: --* Called from : upd_ia_main *--
75: --* Calls : fv_utility.log_mesg *--
76: --* Tables Used : fv_interagency_funds INSERT *--
77: --* Logic : Inserts record into fv_interagency_funds table *--
78: --****************************************************************************************--
79: PROCEDURE insert_ia_recs
80: (
81: inv_id NUMBER ,

Line 97: INSERT INTO fv_interagency_funds

93: l_module_name := g_module_name || 'insert_ia_recs';
94: g_err_buf := '';
95: g_err_code := 0;
96:
97: INSERT INTO fv_interagency_funds
98: (
99: interagency_fund_id,
100: set_of_books_id,
101: processed_flag,

Line 114: fv_interagency_funds_s.nextval,

110: invoice_number
111: )
112: VALUES
113: (
114: fv_interagency_funds_s.nextval,
115: g_set_of_books_id,
116: 'N',
117: 'N',
118: SYSDATE,

Line 160: --* : fv_interagency_funds SELECT *--

156: --* : fnd_date.canonical_to_date *--
157: --* Tables Used : ap_invoices SELECT *--
158: --* : po_vendors SELECT *--
159: --* : fv_operating_units SELECT *--
160: --* : fv_interagency_funds SELECT *--
161: --* Logic : *--
162: --****************************************************************************************--
163: PROCEDURE upd_ia_main
164: (

Line 197: FROM fv_interagency_funds

193: AND TO_DATE(ai.creation_date,'DD-MM-YYYY') BETWEEN
194: TO_DATE(parm_inv_creation_date_low,'DD-MM-YYYY') AND
195: TO_DATE(parm_inv_creation_date_high,'DD-MM-YYYY')
196: AND NOT EXISTS (SELECT 'X'
197: FROM fv_interagency_funds
198: WHERE set_of_books_id = p_sob_id
199: AND invoice_id IS NOT NULL
200: AND invoice_id = ai.invoice_id);
201: