APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_HEADERS

Line 366: x_po_header_id po_headers_all.po_header_id%type,

362:
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,

Line 376: l_cc_num po_headers.segment1%type; /* cc number */

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 */
377: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
378: l_CC_STATE igc_cc_headers.cc_state%type;
379: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
380: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;

Line 393: CURSOR c_acct_line(p_cc_num IN po_headers.segment1%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
395: SELECT CC_acct_LINE_ID
396: FROM IGC_CC_ACCT_LINES
397: WHERE cc_header_id = (SELECT cc_header_id

Line 403: CURSOR for_each_dist_in_po(p_cc_num IN po_headers.segment1%type)

399: WHERE CC_NUM = p_cc_num)
400: AND CC_ACCT_LINE_NUM = x_shipment_num;
401:
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

Line 412: CURSOR c_get_po_line_id(p_po_header_id po_headers_all.po_header_id%type)

408: AND po_line_id = x_po_line_id
409: AND line_location_id = x_line_location_id;
410:
411: -- Cursors for the call from Invoice Gateway
412: CURSOR c_get_po_line_id(p_po_header_id po_headers_all.po_header_id%type)
413: IS SELECT po_line_id
414: FROM po_lines
415: WHERE po_header_id = p_po_header_id;
416:

Line 468: FROM po_headers

464: /* cc number is stored in the segment1 so get it */
465: BEGIN
466: SELECT segment1
467: INTO l_cc_num
468: FROM po_headers
469: WHERE po_header_id = x_po_header_id;
470: EXCEPTION
471: WHEN OTHERS THEN
472: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');