1: PACKAGE GMD_OPERATION_RESOURCES_PUB AS
2: /* $Header: GMDPOPRS.pls 120.1.12010000.1 2008/07/24 09:56:44 appldev ship $ */
3: /*#
4: * This interface is used to create, update and delete operation resources.
5: * This package defines and implements the procedures and datatypes
13: */
14:
15: TYPE resources_rec_type IS RECORD
16: (
17: OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
14:
15: TYPE resources_rec_type IS RECORD
16: (
17: OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
15: TYPE resources_rec_type IS RECORD
16: (
17: OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
16: (
17: OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
17: OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
18: ,RESOURCES gmd_operation_resources.resources%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
19: ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
20: ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
21: ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
22: ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
23: ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
24: ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
25: ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
26: ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
27: ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
28: ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
29: ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
30: ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
31: ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
32: ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
33: ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
34: ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
35: ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
36: ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
37: ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
38: ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
39: ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
40: ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
41: ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
42: ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
43: ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
44: ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
45: ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
46: ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
47: ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
48: ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
49: ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
50: ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
51: ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
52: ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
53: ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
54: ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
55: ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
56: ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
57: ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
58: ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
59: ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67: ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
60: ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67: ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
68: ,ACTIVITY gmd_operation_activities.activity%TYPE --added w.r.t. bug 3408799
61: ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67: ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
68: ,ACTIVITY gmd_operation_activities.activity%TYPE --added w.r.t. bug 3408799
69: );
62: ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67: ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
68: ,ACTIVITY gmd_operation_activities.activity%TYPE --added w.r.t. bug 3408799
69: );
70:
63: ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64: ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65: ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66: ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67: ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
68: ,ACTIVITY gmd_operation_activities.activity%TYPE --added w.r.t. bug 3408799
69: );
70:
71: TYPE gmd_oprn_resources_tbl_type IS TABLE OF resources_rec_type INDEX BY BINARY_INTEGER;
81:
82: /*#
83: * Insert a new Operation Resource
84: * This is a PL/SQL procedure to insert a new Operation Resource
85: * Call is made to insert_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
86: * @param p_api_version API version field
87: * @param p_init_msg_list Flag to check if message list intialized
88: * @param p_commit Flag to check for commit
89: * @param p_oprn_line_id Operation Line ID
100: ( p_api_version IN NUMBER DEFAULT 1
101: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
102: , p_commit IN BOOLEAN DEFAULT FALSE
103: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
104: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
105: , x_message_count OUT NOCOPY NUMBER
106: , x_message_list OUT NOCOPY VARCHAR2
107: , x_return_status OUT NOCOPY VARCHAR2
108: );
109:
110: /*#
111: * Update an Operation Resource
112: * This is a PL/SQL procedure to update an Operation Resource
113: * Call is made to update_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
114: * @param p_api_version API version field
115: * @param p_init_msg_list Flag to check if message list intialized
116: * @param p_commit Flag to check for commit
117: * @param p_oprn_line_id Operation Line ID
128: PROCEDURE update_operation_resources
129: ( p_api_version IN NUMBER DEFAULT 1
130: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
131: , p_commit IN BOOLEAN DEFAULT FALSE
132: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
133: , p_resources IN gmd_operation_resources.resources%TYPE
134: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
135: , x_message_count OUT NOCOPY NUMBER
136: , x_message_list OUT NOCOPY VARCHAR2
129: ( p_api_version IN NUMBER DEFAULT 1
130: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
131: , p_commit IN BOOLEAN DEFAULT FALSE
132: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
133: , p_resources IN gmd_operation_resources.resources%TYPE
134: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
135: , x_message_count OUT NOCOPY NUMBER
136: , x_message_list OUT NOCOPY VARCHAR2
137: , x_return_status OUT NOCOPY VARCHAR2
130: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
131: , p_commit IN BOOLEAN DEFAULT FALSE
132: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
133: , p_resources IN gmd_operation_resources.resources%TYPE
134: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
135: , x_message_count OUT NOCOPY NUMBER
136: , x_message_list OUT NOCOPY VARCHAR2
137: , x_return_status OUT NOCOPY VARCHAR2
138: );
139:
140: /*#
141: * Delete an Operation Resource
142: * This is a PL/SQL procedure to delete an Operation Resource
143: * Call is made to delete_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
144: * @param p_api_version API version field
145: * @param p_init_msg_list Flag to check if message list intialized
146: * @param p_commit Flag to check for commit
147: * @param p_oprn_line_id Operation Line ID
157: PROCEDURE delete_operation_resources
158: ( p_api_version IN NUMBER DEFAULT 1
159: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
160: , p_commit IN BOOLEAN DEFAULT FALSE
161: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
162: , p_resources IN gmd_operation_resources.resources%TYPE
163: , x_message_count OUT NOCOPY NUMBER
164: , x_message_list OUT NOCOPY VARCHAR2
165: , x_return_status OUT NOCOPY VARCHAR2
158: ( p_api_version IN NUMBER DEFAULT 1
159: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
160: , p_commit IN BOOLEAN DEFAULT FALSE
161: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
162: , p_resources IN gmd_operation_resources.resources%TYPE
163: , x_message_count OUT NOCOPY NUMBER
164: , x_message_list OUT NOCOPY VARCHAR2
165: , x_return_status OUT NOCOPY VARCHAR2
166: );
164: , x_message_list OUT NOCOPY VARCHAR2
165: , x_return_status OUT NOCOPY VARCHAR2
166: );
167:
168: END GMD_OPERATION_RESOURCES_PUB;