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_RT_FORMULA_ASGNS_PKG dependencies on CN_RT_FORMULA_ASGNS_S

Line 8: X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE,

4: procedure INSERT_ROW
5: (X_RT_FORMULA_ASGN_ID IN OUT NOCOPY CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RT_FORMULA_ASGNS.RATE_SCHEDULE_ID%TYPE,
8: X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE,
9: X_END_DATE IN CN_RT_FORMULA_ASGNS.END_DATE%TYPE := NULL,
10: --R12 MOAC Changes--Start
11: X_ORG_ID IN CN_RT_FORMULA_ASGNS.ORG_ID%TYPE,
12: --R12 MOAC Changes--End

Line 38: CURSOR id IS SELECT cn_rt_formula_asgns_s.NEXTVAL FROM dual;

34:
35: cursor C is select rt_formula_asgn_id from CN_RT_FORMULA_ASGNS
36: where RT_FORMULA_ASGN_ID = x_rt_formula_asgn_id;
37:
38: CURSOR id IS SELECT cn_rt_formula_asgns_s.NEXTVAL FROM dual;
39: BEGIN
40: IF (x_rt_formula_asgn_id IS NULL) THEN
41: OPEN id;
42: FETCH id INTO x_rt_formula_asgn_id;

Line 156: X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE := CN_API.G_MISS_DATE,

152: procedure UPDATE_ROW
153: (X_RT_FORMULA_ASGN_ID IN CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE,
154: X_CALC_FORMULA_ID IN CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
155: X_RATE_SCHEDULE_ID IN CN_RT_FORMULA_ASGNS.RATE_SCHEDULE_ID%TYPE := CN_API.G_MISS_NUM,
156: X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE := CN_API.G_MISS_DATE,
157: X_END_DATE IN CN_RT_FORMULA_ASGNS.END_DATE%TYPE := CN_API.G_MISS_DATE,
158: X_ATTRIBUTE_CATEGORY IN CN_RT_FORMULA_ASGNS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
159: X_ATTRIBUTE1 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE2 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

Line 180: update CN_RT_FORMULA_ASGNS set

176: X_LAST_UPDATED_BY IN CN_RT_FORMULA_ASGNS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RT_FORMULA_ASGNS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
178:
179: BEGIN
180: update CN_RT_FORMULA_ASGNS set
181: RATE_SCHEDULE_ID = Decode(X_RATE_SCHEDULE_ID, fnd_api.g_miss_char, rate_schedule_id, x_rate_schedule_id),
182: START_DATE = Decode(X_START_DATE, fnd_api.g_miss_char, start_date, x_start_date),
183: END_DATE = Decode(X_END_DATE, fnd_api.g_miss_char, end_date, x_end_date),
184: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),