APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_HEADERS_ALL

Line 1281: l_org_id PO_HEADERS_ALL.org_id%type;

1277: d_mod CONSTANT VARCHAR2(100) :=
1278: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForHeader');
1279: d_position NUMBER := 0;
1280: l_return_val NUMBER := 0;
1281: l_org_id PO_HEADERS_ALL.org_id%type;
1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1294: FROM po_headers_all poh

1290: d_position := 10;
1291:
1292: SELECT poh.org_id
1293: INTO l_org_id
1294: FROM po_headers_all poh
1295: WHERE poh.po_header_id = p_header_id
1296: ;
1297:
1298: d_position := 20;

Line 1564: l_org_id PO_HEADERS_ALL.org_id%type;

1560: d_mod CONSTANT VARCHAR2(100) :=
1561: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForHeader');
1562: d_position NUMBER := 0;
1563: l_return_val NUMBER := 0;
1564: l_org_id PO_HEADERS_ALL.org_id%type;
1565: BEGIN
1566:
1567: IF PO_LOG.d_proc THEN
1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1577: FROM po_headers_all poh

1573: d_position := 10;
1574:
1575: SELECT poh.org_id
1576: INTO l_org_id
1577: FROM po_headers_all poh
1578: WHERE poh.po_header_id = p_header_id
1579: ;
1580:
1581: d_position := 20;

Line 1841: l_org_id PO_HEADERS_ALL.org_id%type;

1837: d_mod CONSTANT VARCHAR2(100) :=
1838: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForHeader');
1839: d_position NUMBER := 0;
1840: l_return_val NUMBER := 0;
1841: l_org_id PO_HEADERS_ALL.org_id%type;
1842: BEGIN
1843:
1844: IF PO_LOG.d_proc THEN
1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1854: FROM po_headers_all poh

1850: d_position := 10;
1851:
1852: SELECT poh.org_id
1853: INTO l_org_id
1854: FROM po_headers_all poh
1855: WHERE poh.po_header_id = p_header_id
1856: ;
1857:
1858: d_position := 20;

Line 2122: l_org_id PO_HEADERS_ALL.org_id%type;

2118: d_mod CONSTANT VARCHAR2(100) :=
2119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForHeader');
2120: d_position NUMBER := 0;
2121: l_return_val NUMBER := 0;
2122: l_org_id PO_HEADERS_ALL.org_id%type;
2123: BEGIN
2124:
2125: IF PO_LOG.d_proc THEN
2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 2135: FROM po_headers_all poh

2131: d_position := 10;
2132:
2133: SELECT poh.org_id
2134: INTO l_org_id
2135: FROM po_headers_all poh
2136: WHERE poh.po_header_id = p_header_id
2137: ;
2138:
2139: d_position := 20;

Line 2252: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;

2248: d_mod CONSTANT VARCHAR2(100) :=
2249: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocQuantityForLine');
2250: d_position NUMBER := 0;
2251: l_return_val NUMBER := 0;
2252: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2253: l_is_complex_work_po BOOLEAN := FALSE;
2254: BEGIN
2255:
2256: IF PO_LOG.d_proc THEN

Line 2357: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;

2353: d_mod CONSTANT VARCHAR2(100) :=
2354: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocAmountForLine');
2355: d_position NUMBER := 0;
2356: l_return_val NUMBER := 0;
2357: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2358: l_is_complex_work_po BOOLEAN := FALSE;
2359: l_precision GL_CURRENCIES.precision%TYPE;
2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2361: BEGIN

Line 2602: l_header_id PO_HEADERS_ALL.po_header_id%type;

2598: ) IS
2599: d_mod CONSTANT VARCHAR2(100) :=
2600: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2601: d_position NUMBER := 0;
2602: l_header_id PO_HEADERS_ALL.po_header_id%type;
2603: l_org_id PO_HEADERS_ALL.org_id%type;
2604: l_po_currency PO_HEADERS_ALL.currency_code%type;
2605: BEGIN
2606:

Line 2603: l_org_id PO_HEADERS_ALL.org_id%type;

2599: d_mod CONSTANT VARCHAR2(100) :=
2600: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2601: d_position NUMBER := 0;
2602: l_header_id PO_HEADERS_ALL.po_header_id%type;
2603: l_org_id PO_HEADERS_ALL.org_id%type;
2604: l_po_currency PO_HEADERS_ALL.currency_code%type;
2605: BEGIN
2606:
2607: IF PO_LOG.d_proc THEN

Line 2604: l_po_currency PO_HEADERS_ALL.currency_code%type;

2600: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2601: d_position NUMBER := 0;
2602: l_header_id PO_HEADERS_ALL.po_header_id%type;
2603: l_org_id PO_HEADERS_ALL.org_id%type;
2604: l_po_currency PO_HEADERS_ALL.currency_code%type;
2605: BEGIN
2606:
2607: IF PO_LOG.d_proc THEN
2608: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

Line 2652: FROM po_headers_all poh

2648: END IF;
2649:
2650: SELECT poh.currency_code, poh.org_id
2651: INTO l_po_currency, l_org_id
2652: FROM po_headers_all poh
2653: WHERE poh.po_header_id = l_header_id
2654: ;
2655:
2656: d_position := 70;