eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_RATE_SCH_DIMS

Line 48: RETURN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE IS

44:
45: -- to get a rate_sch_dim_id from a given rate dimension ID and rate schedule ID
46: FUNCTION get_rate_sch_dim_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
47: p_rate_dimension_id in CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
48: RETURN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE IS
49:
50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
51: BEGIN
52: select rate_sch_dim_id into l_rate_sch_dim_id

Line 50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

46: FUNCTION get_rate_sch_dim_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
47: p_rate_dimension_id in CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
48: RETURN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE IS
49:
50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
51: BEGIN
52: select rate_sch_dim_id into l_rate_sch_dim_id
53: from cn_rate_sch_dims
54: where rate_schedule_id = p_rate_schedule_id

Line 53: from cn_rate_sch_dims

49:
50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
51: BEGIN
52: select rate_sch_dim_id into l_rate_sch_dim_id
53: from cn_rate_sch_dims
54: where rate_schedule_id = p_rate_schedule_id
55: and rate_dimension_id = p_rate_dimension_id;
56:
57: RETURN l_rate_sch_dim_id;

Line 105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

101: END get_rate_dim_tier_id;
102:
103: -- to get a rate_dim_tier_id from the rate_schedule and sequence numbers
104: FUNCTION get_rate_dim_tier_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

Line 112: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt

108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
110: BEGIN
111: select rdt.rate_dim_tier_id into l_rate_dim_tier_id
112: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
113: where rsd.rate_schedule_id = p_rate_schedule_id
114: and rsd.rate_dim_sequence = p_rate_dim_sequence
115: and rdt.rate_dimension_id = rsd.rate_dimension_id
116: and rdt.tier_sequence = p_tier_sequence;

Line 708: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

704: p_commit IN VARCHAR2 := FND_API.G_FALSE,
705: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
706: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
707: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
708: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
709: -- Start - MOAC Change
710: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
711: -- End - MOAC Change
712: x_return_status OUT NOCOPY VARCHAR2,

Line 720: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

716: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension_Assign';
717: l_api_version CONSTANT NUMBER := 1.0;
718: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
719: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
720: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
721: -- Start - MOAC Change
722: l_org_id NUMBER;
723: l_status VARCHAR2(1);
724: -- End - MOAC Change

Line 883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=

879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change
887: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,

Line 885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change
887: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
888: -- End - MOAC Change
889: x_return_status OUT NOCOPY VARCHAR2,

Line 897: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;

893: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension_Assign';
894: l_api_version CONSTANT NUMBER := 1.0;
895: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
896: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
897: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
898: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
899: -- Start - MOAC Change
900: l_org_id NUMBER;
901: -- End - MOAC Change

Line 898: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

894: l_api_version CONSTANT NUMBER := 1.0;
895: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
896: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
897: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
898: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
899: -- Start - MOAC Change
900: l_org_id NUMBER;
901: -- End - MOAC Change
902: BEGIN

Line 930: FROM cn_rate_sch_dims

926: l_rate_sch_dim_id := get_rate_sch_dim_id (l_rate_schedule_id, l_rate_dimension_id);
927:
928: -- Start - MOAC Change
929: SELECT org_id INTO l_org_id
930: FROM cn_rate_sch_dims
931: WHERE rate_sch_dim_id = l_rate_sch_dim_id;
932:
933: IF (l_org_id <> p_org_id)
934: THEN

Line 953: from cn_rate_sch_dims

949: END IF;
950: -- End - MOAC Change
951: -- get rate_dim_sequence (validation for this select already performed)
952: select rate_dim_sequence into l_rate_dim_sequence
953: from cn_rate_sch_dims
954: where rate_sch_dim_id = l_rate_sch_dim_id;
955:
956: -- get new rate dim name if necessary
957: if p_new_rate_dim_name <> cn_api.g_miss_char then

Line 1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

1100: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dimension_Assign';
1101: l_api_version CONSTANT NUMBER := 1.0;
1102: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1103: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT Delete_Dimension_Assign;
1108: -- Standard call to check for call compatibility.