APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINES_ALL

Line 222: FROM po_lines_all pol

218: nvl2(l_mau
219: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
220: , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
221: INTO l_return_val
222: FROM po_lines_all pol
223: WHERE pol.po_header_id = p_doc_level_id
224: ;
225:
226: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 273: FROM po_lines_all pol

269: nvl2(l_mau
270: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
271: , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
272: INTO l_return_val
273: FROM po_lines_all pol
274: WHERE pol.po_line_id = p_doc_level_id
275: ;
276:
277: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 1140: l_org_id PO_LINES_ALL.org_id%type;

1136: d_mod CONSTANT VARCHAR2(100) :=
1137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForLine');
1138: d_position NUMBER := 0;
1139: l_return_val NUMBER := 0;
1140: l_org_id PO_LINES_ALL.org_id%type;
1141: BEGIN
1142:
1143: IF PO_LOG.d_proc THEN
1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1153: FROM po_lines_all pol

1149: d_position := 10;
1150:
1151: SELECT pol.org_id
1152: INTO l_org_id
1153: FROM po_lines_all pol
1154: WHERE pol.po_line_id = p_line_id;
1155:
1156: d_position := 20;
1157: IF PO_LOG.d_stmt THEN

Line 1423: l_org_id PO_LINES_ALL.org_id%type;

1419: d_mod CONSTANT VARCHAR2(100) :=
1420: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForLine');
1421: d_position NUMBER := 0;
1422: l_return_val NUMBER := 0;
1423: l_org_id PO_LINES_ALL.org_id%type;
1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1436: FROM po_lines_all pol

1432: d_position := 10;
1433:
1434: SELECT pol.org_id
1435: INTO l_org_id
1436: FROM po_lines_all pol
1437: WHERE pol.po_line_id = p_line_id;
1438:
1439: d_position := 20;
1440: IF PO_LOG.d_stmt THEN

Line 1703: l_org_id PO_LINES_ALL.org_id%type;

1699: d_mod CONSTANT VARCHAR2(100) :=
1700: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForLine');
1701: d_position NUMBER := 0;
1702: l_return_val NUMBER := 0;
1703: l_org_id PO_LINES_ALL.org_id%type;
1704: BEGIN
1705:
1706: IF PO_LOG.d_proc THEN
1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1716: FROM po_lines_all pol

1712: d_position := 10;
1713:
1714: SELECT pol.org_id
1715: INTO l_org_id
1716: FROM po_lines_all pol
1717: WHERE pol.po_line_id = p_line_id;
1718:
1719: d_position := 20;
1720: IF PO_LOG.d_stmt THEN

Line 1981: l_org_id PO_LINES_ALL.org_id%type;

1977: d_mod CONSTANT VARCHAR2(100) :=
1978: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForLine');
1979: d_position NUMBER := 0;
1980: l_return_val NUMBER := 0;
1981: l_org_id PO_LINES_ALL.org_id%type;
1982: BEGIN
1983:
1984: IF PO_LOG.d_proc THEN
1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1994: FROM po_lines_all pol

1990: d_position := 10;
1991:
1992: SELECT pol.org_id
1993: INTO l_org_id
1994: FROM po_lines_all pol
1995: WHERE pol.po_line_id = p_line_id;
1996:
1997: d_position := 20;
1998: IF PO_LOG.d_stmt THEN

Line 2264: FROM po_lines_all pol

2260: d_position := 10;
2261:
2262: SELECT pol.po_header_id
2263: INTO l_header_id
2264: FROM po_lines_all pol
2265: WHERE pol.po_line_id = p_line_id
2266: ;
2267:
2268: d_position := 20;

Line 2305: FROM po_lines_all pol

2301: d_position := 40;
2302:
2303: SELECT nvl(pol.quantity, 0)
2304: INTO l_return_val
2305: FROM po_lines_all pol
2306: WHERE pol.po_line_id = p_line_id
2307: ;
2308:
2309: END IF;

Line 2624: FROM po_lines_all pol

2620:
2621: d_position := 30;
2622: SELECT pol.po_header_id
2623: INTO l_header_id
2624: FROM po_lines_all pol
2625: WHERE pol.po_line_id = p_doc_level_id;
2626:
2627: ELSIF p_doc_level = g_doc_level_SHIPMENT THEN
2628: