[Home] [Help]
PACKAGE: APPS.GHG_TRANSACTION_BATCHES_PKG
Source
1 PACKAGE GHG_TRANSACTION_BATCHES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgtxnbs.pls 120.1.12020000.2 2012/10/17 04:37:45 sasuren ship $ */
3
4 PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5 x_transaction_batch_id NUMBER,
6 x_transaction_batch_number VARCHAR2,
7 x_batch_type VARCHAR2,
8 x_batch_sub_type VARCHAR2,
9 x_vendor_id NUMBER,
10 x_vendor_site_id NUMBER,
11 x_description VARCHAR2,
12 x_status VARCHAR2,
13 x_reversal_date DATE,
14 x_reversed_transact_batch_id NUMBER,
15 x_org_id NUMBER,
16 x_set_of_books_id NUMBER,
17 x_created_by NUMBER,
18 x_creation_date DATE,
19 x_last_updated_by NUMBER,
20 x_last_update_date DATE,
21 x_last_update_login NUMBER,
22 x_called_from_api VARCHAR2 DEFAULT 'N');
23
24 PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
25 x_transaction_batch_id NUMBER,
26 x_transaction_batch_number VARCHAR2,
27 x_batch_type VARCHAR2,
28 x_batch_sub_type VARCHAR2,
29 x_vendor_id NUMBER,
30 x_vendor_site_id NUMBER,
31 x_description VARCHAR2,
32 x_status VARCHAR2,
33 x_reversal_date DATE,
34 x_reversed_transact_batch_id NUMBER,
35 x_org_id NUMBER,
36 x_set_of_books_id NUMBER,
37 x_created_by NUMBER,
38 x_creation_date DATE,
39 x_last_updated_by NUMBER,
40 x_last_update_date DATE,
41 x_last_update_login NUMBER);
42
43 PROCEDURE delete_row(x_transaction_batch_id NUMBER);
44
45 PROCEDURE lock_row (x_rowid IN OUT NOCOPY VARCHAR2,
46 x_transaction_batch_id NUMBER,
47 x_transaction_batch_number VARCHAR2,
48 x_batch_type VARCHAR2,
49 x_batch_sub_type VARCHAR2,
50 x_vendor_id NUMBER,
51 x_vendor_site_id NUMBER,
52 x_description VARCHAR2,
53 x_status VARCHAR2,
54 x_reversal_date DATE,
55 x_reversed_transact_batch_id NUMBER,
56 x_org_id NUMBER,
57 x_set_of_books_id NUMBER,
58 x_created_by NUMBER,
59 x_creation_date DATE,
60 x_last_updated_by NUMBER,
61 x_last_update_date DATE,
62 x_last_update_login NUMBER);
63
64 PROCEDURE copy_batch (x_copy_transaction_batch_id NUMBER,
65 x_transaction_batch_id NUMBER,
66 x_created_by NUMBER,
67 x_creation_date DATE,
68 x_last_updated_by NUMBER,
69 x_last_update_date DATE,
70 x_last_update_login NUMBER);
71
72 PROCEDURE reverse_batch (x_transaction_batch_id NUMBER,
73 x_reversed_transact_batch_id NUMBER,
74 x_created_by NUMBER,
75 x_creation_date DATE,
76 x_last_updated_by NUMBER,
77 x_last_update_date DATE,
78 x_last_update_login NUMBER);
79
80
81 END GHG_TRANSACTION_BATCHES_PKG;