eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESTYPE_MAPPING_PKG dependencies on PA_RESTYPE_MAP_TO_RESFORMAT

Line 5: --Purpose : Purpose of this procedure is to insert data into pa_restype_map_to_resformat table.

1: PACKAGE BODY PA_RESTYPE_MAPPING_PKG AS
2: /* $Header: PARSUPGB.pls 120.0 2005/05/31 15:55:52 appldev noship $ */
3:
4: --Procedure : Insert_row
5: --Purpose : Purpose of this procedure is to insert data into pa_restype_map_to_resformat table.
6: --Parameters: All Parameters passed to his procedure are IN parameters.
7:
8: PROCEDURE INSERT_ROW(
9: PX_ROWID IN OUT NOCOPY ROWID,

Line 10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

6: --Parameters: All Parameters passed to his procedure are IN parameters.
7:
8: PROCEDURE INSERT_ROW(
9: PX_ROWID IN OUT NOCOPY ROWID,
10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

Line 11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

7:
8: PROCEDURE INSERT_ROW(
9: PX_ROWID IN OUT NOCOPY ROWID,
10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

Line 12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

8: PROCEDURE INSERT_ROW(
9: PX_ROWID IN OUT NOCOPY ROWID,
10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

Line 13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

9: PX_ROWID IN OUT NOCOPY ROWID,
10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

Line 14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

10: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

Line 15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

11: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type

Line 16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

12: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
20: ) IS

Line 17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

13: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
20: ) IS
21:

Line 18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

14: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
20: ) IS
21:
22:

Line 19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type

15: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
16: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
17: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
18: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
19: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
20: ) IS
21:
22:
23:

Line 27: INSERT INTO PA_RESTYPE_MAP_TO_RESFORMAT(

23:
24: BEGIN
25:
26:
27: INSERT INTO PA_RESTYPE_MAP_TO_RESFORMAT(
28: GROUP_RES_TYPE_CODE,
29: RES_TYPE_CODE ,
30: RES_FORMAT_ID ,
31: RESOURCE_CLASS_ID,

Line 53: --Purpose : Purpose of this procedure is to update data of pa_restype_map_to_resformat table.

49: );
50: END INSERT_ROW;
51:
52: --Procedure : Update_row
53: --Purpose : Purpose of this procedure is to update data of pa_restype_map_to_resformat table.
54: --Parameters: All Parameters passed to his procedure are IN parameters.
55:
56: PROCEDURE UPDATE_ROW(
57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

Line 57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

53: --Purpose : Purpose of this procedure is to update data of pa_restype_map_to_resformat table.
54: --Parameters: All Parameters passed to his procedure are IN parameters.
55:
56: PROCEDURE UPDATE_ROW(
57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

Line 58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

54: --Parameters: All Parameters passed to his procedure are IN parameters.
55:
56: PROCEDURE UPDATE_ROW(
57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

Line 59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

55:
56: PROCEDURE UPDATE_ROW(
57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

Line 60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

56: PROCEDURE UPDATE_ROW(
57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

Line 61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

57: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

Line 62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

58: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type

Line 63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

59: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
67: ) IS

Line 64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

60: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
67: ) IS
68: BEGIN

Line 65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

61: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
67: ) IS
68: BEGIN
69:

Line 66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type

62: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
63: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
64: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
65: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
67: ) IS
68: BEGIN
69:
70: UPDATE pa_restype_map_to_resformat

Line 70: UPDATE pa_restype_map_to_resformat

66: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type
67: ) IS
68: BEGIN
69:
70: UPDATE pa_restype_map_to_resformat
71: set GROUP_RES_TYPE_CODE= P_GROUP_RES_TYPE_CODE,
72: RES_TYPE_CODE = P_RES_TYPE_CODE,
73: RES_FORMAT_ID = P_RES_FORMAT_ID,
74: RESOURCE_CLASS_ID= P_RESOURCE_CLASS_ID,

Line 93: --Purpose : Purpose of this procedure is to delet data from pa_restype_map_to_resformat table.

89:
90: END UPDATE_ROW;
91:
92: --Procedure : Delete_row
93: --Purpose : Purpose of this procedure is to delet data from pa_restype_map_to_resformat table.
94: --Parameters: All Parameters passed to this procedure are IN parameters.
95:
96: PROCEDURE DELETE_ROW(
97: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

Line 97: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

93: --Purpose : Purpose of this procedure is to delet data from pa_restype_map_to_resformat table.
94: --Parameters: All Parameters passed to this procedure are IN parameters.
95:
96: PROCEDURE DELETE_ROW(
97: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
98: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
99: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
100: IS
101:

Line 98: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

94: --Parameters: All Parameters passed to this procedure are IN parameters.
95:
96: PROCEDURE DELETE_ROW(
97: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
98: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
99: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
100: IS
101:
102: begin

Line 99: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)

95:
96: PROCEDURE DELETE_ROW(
97: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
98: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
99: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
100: IS
101:
102: begin
103: delete from pa_restype_map_to_resformat

Line 103: delete from pa_restype_map_to_resformat

99: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
100: IS
101:
102: begin
103: delete from pa_restype_map_to_resformat
104: where GROUP_RES_TYPE_CODE = P_GROUP_RES_TYPE_CODE
105: and RES_TYPE_CODE = P_RES_TYPE_CODE
106: and RES_FORMAT_ID = P_RES_FORMAT_ID;
107:

Line 115: --Purpose : Purpose of this procedure is to lock data from pa_restype_map_to_resformat table.

111:
112: end delete_row;
113:
114: --Procedure : Lock_row
115: --Purpose : Purpose of this procedure is to lock data from pa_restype_map_to_resformat table.
116: --Parameters: All Parameters passed to this procedure are IN parameters.
117:
118: PROCEDURE LOCK_ROW(
119: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

Line 119: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

115: --Purpose : Purpose of this procedure is to lock data from pa_restype_map_to_resformat table.
116: --Parameters: All Parameters passed to this procedure are IN parameters.
117:
118: PROCEDURE LOCK_ROW(
119: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
120: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
121: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
122: IS
123:

Line 120: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

116: --Parameters: All Parameters passed to this procedure are IN parameters.
117:
118: PROCEDURE LOCK_ROW(
119: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
120: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
121: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
122: IS
123:
124: cursor lock_row_csr is

Line 121: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)

117:
118: PROCEDURE LOCK_ROW(
119: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
120: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
121: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type)
122: IS
123:
124: cursor lock_row_csr is
125: select GROUP_RES_TYPE_CODE,RES_TYPE_CODE,RES_FORMAT_ID

Line 126: from pa_restype_map_to_resformat

122: IS
123:
124: cursor lock_row_csr is
125: select GROUP_RES_TYPE_CODE,RES_TYPE_CODE,RES_FORMAT_ID
126: from pa_restype_map_to_resformat
127: for update of GROUP_RES_TYPE_CODE,RES_TYPE_CODE,RES_FORMAT_ID NOWAIT;
128:
129: recinfo lock_row_csr%rowtype;
130: begin

Line 140: --Purpose : Purpose of this procedure is to load data into pa_restype_map_to_resformat table.

136: return;
137: END LOCK_ROW;
138:
139: --Procedure : Load_row
140: --Purpose : Purpose of this procedure is to load data into pa_restype_map_to_resformat table.
141: --Parameters: All Parameters passed to this procedure are IN parameters.
142: PROCEDURE LOAD_ROW(
143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

Line 143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

139: --Procedure : Load_row
140: --Purpose : Purpose of this procedure is to load data into pa_restype_map_to_resformat table.
141: --Parameters: All Parameters passed to this procedure are IN parameters.
142: PROCEDURE LOAD_ROW(
143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

Line 144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

140: --Purpose : Purpose of this procedure is to load data into pa_restype_map_to_resformat table.
141: --Parameters: All Parameters passed to this procedure are IN parameters.
142: PROCEDURE LOAD_ROW(
143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

Line 145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

141: --Parameters: All Parameters passed to this procedure are IN parameters.
142: PROCEDURE LOAD_ROW(
143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

Line 146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

142: PROCEDURE LOAD_ROW(
143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

Line 147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

143: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,
144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

Line 148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,

144: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,
145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,

Line 149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,

145: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,
146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,
153: P_OWNER IN VARCHAR2

Line 150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,

146: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,
147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,
153: P_OWNER IN VARCHAR2
154: ) IS

Line 151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,

147: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,
148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,
153: P_OWNER IN VARCHAR2
154: ) IS
155:

Line 152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,

148: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%type,
149: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%type,
150: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%type,
151: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%type,
152: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%type,
153: P_OWNER IN VARCHAR2
154: ) IS
155:
156: PX_ROWID ROWID;