DBA Data[Home] [Help]

APPS.AMS_RULE_GROUP_PVT dependencies on FND_GLOBAL

Line 129: IF FND_GLOBAL.User_Id IS NULL

125: RAISE FND_API.g_exc_error;
126: END IF;
127:
128:
129: IF FND_GLOBAL.User_Id IS NULL
130: THEN
131: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;

Line 237: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

233: p_posting_id => p_rule_group_rec.posting_id,
234: p_strategy_type => p_rule_group_rec.strategy_type,
235: p_exec_priority => p_rule_group_rec.exec_priority,
236: p_last_update_date => SYSDATE,
237: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
238: p_created_by => FND_GLOBAL.USER_ID,
239: p_creation_date => SYSDATE,
240: p_last_updated_by => FND_GLOBAL.USER_ID,
241: px_object_version_number => l_object_version_number,

Line 238: p_created_by => FND_GLOBAL.USER_ID,

234: p_strategy_type => p_rule_group_rec.strategy_type,
235: p_exec_priority => p_rule_group_rec.exec_priority,
236: p_last_update_date => SYSDATE,
237: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
238: p_created_by => FND_GLOBAL.USER_ID,
239: p_creation_date => SYSDATE,
240: p_last_updated_by => FND_GLOBAL.USER_ID,
241: px_object_version_number => l_object_version_number,
242: p_rule_name => p_rule_group_rec.rule_name,

Line 240: p_last_updated_by => FND_GLOBAL.USER_ID,

236: p_last_update_date => SYSDATE,
237: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
238: p_created_by => FND_GLOBAL.USER_ID,
239: p_creation_date => SYSDATE,
240: p_last_updated_by => FND_GLOBAL.USER_ID,
241: px_object_version_number => l_object_version_number,
242: p_rule_name => p_rule_group_rec.rule_name,
243: p_rule_description => p_rule_group_rec.rule_description);
244:

Line 582: last_updated_by = FND_GLOBAL.user_id,

578: Update AMS_IBA_PS_RULEGRPS_B
579: SET
580: strategy_type = DECODE( p_rule_group_rec.strategy_type, FND_API.g_miss_char, strategy_type, p_rule_group_rec.strategy_type),
581: exec_priority = DECODE( p_rule_group_rec.exec_priority, FND_API.g_miss_num, exec_priority, p_rule_group_rec.exec_priority),
582: last_updated_by = FND_GLOBAL.user_id,
583: last_update_date = SYSDATE,
584: last_update_login = FND_GLOBAL.conc_login_id,
585: object_version_number = p_rule_group_rec.object_version_number+1
586: WHERE RULEGROUP_ID = p_rule_group_rec.rulegroup_id

Line 584: last_update_login = FND_GLOBAL.conc_login_id,

580: strategy_type = DECODE( p_rule_group_rec.strategy_type, FND_API.g_miss_char, strategy_type, p_rule_group_rec.strategy_type),
581: exec_priority = DECODE( p_rule_group_rec.exec_priority, FND_API.g_miss_num, exec_priority, p_rule_group_rec.exec_priority),
582: last_updated_by = FND_GLOBAL.user_id,
583: last_update_date = SYSDATE,
584: last_update_login = FND_GLOBAL.conc_login_id,
585: object_version_number = p_rule_group_rec.object_version_number+1
586: WHERE RULEGROUP_ID = p_rule_group_rec.rulegroup_id
587: AND object_version_number = p_rule_group_rec.object_version_number;
588:

Line 597: last_updated_by = FND_GLOBAL.user_id,

593: --added the following update statement to update ams_iba_ps_rules table ::anchaudh 2003/01/27.
594:
595: Update AMS_IBA_PS_RULES
596: SET
597: last_updated_by = FND_GLOBAL.user_id,
598: last_update_date = SYSDATE,
599: last_update_login = FND_GLOBAL.conc_login_id,
600: object_version_number = p_rule_group_rec.object_version_number+1,
601: exec_priority = DECODE(p_rule_group_rec.exec_priority,FND_API.g_miss_num,exec_priority,p_rule_group_rec.exec_priority)

Line 599: last_update_login = FND_GLOBAL.conc_login_id,

595: Update AMS_IBA_PS_RULES
596: SET
597: last_updated_by = FND_GLOBAL.user_id,
598: last_update_date = SYSDATE,
599: last_update_login = FND_GLOBAL.conc_login_id,
600: object_version_number = p_rule_group_rec.object_version_number+1,
601: exec_priority = DECODE(p_rule_group_rec.exec_priority,FND_API.g_miss_num,exec_priority,p_rule_group_rec.exec_priority)
602: --strategy_id = DECODE( p_rule_group_rec.strategy_id, FND_API.g_miss_num,strategy_id, p_rule_group_rec.strategy_id),
603: --bus_priority_code = DECODE( p_rule_group_rec.bus_priority_code, FND_API.g_miss_char, bus_priority_code, p_rule_group_rec.bus_priority_code),

Line 625: last_updated_by = FND_GLOBAL.user_id,

621: SET
622: rulegroup_name = decode( p_rule_group_rec.rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_group_rec.rule_name),
623: rulegroup_description = decode( p_rule_group_rec.rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_group_rec.rule_description),
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.conc_login_id,
627: source_lang = USERENV('LANG')
628: WHERE rulegroup_id = p_rule_group_rec.rulegroup_id
629: AND USERENV('LANG') IN (language, source_lang);

Line 626: last_update_login = FND_GLOBAL.conc_login_id,

622: rulegroup_name = decode( p_rule_group_rec.rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_group_rec.rule_name),
623: rulegroup_description = decode( p_rule_group_rec.rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_group_rec.rule_description),
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.conc_login_id,
627: source_lang = USERENV('LANG')
628: WHERE rulegroup_id = p_rule_group_rec.rulegroup_id
629: AND USERENV('LANG') IN (language, source_lang);
630: