[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;
1663: -- (PO vs. Req) and the join conditions
1664: --p_doc_subtype
1665: -- Differentiates between the possible subtypes of the main document
1666: -- REQUISITION: NULL
1667: -- PURCHASE ORDER: STANDARD, PLANNED
1668: -- AGREEMENT: CONTRACT, BLANKET
1669: -- RELEASE: SCHEDULED, BLANKET
1670: --p_action
1671: -- Encumbrance action requested on the main document:
1767: -- (PO vs. Req) and the join conditions
1768: --p_doc_subtype
1769: -- Differentiates between the possible subtypes of the main document
1770: -- REQUISITION: NULL
1771: -- PURCHASE ORDER: STANDARD, PLANNED
1772: -- AGREEMENT: CONTRACT, BLANKET
1773: -- RELEASE: SCHEDULED, BLANKET
1774: --p_action
1775: -- Encumbrance action requested on the main document:
2300: (
2301: SELECT EXEC_DOC.req_distribution_id
2302: FROM PO_ENCUMBRANCE_GT EXEC_DOC
2303: WHERE EXEC_DOC.distribution_type
2304: IN (g_dist_type_STANDARD, g_dist_type_BLANKET, g_dist_type_PLANNED)
2305: AND EXEC_DOC.req_distribution_id IS NOT NULL
2306: AND EXEC_DOC.gl_status_code = 'A'
2307: AND EXEC_DOC.send_to_gl_flag = 'Y' --bug 3568512
2308: );
2592: (
2593: SELECT TEMP.line_location_id
2594: FROM PO_ENCUMBRANCE_GT TEMP
2595: WHERE TEMP.gl_status_code = 'A'
2596: AND TEMP.distribution_type IN (g_dist_type_STANDARD, g_dist_type_PLANNED,
2597: g_dist_type_SCHEDULED, g_dist_type_BLANKET)
2598: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
2599: -- this makes sure that there is atleast one distribution that can be reserved
2600: );
3166: WHERE TEMP.gl_status_code = l_affected_gl_status_code
3167: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
3168: AND TEMP.line_location_id = POLL.line_location_id
3169: AND TEMP.distribution_type IN
3170: (g_dist_type_STANDARD, g_dist_type_PLANNED)
3171: );
3172:
3173: IF g_debug_stmt THEN
3174: l_debug_count := SQL%ROWCOUNT;
3201: WHERE TEMP.gl_status_code = l_affected_gl_status_code
3202: AND TEMP.send_to_gl_flag = 'Y' --bug 3568512: use new column
3203: AND TEMP.header_id = POH.po_header_id
3204: AND TEMP.distribution_type IN
3205: (g_dist_type_STANDARD, g_dist_type_PLANNED)
3206: );
3207:
3208: IF g_debug_stmt THEN
3209: l_debug_count := SQL%ROWCOUNT;
4192: -- Indicates wether the document is a main/backing document.
4193: -- p_adjustment_status
4194: -- this could have a value of NEW/OLD
4195: -- p_distribution_type
4196: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4197: --IN OUT:
4198: -- None.
4199: --OUT:
4200: -- None.
4377: -- This function gets the event_type_code given the distribution type and action.
4378: --Parameters:
4379: --IN:
4380: -- p_distribution_type
4381: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4382: -- p_action
4383: -- Indicates the action type. This could be RESERVE/UNRESERVE etc.
4384: --IN OUT:
4385: -- None.
4443: -- This function gets the entity_type_code given the distribution type and action.
4444: --Parameters:
4445: --IN:
4446: -- p_distribution_type
4447: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4448: -- p_action
4449: -- Indicates the action type. This could be RESERVE/UNRESERVE etc.
4450: --IN OUT:
4451: -- None.
4509: -- This procedure derives the document type and subtype given the distribution type.
4510: --Parameters:
4511: --IN:
4512: -- p_distribution_type
4513: -- Indicates the distribution type. e.g STANDARD/AGREEMENT/REQUISITION etc.
4514: --IN OUT:
4515: -- None.
4516: --OUT:
4517: -- x_doc_type
4516: --OUT:
4517: -- x_doc_type
4518: -- Indicates the document type e.g PO/PA/RELEASE etc
4519: -- x_doc_subtype
4520: -- Indicates the document sub type e.g STANDARD/BLANKET/SCHEDULED etc.
4521: --Notes:
4522: --Testing:
4523: --
4524: --End of Comments
4549: l_doc_subtype := 'PURCHASE';
4550: WHEN g_dist_type_BLANKET THEN
4551: l_doc_type := g_doc_type_RELEASE;
4552: l_doc_subtype := g_doc_subtype_BLANKET;
4553: WHEN g_dist_type_STANDARD THEN
4554: l_doc_type := g_doc_type_PO;
4555: l_doc_subtype := g_doc_subtype_STANDARD;
4556: WHEN g_dist_type_SCHEDULED THEN
4557: l_doc_type := g_doc_type_RELEASE;
4551: l_doc_type := g_doc_type_RELEASE;
4552: l_doc_subtype := g_doc_subtype_BLANKET;
4553: WHEN g_dist_type_STANDARD THEN
4554: l_doc_type := g_doc_type_PO;
4555: l_doc_subtype := g_doc_subtype_STANDARD;
4556: WHEN g_dist_type_SCHEDULED THEN
4557: l_doc_type := g_doc_type_RELEASE;
4558: l_doc_subtype := g_doc_subtype_SCHEDULED;
4559: END CASE;