[Home] [Help]
13:
14: /* Commenting for bug 6352484
15: Cursor C is
16: Select 'Y'
17: from PA_PRODUCT_FUNCTIONS PF,
18: pa_product_installation_v pi
19: where PF.object_type = p_object_type
20: and PF.object_code = p_object_code
21: and PF.product_code=pi.product_short_code
22: and pi.installed_flag='Y';
23:
24: Cursor C2 is
25: Select 'N'
26: from PA_PRODUCT_FUNCTIONS PF,
27: pa_product_installation_v pi
28: where PF.object_type = p_object_type
29: and PF.object_code = p_object_code
30: and PF.product_code=pi.product_short_code
33: /* Modified CNEW for bug# 8719060 */
34: Cursor CNEW is
35: Select SUM(DECODE(nvl(pi.installed_flag,'Y'),'Y',1,0)) YCnt,
36: SUM(DECODE(nvl(pi.installed_flag,'N'),'N',1,0)) NCnt
37: from PA_PRODUCT_FUNCTIONS PF,
38: pa_product_installation_v pi
39: where PF.object_type = p_object_type
40: and PF.object_code = p_object_code
41: and PF.product_code=pi.product_short_code;
107: select 'X' from fnd_form_functions
108: where function_name=p_object_code;
109:
110: Cursor valid_project_function is
111: select 'X' from pa_product_functions
112: where object_type = 'FND_FUNCTION'
113: and object_code = p_object_code;
114:
115: Cursor valid_region is
117: where region_code=p_object_code
118: and region_application_id=275;
119:
120: Cursor valid_product_region is
121: select 'X' from pa_product_functions
122: where object_type = 'AK_REGION'
123: and object_code = p_object_code;
124: Begin
125: pa_debug.Init_err_stack ( 'Validate Object');