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.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_SCHEDULES

Line 25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

21: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);
22:
23: -- record type of the rate table summary
24: TYPE rate_table_rec_type IS RECORD
25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
26: name CN_RATE_SCHEDULES.NAME%TYPE,
27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);

Line 26: name CN_RATE_SCHEDULES.NAME%TYPE,

22:
23: -- record type of the rate table summary
24: TYPE rate_table_rec_type IS RECORD
25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
26: name CN_RATE_SCHEDULES.NAME%TYPE,
27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
30:

Line 27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

23: -- record type of the rate table summary
24: TYPE rate_table_rec_type IS RECORD
25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
26: name CN_RATE_SCHEDULES.NAME%TYPE,
27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
30:
31: -- record type of the plan element assignment summary

Line 28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

24: TYPE rate_table_rec_type IS RECORD
25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
26: name CN_RATE_SCHEDULES.NAME%TYPE,
27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
30:
31: -- record type of the plan element assignment summary
32: TYPE plan_elt_rec_type IS RECORD

Line 29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);

25: (rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
26: name CN_RATE_SCHEDULES.NAME%TYPE,
27: type CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
28: number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
29: object_version_number CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
30:
31: -- record type of the plan element assignment summary
32: TYPE plan_elt_rec_type IS RECORD
33: (quota_id CN_RT_QUOTA_ASGNS.QUOTA_ID%TYPE,

Line 69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,

65: (p_api_version IN NUMBER ,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
73: --R12 MOAC Changes--Start

Line 70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
73: --R12 MOAC Changes--Start
74: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
73: --R12 MOAC Changes--Start
74: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
75: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

Line 74: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
73: --R12 MOAC Changes--Start
74: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
75: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
76: --R12 MOAC Changes--End
77: x_return_status OUT NOCOPY VARCHAR2 ,
78: x_msg_count OUT NOCOPY NUMBER ,

Line 75: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
73: --R12 MOAC Changes--Start
74: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
75: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
76: --R12 MOAC Changes--End
77: x_return_status OUT NOCOPY VARCHAR2 ,
78: x_msg_count OUT NOCOPY NUMBER ,
79: x_msg_data OUT NOCOPY VARCHAR2 );

Line 95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

91: (p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start

Line 96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start
100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start
100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
101: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed

Line 98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start
100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
101: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
102: --R12 MOAC Changes--End

Line 100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start
100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
101: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
102: --R12 MOAC Changes--End
103: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
104: x_return_status OUT NOCOPY VARCHAR2 ,

Line 101: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed

97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
99: --R12 MOAC Changes--Start
100: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
101: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
102: --R12 MOAC Changes--End
103: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
104: x_return_status OUT NOCOPY VARCHAR2 ,
105: x_msg_count OUT NOCOPY NUMBER ,

Line 117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

113: (p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
118: --R12 MOAC Changes--Start
119: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
120: --R12 MOAC Changes--End
121: x_return_status OUT NOCOPY VARCHAR2 ,

Line 119: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
118: --R12 MOAC Changes--Start
119: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
120: --R12 MOAC Changes--End
121: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER ,
123: x_msg_data OUT NOCOPY VARCHAR2 );

Line 128: -- 3) update cn_rate_schedules.number_dim if not called from form

124:
125: -- Notes : Delete schedule dimension
126: -- 1) If the rate schedule is used, its dimensions can not be deleted
127: -- 2) delete the corresponding records in cn_rate_sch_dims and cn_rate_tiers
128: -- 3) update cn_rate_schedules.number_dim if not called from form
129: -- 4) rate_dim_sequence is not adjusted here, users should take
130: -- care of the adjustment by calling update_dimension_assign
131: PROCEDURE delete_dimension_assign
132: (p_api_version IN NUMBER ,

Line 139: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
138: --R12 MOAC Changes--Start
139: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
140: --R12 MOAC Changes--End
141: x_return_status OUT NOCOPY VARCHAR2 ,
142: x_msg_count OUT NOCOPY NUMBER ,
143: x_msg_data OUT NOCOPY VARCHAR2 );

Line 159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start
159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
160: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed
161: --R12 MOAC Changes--End
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,

Line 160: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed

156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start
159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
160: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed
161: --R12 MOAC Changes--End
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,
164: x_msg_data OUT NOCOPY VARCHAR2 );

Line 170: -- 3) update cn_rate_schedules.number_dim

166: -- Notes : Create dimension assignment
167: -- 1) If the rate table is used, new assignment can not be created
168: -- 2) if the rate table is not used, update and cn_rate_tiers;
169: -- and adjust cn_rate_tiers.rate_sequence
170: -- 3) update cn_rate_schedules.number_dim
171: -- 4) rate_dim_sequence is not adjusted here, users should do it by
172: -- calling update_dimension_assign
173: PROCEDURE create_dimension_assign
174: (p_api_version IN NUMBER ,

Line 182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start
182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
183: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed
184: --R12 MOAC Changes--End
185: x_return_status OUT NOCOPY VARCHAR2 ,
186: x_msg_count OUT NOCOPY NUMBER ,

Line 255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,

251: (p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

Line 256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
260: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

Line 258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
260: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,

Line 259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
260: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2

Line 260: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
259: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
260: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2
264: