[Home] [Help]
361:
362: FUNCTION DATE_IS_VALID(x_form_name VARCHAR2,
363: x_gl_date gl_period_statuses.start_date%type,
364: x_po_header_id po_headers_all.po_header_id%type,
365: x_po_line_id po_lines_all.po_line_id%type,
366: x_line_location_id po_line_locations_all.line_location_id%type,
367: x_po_distribution_id po_distributions_all.po_distribution_id%type,
368: x_po_dist_num po_distributions_all.distribution_num%type,
369: x_shipment_num po_line_locations_all.shipment_num%type,
366: x_line_location_id po_line_locations_all.line_location_id%type,
367: x_po_distribution_id po_distributions_all.po_distribution_id%type,
368: x_po_dist_num po_distributions_all.distribution_num%type,
369: x_shipment_num po_line_locations_all.shipment_num%type,
370: x_line_num po_lines_all.line_num%type)
371: RETURN BOOLEAN
372: IS
373:
374: l_cc_num po_headers.segment1%type; /* cc number */
411: IS SELECT po_line_id
412: FROM po_lines
413: WHERE po_header_id = p_po_header_id;
414:
415: CURSOR c_get_shipment_num(p_po_line_id po_lines_all.po_line_id%type)
416: IS SELECT line_location_id, shipment_num
417: FROM po_line_locations
418: WHERE po_line_id = p_po_line_id;
419:
424: FROM IGC_CC_HEADERS
425: WHERE CC_NUM = l_cc_num)
426: AND cc_acct_line_num = p_shipment_num;
427:
428: CURSOR c_get_distribution_num(p_po_line_id po_lines_all.po_line_id%type,
429: p_line_location_id po_line_locations.line_location_id%type)
430: IS SELECT distribution_num
431: FROM po_distributions
432: WHERE po_header_id = x_po_header_id