1 PACKAGE PA_RESTYPE_MAPPING_PKG AUTHID CURRENT_USER AS
2 /* $Header: PARSUPGS.pls 120.1 2005/08/19 17:00:51 mwasowic noship $ */
3 -- Procedure : insert_row
4 -- Purpose : To insert data into pa_restype_map_to_resformat table
5 PROCEDURE insert_row(
6 PX_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
7 P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
8 P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
9 P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
10 P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
11 P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
12 P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
13 P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
14 P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
15 P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
16 P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type);
17
18
19
20 -- updates record into PA_RESTYPE_MAP_TO_RESFORMAT table
21 -- Procedure : update_row
22 -- Purpose : To update data of pa_restype_map_to_resformat table
23
24 PROCEDURE update_row(
25 P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
26 P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
27 P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
28 P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
29 P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
30 P_CREATION_DATE IN pa_restype_map_to_resformat.CREATION_DATE%type,
31 P_CREATED_BY IN pa_restype_map_to_resformat.CREATED_BY%type,
32 P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.LAST_UPDATE_LOGIN%type,
33 P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.LAST_UPDATED_BY%type,
34 P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.LAST_UPDATE_DATE%type);
35
36 -- Procedure : delete_row
37 -- Purpose : To delete data from pa_restype_map_to_resformat table
38 PROCEDURE delete_row(
39 P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
40 P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
41 P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type);
42
43
44 -- Procedure : lock_row
45 -- Purpose : To lock data from pa_restype_map_to_resformat table
46 PROCEDURE lock_row(
47 P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
48 P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
49 P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type);
50
51 -- Procedure : load_row
52 -- Purpose : To load data into pa_restype_map_to_resformat table from .ldt file
53 PROCEDURE load_row(
54 P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
55 P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
56 P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
57 P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
58 P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
59 P_CREATION_DATE IN pa_restype_map_to_resformat.CREATION_DATE%type,
60 P_CREATED_BY IN pa_restype_map_to_resformat.CREATED_BY%type,
61 P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.LAST_UPDATE_LOGIN%type,
62 P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.LAST_UPDATED_BY%type,
63 P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.LAST_UPDATE_DATE%type,
64 P_OWNER IN varchar2);
65
66
67 END PA_RESTYPE_MAPPING_PKG;