DBA Data[Home] [Help]

APPS.FV_PROMPT_PAY dependencies on FV_PROMPT_PAY

Line 1: PACKAGE BODY fv_prompt_pay as

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:

Line 4: g_module_name VARCHAR2(100) := 'fv.plsql.fv_prompt_pay.';

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) ;

Line 54: Delete from fv_prompt_pay_temp ;

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

Line 137: Insert Into fv_prompt_pay_temp

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 ,

Line 205: End fv_Prompt_pay ;

201:
202: -----------------------------------------------------------------
203: -- End Of the Package
204: -----------------------------------------------------------------
205: End fv_Prompt_pay ;
206: