APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_HEADERS_ALL

Line 1290: l_org_id PO_HEADERS_ALL.org_id%type;

1286: d_mod CONSTANT VARCHAR2(100) :=
1287: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForHeader');
1288: d_position NUMBER := 0;
1289: l_return_val NUMBER := 0;
1290: l_org_id PO_HEADERS_ALL.org_id%type;
1291: BEGIN
1292:
1293: IF PO_LOG.d_proc THEN
1294: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1303: FROM po_headers_all poh

1299: d_position := 10;
1300:
1301: SELECT poh.org_id
1302: INTO l_org_id
1303: FROM po_headers_all poh
1304: WHERE poh.po_header_id = p_header_id
1305: ;
1306:
1307: d_position := 20;

Line 1573: l_org_id PO_HEADERS_ALL.org_id%type;

1569: d_mod CONSTANT VARCHAR2(100) :=
1570: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForHeader');
1571: d_position NUMBER := 0;
1572: l_return_val NUMBER := 0;
1573: l_org_id PO_HEADERS_ALL.org_id%type;
1574: BEGIN
1575:
1576: IF PO_LOG.d_proc THEN
1577: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1586: FROM po_headers_all poh

1582: d_position := 10;
1583:
1584: SELECT poh.org_id
1585: INTO l_org_id
1586: FROM po_headers_all poh
1587: WHERE poh.po_header_id = p_header_id
1588: ;
1589:
1590: d_position := 20;

Line 1850: l_org_id PO_HEADERS_ALL.org_id%type;

1846: d_mod CONSTANT VARCHAR2(100) :=
1847: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForHeader');
1848: d_position NUMBER := 0;
1849: l_return_val NUMBER := 0;
1850: l_org_id PO_HEADERS_ALL.org_id%type;
1851: BEGIN
1852:
1853: IF PO_LOG.d_proc THEN
1854: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 1863: FROM po_headers_all poh

1859: d_position := 10;
1860:
1861: SELECT poh.org_id
1862: INTO l_org_id
1863: FROM po_headers_all poh
1864: WHERE poh.po_header_id = p_header_id
1865: ;
1866:
1867: d_position := 20;

Line 2131: l_org_id PO_HEADERS_ALL.org_id%type;

2127: d_mod CONSTANT VARCHAR2(100) :=
2128: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForHeader');
2129: d_position NUMBER := 0;
2130: l_return_val NUMBER := 0;
2131: l_org_id PO_HEADERS_ALL.org_id%type;
2132: BEGIN
2133:
2134: IF PO_LOG.d_proc THEN
2135: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 2144: FROM po_headers_all poh

2140: d_position := 10;
2141:
2142: SELECT poh.org_id
2143: INTO l_org_id
2144: FROM po_headers_all poh
2145: WHERE poh.po_header_id = p_header_id
2146: ;
2147:
2148: d_position := 20;

Line 2262: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;

2258: d_mod CONSTANT VARCHAR2(100) :=
2259: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocQuantityForLine');
2260: d_position NUMBER := 0;
2261: l_return_val NUMBER := 0;
2262: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2263: l_is_complex_work_po BOOLEAN := FALSE;
2264: BEGIN
2265:
2266: IF PO_LOG.d_proc THEN

Line 2369: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;

2365: d_mod CONSTANT VARCHAR2(100) :=
2366: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocAmountForLine');
2367: d_position NUMBER := 0;
2368: l_return_val NUMBER := 0;
2369: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2370: l_is_complex_work_po BOOLEAN := FALSE;
2371: l_precision GL_CURRENCIES.precision%TYPE;
2372: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2373: BEGIN

Line 2721: l_header_id PO_HEADERS_ALL.po_header_id%type;

2717: ) IS
2718: d_mod CONSTANT VARCHAR2(100) :=
2719: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2720: d_position NUMBER := 0;
2721: l_header_id PO_HEADERS_ALL.po_header_id%type;
2722: l_org_id PO_HEADERS_ALL.org_id%type;
2723: l_po_currency PO_HEADERS_ALL.currency_code%type;
2724: BEGIN
2725:

Line 2722: l_org_id PO_HEADERS_ALL.org_id%type;

2718: d_mod CONSTANT VARCHAR2(100) :=
2719: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2720: d_position NUMBER := 0;
2721: l_header_id PO_HEADERS_ALL.po_header_id%type;
2722: l_org_id PO_HEADERS_ALL.org_id%type;
2723: l_po_currency PO_HEADERS_ALL.currency_code%type;
2724: BEGIN
2725:
2726: IF PO_LOG.d_proc THEN

Line 2723: l_po_currency PO_HEADERS_ALL.currency_code%type;

2719: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2720: d_position NUMBER := 0;
2721: l_header_id PO_HEADERS_ALL.po_header_id%type;
2722: l_org_id PO_HEADERS_ALL.org_id%type;
2723: l_po_currency PO_HEADERS_ALL.currency_code%type;
2724: BEGIN
2725:
2726: IF PO_LOG.d_proc THEN
2727: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

Line 2771: FROM po_headers_all poh

2767: END IF;
2768:
2769: SELECT poh.currency_code, poh.org_id
2770: INTO l_po_currency, l_org_id
2771: FROM po_headers_all poh
2772: WHERE poh.po_header_id = l_header_id
2773: ;
2774:
2775: d_position := 70;