68: dummy INTEGER;
69:
70: BEGIN
71:
72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));
73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));
74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));
75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));
76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
69:
70: BEGIN
71:
72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));
73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));
74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));
75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));
76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
77:
70: BEGIN
71:
72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));
73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));
74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));
75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));
76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
77:
78: -- Create a query string to get languages based on the parameters
71:
72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));
73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));
74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));
75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));
76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
77:
78: -- Create a query string to get languages based on the parameters
79: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));
73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));
74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));
75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));
76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
77:
78: -- Create a query string to get languages based on the parameters
79: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
80: ' FROM po_vendors pvd,'||
235: dummy INTEGER;
236:
237: BEGIN
238:
239: p_vendor_type := fnd_request_info.get_parameter(1);
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
236:
237: BEGIN
238:
239: p_vendor_type := fnd_request_info.get_parameter(1);
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
237: BEGIN
238:
239: p_vendor_type := fnd_request_info.get_parameter(1);
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
238:
239: p_vendor_type := fnd_request_info.get_parameter(1);
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
246:
239: p_vendor_type := fnd_request_info.get_parameter(1);
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
246:
247: -- Create a query string to get languages based on the parameters
240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
246:
247: -- Create a query string to get languages based on the parameters
248: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
241: p_pay_group := fnd_request_info.get_parameter(3);
242: p_invoice_type := fnd_request_info.get_parameter(4);
243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));
244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));
245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
246:
247: -- Create a query string to get languages based on the parameters
248: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
249: ' FROM ap_suppliers pvd,' || /*Bug 13630276: Changed table from po_vendors*/
366: dummy INTEGER;
367: retval INTEGER;
368: parm_number NUMBER;
369: BEGIN
370: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name From',parm_number);
371: if retval = -1 then
372: P_VENDOR_NAME_FROM := NULL;
373: else
374: P_VENDOR_NAME_FROM := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
370: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name From',parm_number);
371: if retval = -1 then
372: P_VENDOR_NAME_FROM := NULL;
373: else
374: P_VENDOR_NAME_FROM := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
375: end if;
376: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name To',parm_number);
377: if retval = -1 then
378: P_VENDOR_NAME_TO := NULL;
372: P_VENDOR_NAME_FROM := NULL;
373: else
374: P_VENDOR_NAME_FROM := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
375: end if;
376: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name To',parm_number);
377: if retval = -1 then
378: P_VENDOR_NAME_TO := NULL;
379: else
380: P_VENDOR_NAME_TO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
376: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name To',parm_number);
377: if retval = -1 then
378: P_VENDOR_NAME_TO := NULL;
379: else
380: P_VENDOR_NAME_TO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
381: end if;
382:
383: -- Create a query string to get languages based on the parameters
384: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||