DBA Data[Home] [Help]

APPS.AMS_PS_RULE_PVT dependencies on FND_GLOBAL

Line 154: IF FND_GLOBAL.User_Id IS NULL

150: -- ========================================================
151: -- Validate Environment
152: -- ========================================================
153:
154: IF FND_GLOBAL.User_Id IS NULL
155:
156: THEN
157:
158: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 331: p_created_by => FND_GLOBAL.USER_ID,

327:
328:
329: AMS_IBA_PS_RULES_PKG.Insert_Row(
330:
331: p_created_by => FND_GLOBAL.USER_ID,
332: p_creation_date => SYSDATE,
333: p_last_updated_by => FND_GLOBAL.USER_ID,
334: p_last_update_date => SYSDATE,
335: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 333: p_last_updated_by => FND_GLOBAL.USER_ID,

329: AMS_IBA_PS_RULES_PKG.Insert_Row(
330:
331: p_created_by => FND_GLOBAL.USER_ID,
332: p_creation_date => SYSDATE,
333: p_last_updated_by => FND_GLOBAL.USER_ID,
334: p_last_update_date => SYSDATE,
335: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
336: px_object_version_number => l_object_version_number,
337: px_rule_id => l_RULE_ID,

Line 335: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

331: p_created_by => FND_GLOBAL.USER_ID,
332: p_creation_date => SYSDATE,
333: p_last_updated_by => FND_GLOBAL.USER_ID,
334: p_last_update_date => SYSDATE,
335: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
336: px_object_version_number => l_object_version_number,
337: px_rule_id => l_RULE_ID,
338: p_rulegroup_id => p_ps_rules_rec.rulegroup_id,
339: p_posting_id => p_ps_rules_rec.posting_id,

Line 398: p_created_by => FND_GLOBAL.USER_ID,

394: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)
395:
396: AMS_IBA_PS_RULES_PKG.Insert_Row(
397:
398: p_created_by => FND_GLOBAL.USER_ID,
399: p_creation_date => SYSDATE,
400: p_last_updated_by => FND_GLOBAL.USER_ID,
401: p_last_update_date => SYSDATE,
402: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 400: p_last_updated_by => FND_GLOBAL.USER_ID,

396: AMS_IBA_PS_RULES_PKG.Insert_Row(
397:
398: p_created_by => FND_GLOBAL.USER_ID,
399: p_creation_date => SYSDATE,
400: p_last_updated_by => FND_GLOBAL.USER_ID,
401: p_last_update_date => SYSDATE,
402: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
403: px_object_version_number => l_object_version_number,
404: px_rule_id => l_RULE_ID,

Line 402: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

398: p_created_by => FND_GLOBAL.USER_ID,
399: p_creation_date => SYSDATE,
400: p_last_updated_by => FND_GLOBAL.USER_ID,
401: p_last_update_date => SYSDATE,
402: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
403: px_object_version_number => l_object_version_number,
404: px_rule_id => l_RULE_ID,
405: p_rulegroup_id => p_ps_rules_rec.rulegroup_id,
406: p_posting_id => p_ps_rules_rec.posting_id,

Line 658: last_updated_by = FND_GLOBAL.user_id,

654: END IF;
655:
656: Update AMS_IBA_PS_RULES
657: SET
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_date = SYSDATE,
660: last_update_login = FND_GLOBAL.conc_login_id,
661: object_version_number = p_ps_rules_rec.object_version_number+1,
662: exec_priority = DECODE(p_ps_rules_rec.exec_priority,FND_API.g_miss_num,exec_priority,p_ps_rules_rec.exec_priority),--added this line to update priority of a rule also:anchaudh 2003/01/27.

Line 660: last_update_login = FND_GLOBAL.conc_login_id,

656: Update AMS_IBA_PS_RULES
657: SET
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_date = SYSDATE,
660: last_update_login = FND_GLOBAL.conc_login_id,
661: object_version_number = p_ps_rules_rec.object_version_number+1,
662: exec_priority = DECODE(p_ps_rules_rec.exec_priority,FND_API.g_miss_num,exec_priority,p_ps_rules_rec.exec_priority),--added this line to update priority of a rule also:anchaudh 2003/01/27.
663: strategy_id = DECODE( p_ps_rules_rec.strategy_id, FND_API.g_miss_num,strategy_id, p_ps_rules_rec.strategy_id),
664: bus_priority_code = DECODE( p_ps_rules_rec.bus_priority_code, FND_API.g_miss_char, bus_priority_code, p_ps_rules_rec.bus_priority_code),

Line 926: p_created_by => FND_GLOBAL.USER_ID,

922: EXIT WHEN l_dummy IS NULL;
923: END LOOP;
924:
925: AMS_IBA_PS_RULES_PKG.Insert_Row(
926: p_created_by => FND_GLOBAL.USER_ID,
927: p_creation_date => SYSDATE,
928: p_last_updated_by => FND_GLOBAL.USER_ID,
929: p_last_update_date => SYSDATE,
930: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 928: p_last_updated_by => FND_GLOBAL.USER_ID,

924:
925: AMS_IBA_PS_RULES_PKG.Insert_Row(
926: p_created_by => FND_GLOBAL.USER_ID,
927: p_creation_date => SYSDATE,
928: p_last_updated_by => FND_GLOBAL.USER_ID,
929: p_last_update_date => SYSDATE,
930: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
931: px_object_version_number => l_object_version_number,
932: px_rule_id => l_RULE_ID,

Line 930: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

926: p_created_by => FND_GLOBAL.USER_ID,
927: p_creation_date => SYSDATE,
928: p_last_updated_by => FND_GLOBAL.USER_ID,
929: p_last_update_date => SYSDATE,
930: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
931: px_object_version_number => l_object_version_number,
932: px_rule_id => l_RULE_ID,
933: p_rulegroup_id => p_ps_rules_rec.rulegroup_id,
934: p_posting_id => p_ps_rules_rec.posting_id,

Line 979: p_created_by => FND_GLOBAL.USER_ID,

975: EXIT WHEN l_dummy IS NULL;
976: END LOOP;
977:
978: AMS_IBA_PS_RULES_PKG.Insert_Row(
979: p_created_by => FND_GLOBAL.USER_ID,
980: p_creation_date => SYSDATE,
981: p_last_updated_by => FND_GLOBAL.USER_ID,
982: p_last_update_date => SYSDATE,
983: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 981: p_last_updated_by => FND_GLOBAL.USER_ID,

977:
978: AMS_IBA_PS_RULES_PKG.Insert_Row(
979: p_created_by => FND_GLOBAL.USER_ID,
980: p_creation_date => SYSDATE,
981: p_last_updated_by => FND_GLOBAL.USER_ID,
982: p_last_update_date => SYSDATE,
983: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
984: px_object_version_number => l_object_version_number,
985: px_rule_id => l_RULE_ID,

Line 983: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

979: p_created_by => FND_GLOBAL.USER_ID,
980: p_creation_date => SYSDATE,
981: p_last_updated_by => FND_GLOBAL.USER_ID,
982: p_last_update_date => SYSDATE,
983: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
984: px_object_version_number => l_object_version_number,
985: px_rule_id => l_RULE_ID,
986: p_rulegroup_id => p_ps_rules_rec.rulegroup_id,
987: p_posting_id => p_ps_rules_rec.posting_id,

Line 1690: FND_GLOBAL.USER_ID,

1686: rulegroup_id,
1687: filter_id,
1688: filter_ref_code
1689: ) VALUES (
1690: FND_GLOBAL.USER_ID,
1691: SYSDATE,
1692: FND_GLOBAL.USER_ID,
1693: SYSDATE,
1694: FND_GLOBAL.CONC_LOGIN_ID,

Line 1692: FND_GLOBAL.USER_ID,

1688: filter_ref_code
1689: ) VALUES (
1690: FND_GLOBAL.USER_ID,
1691: SYSDATE,
1692: FND_GLOBAL.USER_ID,
1693: SYSDATE,
1694: FND_GLOBAL.CONC_LOGIN_ID,
1695: 1,
1696: l_id,

Line 1694: FND_GLOBAL.CONC_LOGIN_ID,

1690: FND_GLOBAL.USER_ID,
1691: SYSDATE,
1692: FND_GLOBAL.USER_ID,
1693: SYSDATE,
1694: FND_GLOBAL.CONC_LOGIN_ID,
1695: 1,
1696: l_id,
1697: DECODE( p_rulegroup_id, FND_API.g_miss_num, NULL, p_rulegroup_id),
1698: DECODE( to_number(l_tuple.name), FND_API.g_miss_num, NULL, to_number(l_tuple.name)),

Line 1806: FND_GLOBAL.USER_ID,

1802: rulegroup_id,
1803: parameter_name,
1804: parameter_value
1805: ) VALUES (
1806: FND_GLOBAL.USER_ID,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: SYSDATE,
1810: FND_GLOBAL.CONC_LOGIN_ID,

Line 1808: FND_GLOBAL.USER_ID,

1804: parameter_value
1805: ) VALUES (
1806: FND_GLOBAL.USER_ID,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: SYSDATE,
1810: FND_GLOBAL.CONC_LOGIN_ID,
1811: 1,
1812: l_id,

Line 1810: FND_GLOBAL.CONC_LOGIN_ID,

1806: FND_GLOBAL.USER_ID,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: SYSDATE,
1810: FND_GLOBAL.CONC_LOGIN_ID,
1811: 1,
1812: l_id,
1813: DECODE( p_rulegroup_id, FND_API.g_miss_num, NULL, p_rulegroup_id),
1814: DECODE( l_tuple.name, FND_API.g_miss_char, NULL, l_tuple.name),