[Home] [Help]
PACKAGE: APPS.GHG_ASSETS_PKG
Source
1 PACKAGE ghg_assets_pkg AUTHID CURRENT_USER AS
2 /*$Header: ghgasets.pls 120.1 2011/10/31 09:02:54 pwaghmar noship $ */
3
4 PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5 x_ghg_asset_id NUMBER,
6 x_asset_id NUMBER,
7 x_asset_type_lookup_code VARCHAR2,
8 x_book_type_code VARCHAR2,
9 x_asset_number VARCHAR2,
10 x_description VARCHAR2,
11 x_tag_number VARCHAR2,
12 x_serial_number VARCHAR2,
13 x_transport_type_lookup_code VARCHAR2,
14 x_vendor_id NUMBER,
15 x_vendor_site_id number,
16 x_start_date DATE,
17 x_end_date DATE,
18 x_created_by NUMBER,
19 x_creation_date DATE,
20 x_last_updated_by NUMBER,
21 x_last_update_date date,
22 x_last_update_login number,
23 x_ghg_organization_id number);
24
25 PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
26 x_ghg_asset_id NUMBER,
27 x_asset_id NUMBER,
28 x_asset_type_lookup_code VARCHAR2,
29 x_book_type_code VARCHAR2,
30 x_asset_number VARCHAR2,
31 x_description VARCHAR2,
32 x_tag_number VARCHAR2,
33 x_serial_number VARCHAR2,
34 x_transport_type_lookup_code VARCHAR2,
35 x_vendor_id NUMBER,
36 x_vendor_site_id NUMBER,
37 x_start_date DATE,
38 x_end_date DATE,
39 x_created_by NUMBER,
40 x_creation_date DATE,
41 x_last_updated_by NUMBER,
42 x_last_update_date date,
43 x_last_update_login number,
44 x_ghg_organization_id number);
45
46 PROCEDURE delete_row(x_ghg_asset_id NUMBER);
47
48 PROCEDURE lock_row (x_rowid IN OUT NOCOPY VARCHAR2,
49 x_ghg_asset_id NUMBER,
50 x_asset_id NUMBER,
51 x_asset_type_lookup_code VARCHAR2,
52 x_book_type_code VARCHAR2,
53 x_asset_number VARCHAR2,
54 x_description VARCHAR2,
55 x_tag_number VARCHAR2,
56 x_serial_number VARCHAR2,
57 x_transport_type_lookup_code VARCHAR2,
58 x_vendor_id NUMBER,
59 x_vendor_site_id NUMBER,
60 x_start_date DATE,
61 x_end_date DATE,
62 x_created_by NUMBER,
63 x_creation_date DATE,
64 x_last_updated_by NUMBER,
65 x_last_update_date date,
66 x_last_update_login number,
67 x_ghg_organization_id number);
68
69 END GHG_ASSETS_pkg;