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