[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'
427:
428: --pragma restrict_references (get_total, WNDS);
429:
430: --
431: --FUNCTION to get archive total amount when the document is Standard Purchase order
432: --IF GET_TOTAL is changed, please investigate the impact on this function as well.
433: --Please check package bosy for more detailed comments
434: FUNCTION get_archive_total (p_object_id IN NUMBER,
435: p_doc_type IN VARCHAR2,
439:
440:
441: --
442:
443: --FUNCTION to get archive total amount for a specified revision when the document is Standard Purchase order
444: --IF GET_TOTAL/GET_ARCHIVE_TOTAL is changed, please investigate the impact on this function as well.
445: --Name: GET_ARCHIVE_TOTAL_FOR_ANY_REV
446: --Pre-reqs:
447: -- None
449: -- None.
450: --Locks:
451: -- None.
452: --Function:
453: -- Returns total amount for any specified revision for Standard Purchase order
454: --Parameters:
455: --IN:
456: -- p_object_id
457: -- PO header id
455: --IN:
456: -- p_object_id
457: -- PO header id
458: -- p_object_type
459: -- 'H' for Standard
460: -- 'L' for Standard PO Line
461: -- 'S' for Shipment Line
462: -- 'R' for Release
463: -- p_doc_type
456: -- p_object_id
457: -- PO header id
458: -- p_object_type
459: -- 'H' for Standard
460: -- 'L' for Standard PO Line
461: -- 'S' for Shipment Line
462: -- 'R' for Release
463: -- p_doc_type
464: -- The main doc type for PO. Valid values are 'PO', 'RELEASE'
462: -- 'R' for Release
463: -- p_doc_type
464: -- The main doc type for PO. Valid values are 'PO', 'RELEASE'
465: -- p_doc_subtype
466: -- The lookup code of the document. Valid values are 'STANDARD', 'BLANKET'
467: -- p_doc_revision
468: -- The Revision of the PO header
469: -- p_base_cur_result
470: -- Whether result should be returned in base currency or transaction currency
494:
495: FUNCTION: get_ga_amount_released
496:
497: DESCRIPTION: Gets the total Amount Released for a particular Global Agreement.
498: That is, sum up the total for all uncancelled Standard PO lines
499: which reference that Global Agreement.
500:
501: ===================================================================================*/
502: FUNCTION get_ga_amount_released
511:
512: FUNCTION: get_ga_line_amount_released
513:
514: DESCRIPTION: Gets the total Amount Released for a Global Agreement line.
515: That is, sum up the total for all uncancelled Standard PO lines
516: which reference that Global Agreement line.
517:
518: ===================================================================================*/
519: PROCEDURE get_ga_line_amount_released