DBA Data[Home] [Help]

APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_HEADERS

Line 364: x_po_header_id po_headers_all.po_header_id%type,

360:
361:
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,

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

370: x_line_num po_lines_all.line_num%type)
371: RETURN BOOLEAN
372: IS
373:
374: l_cc_num po_headers.segment1%type; /* cc number */
375: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
376: l_CC_STATE igc_cc_headers.cc_state%type;
377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;

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

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

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

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

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

Line 466: FROM po_headers

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