[Home] [Help]
82: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE;
83:
84: -- doc subtypes
85:
86: g_doc_subtype_STANDARD CONSTANT
87: PO_HEADERS_ALL.type_lookup_code%TYPE
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
84: -- doc subtypes
85:
86: g_doc_subtype_STANDARD CONSTANT
87: PO_HEADERS_ALL.type_lookup_code%TYPE
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
91: PO_HEADERS_ALL.type_lookup_code%TYPE
92: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
118: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION;
119:
120: -- distribution types
121:
122: g_dist_type_STANDARD CONSTANT
123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
120: -- distribution types
121:
122: g_dist_type_STANDARD CONSTANT
123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
1822: -- (PO vs. Req) and the join conditions
1823: --p_doc_subtype
1824: -- Differentiates between the possible subtypes of the main document
1825: -- REQUISITION: NULL
1826: -- PURCHASE ORDER: STANDARD, PLANNED
1827: -- AGREEMENT: CONTRACT, BLANKET
1828: -- RELEASE: SCHEDULED, BLANKET
1829: --p_action
1830: -- Encumbrance action requested on the main document:
1926: -- (PO vs. Req) and the join conditions
1927: --p_doc_subtype
1928: -- Differentiates between the possible subtypes of the main document
1929: -- REQUISITION: NULL
1930: -- PURCHASE ORDER: STANDARD, PLANNED
1931: -- AGREEMENT: CONTRACT, BLANKET
1932: -- RELEASE: SCHEDULED, BLANKET
1933: --p_action
1934: -- Encumbrance action requested on the main document:
2507: (
2508: SELECT EXEC_DOC.req_distribution_id
2509: FROM PO_ENCUMBRANCE_GT EXEC_DOC
2510: WHERE EXEC_DOC.distribution_type
2511: IN (g_dist_type_STANDARD, g_dist_type_BLANKET, g_dist_type_PLANNED)
2512: AND EXEC_DOC.req_distribution_id IS NOT NULL
2513: AND EXEC_DOC.gl_status_code = 'A'
2514: AND EXEC_DOC.send_to_gl_flag = 'Y' --bug 3568512
2515: ); */
2520: (
2521: SELECT EXEC_DOC.req_distribution_id
2522: FROM PO_ENCUMBRANCE_GT EXEC_DOC
2523: WHERE EXEC_DOC.distribution_type
2524: IN (g_dist_type_STANDARD, g_dist_type_BLANKET, g_dist_type_PLANNED)
2525: AND EXEC_DOC.req_distribution_id IS NOT NULL
2526: AND EXEC_DOC.gl_status_code = 'A'
2527: AND EXEC_DOC.send_to_gl_flag = 'Y' --bug 3568512
2528: AND EXEC_DOC.agreement_dist_id IS NOT NULL
2546: IF (po_partial_funding_pkg.is_CLM_Enabled = 'Y'
2547: AND p_action = g_action_RESERVE) THEN
2548:
2549: IF (p_doc_type = g_doc_type_PO
2550: AND p_doc_subtype = g_doc_subtype_STANDARD) THEN
2551:
2552: l_progress := '076';
2553: IF g_debug_stmt THEN
2554: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on a Standard PO');
2550: AND p_doc_subtype = g_doc_subtype_STANDARD) THEN
2551:
2552: l_progress := '076';
2553: IF g_debug_stmt THEN
2554: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on a Standard PO');
2555: END IF;
2556: -- Update the Encumbered Flag for the Main Document and Set the Change In funded Value to Zero for successful rows
2557: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2558: UPDATE PO_DISTRIBUTIONS_ALL POD
2921: (
2922: SELECT TEMP.line_location_id
2923: FROM PO_ENCUMBRANCE_GT TEMP
2924: WHERE TEMP.gl_status_code = 'A'
2925: AND TEMP.distribution_type IN (g_dist_type_STANDARD, g_dist_type_PLANNED,
2926: g_dist_type_SCHEDULED, g_dist_type_BLANKET)
2927: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
2928: -- this makes sure that there is atleast one distribution that can be reserved
2929: );
3496: WHERE TEMP.gl_status_code = l_affected_gl_status_code
3497: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
3498: AND TEMP.line_location_id = POLL.line_location_id
3499: AND TEMP.distribution_type IN
3500: (g_dist_type_STANDARD, g_dist_type_PLANNED)
3501: );
3502:
3503: IF g_debug_stmt THEN
3504: l_debug_count := SQL%ROWCOUNT;
3531: WHERE TEMP.gl_status_code = l_affected_gl_status_code
3532: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
3533: AND TEMP.header_id = POH.po_header_id
3534: AND TEMP.distribution_type IN
3535: (g_dist_type_STANDARD, g_dist_type_PLANNED)
3536: );
3537:
3538: IF g_debug_stmt THEN
3539: l_debug_count := SQL%ROWCOUNT;
4574: -- Indicates wether the document is a main/backing document.
4575: -- p_adjustment_status
4576: -- this could have a value of NEW/OLD
4577: -- p_distribution_type
4578: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4579: --IN OUT:
4580: -- None.
4581: --OUT:
4582: -- None.
4759: -- This function gets the event_type_code given the distribution type and action.
4760: --Parameters:
4761: --IN:
4762: -- p_distribution_type
4763: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4764: -- p_action
4765: -- Indicates the action type. This could be RESERVE/UNRESERVE etc.
4766: --IN OUT:
4767: -- None.
4825: -- This function gets the entity_type_code given the distribution type and action.
4826: --Parameters:
4827: --IN:
4828: -- p_distribution_type
4829: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4830: -- p_action
4831: -- Indicates the action type. This could be RESERVE/UNRESERVE etc.
4832: --IN OUT:
4833: -- None.
4891: -- This procedure derives the document type and subtype given the distribution type.
4892: --Parameters:
4893: --IN:
4894: -- p_distribution_type
4895: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4896: --IN OUT:
4897: -- None.
4898: --OUT:
4899: -- x_doc_type
4898: --OUT:
4899: -- x_doc_type
4900: -- Indicates the document type e.g PO/PA/RELEASE etc
4901: -- x_doc_subtype
4902: -- Indicates the document sub type e.g STANDARD/BLANKET/SCHEDULED etc.
4903: --Notes:
4904: --Testing:
4905: --
4906: --End of Comments
4931: l_doc_subtype := 'PURCHASE';
4932: WHEN g_dist_type_BLANKET THEN
4933: l_doc_type := g_doc_type_RELEASE;
4934: l_doc_subtype := g_doc_subtype_BLANKET;
4935: WHEN g_dist_type_STANDARD THEN
4936: l_doc_type := g_doc_type_PO;
4937: l_doc_subtype := g_doc_subtype_STANDARD;
4938: WHEN g_dist_type_SCHEDULED THEN
4939: l_doc_type := g_doc_type_RELEASE;
4933: l_doc_type := g_doc_type_RELEASE;
4934: l_doc_subtype := g_doc_subtype_BLANKET;
4935: WHEN g_dist_type_STANDARD THEN
4936: l_doc_type := g_doc_type_PO;
4937: l_doc_subtype := g_doc_subtype_STANDARD;
4938: WHEN g_dist_type_SCHEDULED THEN
4939: l_doc_type := g_doc_type_RELEASE;
4940: l_doc_subtype := g_doc_subtype_SCHEDULED;
4941: END CASE;