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.PV_GE_NOTIF_RULES_PVT dependencies on FND_GLOBAL

Line 25: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Ge_Notif_Rules_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvgnrb.pls';
24:
25: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
27: --
28: -- Foreward Procedure Declarations
29: --

Line 26: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Ge_Notif_Rules_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvgnrb.pls';
24:
25: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
27: --
28: -- Foreward Procedure Declarations
29: --
30:

Line 171: IF FND_GLOBAL.USER_ID IS NULL

167: -- =========================================================================
168: -- Validate Environment
169: -- =========================================================================
170:
171: IF FND_GLOBAL.USER_ID IS NULL
172: THEN
173: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;

Line 190: l_ge_notif_rules_rec.last_updated_by := FND_GLOBAL.user_id;

186:
187: -- Anubhav added to populate default values for not null columns
188:
189: l_ge_notif_rules_rec.last_update_date := SYSDATE;
190: l_ge_notif_rules_rec.last_updated_by := FND_GLOBAL.user_id;
191: l_ge_notif_rules_rec.creation_date := SYSDATE;
192: l_ge_notif_rules_rec.created_by := FND_GLOBAL.user_id;
193: l_ge_notif_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
194: l_ge_notif_rules_rec.object_version_number := l_object_version_number;

Line 192: l_ge_notif_rules_rec.created_by := FND_GLOBAL.user_id;

188:
189: l_ge_notif_rules_rec.last_update_date := SYSDATE;
190: l_ge_notif_rules_rec.last_updated_by := FND_GLOBAL.user_id;
191: l_ge_notif_rules_rec.creation_date := SYSDATE;
192: l_ge_notif_rules_rec.created_by := FND_GLOBAL.user_id;
193: l_ge_notif_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
194: l_ge_notif_rules_rec.object_version_number := l_object_version_number;
195:
196: -- Anubhav added ends

Line 193: l_ge_notif_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;

189: l_ge_notif_rules_rec.last_update_date := SYSDATE;
190: l_ge_notif_rules_rec.last_updated_by := FND_GLOBAL.user_id;
191: l_ge_notif_rules_rec.creation_date := SYSDATE;
192: l_ge_notif_rules_rec.created_by := FND_GLOBAL.user_id;
193: l_ge_notif_rules_rec.last_update_login := FND_GLOBAL.conc_login_id;
194: l_ge_notif_rules_rec.object_version_number := l_object_version_number;
195:
196: -- Anubhav added ends
197:

Line 246: p_created_by => FND_GLOBAL.USER_ID,

242: p_send_notif_after_unit => p_ge_notif_rules_rec.send_notif_after_unit,
243: p_send_notif_after_value => p_ge_notif_rules_rec.send_notif_after_value,
244: p_repeat_until_unit => p_ge_notif_rules_rec.repeat_until_unit,
245: p_repeat_until_value => p_ge_notif_rules_rec.repeat_until_value,
246: p_created_by => FND_GLOBAL.USER_ID,
247: p_creation_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.USER_ID,
249: p_last_update_date => SYSDATE,
250: p_last_update_login => FND_GLOBAL.conc_login_id,

Line 248: p_last_updated_by => FND_GLOBAL.USER_ID,

244: p_repeat_until_unit => p_ge_notif_rules_rec.repeat_until_unit,
245: p_repeat_until_value => p_ge_notif_rules_rec.repeat_until_value,
246: p_created_by => FND_GLOBAL.USER_ID,
247: p_creation_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.USER_ID,
249: p_last_update_date => SYSDATE,
250: p_last_update_login => FND_GLOBAL.conc_login_id,
251: p_notif_name => p_ge_notif_rules_rec.notif_name,
252: p_notif_content => p_ge_notif_rules_rec.notif_content,

Line 250: p_last_update_login => FND_GLOBAL.conc_login_id,

246: p_created_by => FND_GLOBAL.USER_ID,
247: p_creation_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.USER_ID,
249: p_last_update_date => SYSDATE,
250: p_last_update_login => FND_GLOBAL.conc_login_id,
251: p_notif_name => p_ge_notif_rules_rec.notif_name,
252: p_notif_content => p_ge_notif_rules_rec.notif_content,
253: p_notif_desc => p_ge_notif_rules_rec.notif_desc
254: );

Line 468: last_updated_by = FND_GLOBAL.USER_ID,

464: send_notif_after_value = send_notif_after_value_array(i),
465: repeat_until_unit = repeat_until_unit_array(i),
466: repeat_until_value = repeat_until_value_array(i),
467: object_version_number = object_version_number + 1,
468: last_updated_by = FND_GLOBAL.USER_ID,
469: last_update_date = sysdate,
470: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
471: where notif_rule_id = notif_rule_id_array(i);
472:

Line 470: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

466: repeat_until_value = repeat_until_value_array(i),
467: object_version_number = object_version_number + 1,
468: last_updated_by = FND_GLOBAL.USER_ID,
469: last_update_date = sysdate,
470: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
471: where notif_rule_id = notif_rule_id_array(i);
472:
473: exit when c_get_notif_rules_rec%notfound;
474: END LOOP;

Line 503: last_updated_by = FND_GLOBAL.USER_ID,

499: set notif_name = notif_name_array(i),
500: notif_content = notif_content_array(i),
501: notif_desc = notif_desc_array(i),
502: source_lang = source_lang_array(i),
503: last_updated_by = FND_GLOBAL.USER_ID,
504: last_update_date = sysdate,
505: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
506: where notif_rule_id = new_notif_rule_id_array(i)
507: and language = language_array(i);

Line 505: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

501: notif_desc = notif_desc_array(i),
502: source_lang = source_lang_array(i),
503: last_updated_by = FND_GLOBAL.USER_ID,
504: last_update_date = sysdate,
505: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
506: where notif_rule_id = new_notif_rule_id_array(i)
507: and language = language_array(i);
508:
509: exit when c_get_notif_rules_tl_rec%notfound;

Line 750: p_last_updated_by => FND_GLOBAL.USER_ID,

746: p_send_notif_after_unit => p_ge_notif_rules_rec.send_notif_after_unit,
747: p_send_notif_after_value => p_ge_notif_rules_rec.send_notif_after_value,
748: p_repeat_until_unit => p_ge_notif_rules_rec.repeat_until_unit,
749: p_repeat_until_value => p_ge_notif_rules_rec.repeat_until_value,
750: p_last_updated_by => FND_GLOBAL.USER_ID,
751: p_last_update_date => SYSDATE,
752: p_last_update_login => FND_GLOBAL.conc_login_id,
753: p_notif_name => p_ge_notif_rules_rec.notif_name,
754: p_notif_content => p_ge_notif_rules_rec.notif_content,

Line 752: p_last_update_login => FND_GLOBAL.conc_login_id,

748: p_repeat_until_unit => p_ge_notif_rules_rec.repeat_until_unit,
749: p_repeat_until_value => p_ge_notif_rules_rec.repeat_until_value,
750: p_last_updated_by => FND_GLOBAL.USER_ID,
751: p_last_update_date => SYSDATE,
752: p_last_update_login => FND_GLOBAL.conc_login_id,
753: p_notif_name => p_ge_notif_rules_rec.notif_name,
754: p_notif_content => p_ge_notif_rules_rec.notif_content,
755: p_notif_desc => p_ge_notif_rules_rec.notif_desc
756: );