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.PV_PEC_RULES_PKG dependencies on FND_API

Line 82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),

78: last_updated_by,
79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),

Line 83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),

Line 84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),

80: last_update_login
81: ) VALUES (
82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),

Line 85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),

81: ) VALUES (
82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

Line 86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),

82: DECODE( px_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, px_enrl_change_rule_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),

83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),

84: DECODE( p_change_from_program_id, FND_API.G_MISS_NUM, NULL, p_change_from_program_id),
85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

85: DECODE( p_change_to_program_id, FND_API.G_MISS_NUM, NULL, p_change_to_program_id),
86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

86: DECODE( p_change_direction_code, FND_API.g_miss_char, NULL, p_change_direction_code),
87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

87: DECODE( p_effective_from_date, FND_API.G_MISS_DATE, NULL, p_effective_from_date),
88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:

Line 92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

88: DECODE( p_effective_to_date, FND_API.G_MISS_DATE, NULL, p_effective_to_date),
89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;

Line 93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

89: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:

Line 94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:
98:

Line 130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),

126: IS
127: BEGIN
128: Update pv_pg_enrl_change_rules
129: SET
130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),

Line 132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),

128: Update pv_pg_enrl_change_rules
129: SET
130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),

Line 133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),

129: SET
130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

Line 134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),

130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),

131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),

132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),
133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

133: change_to_program_id = DECODE( p_change_to_program_id, null, change_to_program_id, FND_API.G_MISS_NUM, null, p_change_to_program_id),
134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE enrl_change_rule_id = p_enrl_change_rule_id;

Line 138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

134: change_direction_code = DECODE( p_change_direction_code, null, change_direction_code, FND_API.g_miss_char, null, p_change_direction_code),
135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE enrl_change_rule_id = p_enrl_change_rule_id;
142: -- AND object_version_number = px_object_version_number;

Line 139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

135: effective_from_date = DECODE( p_effective_from_date, null, effective_from_date, FND_API.G_MISS_DATE, null, p_effective_from_date),
136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE enrl_change_rule_id = p_enrl_change_rule_id;
142: -- AND object_version_number = px_object_version_number;
143:

Line 140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

136: effective_to_date = DECODE( p_effective_to_date, null, effective_to_date, FND_API.G_MISS_DATE, null, p_effective_to_date),
137: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE enrl_change_rule_id = p_enrl_change_rule_id;
142: -- AND object_version_number = px_object_version_number;
143:
144:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: -- AND object_version_number = px_object_version_number;
143:
144:
145: IF (SQL%NOTFOUND) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: px_object_version_number := nvl(px_object_version_number,0) + 1;
150:

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: DELETE FROM pv_pg_enrl_change_rules
174: WHERE enrl_change_rule_id = p_enrl_change_rule_id
175: AND object_version_number = p_object_version_number;
176: If (SQL%NOTFOUND) then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: End If;
179: END Delete_Row ;
180:
181:

Line 215: RAISE FND_API.g_exc_error;

211: FETCH c INTO Recinfo;
212: IF (c%NOTFOUND) THEN
213: CLOSE c;
214: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
215: RAISE FND_API.g_exc_error;
216: END IF;
217: CLOSE c;
218: END Lock_Row;
219: