PACKAGE: APPS.JL_BR_AP_PAY_SCHED_GDF_PKG

Source

1 PACKAGE JL_BR_AP_PAY_SCHED_GDF_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlbrpgps.pls 120.6 2006/05/25 19:22:58 dbetanco ship $ */
3 
4 Procedure VALIDATE_DATE
5             (
6              p_date date,
7              p_city varchar2,
8              p_new_date IN OUT NOCOPY date,
9              p_status IN OUT NOCOPY number);
10 
11 Procedure APXWKB_BR_VALIDATE_DATE_LOCAL
12             (
13              p_in_date Date,
14              p_vendor_site_id Number,
15              new_date_val IN OUT NOCOPY Varchar2);
16 
17 Procedure APXINWKB_BR_DEF_PS_SEGMENTS
18             (
19              P_Invoice_ID Number,
20              p_vendor_site_id Number);
21 
22 PROCEDURE APXINWKB_BR_VALIDATE_PAY_SCHED
23             (
24              P_Invoice_ID Number,
25              p_invoice_type_lookup_code Varchar2,
26              p_colldoc_assoc Varchar2,
27              P_Vendor_Site_Id Number);
28 
29 PROCEDURE Suppl_Def_Pay_Sched_GDF
30             (
31              P_Invoice_Id  ap_invoices_all.invoice_id%TYPE);
32 
33 Procedure VALIDATE_DATE
34             (
35              p_date date,
36              p_city varchar2,
37              p_new_date IN OUT NOCOPY date,
38              p_status IN OUT NOCOPY number,
39              p_state varchar2); --Bug # 2319552
40 
41 /* ***************************************************************
42    Function : GET_BORDERO_BANK_REF
43    Return   : jl_br_ap_collection_docs.OUR_NUMBER
44    Type     : Varchar2
45    Objective: Return Bank references stored in 'our_number'
46               to ipayments extract. This field is display in
47               Bordero as Bank Reference.
48    *************************************************************** */
49 FUNCTION Get_Bordero_Bank_Ref
50            (P_Doc_Payable_ID  IN  IBY_Docs_Payable_All.document_payable_id%TYPE,
51             P_RETURN_STATUS   OUT NOCOPY     Varchar2)
52             RETURN Varchar2;
53 
54 /* ***************************************************************
55    Function : GET_BORDERO_INT_AMT
56    Return   : Invoice Interest Amount
57    Type     : Number
58    Objective: Return Invoice Interest Amount
59    *************************************************************** */
60 FUNCTION Get_Bordero_Int_Amt
61            (P_Doc_Payable_ID    IN  IBY_Docs_Payable_All.document_payable_id%TYPE,
62             P_Process_Type      IN  VARCHAR2,
63             P_RETURN_STATUS     OUT NOCOPY  Varchar2)
64             RETURN Number;
65 
66 /* ***************************************************************
67    Function : GET_BORDERO_ABATEMENT
68    Return   : Invoice Interest Amount
69    Type     : Number
70    Objective: Return Invoice Abatement Amount
71    *************************************************************** */
72 FUNCTION Get_Bordero_Abatement
73            (P_Doc_Payable_ID    IN  IBY_Docs_Payable_All.document_payable_id%TYPE,
74             P_Process_Type      IN  VARCHAR2,
75             P_RETURN_STATUS     OUT NOCOPY  Varchar2)
76             RETURN Number;
77 
78 /* ***************************************************************
79    Function : Check_Brazil
80    Return   : Checking if country is brazil
81    Type     : Number
82    Objective: Verify if invoice country is brazil
83    *************************************************************** */
84 Function Check_Brazil
85            (P_Doc_Payable_ID    IN  IBY_Docs_Payable_All.document_payable_id%TYPE,
86             P_RETURN_STATUS     OUT NOCOPY  Varchar2)
87 RETURN Number;
88 
89 END JL_BR_AP_PAY_SCHED_GDF_PKG; -- Package