APPS.AMS_CT_RULE_PVT dependencies on AMS_CONTENT_RULES_B

Line 73: SELECT AMS_CONTENT_RULES_B_s.NEXTVAL

69: l_CONTENT_RULE_ID NUMBER;
70: l_dummy NUMBER;
71:
72: CURSOR c_id IS
73: SELECT AMS_CONTENT_RULES_B_s.NEXTVAL
74: FROM dual;
75:
76: CURSOR c_id_exists (l_id IN NUMBER) IS
77: SELECT 1

Line 78: FROM AMS_CONTENT_RULES_B

74: FROM dual;
75:
76: CURSOR c_id_exists (l_id IN NUMBER) IS
77: SELECT 1
78: FROM AMS_CONTENT_RULES_B
79: WHERE CONTENT_RULE_ID = l_id;
80:
81: BEGIN
82: -- Standard Start of API savepoint

Line 165: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Insert_Row)

161:
162: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Calling create table handler');
163: END IF;
164:
165: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Insert_Row)
166: AMS_CONTENT_RULES_B_PKG.Insert_Row(
167: px_content_rule_id => l_content_rule_id,
168: p_created_by => G_USER_ID,
169: p_creation_date => SYSDATE,

Line 166: AMS_CONTENT_RULES_B_PKG.Insert_Row(

162: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Calling create table handler');
163: END IF;
164:
165: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Insert_Row)
166: AMS_CONTENT_RULES_B_PKG.Insert_Row(
167: px_content_rule_id => l_content_rule_id,
168: p_created_by => G_USER_ID,
169: p_creation_date => SYSDATE,
170: p_last_updated_by => G_USER_ID,

Line 289: FROM AMS_CONTENT_RULES_B;

285: IS
286:
287: CURSOR c_get_ct_rule(content_rule_id NUMBER) IS
288: SELECT *
289: FROM AMS_CONTENT_RULES_B;
290: -- Hint: Developer need to provide Where clause
291:
292: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ct_Rule';
293: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 402: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Update_Row)

398:
399: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
400: END IF;
401:
402: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Update_Row)
403: AMS_CONTENT_RULES_B_PKG.Update_Row(
404: p_content_rule_id => p_ct_rule_rec.content_rule_id,
405: p_created_by => G_USER_ID,
406: p_creation_date => SYSDATE,

Line 403: AMS_CONTENT_RULES_B_PKG.Update_Row(

399: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
400: END IF;
401:
402: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Update_Row)
403: AMS_CONTENT_RULES_B_PKG.Update_Row(
404: p_content_rule_id => p_ct_rule_rec.content_rule_id,
405: p_created_by => G_USER_ID,
406: p_creation_date => SYSDATE,
407: p_last_updated_by => G_USER_ID,

Line 560: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Delete_Row)

556:
557: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
558: END IF;
559:
560: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Delete_Row)
561: AMS_CONTENT_RULES_B_PKG.Delete_Row(
562: p_CONTENT_RULE_ID => p_CONTENT_RULE_ID);
563: --
564: -- End of API body

Line 561: AMS_CONTENT_RULES_B_PKG.Delete_Row(

557: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
558: END IF;
559:
560: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Delete_Row)
561: AMS_CONTENT_RULES_B_PKG.Delete_Row(
562: p_CONTENT_RULE_ID => p_CONTENT_RULE_ID);
563: --
564: -- End of API body
565: --

Line 662: FROM AMS_CONTENT_RULES_B

658: l_CONTENT_RULE_ID NUMBER;
659:
660: CURSOR c_Ct_Rule IS
661: SELECT CONTENT_RULE_ID
662: FROM AMS_CONTENT_RULES_B
663: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID
664: AND object_version_number = p_object_version
665: FOR UPDATE NOWAIT;
666:

Line 885: 'AMS_CONTENT_RULES_B',

881:
882: x_return_status := FND_API.g_ret_sts_success;
883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
884: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
885: 'AMS_CONTENT_RULES_B',
886: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||''''
887: );
888: ELSE
889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 890: 'AMS_CONTENT_RULES_B',

886: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||''''
887: );
888: ELSE
889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
890: 'AMS_CONTENT_RULES_B',
891: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||
892: ''' AND CONTENT_RULE_ID <> ' || p_ct_rule_rec.CONTENT_RULE_ID
893: );
894: END IF;

Line 918: 'AMS_CONTENT_RULES_B',

914: END IF;
915:
916: /*
917: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
918: 'AMS_CONTENT_RULES_B',
919: l_sql
920: );
921:
922: IF l_valid_flag = FND_API.g_false

Line 1152: FROM ams_content_rules_b

1148: l_return_status VARCHAR2(1);
1149:
1150: CURSOR c_complete IS
1151: SELECT *
1152: FROM ams_content_rules_b
1153: WHERE content_rule_id = p_ct_rule_rec.content_rule_id;
1154: l_ct_rule_rec c_complete%ROWTYPE;
1155: BEGIN
1156: x_complete_rec := p_ct_rule_rec;