APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_RATE_TIERS

Line 1243: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

1239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1241: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1242: p_tier_coordinates_tbl IN tier_coordinates_tbl,
1243: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1244: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
1245: -- Start - MOAC Change
1246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
1247: -- End - MOAC Change

Line 1244: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,

1240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1241: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1242: p_tier_coordinates_tbl IN tier_coordinates_tbl,
1243: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1244: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
1245: -- Start - MOAC Change
1246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
1247: -- End - MOAC Change
1248: x_return_status OUT NOCOPY VARCHAR2,

Line 1246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,

1242: p_tier_coordinates_tbl IN tier_coordinates_tbl,
1243: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1244: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
1245: -- Start - MOAC Change
1246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
1247: -- End - MOAC Change
1248: x_return_status OUT NOCOPY VARCHAR2,
1249: x_msg_count OUT NOCOPY NUMBER,
1250: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1255: l_rate_tier_id CN_RATE_TIERS.RATE_TIER_ID%TYPE;

1251:
1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rate';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%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;

Line 1257: l_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE;

1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%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;

Line 1258: l_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE;

1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%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

Line 1289: FROM cn_rate_tiers

1285: l_rate_schedule_id := get_rate_schedule_id(p_rate_schedule_name);
1286:
1287: -- Start - MOAC Change
1288: SELECT org_id INTO l_org_id
1289: FROM cn_rate_tiers
1290: WHERE rate_schedule_id = l_rate_schedule_id;
1291:
1292: IF (l_org_id <> p_org_id)
1293: THEN

Line 2005: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE := NULL,

2001: p_value1 IN VARCHAR2,
2002: p_value2 IN VARCHAR2,
2003: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
2004: -- Start - MOAC Change
2005: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE := NULL,
2006: -- End - MOAC Change
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_msg_count OUT NOCOPY NUMBER,
2009: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2199: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,

2195: p_value1 IN VARCHAR2,
2196: p_value2 IN VARCHAR2,
2197: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
2198: -- Start - MOAC Change
2199: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
2200: -- End - MOAC Change
2201: x_return_status OUT NOCOPY VARCHAR2,
2202: x_msg_count OUT NOCOPY NUMBER,
2203: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2404: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new

2400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2401: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
2402: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
2403: -- Start - R12 MOAC Changes
2404: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new
2405: -- End - R12 MOAC Changes
2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,
2408: x_msg_data OUT NOCOPY VARCHAR2) IS