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_RATE_DIM_TIERS_PKG dependencies on CN_RATE_DIM_TIERS_S

Line 12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,

8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
16: -- R12 MOAC Changes--End

Line 42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;

38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
41:
42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;
43: BEGIN
44: IF (x_rate_dim_tier_id IS NULL) THEN
45: OPEN id;
46: FETCH id INTO x_rate_dim_tier_id;

Line 173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,

169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

Line 198: update CN_RATE_DIM_TIERS set

194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:
196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),