eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROF_MODULE_GROUPS_PVT dependencies on CSC_PROF_MODULE_GROUPS

Line 1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PVT as

1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PVT as
2: /* $Header: cscvpmgb.pls 115.23 2003/02/18 23:33:08 agaddam ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_MODULE_GROUPS_PVT
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_MODULE_GROUPS_PVT

1: PACKAGE BODY CSC_PROF_MODULE_GROUPS_PVT as
2: /* $Header: cscvpmgb.pls 115.23 2003/02/18 23:33:08 agaddam ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_MODULE_GROUPS_PVT
5: -- Purpose :
6: -- History :
7: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
8: -- from the definition for the performance reason

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_MODULE_GROUPS_PVT';

9: -- NOTE :
10: -- End of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_MODULE_GROUPS_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvpmgb.pls';
15:
16: l_dummy VARCHAR2(100);
17:

Line 190: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Insert_Row)

186: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Insert_Row)
191: CSC_PROF_MODULE_GROUPS_PKG.Insert_Row(
192: px_MODULE_GROUP_ID => px_MODULE_GROUP_ID,
193: p_FORM_FUNCTION_ID => p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,
194: p_FORM_FUNCTION_NAME => p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,

Line 191: CSC_PROF_MODULE_GROUPS_PKG.Insert_Row(

187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Insert_Row)
191: CSC_PROF_MODULE_GROUPS_PKG.Insert_Row(
192: px_MODULE_GROUP_ID => px_MODULE_GROUP_ID,
193: p_FORM_FUNCTION_ID => p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,
194: p_FORM_FUNCTION_NAME => p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,
195: p_RESPONSIBILITY_ID => p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,

Line 350: From CSC_PROF_MODULE_GROUPS

346: LAST_UPDATE_LOGIN,
347: SEEDED_FLAG,
348: APPLICATION_ID,
349: DASHBOARD_GROUP_ID
350: From CSC_PROF_MODULE_GROUPS
351: Where module_group_id = c_module_group_id
352: For Update NOWAIT;
353: l_api_name CONSTANT VARCHAR2(30) := 'Update_prof_module_groups';
354: l_api_version_number CONSTANT NUMBER := 1.0;

Line 459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)

455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457:
458:
459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)
460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),

Line 460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(

456: END IF;
457:
458:
459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)
460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),

Line 553: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Delete_Row)

549:
550: -- Initialize API return status to SUCCESS
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Delete_Row)
554: CSC_PROF_MODULE_GROUPS_PKG.Delete_Row(
555: p_MODULE_GROUP_ID => p_PROF_MODULE_GRP_Id);
556: --
557: -- End of API body

Line 554: CSC_PROF_MODULE_GROUPS_PKG.Delete_Row(

550: -- Initialize API return status to SUCCESS
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Delete_Row)
554: CSC_PROF_MODULE_GROUPS_PKG.Delete_Row(
555: p_MODULE_GROUP_ID => p_PROF_MODULE_GRP_Id);
556: --
557: -- End of API body
558: --

Line 1120: select count(*) from csc_prof_module_groups

1116: FOR MODULE W/O PROBLEM- to solve this problem this cursor is added*/
1117:
1118: Cursor C3(c_form_function_name varchar2 ,c_party_type varchar2,
1119: c_resp_id number, c_resp_appl_id number ) is
1120: select count(*) from csc_prof_module_groups
1121: where form_function_name=c_form_function_name
1122: and party_type=c_party_type
1123: and responsibility_id = c_resp_id
1124: and resp_appl_id = c_resp_appl_id;

Line 1128: select count(*) from csc_prof_module_groups

1124: and resp_appl_id = c_resp_appl_id;
1125:
1126: Cursor C4(c_form_function_name varchar2 ,c_party_type varchar2,
1127: c_resp_id number, c_resp_appl_id number, c_mod_grp_id number ) is
1128: select count(*) from csc_prof_module_groups
1129: where form_function_name=c_form_function_name
1130: and party_type=c_party_type
1131: and responsibility_id = c_resp_id
1132: and resp_appl_id = c_resp_appl_id

Line 1402: p_api_name =>'CSC_PROF_MODULE_GROUPS_PVT.VALIDATE_SEEDED_FLAG',

1398:
1399: --Validate seeded flag
1400:
1401: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1402: p_api_name =>'CSC_PROF_MODULE_GROUPS_PVT.VALIDATE_SEEDED_FLAG',
1403: p_seeded_flag => p_PROF_MODULE_GRP_rec.seeded_flag,
1404: x_return_status => x_return_status );
1405:
1406: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1457: End CSC_PROF_MODULE_GROUPS_PVT;

1453:
1454:
1455: END Validate_prof_module_groups;
1456:
1457: End CSC_PROF_MODULE_GROUPS_PVT;