APPS.FII_AP_INV_ACTIVITY_DETAIL dependencies on FII_PMV_UTIL

Line 67: FII_PMV_UTIL.get_parameters(

63: l_sysdate VARCHAR2(30);
64: BEGIN
65:
66: -- Read the parameters passed
67: FII_PMV_UTIL.get_parameters(
68: p_page_parameter_tbl=>p_page_parameter_tbl,
69: p_as_of_date=>l_as_of_date,
70: p_operating_unit=>l_organization,
71: p_supplier=>l_supplier,

Line 84: FII_PMV_UTIL.get_report_source (

80: p_org_where=>l_org_where,
81: p_supplier_where=>l_sup_where);
82:
83:
84: FII_PMV_UTIL.get_report_source (
85: p_page_parameter_tbl=>p_page_parameter_tbl,
86: p_report_source=>l_report_source);
87:
88: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');

Line 88: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');

84: FII_PMV_UTIL.get_report_source (
85: p_page_parameter_tbl=>p_page_parameter_tbl,
86: p_report_source=>l_report_source);
87:
88: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');
89:
90: --Added for Bug 4309974
91: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
92:

Line 93: FII_PMV_UTIL.get_check_id(p_page_parameter_tbl, l_check_id);

89:
90: --Added for Bug 4309974
91: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
92:
93: FII_PMV_UTIL.get_check_id(p_page_parameter_tbl, l_check_id);
94:
95: --Modified for Bug 4309974
96: -- l_url_1 := 'pFunctionName=FII_AP_INV_ACTIVITY_HISTORY&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
97: l_url_1 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_ACTIVITY_HISTORY&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';

Line 105: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);

101: -- l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_DIST_DETAIL&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
102:
103: l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_LINES_DETAIL&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE_NUM=FII_MEASURE1';
104:
105: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
106: FII_PMV_Util.get_format_mask(l_date_mask);
107: FII_PMV_Util.get_period_strt(p_page_parameter_tbl,
108: l_period_start,
109: l_days_into_period,

Line 106: FII_PMV_Util.get_format_mask(l_date_mask);

102:
103: l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_LINES_DETAIL&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE_NUM=FII_MEASURE1';
104:
105: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
106: FII_PMV_Util.get_format_mask(l_date_mask);
107: FII_PMV_Util.get_period_strt(p_page_parameter_tbl,
108: l_period_start,
109: l_days_into_period,
110: l_cur_period,

Line 107: FII_PMV_Util.get_period_strt(p_page_parameter_tbl,

103: l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_LINES_DETAIL&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE_NUM=FII_MEASURE1';
104:
105: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
106: FII_PMV_Util.get_format_mask(l_date_mask);
107: FII_PMV_Util.get_period_strt(p_page_parameter_tbl,
108: l_period_start,
109: l_days_into_period,
110: l_cur_period,
111: l_id_column );

Line 135: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_curr_suffix, 'payment_amount');

131: | FII_MEASURE18 - Check ID |
132: | FII_MEASURE[21-27] - GrAND Total columns |
133: +--------------------------------------------------------------*/
134:
135: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_curr_suffix, 'payment_amount');
136:
137:
138: If l_curr_suffix = '_prim_g' then
139: l_invoice_amount := 'prim_amount';

Line 2660: FII_PMV_UTIL.bind_variable(

2656:
2657: END CASE;
2658:
2659: -- Attach bind parameters
2660: FII_PMV_UTIL.bind_variable(
2661: p_sqlstmt=>sqlstmt,
2662: p_page_parameter_tbl=>p_page_parameter_tbl,
2663: p_sql_output=>inv_dtl_sql,
2664: p_bind_output_table=>inv_dtl_output,