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.AMS_PS_RULE_PVT dependencies on AMS_IBA_PS_RULES

Line 74: SELECT AMS_IBA_PS_RULES_s.NEXTVAL

70:
71: --patch end 2225359
72:
73: CURSOR c_id IS
74: SELECT AMS_IBA_PS_RULES_s.NEXTVAL
75: FROM dual;
76:
77: CURSOR c_id_exists (l_id IN NUMBER) IS
78: SELECT 1

Line 79: FROM AMS_IBA_PS_RULES

75: FROM dual;
76:
77: CURSOR c_id_exists (l_id IN NUMBER) IS
78: SELECT 1
79: FROM AMS_IBA_PS_RULES
80: WHERE RULE_ID = l_id;
81:
82: CURSOR c_strategy_id_exists(l_p_id IN NUMBER,l_r_id IN NUMBER) IS
83: SELECT DISTINCT STRATEGY_ID

Line 84: FROM AMS_IBA_PS_RULES

80: WHERE RULE_ID = l_id;
81:
82: CURSOR c_strategy_id_exists(l_p_id IN NUMBER,l_r_id IN NUMBER) IS
83: SELECT DISTINCT STRATEGY_ID
84: FROM AMS_IBA_PS_RULES
85: WHERE (POSTING_ID = l_p_id AND RULEGROUP_ID = l_r_id);
86:
87: BEGIN
88: -- Standard Start of API savepoint

Line 202: SELECT COUNT(1) into l_no_of_records FROM AMS_IBA_PS_RULES ps_rule

198:
199: AMS_UTILITY_PVT.debug_message('CLAUSEVALUE2,CLAUSEVALUE3 :' || p_ps_rules_rec.CLAUSEVALUE2||' '||p_ps_rules_rec.CLAUSEVALUE3 );
200: END IF;
201:
202: SELECT COUNT(1) into l_no_of_records FROM AMS_IBA_PS_RULES ps_rule
203: WHERE (ps_rule.posting_id = p_ps_rules_rec.posting_id AND ps_rule.rulegroup_id = p_ps_rules_rec.rulegroup_id
204: AND ps_rule.CLAUSEVALUE2 = p_ps_rules_rec.CLAUSEVALUE2 AND ps_rule.CLAUSEVALUE3 = p_ps_rules_rec.CLAUSEVALUE3 );
205:
206: IF l_no_of_records > 0 THEN

Line 311: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)

307: p_visitor_rec.rgoh is null AND
308: p_visitor_rec.rgnoh is null)
309: THEN
310:
311: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)
312:
313: IF p_ps_rules_rec.RULE_ID IS NULL OR p_ps_rules_rec.RULE_ID = FND_API.g_miss_num THEN
314:
315: LOOP

Line 329: AMS_IBA_PS_RULES_PKG.Insert_Row(

325: END LOOP;
326: END IF;
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,

Line 394: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Insert_Row)

390: EXIT WHEN l_dummy IS NULL;
391: END LOOP;
392: END IF;
393:
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,

Line 396: AMS_IBA_PS_RULES_PKG.Insert_Row(

392: END IF;
393:
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,

Line 539: FROM AMS_IBA_PS_RULES

535: l_RULE_ID NUMBER;
536:
537: CURSOR c_object_version(rgp_id IN NUMBER) IS
538: SELECT object_version_number
539: FROM AMS_IBA_PS_RULES
540: WHERE rulegroup_id = rgp_id
541: and rownum <= 1;
542:
543: BEGIN

Line 656: Update AMS_IBA_PS_RULES

652:
653: AMS_UTILITY_PVT.debug_message('Private API: Calling update ');
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,

Line 812: SELECT AMS_IBA_PS_RULES_s.NEXTVAL FROM dual;

808: i NUMBER;
809: j NUMBER;
810:
811: CURSOR c_id IS
812: SELECT AMS_IBA_PS_RULES_s.NEXTVAL FROM dual;
813:
814: CURSOR c_id_exists (l_id IN NUMBER) IS
815: SELECT 1
816: FROM AMS_IBA_PS_RULES

Line 816: FROM AMS_IBA_PS_RULES

812: SELECT AMS_IBA_PS_RULES_s.NEXTVAL FROM dual;
813:
814: CURSOR c_id_exists (l_id IN NUMBER) IS
815: SELECT 1
816: FROM AMS_IBA_PS_RULES
817: WHERE RULE_ID = l_id;
818:
819: BEGIN
820: /*

Line 894: FROM ams_iba_ps_rules

890: -- posting_id, strategy_id, exec_priority,
891: -- bus_priority_code, bus_priority_disp_order
892: BULK COLLECT INTO l_cl2, l_cl3 -- l_rgid, l_pstng_id, l_strat_id
893: -- ,l_ex_pty, l_bus_pc, l_bus_do
894: FROM ams_iba_ps_rules
895: WHERE posting_id = p_ps_rules_rec.posting_id
896: AND rulegroup_id = p_ps_rules_rec.rulegroup_id;
897:
898: -- END IF; -- REMOVE THIS AFTER UNCOMMENTING BLOCK BELOW

Line 900: DELETE FROM ams_iba_ps_rules

896: AND rulegroup_id = p_ps_rules_rec.rulegroup_id;
897:
898: -- END IF; -- REMOVE THIS AFTER UNCOMMENTING BLOCK BELOW
899:
900: DELETE FROM ams_iba_ps_rules
901: WHERE posting_id = p_ps_rules_rec.posting_id
902: AND rulegroup_id = p_ps_rules_rec.rulegroup_id
903: AND clausevalue1 IS NOT NULL;
904:

Line 925: AMS_IBA_PS_RULES_PKG.Insert_Row(

921: CLOSE c_id_exists;
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,

Line 978: AMS_IBA_PS_RULES_PKG.Insert_Row(

974: CLOSE c_id_exists;
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,

Line 1015: UPDATE ams_iba_ps_rules

1011: END IF;
1012: ELSE
1013:
1014: -- Any of CL4 to CL10 has changed.
1015: UPDATE ams_iba_ps_rules
1016: SET
1017: clausevalue4 = p_ps_rules_rec.clausevalue4,
1018: clausevalue5 = p_ps_rules_rec.clausevalue5,
1019: clausevalue6 = p_ps_rules_rec.clausevalue6,

Line 1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)

1088:
1089: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
1090: END IF;
1091:
1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)
1093: AMS_IBA_PS_RULES_PKG.Delete_Row(
1094: p_RULE_ID => p_RULE_ID);
1095: --
1096: -- End of API body

Line 1093: AMS_IBA_PS_RULES_PKG.Delete_Row(

1089: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
1090: END IF;
1091:
1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)
1093: AMS_IBA_PS_RULES_PKG.Delete_Row(
1094: p_RULE_ID => p_RULE_ID);
1095: --
1096: -- End of API body
1097: --

Line 1212: DELETE FROM ams_iba_ps_rules

1208: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1209: END IF;
1210:
1211: -- Special delete case
1212: DELETE FROM ams_iba_ps_rules
1213: WHERE posting_id = p_ps_rules_rec.posting_id
1214: AND rulegroup_id = p_ps_rules_rec.rulegroup_id
1215: AND clausevalue2 = p_ps_rules_rec.clausevalue2
1216: AND clausevalue3 = p_ps_rules_rec.clausevalue3;

Line 1300: FROM AMS_IBA_PS_RULES

1296: l_RULE_ID NUMBER;
1297:
1298: CURSOR c_Ps_Rule IS
1299: SELECT RULE_ID
1300: FROM AMS_IBA_PS_RULES
1301: WHERE RULE_ID = p_RULE_ID
1302: AND object_version_number = p_object_version
1303: FOR UPDATE NOWAIT;
1304:

Line 1419: 'AMS_IBA_PS_RULES',

1415: BEGIN
1416: x_return_status := FND_API.g_ret_sts_success;
1417: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1418: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1419: 'AMS_IBA_PS_RULES',
1420: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||''''
1421: );
1422: ELSE
1423: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1424: 'AMS_IBA_PS_RULES',

1420: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||''''
1421: );
1422: ELSE
1423: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1424: 'AMS_IBA_PS_RULES',
1425: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||
1426: ''' AND RULE_ID <> ' || p_ps_rules_rec.RULE_ID
1427: );
1428: END IF;

Line 1840: FROM ams_iba_ps_rules

1836: l_return_status VARCHAR2(1);
1837:
1838: CURSOR c_complete IS
1839: SELECT *
1840: FROM ams_iba_ps_rules
1841: WHERE rule_id = p_ps_rules_rec.rule_id;
1842: l_ps_rules_rec c_complete%ROWTYPE;
1843: BEGIN
1844: x_complete_rec := p_ps_rules_rec;