Oracle EBS payable module batch payment
CREATE OR REPLACE Package xxx_STD_AP_AutoPMTs_pkg Is
/ * =
* Copyright (C) Andy P. Consulting Co., Ltd All rights reserved
* =
* Program Name: xxx_STD_AP_AutoPMTs_pkg
* Author: Andy P.@xxxxxx.Com
* Date: 2013-02-28
* Purpose: Pl/Sql Html Report PKG
* To Aotu PMTs The Invoiis.
*
* Update History
* Version Date Name Description
*
* V1.0 20136-02-28 Andy P.@xxxxxx.Com. Creation
*
=
P_FULLPMT_DFlag varchar2 (2): ='P'
L_Check_PName varchar2 (50): = 'AutoPMTs@AndyPengYu.Com:'
L_Check_Auto_PPMTs varchar2 (30): = 'Auto_PPMTs*'
L_Check_Auto_FOPMTs varchar2 (30): = 'Auto_FOPMTs*'
L_Check_Auto_FMPMTs varchar2 (30): = 'Auto_FMPMTs*'
P_PMTsTii_FlagM varchar2 (2): ='M'
P_PMTsTii_FlagQ varchar2 (2): ='Q'
P_PMTsTii_FlagR varchar2 (2): ='R'
Type DCAmount is table Of Number index by binary_integer
Type DCVarChar is table Of varchar2 (30000) index by binary_integer
P_CPMTsLookup_Code varchar2 (20): = 'NEGOTIABLE'
P_WPMTsLookup_Code varchar2 (20): = 'ISSUED'
P_STDInvoii_Status varchar2 (20): = 'APPROVED'
P_PREInvoii_Status varchar2 (20): = 'UNPAID'
/ * =
-Function Name: get_BankUseID ()
-To get the BankUseID.
=
Function get_BankUseID (P_Org_ID in Number, P_BankAcc_Number in varchar2)
Return Number
/ * =
-Function Name: get_BankAccID ()
-To get the get_BankAccID.
=
Function get_BankAccID (P_Org_ID in Number, P_BankAcc_Number in varchar2)
Return Number
/ * =
-Function Name: get_BankDocID ()
-To get the get_BankDocID.
=
Function get_BankDocID (P_BankAcc_ID in Number
P_BankDoc_Name in varchar2) Return Number
/ * =
-Function Name: get_xxxRate ()
-To get the get_xxxRate.
=
Function get_xxxRate (P_From_Curr in varchar2
P_To_Curr in varchar2
P_xRate_Ti varchar2
P_Accounting_Date in Date) Return Number
/ * =
-Procedure Name: Build_PMTISs ()
-To Build the PMTs Of The Details.
=
Procedure Build_PMTISs (P_Batch_ID Out Number
P_Org_ID in Number
P_TPName in varchar2
P_PMT_Mode in varchar2)
/ * =
-Procedure Name: Build_InvISs ()
-To Build the Invoices Need to Be Paid Of The Details.
=
Procedure Build_InvISs (P_Batch_ID In Number
P_Org_ID In Number
P_TPName in varchar2
P_PMT_Mode in varchar2)
/ * =
-Procedure Name: Auto_PPMTs ()
=
Procedure Auto_PPMTs (P_Suc_Flag Out Varchar2
P_Suc_Log Out Varchar2
P_Batch_ID in Number
P_Org_ID In Number
P_TPName in varchar2
P_PMT_Mode in varchar2)
/ * =
-Procedure Name: Auto_FOPMTs () Of FullPMTs. For One Installment
=
Procedure Auto_FOPMTs (P_Suc_Flag Out Varchar2
P_Suc_Log Out Varchar2
P_Batch_ID In Number
P_Org_ID In Number
P_TPName in varchar2
P_PMT_Mode in varchar2)
/ * =
-Procedure Name: xxxMain ()
-The Main Procedure Of This pkg.
=
Procedure xxxMain (P_Suc_Flag Out Varchar2
P_Suc_Log Out Varchar2
P_Org_ID in Number
P_TPName in varchar2
P_PMT_Mode in varchar2
P_FULLPMT_Flag in varchar2 Default P_FULLPMT_DFlag)
End xxx_STD_AP_AutoPMTs_pkg
