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

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

78: partner_id,
79: access_level_flag,
80: interaction_level
81: ) VALUES (
82: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),

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

79: access_level_flag,
80: interaction_level
81: ) VALUES (
82: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),

Line 84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),

80: interaction_level
81: ) VALUES (
82: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

81: ) VALUES (
82: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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

82: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),

83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

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

86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),

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

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

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

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

Line 93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));
96:
97: INSERT INTO pv_ge_history_log_tl(

Line 94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),

90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));
96:
97: INSERT INTO pv_ge_history_log_tl(
98: entity_history_log_id ,

Line 95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));

91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));
96:
97: INSERT INTO pv_ge_history_log_tl(
98: entity_history_log_id ,
99: language ,

Line 109: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),

105: source_lang ,
106: COMMENTS
107: )
108: SELECT
109: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),

Line 117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)

113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t
121: WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)

Line 121: WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)

117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t
121: WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)
122: AND t.language = l.language_code);
123: END Insert_Row;
124:
125:

Line 160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),

156: IS
157: BEGIN
158: Update pv_ge_history_log_b
159: SET
160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),

Line 162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),

158: Update pv_ge_history_log_b
159: SET
160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),

159: SET
160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),

160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),

161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

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

162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),

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

163: history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)

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

164: message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
172: WHERE entity_history_log_id = p_entity_history_log_id

Line 169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

165: history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
172: WHERE entity_history_log_id = p_entity_history_log_id
173: AND object_version_number = p_object_version_number;

Line 170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),

166: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
172: WHERE entity_history_log_id = p_entity_history_log_id
173: AND object_version_number = p_object_version_number;
174:

Line 171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)

167: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
168: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
169: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
170: access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
172: WHERE entity_history_log_id = p_entity_history_log_id
173: AND object_version_number = p_object_version_number;
174:
175: UPDATE pv_ge_history_log_tl

Line 176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),

172: WHERE entity_history_log_id = p_entity_history_log_id
173: AND object_version_number = p_object_version_number;
174:
175: UPDATE pv_ge_history_log_tl
176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
179: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
180: source_lang = USERENV('LANG')

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

173: AND object_version_number = p_object_version_number;
174:
175: UPDATE pv_ge_history_log_tl
176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
179: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE entity_history_log_id = p_entity_history_log_id

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

174:
175: UPDATE pv_ge_history_log_tl
176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
179: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE entity_history_log_id = p_entity_history_log_id
182: AND USERENV('LANG') IN (language, source_lang);

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

175: UPDATE pv_ge_history_log_tl
176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
179: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE entity_history_log_id = p_entity_history_log_id
182: AND USERENV('LANG') IN (language, source_lang);
183:

Line 185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

181: WHERE entity_history_log_id = p_entity_history_log_id
182: AND USERENV('LANG') IN (language, source_lang);
183:
184: IF (SQL%NOTFOUND) THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188:
189: END Update_Row;

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: DELETE FROM pv_ge_history_log_b
212: WHERE entity_history_log_id = p_entity_history_log_id
213: AND object_version_number = p_object_version_number;
214: If (SQL%NOTFOUND) then
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: End If;
217: END Delete_Row ;
218:
219:

Line 253: RAISE FND_API.g_exc_error;

249: FETCH c INTO Recinfo;
250: IF (c%NOTFOUND) THEN
251: CLOSE c;
252: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
253: RAISE FND_API.g_exc_error;
254: END IF;
255: CLOSE c;
256: END Lock_Row;
257: