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_GE_NOTIF_RULES_PKG dependencies on FND_API

Line 102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),

98: last_updated_by,
99: last_update_date,
100: last_update_login
101: ) VALUES (
102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),

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

99: last_update_date,
100: last_update_login
101: ) VALUES (
102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),

Line 104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),

100: last_update_login
101: ) VALUES (
102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

Line 105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),

101: ) VALUES (
102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),

Line 106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),

102: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),

Line 107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),

103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),

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

104: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),

Line 109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),

105: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),

Line 110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),

106: DECODE( p_wf_item_type_code, FND_API.g_miss_char, NULL, p_wf_item_type_code),
107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),

Line 111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),

107: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),

Line 112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),

108: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),

Line 113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),

109: DECODE( p_repeat_freq_unit, FND_API.g_miss_char, NULL, p_repeat_freq_unit),
110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),

110: DECODE( p_repeat_freq_value, FND_API.G_MISS_NUM, NULL, p_repeat_freq_value),
111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),

111: DECODE( p_send_notif_before_unit, FND_API.g_miss_char, NULL, p_send_notif_before_unit),
112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),

112: DECODE( p_send_notif_before_value, FND_API.G_MISS_NUM, NULL, p_send_notif_before_value),
113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:

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

115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(

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

116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(
124: notif_rule_id ,

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

117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(
124: notif_rule_id ,
125: language ,

Line 137: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),

133: notif_content,
134: notif_desc
135: )
136: SELECT
137: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
138: l.language_code,
139: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
140: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
141: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),

Line 145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),

141: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')

Line 146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),

142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')
150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t

Line 147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)

143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')
150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t
151: WHERE t.notif_rule_id = DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id)

Line 151: WHERE t.notif_rule_id = DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id)

147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')
150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t
151: WHERE t.notif_rule_id = DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id)
152: AND t.language = l.language_code);
153: END Insert_Row;
154:
155:

Line 198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),

194: IS
195: BEGIN
196: Update pv_ge_notif_rules_b
197: SET
198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),
199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),

Line 200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),

196: Update pv_ge_notif_rules_b
197: SET
198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),
199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

Line 201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),

197: SET
198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),
199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),

Line 202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),

198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),
199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),

Line 203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),

199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),

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

200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),

Line 205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),

201: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),

Line 206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),

202: wf_item_type_code = DECODE( p_wf_item_type_code, null, wf_item_type_code, FND_API.g_miss_char, null, p_wf_item_type_code),
203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),

Line 207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),

203: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),

Line 208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),

204: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),

Line 209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),

205: repeat_freq_unit = DECODE( p_repeat_freq_unit, null, repeat_freq_unit, FND_API.g_miss_char, null, p_repeat_freq_unit),
206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),

206: repeat_freq_value = DECODE( p_repeat_freq_value, null, repeat_freq_value, FND_API.G_MISS_NUM, null, p_repeat_freq_value),
207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),

207: send_notif_before_unit = DECODE( p_send_notif_before_unit, null, send_notif_before_unit, FND_API.g_miss_char, null, p_send_notif_before_unit),
208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),

208: send_notif_before_value = DECODE( p_send_notif_before_value, null, send_notif_before_value, FND_API.G_MISS_NUM, null, p_send_notif_before_value),
209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
216: WHERE notif_rule_id = p_notif_rule_id;

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

209: send_notif_after_unit = DECODE( p_send_notif_after_unit, null, send_notif_after_unit, FND_API.g_miss_char, null, p_send_notif_after_unit),
210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
216: WHERE notif_rule_id = p_notif_rule_id;
217: --AND object_version_number = p_object_version_number;

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

210: send_notif_after_value = DECODE( p_send_notif_after_value, null, send_notif_after_value, FND_API.G_MISS_NUM, null, p_send_notif_after_value),
211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
216: WHERE notif_rule_id = p_notif_rule_id;
217: --AND object_version_number = p_object_version_number;
218:

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

211: repeat_until_unit = DECODE( p_repeat_until_unit, null, repeat_until_unit, FND_API.g_miss_char, null, p_repeat_until_unit),
212: repeat_until_value = DECODE( p_repeat_until_value, null, repeat_until_value, FND_API.G_MISS_NUM, null, p_repeat_until_value),
213: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
214: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
216: WHERE notif_rule_id = p_notif_rule_id;
217: --AND object_version_number = p_object_version_number;
218:
219: UPDATE pv_ge_notif_rules_tl

Line 220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),

216: WHERE notif_rule_id = p_notif_rule_id;
217: --AND object_version_number = p_object_version_number;
218:
219: UPDATE pv_ge_notif_rules_tl
220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),

217: --AND object_version_number = p_object_version_number;
218:
219: UPDATE pv_ge_notif_rules_tl
220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
225: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),

218:
219: UPDATE pv_ge_notif_rules_tl
220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
225: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
226: source_lang = USERENV('LANG')

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

219: UPDATE pv_ge_notif_rules_tl
220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
225: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
226: source_lang = USERENV('LANG')
227: WHERE notif_rule_id = p_notif_rule_id

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

220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
225: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
226: source_lang = USERENV('LANG')
227: WHERE notif_rule_id = p_notif_rule_id
228: AND USERENV('LANG') IN (language, source_lang);

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

221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
224: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
225: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
226: source_lang = USERENV('LANG')
227: WHERE notif_rule_id = p_notif_rule_id
228: AND USERENV('LANG') IN (language, source_lang);
229:

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: WHERE notif_rule_id = p_notif_rule_id
228: AND USERENV('LANG') IN (language, source_lang);
229:
230: IF (SQL%NOTFOUND) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234:
235: END Update_Row;

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: DELETE FROM pv_ge_notif_rules_b
258: WHERE notif_rule_id = p_notif_rule_id
259: AND object_version_number = p_object_version_number;
260: If (SQL%NOTFOUND) then
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: End If;
263: END Delete_Row ;
264:
265:

Line 299: RAISE FND_API.g_exc_error;

295: FETCH c INTO Recinfo;
296: IF (c%NOTFOUND) THEN
297: CLOSE c;
298: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
299: RAISE FND_API.g_exc_error;
300: END IF;
301: CLOSE c;
302: END Lock_Row;
303: