APPS.AST_RS_CAMPAIGNS_PKG dependencies on AST_RS_CAMPAIGNS

Line 1: PACKAGE BODY AST_RS_CAMPAIGNS_PKG as

1: PACKAGE BODY AST_RS_CAMPAIGNS_PKG as
2: /* $Header: asttrcab.pls 120.1 2005/06/01 04:20:54 appldev $ */
3: -- Start of Comments
4: -- Package name : AST_RS_CAMPAIGNS_PKG
5: -- Purpose :

Line 4: -- Package name : AST_RS_CAMPAIGNS_PKG

1: PACKAGE BODY AST_RS_CAMPAIGNS_PKG as
2: /* $Header: asttrcab.pls 120.1 2005/06/01 04:20:54 appldev $ */
3: -- Start of Comments
4: -- Package name : AST_RS_CAMPAIGNS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 29: CURSOR C2 IS SELECT AST_RS_CAMPAIGNS_S.nextval FROM sys.dual;

25: p_LAST_UPDATE_DATE DATE,
26: p_LAST_UPDATE_LOGIN VARCHAR2)
27:
28: IS
29: CURSOR C2 IS SELECT AST_RS_CAMPAIGNS_S.nextval FROM sys.dual;
30: --
31: l_count number := 0;
32: BEGIN
33: If (px_RS_CAMPAIGN_ID IS NULL) OR (px_RS_CAMPAIGN_ID = FND_API.G_MISS_NUM) then

Line 42: from ast_rs_campaigns

38: --
39: -- Before insert rec, check dup rec;
40: select count(rs_campaign_id)
41: into l_count
42: from ast_rs_campaigns
43: where resource_id = p_resource_id
44: and campaign_id = p_campaign_id;
45: --
46: if (l_count > 0) then

Line 50: INSERT INTO AST_RS_CAMPAIGNS(

46: if (l_count > 0) then
47: return;
48: end if;
49: --
50: INSERT INTO AST_RS_CAMPAIGNS(
51: RS_CAMPAIGN_ID,
52: RESOURCE_ID,
53: CAMPAIGN_ID,
54: START_DATE,

Line 94: Update AST_RS_CAMPAIGNS

90: p_LAST_UPDATE_LOGIN VARCHAR2)
91:
92: IS
93: BEGIN
94: Update AST_RS_CAMPAIGNS
95: SET
96: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
97: CAMPAIGN_ID = decode( p_CAMPAIGN_ID, FND_API.G_MISS_NUM, CAMPAIGN_ID, p_CAMPAIGN_ID),
98: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

Line 118: DELETE FROM AST_RS_CAMPAIGNS

114: PROCEDURE Delete_Row(
115: p_RS_CAMPAIGN_ID NUMBER)
116: IS
117: BEGIN
118: DELETE FROM AST_RS_CAMPAIGNS
119: WHERE RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID;
120: If (SQL%NOTFOUND) then
121: RAISE NO_DATA_FOUND;
122: End If;

Line 142: FROM AST_RS_CAMPAIGNS

138:
139: IS
140: CURSOR C IS
141: SELECT *
142: FROM AST_RS_CAMPAIGNS
143: WHERE RS_CAMPAIGN_ID = p_RS_CAMPAIGN_ID
144: FOR UPDATE of RS_CAMPAIGN_ID NOWAIT;
145: Recinfo C%ROWTYPE;
146: BEGIN

Line 198: End AST_RS_CAMPAIGNS_PKG;

194: APP_EXCEPTION.RAISE_EXCEPTION;
195: End If;
196: END Lock_Row;
197:
198: End AST_RS_CAMPAIGNS_PKG;