APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_DBI_RES_GRP_VL

Line 7: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales

3:
4: /****************************************************************************
5: This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS
6: and JTF_RS_DBI_DENORM_RES_GROUPS
7: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales
8: Group Hierarchy in DBI product. This program is exclusively built for DBI
9: product and is NOT included in mainline code of ATG Resource Manager.
10:
11: CREATED BY nsinghai 01/16/2003

Line 56: JTF_RS_DBI_RES_GRP_VL for Sales Group Hierarchy (usage : SALES) in DBI

52: ***************************************************************************/
53:
54: /****************************************************************************
55: This is a concurrent program to populate the data that can be accessed via view
56: JTF_RS_DBI_RES_GRP_VL for Sales Group Hierarchy (usage : SALES) in DBI
57: product.
58:
59: This program is exclusively built for DBI product and is NOT included in
60: mainline code of ATG Resource Manager.

Line 86: JTF_RS_DBI_RES_GRP_VL for usage 'FLD_SRV_DISTRICT' (Field Service District

82: END populate_res_grp;
83:
84: /****************************************************************************
85: This is concurrent program to populate the data that can be accessed via view
86: JTF_RS_DBI_RES_GRP_VL for usage 'FLD_SRV_DISTRICT' (Field Service District
87: Hierarchy) in DBI product.
88:
89: This program is exclusively built for DBI product and is NOT included in
90: mainline code of ATG Resource Manager.

Line 117: JTF_RS_DBI_RES_GRP_VL for usage 'SALES' (Sales Group Hierarchy) and

113:
114: /****************************************************************************
115: This is main procedure to populate the data in JTF_RS_DBI_MGR_GROUPS
116: and JTF_RS_DBI_DENORM_RES_GROUPS table so that it can be accessed via view
117: JTF_RS_DBI_RES_GRP_VL for usage 'SALES' (Sales Group Hierarchy) and
118: 'FLD_SRV_DISTRICT' (Field Service District Hierarchy) in DBI product.
119:
120: This program is exclusively built for DBI product and is NOT included in
121: mainline code of ATG Resource Manager.

Line 178: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)

174: p_retcode := '0' ;
175:
176: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
177: IF(BIS_COLLECTION_UTILITIES.Setup(
178: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
179: THEN
180: p_errbuf := FND_MESSAGE.Get;
181: p_retcode := '-1';
182: RAISE_APPLICATION_ERROR(-20000,p_errbuf);

Line 813: FROM jtf_rs_dbi_res_grp_vl

809: SELECT id
810: INTO l_sg_id
811: FROM (
812: SELECT id, rank() over (order by value, id nulls last) rnk
813: FROM jtf_rs_dbi_res_grp_vl
814: WHERE usage = l_usage
815: AND current_id = -1111
816: AND denorm_level = 0
817: )

Line 826: FROM jtf_rs_dbi_res_grp_vl

822: SELECT id
823: INTO l_sg_id
824: FROM (
825: SELECT id, rank() over (order by current_id desc, value, id nulls last) rnk
826: FROM jtf_rs_dbi_res_grp_vl
827: WHERE usage = l_usage
828: AND current_id IN (-1111, -7777)
829: AND denorm_level = 0
830: )