PACKAGE: APPS.APRX_PY

Source

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