DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_VUHK dependencies on CN_API

Line 40: cn_api.g_miss_char,

36: -- pass, the rate schedule is updated and its object version number is incremented.
37: PROCEDURE Update_Schedule_Pre
38: (p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
39: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
40: cn_api.g_miss_char,
41: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
42: cn_api.g_miss_char,
43: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
44: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

Line 42: cn_api.g_miss_char,

38: (p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
39: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
40: cn_api.g_miss_char,
41: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
42: cn_api.g_miss_char,
43: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
44: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
45: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
46: x_return_status OUT NOCOPY VARCHAR2,

Line 52: cn_api.g_miss_char,

48: x_msg_data OUT NOCOPY VARCHAR2);
49: PROCEDURE Update_Schedule_Post
50: (p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
51: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
52: cn_api.g_miss_char,
53: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
54: cn_api.g_miss_char,
55: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
56: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=

Line 54: cn_api.g_miss_char,

50: (p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
51: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
52: cn_api.g_miss_char,
53: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
54: cn_api.g_miss_char,
55: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
56: p_dims_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.dim_assign_tbl_type :=
57: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_dim_assign_tbl,
58: x_return_status OUT NOCOPY VARCHAR2,

Line 103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

99: -- rate dimension sequence, the new dimension takes the same sequence number.
100: PROCEDURE Update_Dimension_Assign_Pre
101: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
102: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
104: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
105: cn_api.g_miss_num,
106: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2,

Line 105: cn_api.g_miss_num,

101: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
102: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
104: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
105: cn_api.g_miss_num,
106: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2);

Line 113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

109: x_msg_data OUT NOCOPY VARCHAR2);
110: PROCEDURE Update_Dimension_Assign_Post
111: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
112: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
114: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
115: cn_api.g_miss_num,
116: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
117: x_return_status OUT NOCOPY VARCHAR2,

Line 115: cn_api.g_miss_num,

111: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
112: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
114: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
115: cn_api.g_miss_num,
116: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2);

Line 187: cn_api.g_miss_char,

183: -- only the name and description are updated.
184: PROCEDURE Update_Dimension_Pre
185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,

Line 189: cn_api.g_miss_char,

185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

Line 191: cn_api.g_miss_char,

187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,

Line 201: cn_api.g_miss_char,

197: x_msg_data OUT NOCOPY VARCHAR2);
198: PROCEDURE Update_Dimension_Post
199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,

Line 203: cn_api.g_miss_char,

199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

Line 205: cn_api.g_miss_char,

201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,