APPS.PA_PAXPRTSK_XMLP_PKG dependencies on FND_PROFILE

Line 36: P_RULE_OPTIMIZER := FND_PROFILE.VALUE('PA_RULE_BASED_OPTIMIZER');

32: ,'Y')
33: INTO P_COSTING
34: FROM
35: DUAL;
36: P_RULE_OPTIMIZER := FND_PROFILE.VALUE('PA_RULE_BASED_OPTIMIZER');
37: IF P_RULE_OPTIMIZER = 'Y' THEN
38: EXECUTE IMMEDIATE
39: 'ALTER SESSION SET OPTIMIZER_GOAL = RULE';
40: END IF;

Line 41: P_DEBUG_MODE := FND_PROFILE.VALUE('PA_DEBUG_MODE');

37: IF P_RULE_OPTIMIZER = 'Y' THEN
38: EXECUTE IMMEDIATE
39: 'ALTER SESSION SET OPTIMIZER_GOAL = RULE';
40: END IF;
41: P_DEBUG_MODE := FND_PROFILE.VALUE('PA_DEBUG_MODE');
42: SELECT
43: NAME,
44: SEGMENT1
45: INTO P_NAME,P_NUMBER