APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_DISTRIBUTIONS

Line 369: x_po_distribution_id po_distributions_all.po_distribution_id%type,

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,
372: x_line_num po_lines_all.line_num%type)
373: RETURN BOOLEAN

Line 370: x_po_dist_num po_distributions_all.distribution_num%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,
372: x_line_num po_lines_all.line_num%type)
373: RETURN BOOLEAN
374: IS

Line 406: FROM po_distributions

402: -- Cursor to get the distribution numbers of all the distributions for the CC
403: CURSOR for_each_dist_in_po(p_cc_num IN po_headers.segment1%type)
404: IS
405: SELECT distribution_num
406: FROM po_distributions
407: WHERE po_header_id = x_po_header_id
408: AND po_line_id = x_po_line_id
409: AND line_location_id = x_line_location_id;
410:

Line 433: FROM po_distributions

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
435: AND po_line_id = p_po_line_id
436: AND line_location_id = p_line_location_id;
437:

Line 537: * po_distributions*/

533: FOR c_for_each_dist_in_po1 IN for_each_dist_in_po(l_cc_num)
534: LOOP
535: /*Loop and get the pf date of only those Payment Forecast lines which
536: * have corresponding distribution line in
537: * po_distributions*/
538: BEGIN
539: SELECT CC_DET_PF_DATE
540: INTO l_cc_det_pf_date
541: FROM IGC_CC_DET_PF

Line 806: FROM po_distributions

802: IF x_shipment_num IS NULL THEN
803: BEGIN
804: SELECT line_location_id
805: INTO l_line_location_id
806: FROM po_distributions
807: WHERE po_distribution_id = x_po_distribution_id;
808:
809:
810: SELECT shipment_num