APPS.AST_GRP_CAMPAIGNS_PKG dependencies on AST_GRP_CAMPAIGNS

Line 1: PACKAGE BODY AST_GRP_CAMPAIGNS_PKG as

1: PACKAGE BODY AST_GRP_CAMPAIGNS_PKG as
2: /* $Header: asttgcab.pls 120.1 2005/06/01 03:40:29 appldev $ */
3: -- Start of Comments
4: -- Package name : AST_GRP_CAMPAIGNS_PKG
5: -- Purpose :

Line 4: -- Package name : AST_GRP_CAMPAIGNS_PKG

1: PACKAGE BODY AST_GRP_CAMPAIGNS_PKG as
2: /* $Header: asttgcab.pls 120.1 2005/06/01 03:40:29 appldev $ */
3: -- Start of Comments
4: -- Package name : AST_GRP_CAMPAIGNS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AST_GRP_CAMPAIGNS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AST_GRP_CAMPAIGNS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asttgcab.pls';
13:
14: PROCEDURE Insert_Row(
15: px_GROUP_CAMPAIGN_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 28: CURSOR C2 IS SELECT AST_GRP_CAMPAIGNS_S.nextval FROM sys.dual;

24: p_CREATED_BY NUMBER,
25: p_CREATION_DATE DATE)
26:
27: IS
28: CURSOR C2 IS SELECT AST_GRP_CAMPAIGNS_S.nextval FROM sys.dual;
29: l_count NUMBER;
30:
31: BEGIN
32: If (px_GROUP_CAMPAIGN_ID IS NULL) OR (px_GROUP_CAMPAIGN_ID = FND_API.G_MISS_NUM) then

Line 41: from ast_grp_campaigns

37: --
38: -- Before insert rec, check dup rec;
39: select count(group_campaign_id)
40: into l_count
41: from ast_grp_campaigns
42: where group_id = p_group_id
43: and campaign_id = p_campaign_id;
44: --
45: if (l_count > 0) then

Line 49: INSERT INTO AST_GRP_CAMPAIGNS(

45: if (l_count > 0) then
46: return;
47: end if;
48: --
49: INSERT INTO AST_GRP_CAMPAIGNS(
50: GROUP_CAMPAIGN_ID,
51: GROUP_ID,
52: CAMPAIGN_ID,
53: START_DATE,

Line 90: Update AST_GRP_CAMPAIGNS

86: p_CREATION_DATE DATE)
87:
88: IS
89: BEGIN
90: Update AST_GRP_CAMPAIGNS
91: SET
92: GROUP_ID = decode( p_GROUP_ID, FND_API.G_MISS_NUM, GROUP_ID, p_GROUP_ID),
93: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
94: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

Line 113: DELETE FROM AST_GRP_CAMPAIGNS

109: PROCEDURE Delete_Row(
110: p_GROUP_CAMPAIGN_ID NUMBER)
111: IS
112: BEGIN
113: DELETE FROM AST_GRP_CAMPAIGNS
114: WHERE GROUP_CAMPAIGN_ID = p_GROUP_CAMPAIGN_ID;
115: If (SQL%NOTFOUND) then
116: RAISE NO_DATA_FOUND;
117: End If;

Line 136: FROM AST_GRP_CAMPAIGNS

132:
133: IS
134: CURSOR C IS
135: SELECT *
136: FROM AST_GRP_CAMPAIGNS
137: WHERE GROUP_CAMPAIGN_ID = p_GROUP_CAMPAIGN_ID
138: FOR UPDATE of GROUP_CAMPAIGN_ID NOWAIT;
139: Recinfo C%ROWTYPE;
140: BEGIN

Line 189: End AST_GRP_CAMPAIGNS_PKG;

185: APP_EXCEPTION.RAISE_EXCEPTION;
186: End If;
187: END Lock_Row;
188:
189: End AST_GRP_CAMPAIGNS_PKG;