APPS.AST_UWQ_OPP_ENUMS_PVT dependencies on FND_PROFILE

Line 40: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');

36:
37: /* label, view, and where for main node taken from enum table anyway */
38:
39: l_node_counter := 0;
40: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');
41: l_OrgID := FND_PROFILE.VALUE('ORG_ID');
42:
43:
44: SAVEPOINT start_opp_enumeration;

Line 41: l_OrgID := FND_PROFILE.VALUE('ORG_ID');

37: /* label, view, and where for main node taken from enum table anyway */
38:
39: l_node_counter := 0;
40: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');
41: l_OrgID := FND_PROFILE.VALUE('ORG_ID');
42:
43:
44: SAVEPOINT start_opp_enumeration;
45:

Line 60: l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');

56: where lookup_type = lkp_type
57: and lookup_code = lkp_code;
58:
59: /** check the profile AST_SOURCE_UWQ_OPP. **/
60: l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');
61: IF (l_src_code_select = 'N') THEN
62: l_view_name := 'AST_SALESOPP_UWQ_V';
63: l_ds_name := 'AST_SALESOPP_UWQ_DS';
64: ELSIF (l_src_code_select = 'P') THEN

Line 540: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');

536: /* label, view, and where for main node taken from enum table anyway */
537:
538: l_node_counter := 0;
539:
540: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');
541: l_OrgID := FND_PROFILE.VALUE('ORG_ID');
542:
543: SAVEPOINT start_opp_enumeration;
544:

Line 541: l_OrgID := FND_PROFILE.VALUE('ORG_ID');

537:
538: l_node_counter := 0;
539:
540: l_Access := NVL(FND_PROFILE.VALUE('AS_OPP_ACCESS'), 'T');
541: l_OrgID := FND_PROFILE.VALUE('ORG_ID');
542:
543: SAVEPOINT start_opp_enumeration;
544:
545: Select meaning into l_node_label

Line 551: l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');

547: where lookup_type = lkp_type
548: and lookup_code = lkp_code;
549:
550: /** check the profile AST_SOURCE_UWQ_OPP. **/
551: l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');
552: IF (l_src_code_select = 'N') THEN
553: l_view_name := 'AST_MYTEAM_SALESOPP_UWQ_V';
554: l_ds_name := 'AST_MYTEAM_SALESOPP_UWQ_DS';
555: ELSIF (l_src_code_select = 'P') THEN