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

Line 72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),

68: last_update_date,
69: last_update_login,
70: object_version_number
71: ) VALUES (
72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

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

69: last_update_login,
70: object_version_number
71: ) VALUES (
72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),

70: object_version_number
71: ) VALUES (
72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),

71: ) VALUES (
72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

72: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

73: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

74: DECODE( p_site_category_type, FND_API.g_miss_char, NULL, p_site_category_type),
75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

75: DECODE( p_site_category_object_id, FND_API.g_miss_num, NULL, p_site_category_object_id),
76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:

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

76: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: INSERT INTO ams_iba_pl_sites_tl (

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

77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: INSERT INTO ams_iba_pl_sites_tl (
85: site_id,

Line 82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: INSERT INTO ams_iba_pl_sites_tl (
85: site_id,
86: name,

Line 98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),

94: language,
95: source_lang
96: )
97: SELECT
98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

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

95: source_lang
96: )
97: SELECT
98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

96: )
97: SELECT
98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

97: SELECT
98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

98: DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id),
99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
106: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

99: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
106: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
107: l.language_code,

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

100: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
106: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
107: l.language_code,
108: USERENV('LANG')

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

101: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
106: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
107: l.language_code,
108: USERENV('LANG')
109: FROM fnd_languages l

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

102: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
106: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
107: l.language_code,
108: USERENV('LANG')
109: FROM fnd_languages l
110: WHERE l.installed_flag in ('I', 'B')

Line 114: WHERE t.site_id = DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id)

110: WHERE l.installed_flag in ('I', 'B')
111: AND NOT EXISTS(
112: SELECT NULL
113: FROM ams_iba_pl_sites_tl t
114: WHERE t.site_id = DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id)
115: AND t.language = l.language_code);
116:
117: END Insert_Row;
118:

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

149: AMS_UTILITY_PVT.debug_message('table handler : before update site_id = ' || p_site_id );
150: END IF;
151: UPDATE ams_iba_pl_sites_b
152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
156: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )

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

150: END IF;
151: UPDATE ams_iba_pl_sites_b
152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
156: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )
158: -- anchaudh 12/26/2002 : fixed bug#2678933.

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

151: UPDATE ams_iba_pl_sites_b
152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
156: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )
158: -- anchaudh 12/26/2002 : fixed bug#2678933.
159: WHERE site_id = p_site_id;

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

152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
156: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )
158: -- anchaudh 12/26/2002 : fixed bug#2678933.
159: WHERE site_id = p_site_id;
160:

Line 157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )

153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
156: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
157: site_category_object_id = DECODE(p_site_category_object_id , FND_API.g_miss_num, site_category_object_id, p_site_category_object_id )
158: -- anchaudh 12/26/2002 : fixed bug#2678933.
159: WHERE site_id = p_site_id;
160:
161: IF (SQL%NOTFOUND) THEN

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

164:
165:
166: UPDATE ams_iba_pl_sites_tl
167: SET
168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
171: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
172: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

165:
166: UPDATE ams_iba_pl_sites_tl
167: SET
168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
171: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
172: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
173: source_lang = userenv('LANG')

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

166: UPDATE ams_iba_pl_sites_tl
167: SET
168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
171: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
172: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
173: source_lang = userenv('LANG')
174: where site_id = p_site_id

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

167: SET
168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
171: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
172: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
173: source_lang = userenv('LANG')
174: where site_id = p_site_id
175: AND USERENV('LANG') in (language, source_lang);

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

168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
171: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
172: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
173: source_lang = userenv('LANG')
174: where site_id = p_site_id
175: AND USERENV('LANG') in (language, source_lang);
176: