APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_TIERS_PKG

Line 1895: cn_rate_tiers_pkg.insert_row

1891: IF (rate_tier_info%notfound) THEN
1892: -- record may have to be created
1893: CLOSE rate_tier_info;
1894: if p_commission_amount <> 0 then
1895: cn_rate_tiers_pkg.insert_row
1896: (X_RATE_TIER_ID => l_rate_tier_id,
1897: X_RATE_SCHEDULE_ID => p_rate_schedule_id,
1898: X_COMMISSION_AMOUNT => p_commission_amount,
1899: X_RATE_SEQUENCE => p_rate_sequence,

Line 1914: cn_rate_tiers_pkg.lock_row

1910: -- see if amt changed
1911: if p_commission_amount <> l_commission_amount then
1912:
1913: -- lock and update the record
1914: cn_rate_tiers_pkg.lock_row
1915: (X_RATE_TIER_ID => l_rate_tier_id,
1916: X_OBJECT_VERSION_NUMBER => p_object_version_number);
1917:
1918: cn_rate_tiers_pkg.update_row

Line 1918: cn_rate_tiers_pkg.update_row

1914: cn_rate_tiers_pkg.lock_row
1915: (X_RATE_TIER_ID => l_rate_tier_id,
1916: X_OBJECT_VERSION_NUMBER => p_object_version_number);
1917:
1918: cn_rate_tiers_pkg.update_row
1919: (X_RATE_TIER_ID => l_rate_tier_id,
1920: X_RATE_SCHEDULE_ID => p_rate_schedule_id,
1921: X_COMMISSION_AMOUNT => p_commission_amount,
1922: X_RATE_SEQUENCE => p_rate_sequence,

Line 2052: cn_rate_tiers_pkg.insert_row

2048: FETCH get_rate_tier_id into l_rate_tier_id;
2049: CLOSE get_rate_tier_id;
2050: if l_rate_tier_id is null then
2051: -- insert rate tier into main rate table
2052: cn_rate_tiers_pkg.insert_row
2053: (X_RATE_TIER_ID => l_rate_tier_id,
2054: X_RATE_SCHEDULE_ID => l_rate_schedule_id,
2055: X_COMMISSION_AMOUNT => 0, -- place holder record
2056: X_RATE_SEQUENCE => p_rate_sequence,