APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_OPTIONS

Line 23: CURSOR cur_pa_options

19: ,x_sort_order OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
20: ,x_web_html_call OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21: ) AS
22:
23: CURSOR cur_pa_options
24: IS
25: SELECT option_name, option_function_name,sort_order, FFF.web_html_call
26: FROM PA_OPTIONS PO, FND_FORM_FUNCTIONS FFF
27: WHERE option_code = p_option_code

Line 26: FROM PA_OPTIONS PO, FND_FORM_FUNCTIONS FFF

22:
23: CURSOR cur_pa_options
24: IS
25: SELECT option_name, option_function_name,sort_order, FFF.web_html_call
26: FROM PA_OPTIONS PO, FND_FORM_FUNCTIONS FFF
27: WHERE option_code = p_option_code
28: AND PO.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+);
29: BEGIN
30: OPEN cur_pa_options;

Line 30: OPEN cur_pa_options;

26: FROM PA_OPTIONS PO, FND_FORM_FUNCTIONS FFF
27: WHERE option_code = p_option_code
28: AND PO.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+);
29: BEGIN
30: OPEN cur_pa_options;
31: FETCH cur_pa_options INTO x_option_name, x_function_name, x_sort_order,
32: x_web_html_call;
33: CLOSE cur_pa_options;
34: END GET_OPTION_DETAILS;

Line 31: FETCH cur_pa_options INTO x_option_name, x_function_name, x_sort_order,

27: WHERE option_code = p_option_code
28: AND PO.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+);
29: BEGIN
30: OPEN cur_pa_options;
31: FETCH cur_pa_options INTO x_option_name, x_function_name, x_sort_order,
32: x_web_html_call;
33: CLOSE cur_pa_options;
34: END GET_OPTION_DETAILS;
35:

Line 33: CLOSE cur_pa_options;

29: BEGIN
30: OPEN cur_pa_options;
31: FETCH cur_pa_options INTO x_option_name, x_function_name, x_sort_order,
32: x_web_html_call;
33: CLOSE cur_pa_options;
34: END GET_OPTION_DETAILS;
35:
36: -- API name : GET_PROJ_NUM_OPTION
37: -- Type : Utils API

Line 70: CURSOR cur_pa_options

66: -- p_option_code VARCHAR2;
67:
68: FUNCTION Header_Option( p_option_code VARCHAR2 ) RETURN VARCHAR2 IS
69:
70: CURSOR cur_pa_options
71: IS
72: SELECT 'X'
73: FROM pa_options
74: WHERE parent_option_code = p_option_code;

Line 73: FROM pa_options

69:
70: CURSOR cur_pa_options
71: IS
72: SELECT 'X'
73: FROM pa_options
74: WHERE parent_option_code = p_option_code;
75: l_dummy_char VARCHAR2(1);
76: BEGIN
77: OPEN cur_pa_options;

Line 77: OPEN cur_pa_options;

73: FROM pa_options
74: WHERE parent_option_code = p_option_code;
75: l_dummy_char VARCHAR2(1);
76: BEGIN
77: OPEN cur_pa_options;
78: FETCH cur_pa_options INTO l_dummy_char;
79: IF cur_pa_options%FOUND
80: THEN
81: CLOSE cur_pa_options;

Line 78: FETCH cur_pa_options INTO l_dummy_char;

74: WHERE parent_option_code = p_option_code;
75: l_dummy_char VARCHAR2(1);
76: BEGIN
77: OPEN cur_pa_options;
78: FETCH cur_pa_options INTO l_dummy_char;
79: IF cur_pa_options%FOUND
80: THEN
81: CLOSE cur_pa_options;
82: RETURN 'Y';

Line 79: IF cur_pa_options%FOUND

75: l_dummy_char VARCHAR2(1);
76: BEGIN
77: OPEN cur_pa_options;
78: FETCH cur_pa_options INTO l_dummy_char;
79: IF cur_pa_options%FOUND
80: THEN
81: CLOSE cur_pa_options;
82: RETURN 'Y';
83: ELSE

Line 81: CLOSE cur_pa_options;

77: OPEN cur_pa_options;
78: FETCH cur_pa_options INTO l_dummy_char;
79: IF cur_pa_options%FOUND
80: THEN
81: CLOSE cur_pa_options;
82: RETURN 'Y';
83: ELSE
84: CLOSE cur_pa_options;
85: RETURN 'N';

Line 84: CLOSE cur_pa_options;

80: THEN
81: CLOSE cur_pa_options;
82: RETURN 'Y';
83: ELSE
84: CLOSE cur_pa_options;
85: RETURN 'N';
86: END IF;
87: END Header_Option;
88: