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 4: -- Purpose : To insert data into pa_restype_map_to_resformat table

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,

Line 7: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

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,

Line 8: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

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,

Line 9: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

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,

Line 10: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

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,

Line 11: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

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,

Line 12: P_CREATION_DATE IN pa_restype_map_to_resformat.creation_date%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);

Line 13: P_CREATED_BY IN pa_restype_map_to_resformat.created_by%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:

Line 14: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.last_update_login%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:

Line 15: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.last_updated_by%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:

Line 16: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.last_update_date%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

Line 20: -- updates record into PA_RESTYPE_MAP_TO_RESFORMAT table

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(

Line 22: -- Purpose : To update data of pa_restype_map_to_resformat table

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,

Line 25: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

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,

Line 26: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

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,

Line 27: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

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,

Line 28: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

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,

Line 29: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

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,

Line 30: P_CREATION_DATE IN pa_restype_map_to_resformat.CREATION_DATE%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);

Line 31: P_CREATED_BY IN pa_restype_map_to_resformat.CREATED_BY%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:

Line 32: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.LAST_UPDATE_LOGIN%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

Line 33: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.LAST_UPDATED_BY%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

Line 34: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.LAST_UPDATE_DATE%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(

Line 37: -- Purpose : To delete data from pa_restype_map_to_resformat table

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);

Line 39: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%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:

Line 40: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

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

Line 41: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type);

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

Line 45: -- Purpose : To lock data from pa_restype_map_to_resformat table

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);

Line 47: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%type,

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

Line 48: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

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

Line 49: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type);

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(

Line 52: -- Purpose : To load data into pa_restype_map_to_resformat table from .ldt file

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,

Line 54: P_GROUP_RES_TYPE_CODE IN pa_restype_map_to_resformat.group_res_type_code%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,

Line 55: P_RES_TYPE_CODE IN pa_restype_map_to_resformat.res_type_code%type,

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,

Line 56: P_RES_FORMAT_ID IN pa_restype_map_to_resformat.res_format_id%type,

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,

Line 57: P_RESOURCE_CLASS_ID IN pa_restype_map_to_resformat.resource_class_id%type,

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,

Line 58: P_LABOR_FLAG IN pa_restype_map_to_resformat.labor_flag%type,

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,

Line 59: P_CREATION_DATE IN pa_restype_map_to_resformat.CREATION_DATE%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,

Line 60: P_CREATED_BY IN pa_restype_map_to_resformat.CREATED_BY%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);

Line 61: P_LAST_UPDATE_LOGIN IN pa_restype_map_to_resformat.LAST_UPDATE_LOGIN%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:

Line 62: P_LAST_UPDATED_BY IN pa_restype_map_to_resformat.LAST_UPDATED_BY%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:

Line 63: P_LAST_UPDATE_DATE IN pa_restype_map_to_resformat.LAST_UPDATE_DATE%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;