DBA Data[Home] [Help]

APPS.BIS_RSS_PORTLETS_PUB dependencies on FND_GLOBAL

Line 55: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)

51: SELECT
52: p_Rss_Portlet_Rec.Portlet_Short_Name
53: , p_Rss_Portlet_Rec.Xml_Url
54: , p_Rss_Portlet_Rec.Xsl_Url
55: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
56: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
57: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
58: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
59: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)

Line 57: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

53: , p_Rss_Portlet_Rec.Xml_Url
54: , p_Rss_Portlet_Rec.Xsl_Url
55: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
56: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
57: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
58: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
59: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
60: FROM DUAL;
61:

Line 59: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)

55: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
56: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
57: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
58: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
59: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
60: FROM DUAL;
61:
62: INSERT INTO BIS_RSS_PORTLETS_TL
63: ( PORTLET_SHORT_NAME

Line 80: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)

76: , p_Rss_Portlet_Rec.Name
77: , p_Rss_Portlet_Rec.Description
78: , language_code
79: , userenv('LANG')
80: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
81: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
82: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
83: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
84: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)

Line 82: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

78: , language_code
79: , userenv('LANG')
80: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
81: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
82: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
83: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
84: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
85: FROM fnd_languages l
86: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 84: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)

80: , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
81: , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
82: , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
83: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
84: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
85: FROM fnd_languages l
86: WHERE L.INSTALLED_FLAG IN ('I', 'B')
87: AND NOT EXISTS
88: (SELECT null

Line 137: created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),

133: BEGIN
134: UPDATE bis_rss_portlets_tl
135: SET name = p_Rss_Portlet_Rec.Name,
136: description = p_Rss_Portlet_Rec.Description,
137: created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),
138: creation_date = nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate),
139: last_updated_by = nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID),
140: last_update_date = nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate),
141: last_update_login = nvl(p_Rss_Portlet_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID),

Line 139: last_updated_by = nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID),

135: SET name = p_Rss_Portlet_Rec.Name,
136: description = p_Rss_Portlet_Rec.Description,
137: created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),
138: creation_date = nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate),
139: last_updated_by = nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID),
140: last_update_date = nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate),
141: last_update_login = nvl(p_Rss_Portlet_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID),
142: source_lang = userenv('LANG')
143: WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name

Line 141: last_update_login = nvl(p_Rss_Portlet_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID),

137: created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),
138: creation_date = nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate),
139: last_updated_by = nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID),
140: last_update_date = nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate),
141: last_update_login = nvl(p_Rss_Portlet_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID),
142: source_lang = userenv('LANG')
143: WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name
144: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
145: EXCEPTION