DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on STANDARD

Line 114: g_doc_subtype_STANDARD CONSTANT

110: ;
111:
112:
113: -- doc subtypes
114: g_doc_subtype_STANDARD CONSTANT
115: PO_HEADERS_ALL.type_lookup_code%TYPE
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT

Line 116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD

112:
113: -- doc subtypes
114: g_doc_subtype_STANDARD CONSTANT
115: PO_HEADERS_ALL.type_lookup_code%TYPE
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT
119: PO_HEADERS_ALL.type_lookup_code%TYPE
120: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED

Line 156: g_dist_type_STANDARD CONSTANT

152: ;
153:
154:
155: -- distribution types
156: g_dist_type_STANDARD CONSTANT
157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT

Line 158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD

154:
155: -- distribution types
156: g_dist_type_STANDARD CONSTANT
157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT
161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED

Line 523: -- STANDARD Standard PO

519: -- RELEASE
520: -- MIXED_PO_RELEASE - supported only for Adjust
521: --p_doc_subtype
522: -- The document subtype. Use the g_doc_subtype_<> variables:
523: -- STANDARD Standard PO
524: -- PLANNED Planned PO
525: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
526: -- SCHEDULED Scheduled Release
527: -- MIXED_PO_RELEASE supported only for Adjust

Line 789: IF ( p_doc_subtype IN ( g_doc_subtype_STANDARD,g_doc_subtype_BLANKET

785: PO_DEBUG.debug_var(l_log_head,l_progress,'pa encumbrance'
786: , PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on);
787: END IF;
788:
789: IF ( p_doc_subtype IN ( g_doc_subtype_STANDARD,g_doc_subtype_BLANKET
790: , g_doc_subtype_MIXED_PO_RELEASE)
791: AND PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on
792: )
793: THEN

Line 1490: ( g_dist_type_STANDARD, g_dist_type_PLANNED,

1486: -- A workaround for the warnings, as explained in the bug,
1487: -- is to drop only those distributions that are both approved
1488: -- and have prevent encumbrance flag = 'Y'.
1489: OR ( ENC.distribution_type IN
1490: ( g_dist_type_STANDARD, g_dist_type_PLANNED,
1491: g_dist_type_SCHEDULED, g_dist_type_BLANKET )
1492: AND ENC.approved_flag = 'Y'
1493: AND ( p_action = g_action_REJECT
1494: or

Line 1699: (g_dist_type_STANDARD, g_dist_type_MIXED_PO_RELEASE))

1695: -- (i.e., the org of the PO).
1696:
1697: IF (p_main_or_backing = g_MAIN
1698: AND p_distribution_type IN
1699: (g_dist_type_STANDARD, g_dist_type_MIXED_PO_RELEASE))
1700: THEN
1701:
1702: l_progress := '200';
1703: IF g_debug_stmt THEN

Line 1713: WHERE PO_DIST.distribution_type = g_dist_type_STANDARD

1709: ( SELECT GA_DIST.po_distribution_id
1710: FROM PO_DISTRIBUTIONS GA_DIST
1711: WHERE GA_DIST.po_header_id = PO_DIST.from_header_id
1712: )
1713: WHERE PO_DIST.distribution_type = g_dist_type_STANDARD
1714: AND PO_DIST.prevent_encumbrance_flag = 'N'
1715: ;
1716:
1717: l_progress := '210';

Line 2361: -- STANDARD Standard PO

2357: --p_doc_subtype
2358: -- PO_HEADERS_ALL.type_lookup_code%TYPE
2359: -- PO_RELEASES_ALL.release_type%TYPE
2360: -- The document subtype. g_doc_subtype_<>
2361: -- STANDARD Standard PO
2362: -- PLANNED Planned PO
2363: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
2364: -- SCHEDULED Scheduled Release
2365: --Testing:

Line 2400: ELSIF (p_distribution_type IN (g_dist_type_STANDARD, g_dist_type_PLANNED)) THEN

2396: x_doc_subtype := g_doc_subtype_BLANKET;
2397: ELSIF (p_distribution_type IN (g_dist_type_BLANKET, g_dist_type_SCHEDULED)) THEN
2398: x_doc_type := g_doc_type_RELEASE;
2399: x_doc_subtype := p_distribution_type;
2400: ELSIF (p_distribution_type IN (g_dist_type_STANDARD, g_dist_type_PLANNED)) THEN
2401: x_doc_type := g_doc_type_PO;
2402: x_doc_subtype := p_distribution_type;
2403: --
2404: ELSIF (p_distribution_type = g_dist_type_PREPAYMENT) THEN

Line 2406: x_doc_subtype := g_doc_subtype_STANDARD;

2402: x_doc_subtype := p_distribution_type;
2403: --
2404: ELSIF (p_distribution_type = g_dist_type_PREPAYMENT) THEN
2405: x_doc_type := g_doc_type_PO;
2406: x_doc_subtype := g_doc_subtype_STANDARD;
2407: --
2408: ELSIF (p_distribution_type = g_dist_type_MIXED_PO_RELEASE) THEN
2409: x_doc_type := g_doc_type_MIXED_PO_RELEASE;
2410: x_doc_subtype := g_doc_subtype_MIXED_PO_RELEASE;

Line 2466: -- STANDARD Standard PO

2462: -- PO
2463: -- RELEASE
2464: --p_doc_subtype
2465: -- The document subtype. g_doc_subtype_<>
2466: -- STANDARD Standard PO
2467: -- PLANNED Planned PO
2468: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
2469: -- SCHEDULED Scheduled Release
2470: -- This parameter is not checked for requisitions.

Line 2572: -- STANDARD Standard PO

2568: -- RELEASE
2569: -- MIXED_PO_RELEASE - supported only for Adjust
2570: --p_doc_subtype
2571: -- The document subtype. Use the g_doc_subtype_<> variables:
2572: -- STANDARD Standard PO
2573: -- PLANNED Planned PO
2574: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
2575: -- SCHEDULED Scheduled Release
2576: -- MIXED_PO_RELEASE supported only for Adjust

Line 3477: -- STANDARD Standard PO

3473: -- PO
3474: -- RELEASE
3475: --p_doc_subtype
3476: -- The document subtype. Use the g_doc_subtype_<> variables:
3477: -- STANDARD Standard PO
3478: -- PLANNED Planned PO
3479: -- BLANKET Blanket Release, Blanket Agreement, Global Agreement
3480: -- SCHEDULED Scheduled Release
3481: -- This parameter is not checked for requisitions.

Line 5009: IF (p_doc_subtype = g_doc_subtype_STANDARD) THEN

5005: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Doc type can have backing docs');
5006: END IF;
5007:
5008: --: determine if the Std PO is a Complex Work PO
5009: IF (p_doc_subtype = g_doc_subtype_STANDARD) THEN
5010: -- There should only be 1 main doc per encumbrance trxn in the Standard PO
5011: -- Requester Change Order is the only code that calls encumbrance on multiple docs
5012: -- and they pass the subtype as MIXED_PO_RELEASE.
5013: -- Requester Change Order is not supported for Complex Work POs.

Line 5010: -- There should only be 1 main doc per encumbrance trxn in the Standard PO

5006: END IF;
5007:
5008: --: determine if the Std PO is a Complex Work PO
5009: IF (p_doc_subtype = g_doc_subtype_STANDARD) THEN
5010: -- There should only be 1 main doc per encumbrance trxn in the Standard PO
5011: -- Requester Change Order is the only code that calls encumbrance on multiple docs
5012: -- and they pass the subtype as MIXED_PO_RELEASE.
5013: -- Requester Change Order is not supported for Complex Work POs.
5014:

Line 5164: IF p_doc_subtype IN (g_doc_subtype_BLANKET, g_doc_subtype_STANDARD,

5160: -- and store this in the amt_to_encumber_func column.
5161: -- For BPAs, we need to do this before further calculations
5162: -- since the amount_to_encumber and the unencumbered_amount may
5163: -- be in different currencies, and are compared in later calculations.
5164: IF p_doc_subtype IN (g_doc_subtype_BLANKET, g_doc_subtype_STANDARD,
5165: g_doc_subtype_MIXED_PO_RELEASE)
5166: THEN
5167: round_and_convert_amounts(
5168: p_action => p_action

Line 5689: g_doc_subtype_STANDARD,

5685:
5686:
5687: -- Calculations for Backing Reqs:
5688: IF ( (p_doc_subtype IN (g_doc_subtype_PLANNED,
5689: g_doc_subtype_STANDARD,
5690: g_doc_subtype_MIXED_PO_RELEASE))
5691: OR
5692: (p_doc_type = g_doc_type_RELEASE
5693: AND p_doc_subtype = g_doc_subtype_BLANKET) ) THEN

Line 5694: -- Only PPOs, Standard POs and Blanket Releases have backing Reqs

5690: g_doc_subtype_MIXED_PO_RELEASE))
5691: OR
5692: (p_doc_type = g_doc_type_RELEASE
5693: AND p_doc_subtype = g_doc_subtype_BLANKET) ) THEN
5694: -- Only PPOs, Standard POs and Blanket Releases have backing Reqs
5695:
5696: l_progress := '010';
5697:
5698: IF (p_action <> g_action_CANCEL) THEN

Line 6034: and p_doc_subtype = g_doc_subtype_STANDARD

6030:
6031: /* <> */
6032: -- Update the Funded Value for the Backing Requisitions with Last Implemented Req's Funded Value
6033: IF (po_partial_funding_pkg.is_CLM_Enabled = 'Y'
6034: and p_doc_subtype = g_doc_subtype_STANDARD
6035: and p_action = g_action_RESERVE ) Then
6036:
6037: l_progress := '130';
6038: IF g_debug_stmt THEN

Line 6309: IF (p_doc_subtype = g_doc_subtype_STANDARD ) THEN

6305: -- when the action is reserve for SPO and amount_changed_flag is 'Y' then
6306: -- pre_round_amt should consider the modified amount ordered.
6307: -- when action is cancel it should relieve the extra encumbered amount.
6308:
6309: IF (p_doc_subtype = g_doc_subtype_STANDARD ) THEN
6310:
6311: l_progress := '060';
6312:
6313: -- calling this function as to pass the correct entered amount based on the currency and rounding used.

Line 6427: IF p_doc_subtype IN (g_doc_subtype_STANDARD, g_doc_subtype_BLANKET,

6423: END IF;
6424: End If;
6425: /* <> */
6426:
6427: IF p_doc_subtype IN (g_doc_subtype_STANDARD, g_doc_subtype_BLANKET,
6428: g_doc_subtype_MIXED_PO_RELEASE) THEN
6429: -- only Std POs and Bl Releases can have backing PAs
6430: l_progress := '100';
6431:

Line 8471: AND p_doc_subtype = g_doc_subtype_STANDARD) THEN

8467: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updated Final Amount for Main Document Distributions');
8468: End If;
8469:
8470: IF (p_doc_type = g_doc_type_PO
8471: AND p_doc_subtype = g_doc_subtype_STANDARD) THEN
8472:
8473: UPDATE PO_ENCUMBRANCE_GT BACK_REQ
8474: SET (BACK_REQ.PRE_ROUND_AMT, BACK_REQ.FINAL_AMT) =
8475: (SELECT MAIN_DISTS.PRE_ROUND_AMT, MAIN_DISTS.FINAL_AMT