1: PACKAGE BODY fv_prompt_pay as
2: -- $Header: FVPPPSTB.pls 120.11 2006/10/11 09:35:07 arcgupta ship $
3: --==============================================================
4: g_module_name VARCHAR2(100) := 'fv.plsql.fv_prompt_pay.';
5:
1: PACKAGE BODY fv_prompt_pay as
2: -- $Header: FVPPPSTB.pls 120.11 2006/10/11 09:35:07 arcgupta ship $
3: --==============================================================
4: g_module_name VARCHAR2(100) := 'fv.plsql.fv_prompt_pay.';
5:
6: -- Error Code and Error Messages
7: v_error_code Number := 0 ;
8: v_error_mesg Varchar2(500) ;
50: v_to_date := to_date ( to_dt , 'YYYY/MM/DD HH24:MI:SS' ) ;
51:
52: /* -- by ks
53: If v_error_code = 0 Then
54: Delete from fv_prompt_pay_temp ;
55: populate_temp_table ;
56: End If ;
57:
58: If v_error_code = 0 Then
133: l_module_name VARCHAR2(200) := g_module_name || 'populate_temp_table';
134:
135: Begin
136:
137: Insert Into fv_prompt_pay_temp
138: ( invoice_id ,
139: pay_invoice_id,
140: pay_payment_number ,
141: pay_due_date ,
201:
202: -----------------------------------------------------------------
203: -- End Of the Package
204: -----------------------------------------------------------------
205: End fv_Prompt_pay ;
206: