APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_LINE_LOCATIONS

Line 366: x_line_location_id po_line_locations_all.line_location_id%type,

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

Line 369: x_shipment_num po_line_locations_all.shipment_num%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
373:

Line 387: l_shipment_num po_line_locations_all.shipment_num%type;

383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
387: l_shipment_num po_line_locations_all.shipment_num%type;
388: l_line_location_id po_line_locations_all.line_location_id%type;
389:
390: -- Cursor to get the account line id value
391: CURSOR c_acct_line(p_cc_num IN po_headers.segment1%type)

Line 388: l_line_location_id po_line_locations_all.line_location_id%type;

384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
387: l_shipment_num po_line_locations_all.shipment_num%type;
388: l_line_location_id po_line_locations_all.line_location_id%type;
389:
390: -- Cursor to get the account line id value
391: CURSOR c_acct_line(p_cc_num IN po_headers.segment1%type)
392: IS

Line 417: FROM po_line_locations

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:
420: CURSOR c_get_cc_acct_line_id(p_shipment_num po_line_locations.shipment_num%type)
421: IS SELECT cc_acct_line_id

Line 420: CURSOR c_get_cc_acct_line_id(p_shipment_num po_line_locations.shipment_num%type)

416: IS SELECT line_location_id, shipment_num
417: FROM po_line_locations
418: WHERE po_line_id = p_po_line_id;
419:
420: CURSOR c_get_cc_acct_line_id(p_shipment_num po_line_locations.shipment_num%type)
421: IS SELECT cc_acct_line_id
422: FROM igc_cc_acct_lines
423: WHERE cc_header_id = (SELECT cc_header_id
424: FROM IGC_CC_HEADERS

Line 429: p_line_location_id po_line_locations.line_location_id%type)

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
433: AND po_line_id = p_po_line_id

Line 810: FROM po_line_locations

806:
807:
808: SELECT shipment_num
809: INTO l_shipment_num
810: FROM po_line_locations
811: WHERE line_location_id = l_line_location_id;
812: EXCEPTION
813: WHEN OTHERS THEN
814: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');