[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
meaning
FROM
fnd_lookups
WHERE
lookup_type = lkp_type AND
lookup_code = lkp_code;
* non trend reports based on the view by selected *
* PRARAMETERS : *
* p_lkp_code varchar2 IN This is used to get the lookup code *
* p_region_code varchar2 IN This is used to get thr AK region code *
* p_view_by varchar2 IN This is used to get the view by selected *
* RETURN : *
* VARCHAR2 - Graph title *
**********************************************************************************************/
FUNCTION GTTL (p_lkp_code IN varchar2,p_region_code IN varchar2,p_view_by IN varchar2)
return VARCHAR2 IS
l_first VARCHAR2(100);
select ATTRIBUTE_LABEL_LONG
from ak_region_items_vl
where region_code = regioncode
and attribute_code = attributecode;
* PURPOSE : This procedure is used to get the parameters selected in the *
* parameter portlet *
* PRARAMETERS : *
* p_pmv_parameters BIS_PMV_PAGE_PARAMETER_TBL IN This table of records *
* is used to get the *
* paremeters in teh form of *
* (name,id,value) per record *
* x_period_type varchar2 OUT Period type *
* x_site varchar2 OUT Site *
* x_currency_code varchar2 OUT Currency code *
* x_site_area varchar2 OUT Site Area *
* x_page varchar2 OUT Page *
* x_referral varchar2 OUT Referral Category *
* x_prod_cat varchar2 OUT Product Category *
* x_prod varchar2 OUT Product *
* x_cust_class varchar2 OUT Customer Classification *
* x_cust varchar2 OUT Customer *
* x_campaign varchar2 OUT Campaign *
* x_view_by varchar2 OUT View By *
* *
************************************************************************************************/
PROCEDURE GET_PAGE_PARAMETERS(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
x_period_type OUT NOCOPY VARCHAR2,
x_site OUT NOCOPY VARCHAR2,
x_currency_code OUT NOCOPY VARCHAR2,
x_site_area OUT NOCOPY VARCHAR2,
x_page OUT NOCOPY VARCHAR2,
x_referral OUT NOCOPY VARCHAR2,
x_prod_cat OUT NOCOPY VARCHAR2,
x_prod OUT NOCOPY VARCHAR2,
x_cust_class OUT NOCOPY VARCHAR2,
x_cust OUT NOCOPY VARCHAR2,
x_campaign OUT NOCOPY VARCHAR2,
x_view_by OUT NOCOPY VARCHAR2)
AS
l_parameter_name varchar2(1000);