1 PACKAGE AP_CREATE_PAY_SCHEDS_PKG AS
2 /* $Header: apscheds.pls 120.4.12010000.2 2008/11/11 13:01:57 dcshanmu ship $ */
3
4
5 --Bug 4256225
6 TYPE INVOICE_ID IS TABLE OF AP_PAYMENT_SCHEDULES.INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
7 TYPE PAYMENT_NUM IS TABLE OF AP_PAYMENT_SCHEDULES.PAYMENT_NUM%TYPE INDEX BY BINARY_INTEGER;
8 TYPE DUE_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
9 TYPE DISCOUNT_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE INDEX BY BINARY_INTEGER;
10 TYPE SECOND_DISCOUNT_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.SECOND_DISCOUNT_DATE%TYPE INDEX BY BINARY_INTEGER;
11 TYPE THIRD_DISCOUNT_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.THIRD_DISCOUNT_DATE%TYPE INDEX BY BINARY_INTEGER;
12 TYPE LAST_UPDATE_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
13 TYPE LAST_UPDATED_BY IS TABLE OF AP_PAYMENT_SCHEDULES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
14 TYPE LAST_UPDATE_LOGIN IS TABLE OF AP_PAYMENT_SCHEDULES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
15 TYPE CREATION_DATE IS TABLE OF AP_PAYMENT_SCHEDULES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
16 TYPE CREATED_BY IS TABLE OF AP_PAYMENT_SCHEDULES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
17 TYPE PAYMENT_CROSS_RATE IS TABLE OF AP_PAYMENT_SCHEDULES.PAYMENT_CROSS_RATE%TYPE INDEX BY BINARY_INTEGER;
18 TYPE GROSS_AMOUNT IS TABLE OF AP_PAYMENT_SCHEDULES.GROSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19 TYPE INV_CURR_GROSS_AMOUNT IS TABLE OF AP_PAYMENT_SCHEDULES.INV_CURR_GROSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20 TYPE DISCOUNT_AMOUNT_AVAILABLE IS TABLE OF AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE INDEX BY BINARY_INTEGER;
21 TYPE SECOND_DISC_AMT_AVAILABLE IS TABLE OF AP_PAYMENT_SCHEDULES.SECOND_DISC_AMT_AVAILABLE%TYPE INDEX BY BINARY_INTEGER;
22 TYPE THIRD_DISC_AMT_AVAILABLE IS TABLE OF AP_PAYMENT_SCHEDULES.THIRD_DISC_AMT_AVAILABLE%TYPE INDEX BY BINARY_INTEGER;
23 TYPE AMOUNT_REMAINING IS TABLE OF AP_PAYMENT_SCHEDULES.AMOUNT_REMAINING%TYPE INDEX BY BINARY_INTEGER;
24 TYPE DISCOUNT_AMOUNT_REMAINING IS TABLE OF AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_REMAINING%TYPE INDEX BY BINARY_INTEGER;
25 TYPE PAYMENT_PRIORITY IS TABLE OF AP_PAYMENT_SCHEDULES.PAYMENT_PRIORITY%TYPE INDEX BY BINARY_INTEGER;
26 TYPE HOLD_FLAG IS TABLE OF AP_PAYMENT_SCHEDULES.HOLD_FLAG%TYPE INDEX BY BINARY_INTEGER;
27 TYPE PAYMENT_STATUS_FLAG IS TABLE OF AP_PAYMENT_SCHEDULES.PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
28 TYPE BATCH_ID IS TABLE OF AP_PAYMENT_SCHEDULES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
29 TYPE EXTERNAL_BANK_ACCOUNT_ID IS TABLE OF AP_PAYMENT_SCHEDULES.EXTERNAL_BANK_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
30 TYPE ORG_ID IS TABLE OF AP_PAYMENT_SCHEDULES.ORG_ID%TYPE INDEX BY BINARY_INTEGER;
31
32 --4393358
33 TYPE PAYMENT_METHOD_CODE IS TABLE OF AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
34 TYPE REMITTANCE_MESSAGE1 IS TABLE OF AP_PAYMENT_SCHEDULES.REMITTANCE_MESSAGE1%TYPE INDEX BY BINARY_INTEGER;
35 TYPE REMITTANCE_MESSAGE2 IS TABLE OF AP_PAYMENT_SCHEDULES.REMITTANCE_MESSAGE2%TYPE INDEX BY BINARY_INTEGER;
36 TYPE REMITTANCE_MESSAGE3 IS TABLE OF AP_PAYMENT_SCHEDULES.REMITTANCE_MESSAGE3%TYPE INDEX BY BINARY_INTEGER;
37
38 --Third Party Payments
39 TYPE REMIT_TO_SUPPLIER_NAME IS TABLE OF AP_PAYMENT_SCHEDULES.REMIT_TO_SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
40 TYPE REMIT_TO_SUPPLIER_ID IS TABLE OF AP_PAYMENT_SCHEDULES.REMIT_TO_SUPPLIER_ID%TYPE INDEX BY BINARY_INTEGER;
41 TYPE REMIT_TO_SUPPLIER_SITE IS TABLE OF AP_PAYMENT_SCHEDULES.REMIT_TO_SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
42 TYPE REMIT_TO_SUPPLIER_SITE_ID IS TABLE OF AP_PAYMENT_SCHEDULES.REMIT_TO_SUPPLIER_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
43 TYPE RELATIONSHIP_ID IS TABLE OF AP_PAYMENT_SCHEDULES.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;
44
45 --Bug 4256225
46 PROCEDURE Create_Payment_Schedules
47 (
48 P_Invoice_Id IN number,
49 P_Terms_Id IN number,
50 P_Last_Updated_By IN number,
51 P_Created_By IN number,
52 P_Payment_Priority IN number,
53 P_Batch_Id IN number,
54 P_Terms_Date IN date,
55 P_Invoice_Amount IN number,
56 P_Pay_Curr_Invoice_Amount IN number,
57 P_payment_cross_rate IN number,
58 P_Amount_For_Discount IN number,
59 P_Payment_Method IN varchar2,
60 P_Invoice_Currency IN varchar2,
61 P_Payment_currency IN varchar2,
62 P_calling_sequence IN varchar2
63 );
64
65 -- Module that applies terms to an amount and discount amount to
66 -- produce payment schedules and insert them into ap_payment_schedules.
67 -- Called from the invoice import program and from forms through a user
68 -- exit.
69
70 PROCEDURE AP_Create_From_Terms (
71 P_Invoice_Id IN NUMBER,
72 P_Terms_Id IN NUMBER,
73 P_Last_Updated_By IN NUMBER,
74 P_Created_By IN NUMBER,
75 P_Payment_Priority IN NUMBER,
76 P_Batch_Id IN NUMBER,
77 P_Terms_Date IN DATE,
78 P_Invoice_Amount IN NUMBER,
79 P_Pay_Curr_Invoice_Amount IN NUMBER,
80 P_payment_cross_rate IN NUMBER,
81 P_Amount_For_Discount IN NUMBER,
82 P_Payment_Method IN VARCHAR2,
83 P_Invoice_Currency IN VARCHAR2,
84 P_Payment_currency IN VARCHAR2,
85 P_calling_sequence IN VARCHAR2);
86
87 FUNCTION Calc_Due_Date (
88 p_terms_Date IN DATE,
89 p_terms_id IN NUMBER,
90 p_calendar IN VARCHAR2,
91 p_sequence_num IN NUMBER,
92 p_calling_sequence IN VARCHAR2) RETURN DATE;
93 END AP_CREATE_PAY_SCHEDS_PKG;