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 1923: cn_rate_tiers_pkg.lock_row

1919: -- see if amt changed
1920: if p_commission_amount <> l_commission_amount then
1921:
1922: -- lock and update the record
1923: cn_rate_tiers_pkg.lock_row
1924: (X_RATE_TIER_ID => l_rate_tier_id,
1925: X_OBJECT_VERSION_NUMBER => p_object_version_number);
1926:
1927: cn_rate_tiers_pkg.update_row

Line 1927: cn_rate_tiers_pkg.update_row

1923: cn_rate_tiers_pkg.lock_row
1924: (X_RATE_TIER_ID => l_rate_tier_id,
1925: X_OBJECT_VERSION_NUMBER => p_object_version_number);
1926:
1927: cn_rate_tiers_pkg.update_row
1928: (X_RATE_TIER_ID => l_rate_tier_id,
1929: X_RATE_SCHEDULE_ID => p_rate_schedule_id,
1930: X_COMMISSION_AMOUNT => p_commission_amount,
1931: X_RATE_SEQUENCE => p_rate_sequence,

Line 2061: cn_rate_tiers_pkg.insert_row

2057: FETCH get_rate_tier_id into l_rate_tier_id;
2058: CLOSE get_rate_tier_id;
2059: if l_rate_tier_id is null then
2060: -- insert rate tier into main rate table
2061: cn_rate_tiers_pkg.insert_row
2062: (X_RATE_TIER_ID => l_rate_tier_id,
2063: X_RATE_SCHEDULE_ID => l_rate_schedule_id,
2064: X_COMMISSION_AMOUNT => 0, -- place holder record
2065: X_RATE_SEQUENCE => p_rate_sequence,