[Home] [Help]
10: --- Used instead of simply writing a RETURN statement,
11: --- as having RETURNs at multiple places in a procedure
12: --- is poor programming style, making maintenance
13: --- of common exit code difficult.
14: --- See /podev/po/internal/standards/logging/logging.xml for more info.
15: G_EARLY_RETURN_EXC EXCEPTION;
16:
17: --- Used in situations where the prereqs for the procedure
18: --- are not satisfied, or the parameters that have been
73:
74:
75: -- Shipment types
76:
77: g_ship_type_STANDARD CONSTANT
78: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
79: := 'STANDARD'
80: ;
81: g_ship_type_PLANNED CONSTANT
75: -- Shipment types
76:
77: g_ship_type_STANDARD CONSTANT
78: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
79: := 'STANDARD'
80: ;
81: g_ship_type_PLANNED CONSTANT
82: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
83: := 'PLANNED'
124:
125:
126: -- Distribution types
127:
128: g_dist_type_STANDARD CONSTANT
129: VARCHAR2(25)
130: := 'STANDARD'
131: ;
132: g_dist_type_PLANNED CONSTANT
126: -- Distribution types
127:
128: g_dist_type_STANDARD CONSTANT
129: VARCHAR2(25)
130: := 'STANDARD'
131: ;
132: g_dist_type_PLANNED CONSTANT
133: VARCHAR2(25)
134: := 'PLANNED'
401:
402: --pragma restrict_references (get_total, WNDS);
403:
404: --
405: --FUNCTION to get archive total amount when the document is Standard Purchase order
406: --IF GET_TOTAL is changed, please investigate the impact on this function as well.
407: --Please check package bosy for more detailed comments
408: FUNCTION get_archive_total (p_object_id IN NUMBER,
409: p_doc_type IN VARCHAR2,
413:
414:
415: --
416:
417: --FUNCTION to get archive total amount for a specified revision when the document is Standard Purchase order
418: --IF GET_TOTAL/GET_ARCHIVE_TOTAL is changed, please investigate the impact on this function as well.
419: --Name: GET_ARCHIVE_TOTAL_FOR_ANY_REV
420: --Pre-reqs:
421: -- None
423: -- None.
424: --Locks:
425: -- None.
426: --Function:
427: -- Returns total amount for any specified revision for Standard Purchase order
428: --Parameters:
429: --IN:
430: -- p_object_id
431: -- PO header id
429: --IN:
430: -- p_object_id
431: -- PO header id
432: -- p_object_type
433: -- 'H' for Standard
434: -- 'L' for Standard PO Line
435: -- 'S' for Shipment Line
436: -- 'R' for Release
437: -- p_doc_type
430: -- p_object_id
431: -- PO header id
432: -- p_object_type
433: -- 'H' for Standard
434: -- 'L' for Standard PO Line
435: -- 'S' for Shipment Line
436: -- 'R' for Release
437: -- p_doc_type
438: -- The main doc type for PO. Valid values are 'PO', 'RELEASE'
436: -- 'R' for Release
437: -- p_doc_type
438: -- The main doc type for PO. Valid values are 'PO', 'RELEASE'
439: -- p_doc_subtype
440: -- The lookup code of the document. Valid values are 'STANDARD', 'BLANKET'
441: -- p_doc_revision
442: -- The Revision of the PO header
443: -- p_base_cur_result
444: -- Whether result should be returned in base currency or transaction currency
468:
469: FUNCTION: get_ga_amount_released
470:
471: DESCRIPTION: Gets the total Amount Released for a particular Global Agreement.
472: That is, sum up the total for all uncancelled Standard PO lines
473: which reference that Global Agreement.
474:
475: ===================================================================================*/
476: FUNCTION get_ga_amount_released
485:
486: FUNCTION: get_ga_line_amount_released
487:
488: DESCRIPTION: Gets the total Amount Released for a Global Agreement line.
489: That is, sum up the total for all uncancelled Standard PO lines
490: which reference that Global Agreement line.
491:
492: ===================================================================================*/
493: PROCEDURE get_ga_line_amount_released