DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_CORE_S

Line 1: PACKAGE BODY PO_CORE_S AS

1: PACKAGE BODY PO_CORE_S AS
2: -- $Header: POXCOC1B.pls 120.42.12020000.5 2013/03/24 05:43:36 zexie ship $
3:
4:
5: -----------------------------------------------------------------------------

Line 13: := 'PO_CORE_S'

9: -- Debugging
10:
11: g_pkg_name CONSTANT
12: VARCHAR2(30)
13: := 'PO_CORE_S'
14: ;
15: g_log_head CONSTANT
16: VARCHAR2(50)
17: := 'po.plsql.' || g_pkg_name || '.'

Line 1213: po_core_s2.get_po_currency (x_object_id,

1209: /* Result should be returned in base currency. Get the currency code
1210: of the PO and the base currency code
1211: */
1212: x_progress := 10;
1213: po_core_s2.get_po_currency (x_object_id,
1214: x_base_currency,
1215: x_po_currency );
1216:
1217: /* Chk if base_currency = po_currency */

Line 1221: po_core_s2.get_currency_info (x_po_currency,

1217: /* Chk if base_currency = po_currency */
1218: if x_base_currency <> x_po_currency then
1219: /* Get precision and minimum accountable unit of the PO CURRENCY */
1220: x_progress := 20;
1221: po_core_s2.get_currency_info (x_po_currency,
1222: x_precision,
1223: x_min_unit );
1224:
1225: /* Get precision and minimum accountable unit of the base CURRENCY */

Line 1227: po_core_s2.get_currency_info (x_base_currency,

1223: x_min_unit );
1224:
1225: /* Get precision and minimum accountable unit of the base CURRENCY */
1226: x_progress := 30;
1227: po_core_s2.get_currency_info (x_base_currency,
1228: x_base_precision,
1229: x_base_min_unit );
1230:
1231:

Line 1469: po_core_s2.get_po_currency (x_object_id,

1465: /* Result should be returned in base currency. Get the currency code
1466: of the PO and the base currency code */
1467:
1468: x_progress := 60;
1469: po_core_s2.get_po_currency (x_object_id,
1470: x_base_currency,
1471: x_po_currency );
1472:
1473: /* Chk if base_currency = po_currency */

Line 1477: po_core_s2.get_currency_info (x_po_currency,

1473: /* Chk if base_currency = po_currency */
1474: if x_base_currency <> x_po_currency then
1475: /* Get precision and minimum accountable unit of the PO CURRENCY */
1476: x_progress := 70;
1477: po_core_s2.get_currency_info (x_po_currency,
1478: x_precision,
1479: x_min_unit );
1480:
1481: /* Get precision and minimum accountable unit of the base CURRENCY */

Line 1483: po_core_s2.get_currency_info (x_base_currency,

1479: x_min_unit );
1480:
1481: /* Get precision and minimum accountable unit of the base CURRENCY */
1482: x_progress := 80;
1483: po_core_s2.get_currency_info (x_base_currency,
1484: x_base_precision,
1485: x_base_min_unit );
1486:
1487: /* iali - Bug 482497 - 05/09/97

Line 1642: po_core_s2.get_req_currency (x_object_id,

1638: PO_MOAC_UTILS_PVT.g_doc_type_REQUISITION
1639: , PO_MOAC_UTILS_PVT.g_doc_level_HEADER
1640: , x_object_id);--bug#5092574
1641:
1642: po_core_s2.get_req_currency (x_object_id,
1643: x_base_currency,
1644: l_org_id);--bug#5092574
1645:
1646: x_progress := 120;

Line 1647: po_core_s2.get_currency_info (x_base_currency,

1643: x_base_currency,
1644: l_org_id);--bug#5092574
1645:
1646: x_progress := 120;
1647: po_core_s2.get_currency_info (x_base_currency,
1648: x_base_precision,
1649: x_base_min_unit );
1650:
1651: if x_base_min_unit is null then

Line 1720: po_core_s2.get_req_currency (x_object_id,

1716: PO_MOAC_UTILS_PVT.g_doc_type_REQUISITION
1717: , PO_MOAC_UTILS_PVT.g_doc_level_LINE
1718: , x_object_id);--bug#5092574
1719:
1720: po_core_s2.get_req_currency (x_object_id,
1721: x_base_currency,
1722: l_org_id);--bug#5092574
1723:
1724: x_progress := 150;

Line 1725: po_core_s2.get_currency_info (x_base_currency,

1721: x_base_currency,
1722: l_org_id);--bug#5092574
1723:
1724: x_progress := 150;
1725: po_core_s2.get_currency_info (x_base_currency,
1726: x_base_precision,
1727: x_base_min_unit );
1728:
1729: if x_base_min_unit is null then

Line 1793: po_core_s2.get_req_currency (x_object_id,

1789: PO_MOAC_UTILS_PVT.g_doc_type_REQUISITION
1790: , PO_MOAC_UTILS_PVT.g_doc_level_DISTRIBUTION
1791: , x_object_id);--bug#5092574
1792:
1793: po_core_s2.get_req_currency (x_object_id,
1794: x_base_currency,
1795: l_org_id);--bug#5092574
1796: x_progress := 164;
1797: po_core_s2.get_currency_info (x_base_currency,

Line 1797: po_core_s2.get_currency_info (x_base_currency,

1793: po_core_s2.get_req_currency (x_object_id,
1794: x_base_currency,
1795: l_org_id);--bug#5092574
1796: x_progress := 164;
1797: po_core_s2.get_currency_info (x_base_currency,
1798: x_base_precision,
1799: x_base_min_unit );
1800:
1801: x_progress := 166;

Line 2073: po_core_s2.get_currency_info (x_po_currency,

2069:
2070: if (x_base_currency <> x_po_currency) then
2071: /* Get precision and minimum accountable unit of the PO CURRENCY */
2072: x_progress := 190;
2073: po_core_s2.get_currency_info (x_po_currency,
2074: x_precision,
2075: x_min_unit );
2076:
2077: /* Get precision and minimum accountable unit of the base CURRENCY */

Line 2079: po_core_s2.get_currency_info (x_base_currency,

2075: x_min_unit );
2076:
2077: /* Get precision and minimum accountable unit of the base CURRENCY */
2078: x_progress := 200;
2079: po_core_s2.get_currency_info (x_base_currency,
2080: x_base_precision,
2081: x_base_min_unit );
2082:
2083: if x_base_min_unit is null then

Line 2449: po_core_s2.get_po_currency (x_object_id=>p_object_id,

2445: IF (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD') then
2446:
2447: --Get the currency code of the PO and the base currency code
2448:
2449: po_core_s2.get_po_currency (x_object_id=>p_object_id,
2450: x_base_currency =>l_base_currency,
2451: x_po_currency =>l_po_currency );
2452: l_progress := '020';
2453: --Get precision and minimum accountable unit of the PO CURRENCY

Line 2454: po_core_s2.get_currency_info (x_currency_code => l_po_currency,

2450: x_base_currency =>l_base_currency,
2451: x_po_currency =>l_po_currency );
2452: l_progress := '020';
2453: --Get precision and minimum accountable unit of the PO CURRENCY
2454: po_core_s2.get_currency_info (x_currency_code => l_po_currency,
2455: x_precision=>l_precision,
2456: x_min_unit=>l_min_unit );
2457: l_progress := '030';
2458: -- Chk if base_currency = po_currency

Line 2464: po_core_s2.get_currency_info (x_currency_code => l_base_currency,

2460:
2461: l_progress := '040';
2462: --Get precision and minimum accountable unit of the base CURRENCY
2463:
2464: po_core_s2.get_currency_info (x_currency_code => l_base_currency,
2465: x_precision=>l_base_precision,
2466: x_min_unit=>l_base_min_unit );
2467:
2468:

Line 2559: po_core_s2.get_po_currency (x_object_id=>p_object_id,

2555: IF p_object_type = 'H' then
2556:
2557: --Get the currency code of the PO and the base currency code
2558:
2559: po_core_s2.get_po_currency (x_object_id=>p_object_id,
2560: x_base_currency =>l_base_currency,
2561: x_po_currency =>l_po_currency );
2562: l_progress := '020';
2563: --Get precision and minimum accountable unit of the PO CURRENCY

Line 2564: po_core_s2.get_currency_info (x_currency_code => l_po_currency,

2560: x_base_currency =>l_base_currency,
2561: x_po_currency =>l_po_currency );
2562: l_progress := '020';
2563: --Get precision and minimum accountable unit of the PO CURRENCY
2564: po_core_s2.get_currency_info (x_currency_code => l_po_currency,
2565: x_precision=>l_precision,
2566: x_min_unit=>l_min_unit );
2567: l_progress := '030';
2568: -- Chk if base_currency = po_currency

Line 2574: po_core_s2.get_currency_info (x_currency_code => l_base_currency,

2570:
2571: l_progress := '040';
2572: --Get precision and minimum accountable unit of the base CURRENCY
2573:
2574: po_core_s2.get_currency_info (x_currency_code => l_base_currency,
2575: x_precision=>l_base_precision,
2576: x_min_unit=>l_base_min_unit );
2577:
2578:

Line 2776: po_core_s2.get_currency_info (l_po_currency,

2772:
2773: if (l_base_currency <> l_po_currency) then
2774: /* Get precision and minimum accountable unit of the PO CURRENCY */
2775: l_progress := '190';
2776: po_core_s2.get_currency_info (l_po_currency,
2777: l_precision,
2778: l_min_unit );
2779:
2780: /* Get precision and minimum accountable unit of the base CURRENCY */

Line 2782: po_core_s2.get_currency_info (l_base_currency,

2778: l_min_unit );
2779:
2780: /* Get precision and minimum accountable unit of the base CURRENCY */
2781: l_progress := '200';
2782: po_core_s2.get_currency_info (l_base_currency,
2783: l_base_precision,
2784: l_base_min_unit );
2785:
2786: if l_base_min_unit is null then

Line 3116: PO_CORE_S2.get_po_currency( p_po_header_id, -- IN

3112: BEGIN
3113:
3114: -- Get the functional currency code for the current org's Set of Books
3115: -- and the currency code defined for the PO
3116: PO_CORE_S2.get_po_currency( p_po_header_id, -- IN
3117: l_base_currency, --OUT
3118: l_po_currency ); --OUT
3119:
3120: -- Get the Precision (never NULL), Extended Precision, Minimum Accountable Unit

Line 3347: PO_CORE_S2.get_po_currency( p_po_header_id, -- IN

3343: After this fix, document reference is retained and hence from header id and from line id will
3344: be populated.Added AND Nvl(poll.consigned_flag,'N') <> 'Y'; to exclude the consigned shipments*/
3345:
3346: -- Get the currency code defined for the PO
3347: PO_CORE_S2.get_po_currency( p_po_header_id, -- IN
3348: l_base_currency, --OUT
3349: l_po_currency ); --OUT
3350:
3351: -- Get the Precision (never NULL), Extended Precision, Minimum Accountable Unit

Line 3452: PO_CORE_S2.get_po_currency ( x_object_id => p_po_header_id,

3448: END IF;
3449:
3450: l_progress := '010';
3451:
3452: PO_CORE_S2.get_po_currency ( x_object_id => p_po_header_id,
3453: x_base_currency => l_base_currency,
3454: x_po_currency => l_po_currency );
3455:
3456: PO_CORE_S2.get_currency_info ( x_currency_code => l_base_currency,

Line 3456: PO_CORE_S2.get_currency_info ( x_currency_code => l_base_currency,

3452: PO_CORE_S2.get_po_currency ( x_object_id => p_po_header_id,
3453: x_base_currency => l_base_currency,
3454: x_po_currency => l_po_currency );
3455:
3456: PO_CORE_S2.get_currency_info ( x_currency_code => l_base_currency,
3457: x_precision => l_base_precision,
3458: x_min_unit => l_base_min_unit );
3459:
3460: PO_CORE_S2.get_currency_info ( x_currency_code => l_po_currency,

Line 3460: PO_CORE_S2.get_currency_info ( x_currency_code => l_po_currency,

3456: PO_CORE_S2.get_currency_info ( x_currency_code => l_base_currency,
3457: x_precision => l_base_precision,
3458: x_min_unit => l_base_min_unit );
3459:
3460: PO_CORE_S2.get_currency_info ( x_currency_code => l_po_currency,
3461: x_precision => l_po_precision,
3462: x_min_unit => l_po_min_unit );
3463:
3464: --Bug# 5391346 START:

Line 7192: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_document_status';

7188: IS
7189:
7190: d_msg VARCHAR2(200);
7191: d_progress NUMBER;
7192: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_document_status';
7193:
7194: l_sep VARCHAR2(8) := ', ';
7195: l_ret_sts VARCHAR2(1);
7196:

Line 7543: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_default_price';

7539: )
7540: IS
7541:
7542: d_progress NUMBER;
7543: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_default_price';
7544: d_msg VARCHAR2(200);
7545:
7546: l_ret_sts VARCHAR2(1) := 'S';
7547: l_ship_to_loc_id HR_LOCATIONS.ship_to_location_id%TYPE;

Line 8413: l_default_dist_option := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,

8409: l_doc_type := g_doc_type_ANY;
8410: END IF;
8411:
8412: d_pos := 20;
8413: l_default_dist_option := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
8414: p_option_column => PO_CORE_S.g_DEFAULT_DISTRIBUTIONS_COL);
8415: IF l_doc_type = g_doc_type_PO -- Document Type is PO
8416: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id) = 'Y' -- PO is CLM Enabled
8417: AND PO_CORE_S.is_encumbrance_on(l_doc_type, p_org_id) -- Encumbrance is On

Line 8414: p_option_column => PO_CORE_S.g_DEFAULT_DISTRIBUTIONS_COL);

8410: END IF;
8411:
8412: d_pos := 20;
8413: l_default_dist_option := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
8414: p_option_column => PO_CORE_S.g_DEFAULT_DISTRIBUTIONS_COL);
8415: IF l_doc_type = g_doc_type_PO -- Document Type is PO
8416: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id) = 'Y' -- PO is CLM Enabled
8417: AND PO_CORE_S.is_encumbrance_on(l_doc_type, p_org_id) -- Encumbrance is On
8418: AND l_default_dist_option = 'N' -- Profile Value for PO:Default Distributions

Line 8417: AND PO_CORE_S.is_encumbrance_on(l_doc_type, p_org_id) -- Encumbrance is On

8413: l_default_dist_option := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
8414: p_option_column => PO_CORE_S.g_DEFAULT_DISTRIBUTIONS_COL);
8415: IF l_doc_type = g_doc_type_PO -- Document Type is PO
8416: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id) = 'Y' -- PO is CLM Enabled
8417: AND PO_CORE_S.is_encumbrance_on(l_doc_type, p_org_id) -- Encumbrance is On
8418: AND l_default_dist_option = 'N' -- Profile Value for PO:Default Distributions
8419: THEN
8420: d_pos := 30;
8421: l_create_default_dist := 'N';

Line 8558: END PO_CORE_S;

8554:
8555: RETURN returnValue;
8556: END fndFunctionTestAsString;
8557:
8558: END PO_CORE_S;