APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_DISTRIBUTIONS

Line 367: x_po_distribution_id po_distributions_all.po_distribution_id%type,

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

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

Line 404: FROM po_distributions

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

Line 431: FROM po_distributions

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

Line 535: * po_distributions*/

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

Line 804: FROM po_distributions

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