APPS.PO_COMMUNICATION_PVT dependencies on PO_COMPLEX_WORK_PVT

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

5672:
5673: IF (p_which_tables = 'MAIN') THEN
5674:
5675: l_adv_amount_query :=
5676: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id) advance_amount, ';
5677:
5678: l_complex_lloc_query :=
5679: ', CURSOR(SELECT del.* FROM po_line_locations_xml del'
5680: || ' WHERE del.po_line_id = plx.po_line_id AND del.payment_type = ''DELIVERY'')'

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

5692:
5693: ELSIF (p_which_tables = 'ARCHIVE') THEN
5694:
5695: l_adv_amount_query :=
5696: 'PO_COMPLEX_WORK_PVT.get_advance_amount(plx.po_line_id, pcgt.revision_num,'
5697: || '''ARCHIVE'') advance_amount, ';
5698:
5699:
5700: l_complex_lloc_query :=

Line 8180: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_po(

8176: IF (p_which_tables = 'MAIN') THEN
8177:
8178: d_progress := 10;
8179:
8180: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_po(
8181: p_po_header_id => p_document_id
8182: );
8183:
8184: d_progress := 15;

Line 8198: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_style(

8194: AND poha.revision_num = p_revision_num;
8195:
8196: d_progress := 25;
8197:
8198: l_is_complex := PO_COMPLEX_WORK_PVT.is_complex_work_style(
8199: p_style_id => l_style_id
8200: );
8201:
8202: d_progress := 30;