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

Line 10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11: -- Siva Devaki 12/01/2003 Added Overloaded procedures for OA UI
12: -- Siva Devaki 06/24/2005 NOCOPY changes made to fix#4399469
13: -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
14: -- LOAD_SEED_ROW for R12 LCT standards bug 4411674

Line 46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)

42: ,last_updated_by
43: ,last_update_login
44: ) VALUES (
45: p_association_type_code
46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)
47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

Line 47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

43: ,last_update_login
44: ) VALUES (
45: p_association_type_code
46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)
47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)

44: ) VALUES (
45: p_association_type_code
46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)
47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

45: p_association_type_code
46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)
47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

46: ,DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,p_search_page)
47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
54: );

Line 51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

47: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
54: );
55:

Line 52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

48: ,DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,p_call_back_pkg)
49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
54: );
55:
56: INSERT INTO ibc_association_types_tl (

Line 53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

49: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
50: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
51: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
54: );
55:
56: INSERT INTO ibc_association_types_tl (
57: association_type_code

Line 69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)

65: ,language
66: ,source_lang
67: ) SELECT
68: p_association_type_code
69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)
70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)

66: ,source_lang
67: ) SELECT
68: p_association_type_code
69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)
70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

67: ) SELECT
68: p_association_type_code
69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)
70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

68: p_association_type_code
69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)
70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
76: ,l.language_code

Line 73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

69: ,DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,p_association_type_name)
70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
76: ,l.language_code
77: ,USERENV('lang')

Line 74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

70: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
76: ,l.language_code
77: ,USERENV('lang')
78: FROM fnd_languages l

Line 75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

71: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
72: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
73: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
74: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
75: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
76: ,l.language_code
77: ,USERENV('lang')
78: FROM fnd_languages l
79: WHERE l.installed_flag IN ('I', 'B')

Line 168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)

164: )
165: IS
166: BEGIN
167: UPDATE ibc_association_types_b SET
168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)
169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)

166: BEGIN
167: UPDATE ibc_association_types_b SET
168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)
169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
174: WHERE association_type_code = p_association_type_code

Line 171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

167: UPDATE ibc_association_types_b SET
168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)
169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
174: WHERE association_type_code = p_association_type_code
175: AND object_version_number = DECODE(p_object_version_number,

Line 172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)
169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
174: WHERE association_type_code = p_association_type_code
175: AND object_version_number = DECODE(p_object_version_number,
176: FND_API.g_miss_num,

Line 173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
174: WHERE association_type_code = p_association_type_code
175: AND object_version_number = DECODE(p_object_version_number,
176: FND_API.g_miss_num,
177: object_version_number,

Line 176: FND_API.g_miss_num,

172: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
173: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
174: WHERE association_type_code = p_association_type_code
175: AND object_version_number = DECODE(p_object_version_number,
176: FND_API.g_miss_num,
177: object_version_number,
178: NULL,
179: object_version_number,
180: p_object_version_number);

Line 187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)

183: RAISE NO_DATA_FOUND;
184: END IF;
185:
186: UPDATE ibc_association_types_tl SET
187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

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

184: END IF;
185:
186: UPDATE ibc_association_types_tl SET
187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
192: ,source_lang = USERENV('LANG')

Line 189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

185:
186: UPDATE ibc_association_types_tl SET
187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
192: ,source_lang = USERENV('LANG')
193: WHERE association_type_code = p_association_type_code

Line 190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

186: UPDATE ibc_association_types_tl SET
187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
192: ,source_lang = USERENV('LANG')
193: WHERE association_type_code = p_association_type_code
194: AND USERENV('LANG') IN (LANGUAGE, source_lang);

Line 191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
191: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
192: ,source_lang = USERENV('LANG')
193: WHERE association_type_code = p_association_type_code
194: AND USERENV('LANG') IN (LANGUAGE, source_lang);
195:

Line 352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)

348: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
349: db_user_id, db_last_update_date, p_upload_mode )) THEN
350:
351: Ibc_Association_Types_Pkg.UPDATE_ROW (
352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)
353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)
354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)
355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)

Line 353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)

349: db_user_id, db_last_update_date, p_upload_mode )) THEN
350:
351: Ibc_Association_Types_Pkg.UPDATE_ROW (
352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)
353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)
354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)
355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)
357: ,p_last_updated_by => l_user_id

Line 354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)

350:
351: Ibc_Association_Types_Pkg.UPDATE_ROW (
352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)
353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)
354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)
355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)
357: ,p_last_updated_by => l_user_id
358: ,p_last_update_date => l_last_update_date

Line 355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

351: Ibc_Association_Types_Pkg.UPDATE_ROW (
352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)
353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)
354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)
355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)
357: ,p_last_updated_by => l_user_id
358: ,p_last_update_date => l_last_update_date
359: ,p_last_update_login => 0

Line 356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)

352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)
353: ,p_association_type_name => NVL(p_association_type_name,FND_API.G_MISS_CHAR)
354: ,p_call_back_pkg => NVL(p_call_back_pkg,FND_API.G_MISS_CHAR)
355: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
356: ,p_search_page => NVL(p_search_page,FND_API.G_MISS_CHAR)
357: ,p_last_updated_by => l_user_id
358: ,p_last_update_date => l_last_update_date
359: ,p_last_update_login => 0
360: ,p_object_version_number => NULL