[Home] [Help]
8: l_licensed_flag VARCHAR2(1):= 'Y';
9: /* Commenting for bug 6352484
10: Cursor C is
11: Select 'Y'
12: from PA_PRODUCT_FUNCTIONS PF,
13: pa_product_installation_v pi
14: where PF.object_type = p_object_type
15: and PF.object_code = p_object_code
16: and PF.product_code=pi.product_short_code
17: and pi.installed_flag='Y';
18:
19: Cursor C2 is
20: Select 'N'
21: from PA_PRODUCT_FUNCTIONS PF,
22: pa_product_installation_v pi
23: where PF.object_type = p_object_type
24: and PF.object_code = p_object_code
25: and PF.product_code=pi.product_short_code
26: and pi.installed_flag='N';
27: */
28: Cursor CNEW is
29: Select nvl(pi.installed_flag,'Y')
30: from PA_PRODUCT_FUNCTIONS PF,
31: pa_product_installation_v pi
32: where PF.object_type = p_object_type
33: and PF.object_code = p_object_code
34: and PF.product_code=pi.product_short_code;
80: select 'X' from fnd_form_functions
81: where function_name=p_object_code;
82:
83: Cursor valid_project_function is
84: select 'X' from pa_product_functions
85: where object_type = 'FND_FUNCTION'
86: and object_code = p_object_code;
87:
88: Cursor valid_region is
90: where region_code=p_object_code
91: and region_application_id=275;
92:
93: Cursor valid_product_region is
94: select 'X' from pa_product_functions
95: where object_type = 'AK_REGION'
96: and object_code = p_object_code;
97: Begin
98: pa_debug.Init_err_stack ( 'Validate Object');