[Home] [Help]
PACKAGE: APPS.GHG_ORG_PROJECT_MAPPINGS_PKG
Source
1 PACKAGE GHG_ORG_PROJECT_MAPPINGS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgorpms.pls 120.1 2011/10/31 08:49:15 pwaghmar noship $ */
3
4 PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5 x_project_mapping_id NUMBER,
6 x_facility_id NUMBER,
7 x_from_project_id NUMBER,
8 x_to_project_id NUMBER,
9 x_from_task_number VARCHAR2,
10 x_to_task_number VARCHAR2,
11 x_org_id NUMBER,
12 x_set_of_books_id NUMBER,
13 x_start_date DATE,
14 x_end_date DATE,
15 x_created_by NUMBER,
16 x_creation_date DATE,
17 x_last_updated_by NUMBER,
18 x_last_update_date DATE,
19 x_last_update_login NUMBER);
20
21 PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
22 x_project_mapping_id NUMBER,
23 x_facility_id NUMBER,
24 x_from_project_id NUMBER,
25 x_to_project_id NUMBER,
26 x_from_task_number VARCHAR2,
27 x_to_task_number VARCHAR2,
28 x_org_id NUMBER,
29 x_set_of_books_id NUMBER,
30 x_start_date DATE,
31 x_end_date DATE,
32 x_created_by NUMBER,
33 x_creation_date DATE,
34 x_last_updated_by NUMBER,
35 x_last_update_date DATE,
36 x_last_update_login NUMBER);
37
38 PROCEDURE delete_row(x_project_mapping_id NUMBER);
39
40 PROCEDURE lock_row (x_rowid IN OUT NOCOPY VARCHAR2,
41 x_project_mapping_id NUMBER,
42 x_facility_id NUMBER,
43 x_from_project_id NUMBER,
44 x_to_project_id NUMBER,
45 x_from_task_number VARCHAR2,
46 x_to_task_number VARCHAR2,
47 x_org_id NUMBER,
48 x_set_of_books_id NUMBER,
49 x_start_date DATE,
50 x_end_date DATE,
51 x_created_by NUMBER,
52 x_creation_date DATE,
53 x_last_updated_by NUMBER,
54 x_last_update_date DATE,
55 x_last_update_login NUMBER);
56
57 END GHG_ORG_PROJECT_MAPPINGS_PKG;