APPS.AMS_IBA_PL_PAGES_B_PKG dependencies on FND_API

Line 78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),

74: last_update_date,
75: last_update_login,
76: object_version_number
77: ) VALUES (
78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),

75: last_update_login,
76: object_version_number
77: ) VALUES (
78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),

76: object_version_number
77: ) VALUES (
78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),

77: ) VALUES (
78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

78: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

79: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

80: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

Line 85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

81: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
89: );

Line 86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

82: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
89: );
90: IF (AMS_DEBUG_HIGH_ON) THEN

Line 87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

83: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
89: );
90: IF (AMS_DEBUG_HIGH_ON) THEN
91:

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

84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
89: );
90: IF (AMS_DEBUG_HIGH_ON) THEN
91:
92: AMS_UTILITY_PVT.debug_message( 'Table Handler : Just after insert into b table');

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

109: language,
110: source_lang
111: )
112: SELECT
113: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

110: source_lang
111: )
112: SELECT
113: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

111: )
112: SELECT
113: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

112: SELECT
113: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

113: DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id),
114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: l.language_code,

Line 118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

114: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: l.language_code,
122: USERENV('LANG')

Line 119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

115: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: l.language_code,
122: USERENV('LANG')
123: FROM fnd_languages l

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

116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: l.language_code,
122: USERENV('LANG')
123: FROM fnd_languages l
124: WHERE l.installed_flag in ('I', 'B')

Line 128: WHERE t.page_id = DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id)

124: WHERE l.installed_flag in ('I', 'B')
125: AND NOT EXISTS(
126: SELECT NULL
127: FROM ams_iba_pl_pages_tl t
128: WHERE t.page_id = DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id)
129: AND t.language = l.language_code);
130: IF (AMS_DEBUG_HIGH_ON) THEN
131:
132: AMS_UTILITY_PVT.debug_message( 'Table Handler : Just after insert into tl table');

Line 171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),

167: IS
168: BEGIN
169: Update AMS_IBA_PL_PAGES_B
170: SET
171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),

168: BEGIN
169: Update AMS_IBA_PL_PAGES_B
170: SET
171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

169: Update AMS_IBA_PL_PAGES_B
170: SET
171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
177: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

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

170: SET
171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
177: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
178: WHERE PAGE_ID = p_PAGE_ID

Line 175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
177: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
178: WHERE PAGE_ID = p_PAGE_ID
179: AND object_version_number = p_object_version_number;

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

172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
177: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
178: WHERE PAGE_ID = p_PAGE_ID
179: AND object_version_number = p_object_version_number;
180:

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

173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
176: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
177: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
178: WHERE PAGE_ID = p_PAGE_ID
179: AND object_version_number = p_object_version_number;
180:
181: IF (SQL%NOTFOUND) THEN

Line 187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

183: END IF;
184:
185: UPDATE ams_iba_pl_pages_tl
186: SET
187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),

184:
185: UPDATE ams_iba_pl_pages_tl
186: SET
187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: source_lang = userenv('LANG')

Line 189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

185: UPDATE ams_iba_pl_pages_tl
186: SET
187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: source_lang = userenv('LANG')
193: WHERE page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id)

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

186: SET
187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: source_lang = userenv('LANG')
193: WHERE page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id)
194: AND USERENV('lang') IN (language, source_lang);

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

187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: source_lang = userenv('LANG')
193: WHERE page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id)
194: AND USERENV('lang') IN (language, source_lang);
195:

Line 193: WHERE page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id)

189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: source_lang = userenv('LANG')
193: WHERE page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id)
194: AND USERENV('lang') IN (language, source_lang);
195:
196:
197: IF (SQL%NOTFOUND) THEN

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

221: DELETE from ams_iba_pl_pages_b
222: WHERE PAGE_ID = p_page_id;
223:
224: IF (SQL%NOTFOUND) THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END IF;
227:
228: DELETE FROM ams_iba_pl_pages_tL
229: WHERE PAGE_ID = p_page_id;