PACKAGE: APPS.APRX_PY

Source

1 package aprx_py AUTHID CURRENT_USER as
2 /* $Header: aprxpys.pls 120.5.12020000.2 2012/07/13 19:41:00 mkmeda ship $ */
3 
4 
5 --
6 -- Main AP Payment RX Report
7 procedure payment_register_run(
8 	p_payment_date_start in date,
9 	p_payment_date_end in date,
10 	p_payment_currency_code in varchar2,
11 	p_payment_bank_account_name in varchar2,
12 	p_payment_method in varchar2,
13       p_payment_type_flag in varchar2,
14 	p_ledger_id     in  number,         /* bug8760710 */
15       p_org_id in number, 	/* bug 13941628 */
16 	request_id	in	number,
17 	retcode	out NOCOPY	number,
18 	errbuf	out NOCOPY	varchar2) ;
19 
20 --
21 -- Plug-in Payment Actual Report
22 procedure payment_actual_run(
23 	p_payment_date_start in date,
24 	p_payment_date_end in date,
25 	p_payment_currency_code in varchar2,
26 	p_payment_bank_account_name in varchar2,
27 	p_payment_method in varchar2,
28       p_payment_type_flag in varchar2,
29 	p_ledger_id     in  number,         /* bug8760710 */
30 	request_id	in	number,
31 	retcode	out NOCOPY	number,
32 	errbuf	out NOCOPY	varchar2) ;
33 
34 
35 --
36 -- All event trigger procedures must be defined as public procedures
37 procedure register_before_report;
38 procedure register_bind(c in integer);
39 procedure actual_before_report;
40 
41 
42 --
43 -- This is the structre to hold the placeholder values
44 type var_t is record (
45 	ORGANIZATION_NAME 		VARCHAR2(240),
46 	FUNCTIONAL_CURRENCY_CODE	VARCHAR2(15),
47 	PAYMENT_NUMBER			NUMBER,
48 	PAYMENT_TYPE			VARCHAR2(20),
49 	PAYMENT_DOC_SEQ_NAME		VARCHAR2(30),
50 	PAYMENT_DOC_SEQ_VALUE		NUMBER,
51 	PAYMENT_DATE			DATE,
52 	PAYMENT_CURRENCY_CODE		VARCHAR2(15),
53 	ORIG_PAYMENT_AMOUNT		NUMBER,
54 	ORIG_PAYMENT_BASE_AMOUNT	NUMBER,
55 	PAYMENT_AMOUNT			NUMBER,
56 	PAYMENT_BASE_AMOUNT		NUMBER,
57 	PAYMENT_EXCHANGE_RATE		NUMBER,
58 	PAYMENT_EXCHANGE_DATE		DATE,
59 	PAYMENT_EXCHANGE_TYPE		VARCHAR2(30),
60 	PAYMENT_CLEARED_DATE		DATE,
61 	PAYMENT_CLEARED_AMOUNT		NUMBER,
62 	PAYMENT_CLEARED_BASE_AMOUNT	NUMBER,
63 	PAYMENT_CLEARED_EXC_RATE	NUMBER,
64 	PAYMENT_CLEARED_EXC_DATE	DATE,
65 	PAYMENT_CLEARED_EXC_TYPE	VARCHAR2(30),
66 	PAYMENT_FUTURE_PAY_DUE_DATE	DATE,
67 	PAYMENT_VOID_FLAG		VARCHAR2(10),
68 	PAYMENT_PAY_METHOD		VARCHAR2(25),
69 	PAYMENT_STATUS			VARCHAR2(50),
70 	PAYMENT_DOC_NAME		VARCHAR2(20),
71 	PAYMENT_DISBURSEMENT_TYPE	VARCHAR2(25),
72 	SUPPLIER_NAME			VARCHAR2(240),
73 	SUPPLIER_NAME_ALT		VARCHAR2(320),
74 	SUPPLIER_SITE_CODE		VARCHAR2(15),
75 	SUPPLIER_SITE_CODE_ALT		VARCHAR2(320),
76 	SUPPLIER_ADDRESS_LINE1		VARCHAR2(240),
77 	SUPPLIER_ADDRESS_LINE2		VARCHAR2(240),
78 	SUPPLIER_ADDRESS_LINE3		VARCHAR2(240),
79 	SUPPLIER_ADDRESS_ALT		VARCHAR2(560),
80 	SUPPLIER_CITY			AP_SUPPLIER_SITES_ALL.city%type, --6708281
81 	SUPPLIER_STATE			VARCHAR2(150),
82 	SUPPLIER_PROVINCE		VARCHAR2(150),
83 	SUPPLIER_POSTAL_CODE		AP_SUPPLIER_SITES_ALL.zip%type, --6708281
84 	SUPPLIER_COUNTRY		AP_SUPPLIER_SITES_ALL.country%type, --6708281
85 	SUPPLIER_TERRITORY		VARCHAR2(80),
86 	INT_BANK_NAME			VARCHAR2(60),
87 	INT_BANK_NAME_ALT		VARCHAR2(320),
88 	INT_BANK_NUMBER			VARCHAR2(30),
89 	INT_BANK_BRANCH_NAME		VARCHAR2(60),
90 	INT_BANK_BRANCH_NAME_ALT	VARCHAR2(320),
91 	INT_BANK_NUM			VARCHAR2(30),
92 	INT_BANK_ACCOUNT_NAME		VARCHAR2(80),
93 	INT_BANK_ACCOUNT_NAME_ALT	VARCHAR2(320),
94 	INT_BANK_ACCOUNT_NUM		VARCHAR2(30),
95 	INT_BANK_CURRENCY_CODE		VARCHAR2(15),
96 	INV_PAY_AMOUNT			NUMBER,
97 	INV_PAY_BASE_AMOUNT		NUMBER,
98 	INV_PAY_DISCOUNT_TAKEN		NUMBER,
99 	INVOICE_NUM			VARCHAR2(50),
100 	INVOICE_DATE			DATE,
101 	INVOICE_CURRENCY_CODE		VARCHAR2(15),
102 	INVOICE_AMOUNT			NUMBER,
103 	INVOICE_BASE_AMOUNT		NUMBER,
104         INVOICE_DESCRIPTION		VARCHAR2(240)
105 );
106 var var_t;
107 
108 
109 end aprx_py;