[Home] [Help]
PACKAGE: APPS.AS_SALES_METHODOLOGY_PVT
Source
1 PACKAGE AS_SALES_METHODOLOGY_PVT AS
2 /* $Header: asxvsmos.pls 120.0 2005/06/02 17:15:34 appldev noship $ */
3 ---------------------------------------------------------------------------
4 --Define Global Variables--
5 ---------------------------------------------------------------------------
6
7 G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_METH_PVT';
8
9 ---------------------------------------------------------------------------
10
11
12 --Procedure to Create a Sales Methodology
13
14 Procedure CREATE_SALES_METHODOLOGY
15 (
16 P_API_VERSION IN NUMBER,
17 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
18 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
19 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
20 P_SALES_METHODOLOGY_NAME IN VARCHAR2,
21 P_START_DATE_ACTIVE IN DATE,
22 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
23 P_AUTOCREATETASK_FLAG IN VARCHAR2 DEFAULT NULL,
24 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
25 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
26 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
27 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
28 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
29 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
30 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
31 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
32 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
33 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
34 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
35 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
41 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42 X_MSG_COUNT OUT NOCOPY NUMBER,
43 X_MSG_DATA OUT NOCOPY VARCHAR2,
44 X_SALES_METHODOLOGY_ID OUT NOCOPY NUMBER);
45
46 --Procedure to Upate Sales Methodology
47
48 Procedure UPDATE_SALES_METHODOLOGY
49 (
50 P_API_VERSION IN NUMBER,
51 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
52 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
53 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
54 P_SALES_METHODOLOGY_ID IN NUMBER,
55 P_SALES_METHODOLOGY_NAME IN VARCHAR2,
56 P_START_DATE_ACTIVE IN DATE,
57 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
58 P_AUTOCREATETASK_FLAG IN VARCHAR2 DEFAULT NULL,
59 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
69 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
70 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
71 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
72 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
73 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
74 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
75 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
76 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77 X_MSG_COUNT OUT NOCOPY NUMBER,
78 X_MSG_DATA OUT NOCOPY VARCHAR2,
79 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
80 );
81
82
83 --Procedure to Delete Sales Methodology
84 Procedure DELETE_SALES_METHODOLOGY
85 (
86 P_API_VERSION IN NUMBER,
87 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
88 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
89 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
90 P_SALES_METHODOLOGY_ID IN NUMBER,
91 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
92 X_MSG_COUNT OUT NOCOPY NUMBER,
93 X_MSG_DATA OUT NOCOPY VARCHAR2,
94 X_OBJECT_VERSION_NUMBER IN NUMBER
95 );
96
97
98 --Procedure to Add a Sales Stage - Template Group Map
99 Procedure ADD_SALES_METH_STAGE_MAP
100 (
101 P_API_VERSION IN NUMBER,
102 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
103 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
104 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
105 P_SALES_METHODOLOGY_ID IN NUMBER,
106 P_SALES_STAGE_ID IN NUMBER,
107 P_TASK_TEMPLATE_GROUP_ID IN NUMBER default fnd_api.g_miss_num,
108 P_MAX_WIN_PROBABILITY IN NUMBER,
109 P_MIN_WIN_PROBABILITY IN NUMBER,
110 P_SALES_SUPPLEMENT_TEMPLATE IN NUMBER,
111 P_STAGE_SEQUENCE IN NUMBER,
112 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113 X_MSG_COUNT OUT NOCOPY NUMBER,
114 X_MSG_DATA OUT NOCOPY VARCHAR2
115 );
116
117 --Procedure to Delete a Sales Stage - Template Group Map
118 Procedure DELETE_SALES_METH_STAGE_MAP
119 (
120 P_API_VERSION IN NUMBER,
121 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
122 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
123 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
124 P_SALES_METHODOLOGY_ID IN NUMBER,
125 P_SALES_STAGE_ID IN NUMBER,
126 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127 X_MSG_COUNT OUT NOCOPY NUMBER,
128 X_MSG_DATA OUT NOCOPY VARCHAR2
129 );
130
131 END AS_SALES_METHODOLOGY_PVT;