APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_MULTI_RATE_SCHEDULES_PVT

Line 186: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;

182:
183: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
184: l_api_name CONSTANT VARCHAR2(30) := 'Create_Schedule';
185: l_api_version CONSTANT NUMBER := 1.0;
186: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
187: -- Start - MOAC Change
188: l_org_id NUMBER;
189: l_status VARCHAR2(1);
190: -- End - MOAC Change

Line 259: CN_MULTI_RATE_SCHEDULES_PVT.Create_Schedule

255:
256: check_ret_sts(x_return_status);
257: end if;
258:
259: CN_MULTI_RATE_SCHEDULES_PVT.Create_Schedule
260: (p_api_version => p_api_version,
261: p_init_msg_list => p_init_msg_list,
262: p_commit => p_commit,
263: p_validation_level => p_validation_level,

Line 371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;

367: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
368: l_name CN_RATE_SCHEDULES.NAME%TYPE;
369: l_original_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
370: l_comm_unit_code CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
371: l_dims_tbl CN_MULTI_RATE_SCHEDULES_PVT.dims_tbl_type;
372: -- Start - MOAC Change
373: l_org_id NUMBER;
374: -- End - MOAC Change
375: BEGIN

Line 469: CN_MULTI_RATE_SCHEDULES_PVT.Update_Schedule

465:
466: check_ret_sts(x_return_status);
467: end if;
468:
469: CN_MULTI_RATE_SCHEDULES_PVT.Update_Schedule
470: (p_api_version => p_api_version,
471: p_init_msg_list => p_init_msg_list,
472: p_commit => p_commit,
473: p_validation_level => p_validation_level,

Line 622: CN_MULTI_RATE_SCHEDULES_PVT.Delete_Schedule

618:
619: check_ret_sts(x_return_status);
620: end if;
621:
622: CN_MULTI_RATE_SCHEDULES_PVT.Delete_Schedule
623: (p_api_version => p_api_version,
624: p_init_msg_list => p_init_msg_list,
625: p_commit => p_commit,
626: p_validation_level => p_validation_level,

Line 788: CN_MULTI_RATE_SCHEDULES_PVT.create_dimension_assign

784:
785: check_ret_sts(x_return_status);
786: end if;
787:
788: CN_MULTI_RATE_SCHEDULES_PVT.create_dimension_assign
789: (p_api_version => p_api_version,
790: p_init_msg_list => p_init_msg_list,
791: p_commit => p_commit,
792: p_validation_level => p_validation_level,

Line 995: CN_MULTI_RATE_SCHEDULES_PVT.update_dimension_assign

991:
992: check_ret_sts(x_return_status);
993: end if;
994:
995: CN_MULTI_RATE_SCHEDULES_PVT.update_dimension_assign
996: (p_api_version => p_api_version,
997: p_init_msg_list => p_init_msg_list,
998: p_commit => p_commit,
999: p_validation_level => p_validation_level,

Line 1154: CN_MULTI_RATE_SCHEDULES_PVT.delete_dimension_assign

1150:
1151: check_ret_sts(x_return_status);
1152: end if;
1153:
1154: CN_MULTI_RATE_SCHEDULES_PVT.delete_dimension_assign
1155: (p_api_version => p_api_version,
1156: p_init_msg_list => p_init_msg_list,
1157: p_commit => p_commit,
1158: p_validation_level => p_validation_level,

Line 1259: l_rate_dim_tier_id_tbl CN_MULTI_RATE_SCHEDULES_PVT.num_tbl_type;

1255: l_rate_tier_id CN_RATE_TIERS.RATE_TIER_ID%TYPE;
1256: l_rate_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
1257: l_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE;
1258: l_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE;
1259: l_rate_dim_tier_id_tbl CN_MULTI_RATE_SCHEDULES_PVT.num_tbl_type;
1260: -- Start - MOAC Change
1261: l_org_id NUMBER;
1262: -- End - MOAC Change
1263:

Line 1316: CN_MULTI_RATE_SCHEDULES_PVT.get_rate_tier_info

1312: l_rate_dim_tier_id_tbl(i) := get_rate_dim_tier_id
1313: (l_rate_schedule_id, i, p_tier_coordinates_tbl(i));
1314: end loop;
1315:
1316: CN_MULTI_RATE_SCHEDULES_PVT.get_rate_tier_info
1317: (p_rate_schedule_id => l_rate_schedule_id,
1318: p_rate_dim_tier_id_tbl => l_rate_dim_tier_id_tbl,
1319: x_rate_tier_id => l_rate_tier_id,
1320: x_rate_sequence => l_rate_sequence,

Line 1352: CN_MULTI_RATE_SCHEDULES_PVT.update_rate

1348:
1349: check_ret_sts(x_return_status);
1350: end if;
1351:
1352: CN_MULTI_RATE_SCHEDULES_PVT.update_rate
1353: (p_rate_schedule_id => l_rate_schedule_id,
1354: p_rate_sequence => l_rate_sequence,
1355: p_commission_amount => p_commission_amount,
1356: p_object_version_number => p_object_version_number,