APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_SCH_DIMS_PKG

Line 409: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => l_temp_id,

405: -- call table handler to create dimension assignments and populate cn_rate_tiers
406: IF (p_dims_tbl.COUNT > 0) THEN
407: FOR i IN p_dims_tbl.first..p_dims_tbl.last LOOP
408: l_temp_id := NULL;
409: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => l_temp_id,
410: x_rate_dimension_id => p_dims_tbl(i).rate_dimension_id,
411: x_rate_schedule_id => x_rate_schedule_id,
412: x_rate_dim_sequence => p_dims_tbl(i).rate_dim_sequence,
413: --R12 MOAC Changes--Start

Line 629: cn_rate_sch_dims_pkg.insert_row

625:
626: -- reassign rate schedule dimensions
627: FOR i IN p_dims_tbl.first..p_dims_tbl.last LOOP
628: l_temp_id := NULL;
629: cn_rate_sch_dims_pkg.insert_row
630: (x_rate_sch_dim_id => l_temp_id,
631: x_rate_dimension_id => p_dims_tbl(i).rate_dimension_id,
632: x_rate_schedule_id => p_rate_schedule_id,
633: x_rate_dim_sequence => p_dims_tbl(i).rate_dim_sequence,

Line 1060: cn_rate_sch_dims_pkg.delete_row(x_rate_sch_dim_id => p_rate_sch_dim_id);

1056:
1057: /* End - R12 Notes History */
1058:
1059: -- delete records in cn_rate_sch_dims
1060: cn_rate_sch_dims_pkg.delete_row(x_rate_sch_dim_id => p_rate_sch_dim_id);
1061:
1062: -- *********************************************************************
1063: -- ************ Start - R12 Notes History ******************************
1064: -- *********************************************************************

Line 1308: cn_rate_sch_dims_pkg.lock_row

1304: where rate_dimension_id = l_rate_dimension_id;
1305: -- End - R12 Notes History Query for old dimension id assigned to rate table
1306:
1307: -- lock and update the row
1308: cn_rate_sch_dims_pkg.lock_row
1309: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1310: x_object_version_number => p_object_version_number);
1311:
1312: cn_rate_sch_dims_pkg.update_row

Line 1312: cn_rate_sch_dims_pkg.update_row

1308: cn_rate_sch_dims_pkg.lock_row
1309: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1310: x_object_version_number => p_object_version_number);
1311:
1312: cn_rate_sch_dims_pkg.update_row
1313: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1314: x_rate_schedule_id => p_rate_schedule_id,
1315: x_rate_dimension_id => p_rate_dimension_id,
1316: x_rate_dim_sequence => p_rate_dim_sequence,

Line 1515: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => x_rate_sch_dim_id,

1511: -- where rate_schedule_id = p_rate_schedule_id
1512: -- and rate_dim_sequence >= l_rate_dim_sequence;
1513:
1514: -- create this dimension assignment in cn_rate_sch_dims
1515: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => x_rate_sch_dim_id,
1516: x_rate_schedule_id => p_rate_schedule_id,
1517: x_rate_dimension_id => p_rate_dimension_id,
1518: x_rate_dim_sequence => l_rate_dim_sequence,
1519: --R12 MOAC Changes--Start