APPS.AMS_RULE_GROUP_PVT dependencies on AMS_IBA_PS_RULEGRPS_B

Line 52: SELECT AMS_IBA_PS_RULEGRPS_B_s.NEXTVAL

48: l_ps_rules_rec AMS_Ps_Rule_PVT.ps_rules_rec_type;
49: l_content_type VARCHAR2(30);
50:
51: CURSOR c_id IS
52: SELECT AMS_IBA_PS_RULEGRPS_B_s.NEXTVAL
53: FROM dual;
54:
55: CURSOR c_id_exists (l_id IN NUMBER) IS
56: SELECT 1

Line 57: FROM AMS_IBA_PS_RULEGRPS_B

53: FROM dual;
54:
55: CURSOR c_id_exists (l_id IN NUMBER) IS
56: SELECT 1
57: FROM AMS_IBA_PS_RULEGRPS_B
58: WHERE RULEGROUP_ID = l_id;
59:
60: BEGIN
61: -- Standard Start of API savepoint

Line 109: select count(1) into l_no from AMS_IBA_PS_RULEGRPS_B ps_rulegrp

105: -- ====================================================================
106: -- Validate Environment
107: -- ====================================================================
108: BEGIN
109: select count(1) into l_no from AMS_IBA_PS_RULEGRPS_B ps_rulegrp
110: where (ps_rulegrp.posting_id = p_rule_group_rec.posting_id
111: AND ps_rulegrp.exec_priority = p_rule_group_rec.exec_priority);
112:
113:

Line 230: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row)

226:
227: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
228: END IF;
229:
230: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row)
231: AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row(
232: px_rulegroup_id => l_rulegroup_id,
233: p_posting_id => p_rule_group_rec.posting_id,
234: p_strategy_type => p_rule_group_rec.strategy_type,

Line 231: AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row(

227: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
228: END IF;
229:
230: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row)
231: AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row(
232: px_rulegroup_id => l_rulegroup_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,

Line 402: FROM AMS_IBA_PS_RULEGRPS_B

398: l_strategy_type VARCHAR2(30);
399:
400: CURSOR c_object_version(rg_id IN NUMBER) IS
401: SELECT object_version_number
402: FROM AMS_IBA_PS_RULEGRPS_B
403: WHERE rulegroup_id = rg_id;
404:
405: CURSOR c_strategy_type(rg_id IN NUMBER) IS
406: SELECT strategy_type

Line 407: FROM AMS_IBA_PS_RULEGRPS_B

403: WHERE rulegroup_id = rg_id;
404:
405: CURSOR c_strategy_type(rg_id IN NUMBER) IS
406: SELECT strategy_type
407: FROM AMS_IBA_PS_RULEGRPS_B
408: WHERE rulegroup_id = rg_id;
409:
410: BEGIN
411: -- Standard Start of API savepoint

Line 440: select count(1) into l_no from AMS_IBA_PS_RULEGRPS_B ps_rulegrp

436: -- Initialize API return status to SUCCESS
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: BEGIN
440: select count(1) into l_no from AMS_IBA_PS_RULEGRPS_B ps_rulegrp
441: where
442: (ps_rulegrp.posting_id = p_rule_group_rec.posting_id
443: AND ps_rulegrp.rulegroup_id <> p_rule_group_rec.rulegroup_id
444: AND ps_rulegrp.exec_priority = p_rule_group_rec.exec_priority);

Line 578: Update AMS_IBA_PS_RULEGRPS_B

574: AMS_UTILITY_PVT.debug_message('Trying to update B and TL tables for rulegrp and rules');
575:
576: END IF;
577:
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,

Line 766: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row)

762:
763: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
764: END IF;
765:
766: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row)
767: AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row(
768: p_RULEGROUP_ID => p_RULEGROUP_ID);
769: --
770: -- End of API body

Line 767: AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row(

763: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
764: END IF;
765:
766: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row)
767: AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row(
768: p_RULEGROUP_ID => p_RULEGROUP_ID);
769: --
770: -- End of API body
771: --

Line 855: FROM AMS_IBA_PS_RULEGRPS_B

851: l_RULEGROUP_ID NUMBER;
852:
853: CURSOR c_Rule_Group IS
854: SELECT RULEGROUP_ID
855: FROM AMS_IBA_PS_RULEGRPS_B
856: WHERE RULEGROUP_ID = p_RULEGROUP_ID
857: AND object_version_number = p_object_version
858: FOR UPDATE NOWAIT;
859:

Line 1025: FROM ams_iba_ps_rulegrps_b

1021: l_return_status VARCHAR2(1);
1022:
1023: CURSOR c_complete IS
1024: SELECT *
1025: FROM ams_iba_ps_rulegrps_b
1026: WHERE rulegroup_id = p_rule_group_rec.rulegroup_id;
1027: l_rule_group_rec c_complete%ROWTYPE;
1028: BEGIN
1029: x_complete_rec := p_rule_group_rec;