APPS.CSC_PROF_MODULE_GROUPS_PKG dependencies on CSC_PROF_MODULE_GROUPS

Line 1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PKG as

1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PKG as
2: /* $Header: csctpmgb.pls 120.3 2005/09/18 23:38:39 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_MODULE_GROUPS_PKG
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_MODULE_GROUPS_PKG

1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PKG as
2: /* $Header: csctpmgb.pls 120.3 2005/09/18 23:38:39 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_MODULE_GROUPS_PKG
5: -- Purpose :
6: -- History :
7: -- 03 Nov 00 axsubram Added load_row for NLS (# 1487333)
8: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_MODULE_GROUPS_PKG';

13: -- NOTE :
14: -- End of Comments
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_MODULE_GROUPS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctpmgb.pls';
19:
20: PROCEDURE Insert_Row(
21: px_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,

Line 40: CURSOR C2 IS SELECT CSC_PROF_MODULE_GROUPS_S.nextval FROM sys.dual;

36: p_APPLICATION_ID NUMBER,
37: p_DASHBOARD_GROUP_ID NUMBER)
38:
39: IS
40: CURSOR C2 IS SELECT CSC_PROF_MODULE_GROUPS_S.nextval FROM sys.dual;
41: ps_SEEDED_FLAG Varchar2(3);
42:
43: BEGIN
44:

Line 62: INSERT INTO CSC_PROF_MODULE_GROUPS(

58: OPEN C2;
59: FETCH C2 INTO px_MODULE_GROUP_ID;
60: CLOSE C2;
61: End If;
62: INSERT INTO CSC_PROF_MODULE_GROUPS(
63: MODULE_GROUP_ID,
64: FORM_FUNCTION_ID,
65: FORM_FUNCTION_NAME,
66: RESPONSIBILITY_ID,

Line 119: Update CSC_PROF_MODULE_GROUPS

115: p_DASHBOARD_GROUP_ID NUMBER)
116:
117: IS
118: BEGIN
119: Update CSC_PROF_MODULE_GROUPS
120: SET
121: FORM_FUNCTION_ID = p_FORM_FUNCTION_ID,
122: RESPONSIBILITY_ID =p_RESPONSIBILITY_ID,
123: RESP_APPL_ID =p_RESP_APPL_ID,

Line 146: DELETE FROM CSC_PROF_MODULE_GROUPS

142: PROCEDURE Delete_Row(
143: p_MODULE_GROUP_ID NUMBER)
144: IS
145: BEGIN
146: DELETE FROM CSC_PROF_MODULE_GROUPS
147: WHERE MODULE_GROUP_ID = p_MODULE_GROUP_ID;
148: If (SQL%NOTFOUND) then
149: RAISE NO_DATA_FOUND;
150: End If;

Line 175: FROM CSC_PROF_MODULE_GROUPS

171:
172: IS
173: CURSOR C IS
174: SELECT *
175: FROM CSC_PROF_MODULE_GROUPS
176: WHERE MODULE_GROUP_ID = p_MODULE_GROUP_ID
177: FOR UPDATE of MODULE_GROUP_ID NOWAIT;
178: Recinfo C%ROWTYPE;
179: BEGIN

Line 269: Csc_Prof_Module_Groups_Pkg.Update_Row(

265: Begin
266:
267: l_module_group_id := p_module_group_id ;
268:
269: Csc_Prof_Module_Groups_Pkg.Update_Row(
270: p_MODULE_GROUP_ID => p_module_group_id,
271: p_FORM_FUNCTION_ID => p_form_function_id,
272: p_FORM_FUNCTION_NAME => p_form_function_name,
273: p_RESPONSIBILITY_ID => p_responsibility_id,

Line 289: Csc_Prof_Module_Groups_Pkg.Insert_Row(

285:
286: EXCEPTION
287: WHEN NO_DATA_FOUND THEN
288:
289: Csc_Prof_Module_Groups_Pkg.Insert_Row(
290: px_MODULE_GROUP_ID => l_module_group_id,
291: p_FORM_FUNCTION_ID => p_form_function_id,
292: p_FORM_FUNCTION_NAME => p_form_function_name,
293: p_RESPONSIBILITY_ID => p_responsibility_id,

Line 309: End CSC_PROF_MODULE_GROUPS_PKG;

305: p_APPLICATION_ID => p_application_id,
306: p_DASHBOARD_GROUP_ID => p_dashboard_group_id);
307:
308: End Load_Row;
309: End CSC_PROF_MODULE_GROUPS_PKG;