APPS.PO_COMPARE_REVISIONS dependencies on PO_LINES

Line 471: * p_line_id Unique identifier for PO line in PO_LINES table.

467: * PURPOSE
468: * Resolves the source quotation PO line number.
469: *
470: * ARGUMENTS
471: * p_line_id Unique identifier for PO line in PO_LINES table.
472: *
473: * NOTES
474: * Return NULL if no matching records were found.
475: *

Line 482: v_line_num po_lines.line_num%TYPE;

478: ********************************************************************/
479: FUNCTION get_source_quotation_line( p_line_id in number )
480: RETURN VARCHAR2 AS
481:
482: v_line_num po_lines.line_num%TYPE;
483: v_progress varchar2(3);
484:
485: BEGIN
486:

Line 491: FROM po_lines

487: v_progress := '110';
488:
489: SELECT line_num
490: INTO v_line_num
491: FROM po_lines
492: WHERE po_line_id = p_line_id;
493:
494: RETURN v_line_num;
495:

Line 1873: p_line_from in po_lines_archive%ROWTYPE,

1869: * agreed, and amount agreed.
1870: * 08-SEP-97 Rami Haddad Compare closed code
1871: ********************************************************************/
1872: PROCEDURE compare_lines(
1873: p_line_from in po_lines_archive%ROWTYPE,
1874: p_line_to in po_lines_archive%ROWTYPE,
1875: p_sequence IN NUMBER
1876: ) AS
1877:

Line 1874: p_line_to in po_lines_archive%ROWTYPE,

1870: * 08-SEP-97 Rami Haddad Compare closed code
1871: ********************************************************************/
1872: PROCEDURE compare_lines(
1873: p_line_from in po_lines_archive%ROWTYPE,
1874: p_line_to in po_lines_archive%ROWTYPE,
1875: p_sequence IN NUMBER
1876: ) AS
1877:
1878: /*

Line 2620: from po_lines_all

2616: /* Bug 2201739, we should fetch item_id from line level */
2617:
2618: select line_num, item_id
2619: into c_line_num, c_item_id
2620: from po_lines_all
2621: where po_line_id = p_loc_to.po_line_id;
2622:
2623: v_progress := '600';
2624:

Line 3019: from po_lines_all

3015: --get the line number using line id
3016:
3017: select line_num
3018: into c_line_num
3019: from po_lines_all
3020: where po_line_id = p_dist_to.po_line_id;
3021:
3022: --get the shipment number using line location id
3023: