APPS.JTF_TERR_CNR_GROUPS_PVT dependencies on JTF_TERR_CNR_GROUPS

Line 1: Package Body JTF_TERR_CNR_GROUPS_PVT AS

1: Package Body JTF_TERR_CNR_GROUPS_PVT AS
2: /* $Header: jtfvcngb.pls 120.0 2005/06/02 18:22:07 appldev ship $ */
3:
4: -- ---------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: JTF_TERR_CNR_GROUPS_PVT

3:
4: -- ---------------------------------------------------
5: -- Start of Comments
6: -- ---------------------------------------------------
7: -- PACKAGE NAME: JTF_TERR_CNR_GROUPS_PVT
8: -- ---------------------------------------------------
9: -- PURPOSE
10: -- Joint task force core territory resource private api's.
11: -- This package is a private API for inserting CNR groups

Line 35: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_CNR_GROUPS_PVT';

31:
32: -- ***************************************************
33: -- GLOBAL VARIABLES
34: -- ***************************************************
35: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_CNR_GROUPS_PVT';
36: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftrcng.pls';
37:
38:
39:

Line 138: JTF_TERR_CNR_GROUPS_PKG.Insert_Row(

134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136: END IF;
137:
138: JTF_TERR_CNR_GROUPS_PKG.Insert_Row(
139: x_rowid => l_rowid,
140: x_CNR_GROUP_ID => l_terr_cnr_group_Id,
141: x_LAST_UPDATED_BY => p_Terr_cnr_group_rec.LAST_UPDATED_BY,
142: x_LAST_UPDATE_DATE => p_Terr_cnr_group_rec.LAST_UPDATE_DATE,

Line 321: JTF_TERR_CNR_GROUPS_PKG.Delete_Row(

317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: END IF;
320:
321: JTF_TERR_CNR_GROUPS_PKG.Delete_Row(
322: x_CNR_GROUP_ID => p_Terr_cnr_group_rec.cnr_group_id
323: );
324:
325: delete

Line 474: JTF_TERR_CNR_GROUPS_PKG.Update_Row(

470: END IF;
471:
472: --dbms_output.put_line('before update_row call' );
473:
474: JTF_TERR_CNR_GROUPS_PKG.Update_Row(
475: x_Rowid => l_rowid,
476: x_CNR_GROUP_ID => l_terr_cnr_group_Id,
477: x_LAST_UPDATED_BY => p_Terr_cnr_group_rec.LAST_UPDATED_BY,
478: x_LAST_UPDATE_DATE => p_Terr_cnr_group_rec.LAST_UPDATE_DATE,

Line 584: from JTF_TERR_CNR_GROUPS jtcg

580: l_cnr_qual_defined NUMBER;
581:
582: CURSOR c_cnrgroupname IS
583: select 1
584: from JTF_TERR_CNR_GROUPS jtcg
585: where jtcg.NAME = p_Terr_cnr_group_rec.NAME
586: and rownum < 2;
587:
588: CURSOR c_cnrgroupid IS

Line 596: from JTF_TERR_CNR_GROUPS jtcg

592: and rownum < 2;
593:
594: CURSOR c_cnrgroupname_update IS
595: select 1
596: from JTF_TERR_CNR_GROUPS jtcg
597: where jtcg.NAME = p_Terr_cnr_group_rec.NAME
598: and jtcg.CNR_GROUP_ID <> p_Terr_cnr_group_rec.CNR_GROUP_ID
599: and rownum < 2;
600:

Line 1173: END JTF_TERR_CNR_GROUPS_PVT;

1169: --
1170: End Update_Terr_Cnr_Value;
1171:
1172:
1173: END JTF_TERR_CNR_GROUPS_PVT;