APPS.AMS_CONTENT_RULES_B_PKG dependencies on AMS_CONTENT_RULES_B

Line 1: PACKAGE BODY AMS_CONTENT_RULES_B_PKG as

1: PACKAGE BODY AMS_CONTENT_RULES_B_PKG as
2: /* $Header: amstctrb.pls 120.2 2006/05/30 11:10:24 prageorg noship $ */
3:
4: -- ===============================================================
5: -- Start of Comments

Line 7: -- AMS_CONTENT_RULES_B_PKG

3:
4: -- ===============================================================
5: -- Start of Comments
6: -- Package name
7: -- AMS_CONTENT_RULES_B_PKG
8: --
9: -- Purpose
10: -- Private api created to Update/insert/Delete general
11: -- and object-specific content rules

Line 26: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_CONTENT_RULES_B_PKG';

22: -- End of Comments
23: -- ===============================================================
24:
25:
26: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_CONTENT_RULES_B_PKG';
27: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstctrb.pls';
28:
29:
30:

Line 67: cursor C is select ROWID from AMS_content_rules_b

63: x_rowid VARCHAR2(30);
64: l_rowid VARCHAR2(20);
65: l_last_update_date DATE;
66:
67: cursor C is select ROWID from AMS_content_rules_b
68: where content_rule_ID = px_content_rule_id;
69:
70:
71: BEGIN

Line 84: INSERT INTO AMS_CONTENT_RULES_B(

80: END IF;
81:
82: AMS_UTILITY_PVT.debug_message('SONALI table handler '||l_last_update_date);
83:
84: INSERT INTO AMS_CONTENT_RULES_B(
85: content_rule_id,
86: created_by,
87: creation_date,
88: last_updated_by,

Line 199: Update AMS_CONTENT_RULES_B

195: p_delivery_mode VARCHAR2)
196:
197: IS
198: BEGIN
199: Update AMS_CONTENT_RULES_B
200: SET
201: content_rule_id = DECODE( p_content_rule_id, FND_API.g_miss_num, content_rule_id, p_content_rule_id),
202: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
203: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 252: DELETE FROM AMS_CONTENT_RULES_B

248: PROCEDURE Delete_Row(
249: p_CONTENT_RULE_ID NUMBER)
250: IS
251: BEGIN
252: DELETE FROM AMS_CONTENT_RULES_B
253: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
254: If (SQL%NOTFOUND) then
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;

Line 301: FROM AMS_CONTENT_RULES_B

297:
298: IS
299: CURSOR C IS
300: SELECT *
301: FROM AMS_CONTENT_RULES_B
302: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID
303: FOR UPDATE of CONTENT_RULE_ID NOWAIT;
304: Recinfo C%ROWTYPE;
305: BEGIN

Line 379: from AMS_CONTENT_RULES_B B

375: begin
376: delete from AMS_CONTENT_RULES_TL T
377: where not exists
378: (select NULL
379: from AMS_CONTENT_RULES_B B
380: where B.content_rule_id = T.content_rule_id
381: );
382:
383: update AMS_CONTENT_RULES_TL T set (

Line 435: END AMS_CONTENT_RULES_B_PKG;

431: and T.LANGUAGE = L.LANGUAGE_CODE);
432: end ADD_LANGUAGE;
433:
434:
435: END AMS_CONTENT_RULES_B_PKG;