[Home] [Help]
1621: FOR rsc IN terr_resource(p_geo_territory_id(x),tran_type.role_code) LOOP
1622:
1623: i := i+1;
1624:
1625: SELECT JTF_TERR_RSC_S.NEXTVAL
1626: INTO l_terr_rsc_id
1627: FROM DUAL;
1628:
1629: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2220: FOR rsc IN terr_resource(p_geo_territory_id(x), pit.role_code) LOOP
2221:
2222: i:=i+1;
2223:
2224: SELECT JTF_TERR_RSC_S.NEXTVAL
2225: INTO l_terr_rsc_id
2226: FROM DUAL;
2227:
2228: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
3283: FOR rsc IN terr_resource(geo_terr.geo_territory_id,tran_type.role_code) LOOP
3284:
3285: i := i+1;
3286:
3287: SELECT JTF_TERR_RSC_S.NEXTVAL
3288: INTO l_terr_rsc_id
3289: FROM DUAL;
3290:
3291: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
4076: FOR rsc IN terr_resource(overlayterr.geo_territory_id, pit.role_code) LOOP
4077:
4078: i:=i+1;
4079:
4080: SELECT JTF_TERR_RSC_S.NEXTVAL
4081: INTO l_terr_rsc_id
4082: FROM DUAL;
4083:
4084: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
5133: /* JRADHAKR changed the parameter from l_terr_group_id to l_terr_group_acct_id */
5134: FOR rsc IN resource_grp(naterr.terr_group_account_id, tran_type.role_code) LOOP
5135: i:=i+1;
5136:
5137: SELECT JTF_TERR_RSC_S.NEXTVAL
5138: INTO l_terr_rsc_id
5139: FROM DUAL;
5140:
5141: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
5514: /* JRADHAKR changed the parameter from l_terr_group_id to l_terr_group_acct_id */
5515: FOR rsc IN resource_grp(naterr.terr_group_account_id, tran_type.role_code) LOOP
5516: i:=i+1;
5517:
5518: SELECT JTF_TERR_RSC_S.NEXTVAL
5519: INTO l_terr_rsc_id
5520: FROM DUAL;
5521:
5522: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
6178: FOR rsc IN resource_grp(overlayterr.terr_group_account_id,pit.role_code) LOOP
6179:
6180: i:=i+1;
6181:
6182: SELECT JTF_TERR_RSC_S.NEXTVAL
6183: INTO l_terr_rsc_id
6184: FROM DUAL;
6185:
6186: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
6759: FOR rsc IN resource_grp( overlayterr.terr_group_account_id , pit.role_code) LOOP
6760:
6761: i:=i+1;
6762:
6763: SELECT JTF_TERR_RSC_S.NEXTVAL
6764: INTO l_terr_rsc_id
6765: FROM DUAL;
6766:
6767: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
7937:
7938: /* The resources for catch ALL territory will be created through a seperate
7939: procedure call in UI : JTF_TTY_GEN_TERR_PVT.create_catchall_terr_rsc.
7940:
7941: SELECT JTF_TERR_RSC_S.NEXTVAL
7942: INTO l_terr_rsc_id
7943: FROM DUAL;
7944:
7945: l_TerrRsc_Tbl(1).terr_id := x_terr_id;
8352: /* JRADHAKR changed the parameter from l_terr_group_id to l_terr_group_acct_id */
8353: FOR rsc IN resource_grp(naterr.terr_group_account_id,tran_type.role_code) LOOP
8354: i:=i+1;
8355:
8356: SELECT JTF_TERR_RSC_S.NEXTVAL
8357: INTO l_terr_rsc_id
8358: FROM DUAL;
8359:
8360: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
8730: /* JRADHAKR changed the parameter from l_terr_group_id to l_terr_group_acct_id */
8731: FOR rsc IN resource_grp(naterr.terr_group_account_id,tran_type.role_code) LOOP
8732: i:=i+1;
8733:
8734: SELECT JTF_TERR_RSC_S.NEXTVAL
8735: INTO l_terr_rsc_id
8736: FROM DUAL;
8737:
8738: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
9577: FOR rsc IN resource_grp(overlayterr.terr_group_account_id,pit.role_code) LOOP
9578:
9579: i:=i+1;
9580:
9581: SELECT JTF_TERR_RSC_S.NEXTVAL
9582: INTO l_terr_rsc_id
9583: FROM DUAL;
9584:
9585: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
10160: FOR rsc IN resource_grp( overlayterr.terr_group_account_id , pit.role_code) LOOP
10161:
10162: i:=i+1;
10163:
10164: SELECT JTF_TERR_RSC_S.NEXTVAL
10165: INTO l_terr_rsc_id
10166: FROM DUAL;
10167:
10168: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
12690: BEGIN
12691:
12692: l_terr_rsc_id := 0;
12693: l_terr_rsc_access_id := 0;
12694: SELECT jtf_terr_rsc_s.NEXTVAL
12695: INTO l_terr_rsc_id
12696: FROM DUAL;
12697:
12698: SELECT terr_id INTO l_catchall_terr_id
12960: FOR rsc IN resource_grp(p_terr_grp_acct_id, role_type.role_code)
12961: LOOP
12962: i:=i+1;
12963:
12964: SELECT JTF_TERR_RSC_S.NEXTVAL
12965: INTO l_terr_rsc_id
12966: FROM DUAL;
12967:
12968: l_TerrRsc_Tbl(i).terr_id := l_terr_id;