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

Line 105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)

101: sender_display_name,
102: -- ADDED BY PRAGEORG ON 5/29/2006
103: delivery_mode
104: ) VALUES (
105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)
106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)

Line 106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)

102: -- ADDED BY PRAGEORG ON 5/29/2006
103: delivery_mode
104: ) VALUES (
105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)
106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)

Line 107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)

103: delivery_mode
104: ) VALUES (
105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)
106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

Line 108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)

104: ) VALUES (
105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)
106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)

Line 109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)

105: DECODE( px_content_rule_id, FND_API.g_miss_num, NULL, px_content_rule_id)
106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)

Line 110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)

106: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)

Line 111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

107: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)

Line 112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)

108: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)

Line 113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)

109: , DECODE( p_last_updated_date, FND_API.g_miss_date, sysdate, l_last_update_date)
110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',

Line 114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)

110: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)

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

111: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',

Line 116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)

112: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'

Line 117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',

113: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh

Line 118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)

114: , DECODE( p_sender, FND_API.g_miss_char, NULL, p_sender)
115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh
122: -- ADDED BY PRAGEORG ON 5/29/2006

Line 119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',

115: , DECODE( p_reply_to, FND_API.g_miss_char, NULL, p_reply_to)
116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh
122: -- ADDED BY PRAGEORG ON 5/29/2006
123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)

Line 120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'

116: , DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id)
117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh
122: -- ADDED BY PRAGEORG ON 5/29/2006
123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
124: );

Line 121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh

117: , DECODE( p_table_of_content_flag, FND_API.g_miss_char, 'N', NVL(p_table_of_content_flag, 'N')) --'N',
118: , DECODE( p_trigger_code, FND_API.g_miss_char, NULL, p_trigger_code)
119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh
122: -- ADDED BY PRAGEORG ON 5/29/2006
123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
124: );
125:

Line 123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)

119: , DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', NVL(p_enabled_flag, 'Y')) --'Y',
120: , 'N' -- DECODE( p_default_flag, FND_API.g_miss_char, 'Y', p_default_flag) --'Y'
121: , DECODE( p_sender_display_name, FND_API.g_miss_char, NULL, p_sender_display_name)--anchaudh
122: -- ADDED BY PRAGEORG ON 5/29/2006
123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
124: );
125:
126: INSERT INTO AMS_CONTENT_RULES_TL(
127: content_rule_id,

Line 201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),

197: IS
198: BEGIN
199: Update AMS_CONTENT_RULES_B
200: SET
201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),

Line 202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

198: BEGIN
199: Update AMS_CONTENT_RULES_B
200: SET
201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

199: Update AMS_CONTENT_RULES_B
200: SET
201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

200: SET
201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

Line 205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),

201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),

Line 206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),

Line 207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),

Line 208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

204: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),

Line 209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),

205: last_update_date = DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),

Line 210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),

206: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),

Line 211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),

207: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),

208: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh

Line 213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),

209: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh
217: -- added by prageorg on 5/29/2006

Line 214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),

210: sender = DECODE( p_sender, FND_API.g_miss_char, sender, p_sender),
211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh
217: -- added by prageorg on 5/29/2006
218: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)

Line 215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

211: reply_to = DECODE( p_reply_to, FND_API.g_miss_char, reply_to, p_reply_to),
212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh
217: -- added by prageorg on 5/29/2006
218: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
219:

Line 216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh

212: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
213: table_of_content_flag = DECODE( p_table_of_content_flag, FND_API.g_miss_char, table_of_content_flag, p_table_of_content_flag),
214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh
217: -- added by prageorg on 5/29/2006
218: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
219:
220: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID

Line 218: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)

214: trigger_code = DECODE( p_trigger_code, FND_API.g_miss_char, trigger_code, p_trigger_code),
215: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
216: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),--anchaudh
217: -- added by prageorg on 5/29/2006
218: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
219:
220: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID
221: AND object_version_number = p_object_version_number;
222:

Line 225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),

221: AND object_version_number = p_object_version_number;
222:
223: update AMS_CONTENT_RULES_TL
224: set
225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

222:
223: update AMS_CONTENT_RULES_TL
224: set
225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
230: source_lang=userenv('LANG'),

Line 227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

223: update AMS_CONTENT_RULES_TL
224: set
225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
230: source_lang=userenv('LANG'),
231: email_subject=DECODE( p_subject, FND_API.g_miss_char, email_subject, p_subject)

Line 228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

224: set
225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
230: source_lang=userenv('LANG'),
231: email_subject=DECODE( p_subject, FND_API.g_miss_char, email_subject, p_subject)
232: where CONTENT_RULE_ID = p_CONTENT_RULE_ID

Line 229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
230: source_lang=userenv('LANG'),
231: email_subject=DECODE( p_subject, FND_API.g_miss_char, email_subject, p_subject)
232: where CONTENT_RULE_ID = p_CONTENT_RULE_ID
233: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 231: email_subject=DECODE( p_subject, FND_API.g_miss_char, email_subject, p_subject)

227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
228: created_by=DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
229: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
230: source_lang=userenv('LANG'),
231: email_subject=DECODE( p_subject, FND_API.g_miss_char, email_subject, p_subject)
232: where CONTENT_RULE_ID = p_CONTENT_RULE_ID
233: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
234:
235: END Update_Row;

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: BEGIN
252: DELETE FROM AMS_CONTENT_RULES_B
253: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
254: If (SQL%NOTFOUND) then
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257: DELETE FROM AMS_CONTENT_RULES_TL
258: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
259: If (SQL%NOTFOUND) then

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: END IF;
257: DELETE FROM AMS_CONTENT_RULES_TL
258: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
259: If (SQL%NOTFOUND) then
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262: END Delete_Row ;
263:
264: