eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CORE_S dependencies on STANDARD

Line 905: -- not changed to meet standards, as that may have impacted calling code.

901: -- SYSDATE.
902: --Notes:
903: -- This procedure was refactored in FPJ to call the more generalized
904: -- procedure get_period_info. However, the parameter names were
905: -- not changed to meet standards, as that may have impacted calling code.
906: --Testing:
907: --
908: --End of Comments
909: -------------------------------------------------------------------------------

Line 1257: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

1253: X_base_precision)),0)
1254: INTO X_result_fld
1255: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1256: WHERE PLL.po_header_id = X_object_id
1257: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1258: AND PLL.line_location_id = POD.line_location_id;
1259:
1260: else
1261: x_progress := 42;

Line 1284: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

1280: * X_min_unit , X_base_precision)),0)
1281: INTO X_result_fld
1282: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1283: WHERE PLL.po_header_id = X_object_id
1284: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1285: AND PLL.line_location_id = POD.line_location_id;
1286:
1287: end if;
1288:

Line 1313: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

1309: / X_base_min_unit ) * X_base_min_unit) ,0)
1310: INTO X_result_fld
1311: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1312: WHERE PLL.po_header_id = X_object_id
1313: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1314: AND PLL.line_location_id = POD.line_location_id;
1315:
1316: else
1317: x_progress := 46;

Line 1339: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

1335: * X_base_min_unit) , 0)
1336: INTO X_result_fld
1337: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1338: WHERE PLL.po_header_id = X_object_id
1339: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1340: AND PLL.line_location_id = POD.line_location_id;
1341:
1342: end if;
1343:

Line 1392: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');

1388: ,x_precision))
1389: INTO x_result_fld
1390: FROM PO_LINE_LOCATIONS_ALL PLL
1391: WHERE PLL.po_header_id = x_object_id
1392: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');
1393:
1394: else
1395: /* Bug 1111926: GMudgal 2/18/2000
1396: ** Incorrect placement of brackets caused incorrect rounding

Line 1418: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');

1414: * x_min_unit)
1415: INTO x_result_fld
1416: FROM PO_LINE_LOCATIONS_ALL PLL
1417: WHERE PLL.po_header_id = x_object_id
1418: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');
1419:
1420: end if;
1421:
1422: end if;

Line 1832: /* 716188 - SVAIDYAN : Changed the sql stmt to select only Standard and Planned

1828: PO_HEADERS_ALL PH
1829: WHERE PH.po_header_id = x_object_id
1830: AND C.currency_code = PH.CURRENCY_CODE;
1831:
1832: /* 716188 - SVAIDYAN : Changed the sql stmt to select only Standard and Planned
1833: POs that reference this contract and also to convert the amount into the
1834: Contract's currency. This is achieved by converting the PO amt first to the
1835: functional currency and then changing this to the Contract currency */
1836:

Line 1880: AND PLL.shipment_type in ('STANDARD','PLANNED')

1876: WHERE PH.po_header_id = x_object_id
1877: AND PH.po_header_id = PL.contract_id --
1878: --AND PH.currency_code = C.currency_code
1879: AND PL.po_line_id = PLL.po_line_id
1880: AND PLL.shipment_type in ('STANDARD','PLANNED')
1881: AND POD.line_location_id(+) = PLL.line_location_id
1882: AND PH1.po_header_id = PL.po_header_id;
1883: else
1884:

Line 1914: AND PLL.shipment_type in ('STANDARD','PLANNED')

1910: WHERE PH.po_header_id = x_object_id
1911: AND PH.po_header_id = PL.contract_id --
1912: --AND PH.currency_code = C.currency_code
1913: AND PL.po_line_id = PLL.po_line_id
1914: AND PLL.shipment_type in ('STANDARD','PLANNED')
1915: AND POD.line_location_id(+) = PLL.line_location_id
1916: AND PH1.po_header_id = PL.po_header_id;
1917: end if;
1918:

Line 2166: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');

2162: ),x_precision))
2163: INTO x_result_fld
2164: FROM PO_LINE_LOCATIONS_ALL PLL
2165: WHERE PLL.po_line_id = x_object_id
2166: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');
2167:
2168: else
2169: x_progress := 234;
2170:

Line 2189: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');

2185: / x_min_unit) * x_min_unit))
2186: INTO x_result_fld
2187: FROM PO_LINE_LOCATIONS_ALL PLL
2188: WHERE PLL.po_line_id = x_object_id
2189: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');
2190:
2191: end if;
2192:
2193: elsif (x_object_type = 'S' ) then /* PO Shipment */

Line 2279: -- Returns total amount for latest archived revision for Standard Purchase order

2275: -- None.
2276: --Locks:
2277: -- None.
2278: --Function:
2279: -- Returns total amount for latest archived revision for Standard Purchase order
2280: --Parameters:
2281: --IN:
2282: -- p_object_id
2283: -- PO header id

Line 2287: -- The lookup code of the document. Valid values are 'STANDARD'

2283: -- PO header id
2284: -- p_doc_type
2285: -- The main doc type for PO. Valid values are 'PO'
2286: -- p_doc_subtype
2287: -- The lookup code of the document. Valid values are 'STANDARD'
2288: -- p_base_cur_result
2289: -- Whether result should be returned in base currency or transaction currency
2290: -- Valid Values are
2291: -- 'Y'- Return result in Base/Functional Currency for the org

Line 2313: IF (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD') then

2309: l_archive_total_amt NUMBER;
2310: l_progress VARCHAR2(3):='000';
2311: BEGIN
2312: l_progress := '010';
2313: IF (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD') then
2314:
2315: --Get the currency code of the PO and the base currency code
2316:
2317: po_core_s2.get_po_currency (x_object_id=>p_object_id,

Line 2372: AND PLL.shipment_type in ('STANDARD')

2368: )
2369: INTO l_archive_total_amt
2370: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2371: WHERE PLL.po_header_id = p_object_id
2372: AND PLL.shipment_type in ('STANDARD')
2373: AND PLL.line_location_id = POD.line_location_id
2374: AND PLL.LATEST_EXTERNAL_FLAG = 'Y'
2375: AND POD.LATEST_EXTERNAL_FLAG = 'Y';
2376:

Line 2378: END if;-- (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD')

2374: AND PLL.LATEST_EXTERNAL_FLAG = 'Y'
2375: AND POD.LATEST_EXTERNAL_FLAG = 'Y';
2376:
2377: l_progress := '060';
2378: END if;-- (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD')
2379: l_progress := '070';
2380: --If l_archive_total_amt has a null value, return 0 as the total.
2381: IF l_archive_total_amt IS NULL THEN
2382: l_archive_total_amt := 0;

Line 2421: IF (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD') then

2417: l_progress VARCHAR2(3):='000';
2418:
2419: BEGIN
2420: l_progress := '010';
2421: IF (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD') then
2422:
2423: IF p_object_type = 'H' then
2424:
2425: --Get the currency code of the PO and the base currency code

Line 2482: AND PLL.shipment_type in ('STANDARD')

2478: )
2479: INTO l_archive_total_amt
2480: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2481: WHERE PLL.po_header_id = p_object_id
2482: AND PLL.shipment_type in ('STANDARD')
2483: AND PLL.line_location_id = POD.line_location_id
2484: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2485: WHERE pll1.line_location_id = pll.line_location_id AND
2486: pll1.revision_num <= p_doc_revision)

Line 2588: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')

2584: ),l_precision))
2585: INTO l_archive_total_amt
2586: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2587: WHERE PLL.po_line_id = p_object_id
2588: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2589: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2590: pll1.line_location_id = pll.line_location_id AND
2591: pll1.revision_num <= p_doc_revision) ;
2592:

Line 2611: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')

2607: / l_min_unit) * l_min_unit))
2608: INTO l_archive_total_amt
2609: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2610: WHERE PLL.po_line_id = p_object_id
2611: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2612: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2613: pll1.line_location_id = pll.line_location_id AND
2614: pll1.revision_num <= p_doc_revision) ;
2615:

Line 2850: END IF;-- (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD')

2846: end if;
2847:
2848:
2849: end if;
2850: END IF;-- (p_doc_type = 'PO') AND (p_doc_subtype = 'STANDARD')
2851:
2852:
2853: l_progress := '250';
2854: --If l_archive_total_amt has a null value, return 0 as the total.

Line 2924: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');

2920: INTO x_result_fld
2921: FROM PO_LINE_LOCATIONS_ALL PLL
2922: WHERE PLL.po_line_id = p_line_id
2923: AND PLL.po_release_id = p_release_id
2924: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');
2925:
2926: else
2927: --
2928: -- For the new Services lines, quantity will be null.

Line 2944: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');

2940: INTO x_result_fld
2941: FROM PO_LINE_LOCATIONS_ALL PLL
2942: WHERE PLL.po_line_id = p_line_id
2943: AND PLL.po_release_id = p_release_id
2944: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED');
2945:
2946: end if;
2947: return(x_result_fld);
2948: END GET_RELEASE_LINE_TOTAL;

Line 2955: That is, sum up the total for all uncancelled Standard PO lines

2951:
2952: FUNCTION: get_ga_amount_released
2953:
2954: DESCRIPTION: Gets the total Amount Released for a particular Global Agreement.
2955: That is, sum up the total for all uncancelled Standard PO lines
2956: which reference that Global Agreement.
2957:
2958: ===================================================================================*/
2959: FUNCTION get_ga_amount_released

Line 3001: -- NOTE: All Standard PO's must have the same currency code as the

2997: l_po_precision, --OUT
2998: l_po_ext_precision, --OUT
2999: l_po_min_unit ); --OUT
3000:
3001: -- NOTE: All Standard PO's must have the same currency code as the
3002: -- Global Agreement that they reference. The currency conversion rate used
3003: -- will be the rate between the Global Agreement's currency and the owning
3004: -- org's currency.
3005:

Line 3191: That is, sum up the total for all uncancelled Standard PO lines

3187:
3188: FUNCTION: get_ga_line_amount_released
3189:
3190: DESCRIPTION: Gets the total Amount Released for a Global Agreement line.
3191: That is, sum up the total for all uncancelled Standard PO lines
3192: which reference that Global Agreement line.
3193:
3194: ===================================================================================*/
3195: PROCEDURE get_ga_line_amount_released

Line 3332: --1. Where clause POLL.shipment_type in ('STANDARD','PLANNED')

3328: x_min_unit => l_po_min_unit );
3329:
3330: --Bug# 5391346 START:
3331: --Added the following to queries below as was coded in the local contract case (refer bug# 716188)
3332: --1. Where clause POLL.shipment_type in ('STANDARD','PLANNED')
3333: --2. Outer Join POD.line_location_id(+) = POLL.line_location_id instead of simple join
3334: --3. Proper rate conversions taking into account different currencies of GCPA and SPOs sourced to it.
3335:
3336:

Line 3412: AND POLL.shipment_type in ('STANDARD','PLANNED')

3408: PO_LINES_ALL POL,
3409: PO_HEADERS_ALL PH1
3410: WHERE POL.contract_id = p_po_header_id
3411: AND POL.po_line_id = POLL.po_line_id
3412: AND POLL.shipment_type in ('STANDARD','PLANNED')
3413: AND POD.line_location_id(+) = POLL.line_location_id
3414: AND PH1.po_header_id = POL.po_header_id;
3415:
3416: ELSE -- (l_po_min_unit is null)

Line 3478: AND POLL.shipment_type in ('STANDARD','PLANNED')

3474: PO_LINES_ALL POL,
3475: PO_HEADERS_ALL PH1
3476: WHERE POL.contract_id = p_po_header_id
3477: AND POL.po_line_id = POLL.po_line_id
3478: AND POLL.shipment_type in ('STANDARD','PLANNED')
3479: AND POD.line_location_id(+) = POLL.line_location_id
3480: AND PH1.po_header_id = POL.po_header_id;
3481: END IF;
3482:

Line 3545: AND POLL.shipment_type in ('STANDARD','PLANNED')

3541: PO_LINES_ALL PoL,
3542: PO_HEADERS_ALL PH1
3543: WHERE POL.contract_id = p_po_header_id
3544: AND POL.po_line_id = POLL.po_line_id
3545: AND POLL.shipment_type in ('STANDARD','PLANNED')
3546: AND POD.line_location_id(+) = POLL.line_location_id
3547: AND PH1.po_header_id = POL.po_header_id;
3548:
3549: ELSE -- (l_po_min_unit IS NULL)

Line 3608: AND POLL.shipment_type in ('STANDARD','PLANNED')

3604: PO_LINES_ALL POL,
3605: PO_HEADERS_ALL PH1
3606: WHERE POL.contract_id = p_po_header_id
3607: AND POL.po_line_id = POLL.po_line_id
3608: AND POLL.shipment_type in ('STANDARD','PLANNED')
3609: AND POD.line_location_id(+) = POLL.line_location_id
3610: AND PH1.po_header_id = POL.po_header_id;
3611:
3612: END IF;

Line 3678: AND POLL.shipment_type in ('STANDARD','PLANNED')

3674: PO_HEADERS_ALL PH1
3675: WHERE PH.po_header_id = p_po_header_id
3676: AND PH.po_header_id = POL.contract_id
3677: AND POL.po_line_id = POLL.po_line_id
3678: AND POLL.shipment_type in ('STANDARD','PLANNED')
3679: AND POD.line_location_id(+) = POLL.line_location_id
3680: AND PH1.po_header_id = POL.po_header_id;
3681:
3682: ELSE -- (l_po_min unit IS NULL)

Line 3745: AND POLL.shipment_type in ('STANDARD','PLANNED')

3741: PO_HEADERS_ALL PH1
3742: WHERE PH.po_header_id = p_po_header_id
3743: AND PH.po_header_id = POL.contract_id --
3744: AND POL.po_line_id = POLL.po_line_id
3745: AND POLL.shipment_type in ('STANDARD','PLANNED')
3746: AND POD.line_location_id(+) = POLL.line_location_id
3747: AND PH1.po_header_id = POL.po_header_id;
3748:
3749: END IF;

Line 5665: -- The lookup code of the document. Valid values are 'STANDARD', 'PLANNED',

5661: -- The doc number whose uniqueness needs to be tested
5662: -- p_org_id
5663: -- The operating unit where the uniqueness needs to be tested
5664: -- p_type_lookup_code
5665: -- The lookup code of the document. Valid values are 'STANDARD', 'PLANNED',
5666: -- 'CONTRACT','BLANKET', 'RFQ', 'QUOTATION'
5667: --Testing:
5668: -- None
5669: --End of Comments

Line 5697: ('STANDARD','CONTRACT','BLANKET','PLANNED')

5693: (SELECT 'po number is not unique'
5694: FROM po_headers_all ph
5695: WHERE ph.segment1 = p_segment1
5696: AND ph.type_lookup_code IN
5697: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5698: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5699:
5700: l_Progress := '020';
5701:

Line 5710: ('STANDARD','CONTRACT','BLANKET','PLANNED')

5706: (SELECT 'po number is not unique'
5707: FROM po_history_pos_all ph
5708: WHERE ph.segment1 = p_segment1
5709: AND ph.type_lookup_code IN
5710: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5711: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5712:
5713: --Get the install status of Sourcing
5714: po_setup_s1.get_sourcing_startup(l_pon_install_status);

Line 5717: if p_Type_lookup_code in ('STANDARD','BLANKET') then

5713: --Get the install status of Sourcing
5714: po_setup_s1.get_sourcing_startup(l_pon_install_status);
5715:
5716: if nvl(l_pon_install_status,'N') ='I' then
5717: if p_Type_lookup_code in ('STANDARD','BLANKET') then
5718: pon_auction_po_pkg.check_unique(p_org_id,p_segment1,l_status);
5719: if l_status = 'SUCCESS' then
5720: l_Unique :=TRUE;
5721: else