DBA Data[Home] [Help]

APPS.AP_REPORTS_MLS_LANG dependencies on FND_REQUEST_INFO

Line 72: p_vendor_id := to_number(fnd_request_info.get_parameter(1));

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));

Line 73: p_invoice_id := to_number(fnd_request_info.get_parameter(2));

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:

Line 74: p_prepay_id := to_number(fnd_request_info.get_parameter(3));

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

Line 75: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(4));

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))'||

Line 76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));

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,'||

Line 239: p_vendor_type := fnd_request_info.get_parameter(1);

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));

Line 240: p_vendor_id := to_number(fnd_request_info.get_parameter(2));

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));

Line 241: p_pay_group := fnd_request_info.get_parameter(3);

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));

Line 242: p_invoice_type := fnd_request_info.get_parameter(4);

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:

Line 243: p_invoice_id := to_number(fnd_request_info.get_parameter(5));

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

Line 244: p_start_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(6));

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))'||

Line 245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));

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*/

Line 370: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name From',parm_number);

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);

Line 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;

Line 376: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Supplier Name To',parm_number);

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);

Line 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))'||