APPS.CSC_PROF_GROUP_CATEGORIES_PKG dependencies on CSC_PROF_GROUP_CATEGORIES

Line 1: PACKAGE BODY CSC_PROF_GROUP_CATEGORIES_PKG as

1: PACKAGE BODY CSC_PROF_GROUP_CATEGORIES_PKG as
2: /* $Header: csctpcab.pls 120.3 2005/09/18 23:44:08 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CATEGORIES_PKG
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_GROUP_CATEGORIES_PKG

1: PACKAGE BODY CSC_PROF_GROUP_CATEGORIES_PKG as
2: /* $Header: csctpcab.pls 120.3 2005/09/18 23:44:08 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CATEGORIES_PKG
5: -- Purpose :
6: -- History :
7: -- 26 Nov 2002 JAmose For Fnd_Api.G_Miss* changes
8: -- 19 july 2005 tpalaniv Modified the load_row API to fetch last_updated_by using FND API

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CATEGORIES_PKG';

10: -- NOTE :
11: -- End of Comments
12:
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CATEGORIES_PKG';
15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctpgcb.pls';
16:
17: PROCEDURE Insert_Row(
18: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,

Line 30: CURSOR C2 IS SELECT CSC_PROF_GROUP_CATEGORIES_S.nextval FROM sys.dual;

26: p_LAST_UPDATE_LOGIN NUMBER,
27: p_SEEDED_FLAG VARCHAR2)
28:
29: IS
30: CURSOR C2 IS SELECT CSC_PROF_GROUP_CATEGORIES_S.nextval FROM sys.dual;
31: ps_SEEDED_FLAG Varchar2(3);
32: BEGIN
33:
34: /* added the below 2 lines for bug 4596220 */

Line 51: INSERT INTO CSC_PROF_GROUP_CATEGORIES(

47: OPEN C2;
48: FETCH C2 INTO px_GROUP_CATEGORY_ID;
49: CLOSE C2;
50: End If;
51: INSERT INTO CSC_PROF_GROUP_CATEGORIES(
52: GROUP_CATEGORY_ID,
53: GROUP_ID,
54: CATEGORY_CODE,
55: CATEGORY_SEQUENCE,

Line 87: Update CSC_PROF_GROUP_CATEGORIES

83: p_SEEDED_FLAG VARCHAR2)
84:
85: IS
86: BEGIN
87: Update CSC_PROF_GROUP_CATEGORIES
88: SET
89: GROUP_ID = p_GROUP_ID,
90: CATEGORY_CODE = p_CATEGORY_CODE,
91: CATEGORY_SEQUENCE =p_CATEGORY_SEQUENCE,

Line 107: DELETE FROM CSC_PROF_GROUP_CATEGORIES

103: PROCEDURE Delete_Row(
104: p_GROUP_CATEGORY_ID NUMBER)
105: IS
106: BEGIN
107: DELETE FROM CSC_PROF_GROUP_CATEGORIES
108: WHERE GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID;
109: If (SQL%NOTFOUND) then
110: RAISE NO_DATA_FOUND;
111: End If;

Line 129: FROM CSC_PROF_GROUP_CATEGORIES

125:
126: IS
127: CURSOR C IS
128: SELECT *
129: FROM CSC_PROF_GROUP_CATEGORIES
130: WHERE GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID
131: FOR UPDATE of GROUP_CATEGORY_ID NOWAIT;
132: Recinfo C%ROWTYPE;
133: BEGIN

Line 195: Csc_Prof_Group_Categories_Pkg.Update_Row(

191: l_group_category_id number := p_GROUP_CATEGORY_ID;
192:
193: Begin
194:
195: Csc_Prof_Group_Categories_Pkg.Update_Row(
196: p_GROUP_CATEGORY_ID => p_GROUP_CATEGORY_ID,
197: p_GROUP_ID => p_GROUP_ID,
198: p_CATEGORY_CODE => p_CATEGORY_CODE,
199: p_CATEGORY_SEQUENCE => p_CATEGORY_SEQUENCE,

Line 207: Csc_Prof_Group_Categories_Pkg.Insert_Row(

203: p_SEEDED_FLAG => p_SEEDED_FLAG);
204:
205: Exception
206: When no_data_found then
207: Csc_Prof_Group_Categories_Pkg.Insert_Row(
208: px_GROUP_CATEGORY_ID => l_group_category_id,
209: p_GROUP_ID => p_GROUP_ID,
210: p_CATEGORY_CODE => p_CATEGORY_CODE,
211: p_CATEGORY_SEQUENCE => p_CATEGORY_SEQUENCE,

Line 222: End CSC_PROF_GROUP_CATEGORIES_PKG;

218:
219: End Load_Row;
220:
221:
222: End CSC_PROF_GROUP_CATEGORIES_PKG;