DBA Data[Home] [Help]

PACKAGE: APPS.AST_RS_CAMPAIGNS_PKG

Source


1 PACKAGE AST_RS_CAMPAIGNS_PKG as
2 /* $Header: asttrcas.pls 120.1 2005/06/01 04:21:46 appldev  $ */
3 -- Start of Comments
4 -- Package name     : AST_RS_CAMPAIGNS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_RS_CAMPAIGN_ID   IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
12           p_RESOURCE_ID    NUMBER,
13           p_CAMPAIGN_ID    NUMBER,
14           p_START_DATE    DATE,
15           p_END_DATE    DATE,
16           p_STATUS    VARCHAR2,
17           p_ENABLED_FLAG    VARCHAR2,
18           p_CREATED_BY    NUMBER,
19           p_CREATION_DATE    DATE,
20           p_LAST_UPDATED_BY    NUMBER,
21           p_LAST_UPDATE_DATE    DATE,
22           p_LAST_UPDATE_LOGIN    VARCHAR2);
23 
24 PROCEDURE Update_Row(
25           p_RS_CAMPAIGN_ID    NUMBER,
26           p_RESOURCE_ID    NUMBER,
27           p_CAMPAIGN_ID    NUMBER,
28           p_START_DATE    DATE,
29           p_END_DATE    DATE,
30           p_STATUS    VARCHAR2,
31           p_ENABLED_FLAG    VARCHAR2,
32           p_CREATED_BY    NUMBER,
33           p_CREATION_DATE    DATE,
34           p_LAST_UPDATED_BY    NUMBER,
35           p_LAST_UPDATE_DATE    DATE,
36           p_LAST_UPDATE_LOGIN    VARCHAR2);
37 
38 PROCEDURE Lock_Row(
39           p_RS_CAMPAIGN_ID    NUMBER,
40           p_RESOURCE_ID    NUMBER,
41           p_CAMPAIGN_ID    NUMBER,
42           p_START_DATE    DATE,
43           p_END_DATE    DATE,
44           p_STATUS    VARCHAR2,
45           p_ENABLED_FLAG    VARCHAR2,
46           p_CREATED_BY    NUMBER,
47           p_CREATION_DATE    DATE,
48           p_LAST_UPDATED_BY    NUMBER,
49           p_LAST_UPDATE_DATE    DATE,
50           p_LAST_UPDATE_LOGIN    VARCHAR2);
51 
52 PROCEDURE Delete_Row(
53     p_RS_CAMPAIGN_ID  NUMBER);
54 End AST_RS_CAMPAIGNS_PKG;