APPS.CN_RATE_DIMENSIONS_PVT dependencies on CN_RATE_DIM_TIERS_PKG

Line 272: cn_rate_dim_tiers_pkg.insert_row

268: -- call table handler to create dimension tiers
269: IF (p_tiers_tbl.COUNT > 0) THEN
270: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
271: l_temp_id := NULL;
272: cn_rate_dim_tiers_pkg.insert_row
273: (x_rate_dim_tier_id => l_temp_id,
274: x_rate_dimension_id => x_rate_dimension_id,
275: x_minimum_amount => p_tiers_tbl(i).minimum_amount,
276: x_maximum_amount => p_tiers_tbl(i).maximum_amount,

Line 492: cn_rate_dim_tiers_pkg.lock_row

488:
489: -- update the existing tiers
490: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
491: IF (p_tiers_tbl(i).rate_dim_tier_id IS NOT NULL) THEN
492: cn_rate_dim_tiers_pkg.lock_row
493: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
494: x_object_version_number => p_tiers_tbl(i).object_version_number);
495: cn_rate_dim_tiers_pkg.update_row
496: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,

Line 495: cn_rate_dim_tiers_pkg.update_row

491: IF (p_tiers_tbl(i).rate_dim_tier_id IS NOT NULL) THEN
492: cn_rate_dim_tiers_pkg.lock_row
493: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
494: x_object_version_number => p_tiers_tbl(i).object_version_number);
495: cn_rate_dim_tiers_pkg.update_row
496: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
497: x_rate_dimension_id => p_rate_dimension_id,
498: x_minimum_amount => p_tiers_tbl(i).minimum_amount,
499: x_maximum_amount => p_tiers_tbl(i).maximum_amount,

Line 943: cn_rate_dim_tiers_pkg.delete_row(p_rate_dim_tier_id);

939:
940: /* End - R12 Notes History */
941:
942: -- delete this tier in cn_rate_dim_tiers
943: cn_rate_dim_tiers_pkg.delete_row(p_rate_dim_tier_id);
944:
945: -- *********************************************************************
946: -- ************ Start - R12 Notes History ******************************
947: -- *********************************************************************

Line 1140: cn_rate_dim_tiers_pkg.lock_row

1136: close get_old_rec;
1137: /* End - R12 Notes History */
1138:
1139: -- update this tier in cn_rate_dim_tiers
1140: cn_rate_dim_tiers_pkg.lock_row
1141: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1142: x_object_version_number => p_object_version_number);
1143:
1144: cn_rate_dim_tiers_pkg.update_row

Line 1144: cn_rate_dim_tiers_pkg.update_row

1140: cn_rate_dim_tiers_pkg.lock_row
1141: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1142: x_object_version_number => p_object_version_number);
1143:
1144: cn_rate_dim_tiers_pkg.update_row
1145: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1146: x_rate_dimension_id => p_rate_dimension_id,
1147: x_minimum_amount => p_minimum_amount,
1148: x_maximum_amount => p_maximum_amount,

Line 1374: cn_rate_dim_tiers_pkg.insert_row

1370: where rate_dimension_id = p_rate_dimension_id
1371: and tier_sequence >= p_tier_sequence;
1372:
1373: -- create this tier in cn_rate_dim_tiers
1374: cn_rate_dim_tiers_pkg.insert_row
1375: (x_rate_dim_tier_id => x_rate_dim_tier_id,
1376: x_rate_dimension_id => p_rate_dimension_id,
1377: x_minimum_amount => p_minimum_amount,
1378: x_maximum_amount => p_maximum_amount,