APPS.FII_AP_INV_ACTIVITY dependencies on FII_PMV_UTIL

Line 37: FII_PMV_Util.Get_Parameters(

33: l_url_3 VARCHAR2(1000);
34: BEGIN
35:
36: /*getting the parameters values by calling the util package*/
37: FII_PMV_Util.Get_Parameters(
38: p_page_parameter_tbl,
39: l_as_of_date,
40: l_organization,
41: l_supplier,

Line 276: FII_PMV_Util.bind_variable(

272: &ORDER_BY_CLAUSE';
273:
274: /*Section for binding the variables*/
275:
276: FII_PMV_Util.bind_variable(
277: p_sqlstmt=>sqlstmt,
278: p_page_parameter_tbl=>p_page_parameter_tbl,
279: p_sql_output=>inv_act_anal_sql,
280: p_bind_output_table=>inv_act_anal_output,

Line 335: FII_PMV_Util.Get_Parameters(

331:
332: BEGIN
333:
334: /*getting the parameters values FROM the page parameter table*/
335: FII_PMV_Util.Get_Parameters(
336: p_page_parameter_tbl,
337: l_as_of_date,
338: l_organization,
339: l_supplier,

Line 514: FII_PMV_Util.bind_variable(

510: &ORDER_BY_CLAUSE';
511:
512: /*Section for binding the variables*/
513:
514: FII_PMV_Util.bind_variable(
515: p_sqlstmt=>sqlstmt,
516: p_page_parameter_tbl=>p_page_parameter_tbl,
517: p_sql_output=>inv_type_sql,
518: p_bind_output_table=>inv_type_output,

Line 573: FII_PMV_Util.Get_Parameters(

569:
570: BEGIN
571:
572: /*getting the parameters values FROM the page parameter table*/
573: FII_PMV_Util.Get_Parameters(
574: p_page_parameter_tbl,
575: l_as_of_date,
576: l_organization,
577: l_supplier,

Line 799: FII_PMV_Util.bind_variable(

795: &ORDER_BY_CLAUSE';
796:
797: /*Section for binding the variables*/
798:
799: FII_PMV_Util.bind_variable(
800: p_sqlstmt=>sqlstmt,
801: p_page_parameter_tbl=>p_page_parameter_tbl,
802: p_sql_output=>elec_inv_sql,
803: p_bind_output_table=>elec_inv_output,

Line 852: FII_PMV_Util.Get_Parameters(

848:
849: BEGIN
850:
851: /*getting the parameters values FROM the page parameter table*/
852: FII_PMV_Util.Get_Parameters(
853: p_page_parameter_tbl,
854: l_as_of_date,
855: l_organization,
856: l_supplier,

Line 869: l_period_suffix:=FII_PMV_UTIL.get_period_type_suffix(l_period_type);

865: l_org_where,
866: l_supplier_where
867: );
868:
869: l_period_suffix:=FII_PMV_UTIL.get_period_type_suffix(l_period_type);
870:
871: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
872: l_url_1 := 'pFunctionName=FII_AP_HOLD_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
873:

Line 1091: FII_PMV_Util.bind_variable(

1087:
1088: /*Section for binding the variables*/
1089:
1090:
1091: FII_PMV_Util.bind_variable(
1092: p_sqlstmt=>sqlstmt,
1093: p_page_parameter_tbl=>p_page_parameter_tbl,
1094: p_sql_output=>get_hold_sql,
1095: p_bind_output_table=>get_hold_output,

Line 1144: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;

1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1141: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1142: p_bind_output_table.EXTEND;
1143: l_bind_rec.attribute_name := ':SEC_ID';
1144: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
1145: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1146: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1147: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1148: p_bind_output_table.EXTEND;

Line 1309: FII_PMV_Util.Get_Parameters(

1305: l_as_of_date_3 DATE;
1306:
1307:
1308: BEGIN
1309: FII_PMV_Util.Get_Parameters(
1310: p_page_parameter_tbl,
1311: l_as_of_date,
1312: l_organization,
1313: l_supplier,

Line 1334: FII_PMV_Util.get_format_mask(l_date_mask);

1330: l_report_start,
1331: l_cur_effective_num,
1332: l_period_id );
1333:
1334: FII_PMV_Util.get_format_mask(l_date_mask);
1335:
1336: l_as_of_date_2 := to_char(l_as_of_date,'DD/MM/YYYY');
1337: l_as_of_date_3 := to_date(l_as_of_date_2,'DD/MM/YYYY');
1338: