DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_COMPLEX_WORK_PVT

Line 4836: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id) advance_amount, ';

4832:
4833: IF (p_which_tables = 'MAIN') THEN
4834:
4835: l_adv_amount_query :=
4836: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id) advance_amount, ';
4837:
4838: l_complex_lloc_query :=
4839: ', CURSOR(SELECT del.* FROM po_line_locations_xml del'
4840: || ' WHERE del.po_line_id = plx.po_line_id AND del.payment_type = ''DELIVERY'')'

Line 4856: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id, pcgt.revision_num,'

4852:
4853: ELSIF (p_which_tables = 'ARCHIVE') THEN
4854:
4855: l_adv_amount_query :=
4856: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id, pcgt.revision_num,'
4857: || '''ARCHIVE'') advance_amount, ';
4858:
4859:
4860: l_complex_lloc_query :=

Line 6985: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_po(

6981: IF (p_which_tables = 'MAIN') THEN
6982:
6983: d_progress := 10;
6984:
6985: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_po(
6986: p_po_header_id => p_document_id
6987: );
6988:
6989: d_progress := 15;

Line 7003: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_style(

6999: AND poha.revision_num = p_revision_num;
7000:
7001: d_progress := 25;
7002:
7003: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_style(
7004: p_style_id => l_style_id
7005: );
7006:
7007: d_progress := 30;