DBA Data[Home] [Help]

APPS.PV_GE_NOTIF_RULES_PKG dependencies on FND_GLOBAL

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

113: DECODE( p_send_notif_after_unit, FND_API.g_miss_char, NULL, p_send_notif_after_unit),
114: DECODE( p_send_notif_after_value, FND_API.G_MISS_NUM, NULL, p_send_notif_after_value),
115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

115: DECODE( p_repeat_until_unit, FND_API.g_miss_char, NULL, p_repeat_until_unit),
116: DECODE( p_repeat_until_value, FND_API.G_MISS_NUM, NULL, p_repeat_until_value),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(

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

117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(
124: notif_rule_id ,
125: language ,

Line 140: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

136: SELECT
137: DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id),
138: l.language_code,
139: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
140: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
141: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),

Line 142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),

138: l.language_code,
139: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
140: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
141: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),

Line 143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

139: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
140: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
141: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
142: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
143: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)