DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_RSC_S

Line 1308: SELECT JTF_TERR_RSC_S.nextval

1304: where terr_id = x_terr_id;
1305:
1306: l_init_msg_list :=FND_API.G_TRUE;
1307:
1308: SELECT JTF_TERR_RSC_S.nextval
1309: into l_terr_rsc_id
1310: FROM DUAL;
1311:
1312: l_TerrRsc_Tbl(1).terr_id := x_terr_id;

Line 1701: SELECT JTF_TERR_RSC_S.nextval

1697: FOR rsc in resource_grp(naterr.terr_group_account_id,tran_type.role_code)
1698: loop
1699: i:=i+1;
1700:
1701: SELECT JTF_TERR_RSC_S.nextval
1702: into l_terr_rsc_id
1703: FROM DUAL;
1704:
1705: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 2095: SELECT JTF_TERR_RSC_S.nextval

2091: FOR rsc in resource_grp(naterr.terr_group_account_id,tran_type.role_code)
2092: loop
2093: i:=i+1;
2094:
2095: SELECT JTF_TERR_RSC_S.nextval
2096: into l_terr_rsc_id
2097: FROM DUAL;
2098:
2099: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 2932: SELECT JTF_TERR_RSC_S.nextval

2928: for rsc in resource_grp(overlayterr.terr_group_account_id,pit.role_code) loop
2929:
2930: i:=i+1;
2931:
2932: SELECT JTF_TERR_RSC_S.nextval
2933: into l_terr_rsc_id
2934: FROM DUAL;
2935:
2936: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 3516: SELECT JTF_TERR_RSC_S.nextval

3512: , pit.role_code) loop
3513:
3514: i:=i+1;
3515:
3516: SELECT JTF_TERR_RSC_S.nextval
3517: into l_terr_rsc_id
3518: FROM DUAL;
3519:
3520: l_TerrRsc_Tbl(i).terr_id := x_terr_id;