APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 418: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all

414: -- ***************************************************
415: -- API name : Create_TerrResource
416: -- Type : PUBLIC
417: -- Function : To create Territory Resources - which will insert
418: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all
419: -- tables.
420: --
421: -- Pre-reqs :
422: -- Parameters:

Line 684: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all

680: -- ***************************************************
681: -- API name : Create_TerrResource
682: -- Type : PUBLIC
683: -- Function : To create Territory Resources - which will insert
684: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all
685: -- tables.
686: --
687: -- Pre-reqs :
688: -- Parameters:

Line 1002: From JTF_TERR_RSC_ACCESS_ALL JTRA

998:
999: --Declare cursor to get resource accesses
1000: Cursor C_GetTerrRscAccess IS
1001: Select JTRA.TERR_RSC_ACCESS_ID
1002: From JTF_TERR_RSC_ACCESS_ALL JTRA
1003: Where TERR_RSC_ID = v_TerrRsc_Id
1004: for UPDATE;
1005:
1006: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Terr_Resource';

Line 1129: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all

1125: -- ***************************************************
1126: -- API name : Update_TerrResource
1127: -- Type : PUBLIC
1128: -- Function : To Update Territory Resources - which will update
1129: -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all
1130: -- tables.
1131: --
1132: -- Pre-reqs :
1133: -- Parameters:

Line 2755: From jtf_terr_rsc_access_ALL

2751: TERR_RSC_ID,
2752: ACCESS_TYPE,
2753: TRANS_ACCESS_CODE,
2754: ORG_ID
2755: From jtf_terr_rsc_access_ALL
2756: Where TERR_RSC_ACCESS_ID = l_TerrRsc_Access_id
2757: FOR Update NOWAIT;
2758:
2759: --Local variable declaration

Line 4543: FROM jtf_terr_rsc_access_ALL

4539: last_update_login,
4540: --terr_rsc_id,
4541: access_type,
4542: org_id
4543: FROM jtf_terr_rsc_access_ALL
4544: WHERE terr_rsc_id = lp_terr_rsc_id;
4545:
4546:
4547: BEGIN

Line 4751: FROM JTF_TERR_RSC_ACCESS_ALL

4747: -- cursor to check that Unique Key constraint not violated
4748: CURSOR csr_chk_uk_violation ( lp_terr_rsc_id NUMBER
4749: , lp_access_type VARCHAR2) IS
4750: SELECT 'X'
4751: FROM JTF_TERR_RSC_ACCESS_ALL
4752: WHERE terr_rsc_id = lp_terr_rsc_id
4753: AND access_type = lp_access_type;
4754:
4755: l_return_csr VARCHAR2(1);

Line 4780: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');

4776: /* Debug message */
4777: --arpatel bug#1500581 (part of fix)
4778: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4779: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');
4780: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');
4781: FND_MSG_PUB.ADD;
4782: --END IF;
4783:
4784: END IF; /* c_chk_uk_violation%FOUND */

Line 5032: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(

5028: );
5029:
5030: --ARPATEL: 11/06/2003 BUG#2798581 START
5031: FORALL i IN l_terr_ids_tbl.FIRST..l_terr_ids_tbl.LAST
5032: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(
5033: TERR_RSC_ACCESS_ID,
5034: LAST_UPDATE_DATE,
5035: LAST_UPDATED_BY,
5036: CREATION_DATE,

Line 5054: JTF_TERR_RSC_ACCESS_ALL raa

5050: ntra.terr_rsc_id, -- needs to be the newly created terr_rsc_id from above
5051: raa.access_type,
5052: p_dest_resource_rec.ORG_ID
5053: FROM
5054: JTF_TERR_RSC_ACCESS_ALL raa
5055: ,JTF_TERR_RSC_ALL tra -- use old record to find access_type
5056: ,JTF_TERR_RSC_ALL ntra -- pick up new records from above
5057: WHERE
5058: tra.terr_rsc_id = NVL(raa.terr_rsc_id, tra.terr_rsc_id)

Line 5118: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(

5114: );
5115:
5116: --ARPATEL: 11/06/2003 BUG#2798581 START
5117: FORALL i IN l_terr_ids_tbl.FIRST..l_terr_ids_tbl.LAST
5118: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(
5119: TERR_RSC_ACCESS_ID,
5120: LAST_UPDATE_DATE,
5121: LAST_UPDATED_BY,
5122: CREATION_DATE,

Line 5140: JTF_TERR_RSC_ACCESS_ALL raa

5136: ntra.terr_rsc_id, -- needs to be the newly created terr_rsc_id from above
5137: raa.access_type,
5138: p_dest_resource_rec.ORG_ID
5139: FROM
5140: JTF_TERR_RSC_ACCESS_ALL raa
5141: ,JTF_TERR_RSC_ALL tra -- use old record to find access_type
5142: ,JTF_TERR_RSC_ALL ntra -- pick up new records from above
5143: WHERE
5144: tra.terr_rsc_id = NVL(raa.terr_rsc_id, tra.terr_rsc_id)