PACKAGE: APPS.JAI_AP_TDS_OLD_PKG

Source

1 PACKAGE jai_ap_tds_old_pkg
2 /* $Header: jai_ap_tds_old.pls 120.1 2005/07/20 12:55:13 avallabh ship $ */
3 AUTHID CURRENT_USER AS
4 PROCEDURE cancel_invoice
5 (
6   errbuf OUT NOCOPY VARCHAR2,
7   retcode OUT NOCOPY VARCHAR2,
8   p_invoice_id IN NUMBER
9 );
10 
11 PROCEDURE process_prepayment_unapply
12 (
13 errbuf OUT NOCOPY VARCHAR2,
14 retcode OUT NOCOPY VARCHAR2,
15 p_invoice_id 				IN 			NUMBER,
16 p_last_updated_by 			IN 			NUMBER,
17 p_last_update_date 			IN 			DATE,
18 p_created_by 				IN 			NUMBER,
19 p_creation_date 			IN 			DATE,
20 p_org_id 					IN 			NUMBER,
21 p_prepay_dist_id 			IN 			NUMBER,
22 p_inv_dist_id 				IN 			NUMBER,
23 p_attribute 				IN 			VARCHAR2
24 );
25 
26 PROCEDURE process_prepayment_apply(
27   errbuf OUT NOCOPY VARCHAR2,
28   retcode OUT NOCOPY VARCHAR2,
29   p_invoice_id        IN     NUMBER,
30   p_invoice_distribution_id   IN     NUMBER,
31   p_amount          IN     NUMBER,
32   p_last_updated_by       IN     NUMBER,
33   p_last_update_date      IN     DATE,
34   p_created_by        IN     NUMBER,
35   p_creation_date       IN     DATE,
36   p_org_id          IN     NUMBER,
37   p_prepay_dist_id      IN     NUMBER,
38   p_param           IN     VARCHAR2,
39   p_attribute         IN     VARCHAR2
40 );
41 
42 PROCEDURE approve_invoice
43 (
44 errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY VARCHAR2,
46 p_parent_request_id     IN      NUMBER,
47 p_vendor_id         IN      NUMBER,
48 p_vendor_site_id      IN      NUMBER,
49 p_invoice_id        IN      NUMBER,
50 p_invoice_num         IN      VARCHAR2 DEFAULT NULL,
51 p_inv_type          IN      VARCHAR2 DEFAULT NULL
52 );
53 
54 
55 FUNCTION get_invoice_status (l_invoice_id IN NUMBER,
56                                                   l_invoice_amount IN NUMBER,
57                                                   l_payment_status_flag IN VARCHAR2,
58                                                   l_invoice_type_lookup_code IN VARCHAR2,
59                                                   I_org_id number )
60          RETURN VARCHAR2;
61 
62 END jai_ap_tds_old_pkg;