APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_LINE_LOCATIONS

Line 368: x_line_location_id po_line_locations_all.line_location_id%type,

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

Line 371: x_shipment_num po_line_locations_all.shipment_num%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
375:

Line 389: l_shipment_num po_line_locations_all.shipment_num%type;

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

Line 390: l_line_location_id po_line_locations_all.line_location_id%type;

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

Line 419: FROM po_line_locations

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

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

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

Line 431: p_line_location_id po_line_locations.line_location_id%type)

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

Line 812: FROM po_line_locations

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