1 PACKAGE ARI_AUDIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARIADTPS.pls 120.0.12020000.3 2013/03/31 11:04:49 melapaku noship $ */
3 ------------------------------------------------------------------------------
4 PROCEDURE Insert_Payment_Audit(
5 p_payment_audit_id IN OUT NOCOPY NUMBER,
6 p_payment_type IN VARCHAR2,
7 p_cust_account_id IN NUMBER,
8 p_customer_site_use_id IN NUMBER DEFAULT NULL,
9 p_oir_payment_status IN VARCHAR2 DEFAULT NULL,
10 p_cash_receipt_id IN NUMBER DEFAULT NULL,
11 p_receipt_date IN DATE DEFAULT SYSDATE,
12 p_receipt_status IN VARCHAR2 DEFAULT NULL,
13 p_last_updated_by IN NUMBER DEFAULT NULL,
14 p_last_update_date IN DATE DEFAULT NULL,
15 p_last_update_login IN NUMBER DEFAULT NULL,
16 p_created_by IN NUMBER DEFAULT NULL,
17 p_creation_date IN DATE DEFAULT NULL,
18 p_currency_code IN VARCHAR2,
19 p_amount IN NUMBER,
20 p_invoices IN VARCHAR2,
21 p_responsibility_id IN NUMBER DEFAULT NULL,
22 p_operating_unit IN NUMBER DEFAULT NULL,
23 p_transaction_id IN NUMBER DEFAULT NULL);
24 ------------------------------------------------------------------------------
25
26 ------------------------------------------------------------------------------
27 PROCEDURE Update_Payment_Audit(
28 p_payment_audit_id IN NUMBER,
29 p_payment_type IN VARCHAR2 DEFAULT NULL,
30 p_cust_account_id IN NUMBER DEFAULT NULL,
31 p_customer_site_use_id IN NUMBER DEFAULT NULL,
32 p_oir_payment_status IN VARCHAR2 DEFAULT NULL,
33 p_cash_receipt_id IN NUMBER DEFAULT NULL,
34 p_receipt_date IN DATE DEFAULT SYSDATE,
35 p_receipt_status IN VARCHAR2 DEFAULT NULL,
36 p_last_updated_by IN NUMBER DEFAULT NULL,
37 p_last_update_date IN DATE DEFAULT NULL,
38 p_last_update_login IN NUMBER DEFAULT NULL,
39 p_created_by IN NUMBER DEFAULT NULL,
40 p_creation_date IN DATE DEFAULT NULL,
41 p_currency_code IN VARCHAR2 DEFAULT NULL,
42 p_amount IN NUMBER DEFAULT NULL,
43 p_invoices IN VARCHAR2 DEFAULT NULL,
44 p_responsibility_id IN NUMBER DEFAULT NULL,
45 p_operating_unit IN NUMBER DEFAULT NULL,
46 p_transaction_id IN NUMBER DEFAULT NULL);
47 ------------------------------------------------------------------------------
48
49 END ARI_AUDIT_PKG;
[Home] [Help]