eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_VALIDATIONS

Source


1 PACKAGE PO_VALIDATIONS AUTHID CURRENT_USER AS
2 -- $Header: PO_VALIDATIONS.pls 120.7.12020000.5 2013/03/23 01:19:03 pla ship $
3 
4 ---------------------------------------------------------------
5 -- Global constants and types.
6 ---------------------------------------------------------------
7 
8 c_result_type_FATAL   CONSTANT VARCHAR2(30) := 'FATAL';
9 c_result_type_FAILURE CONSTANT VARCHAR2(30) := 'FAILURE';
10 c_result_type_WARNING CONSTANT VARCHAR2(30) := 'WARNING';
11 c_result_type_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
12 
13 g_result_type_rank_FATAL NUMBER;
14 g_result_type_rank_SUCCESS NUMBER;
15 
16 c_entity_type_HEADER CONSTANT VARCHAR2(30) := 'HEADER';
17 c_entity_type_LINE CONSTANT VARCHAR2(30) := 'LINE';
18 c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := 'LINE_LOCATION';
19 c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := 'DISTRIBUTION';
20 c_entity_type_PRICE_DIFF CONSTANT VARCHAR2(30) := 'PRICE_DIFFERENTIAL';
21 c_entity_type_GA_ORG_ASSIGN CONSTANT VARCHAR2(30) := 'GA_ORG_ASSIGNMENT';
22 c_entity_type_NOTIF_CTRL CONSTANT VARCHAR2(30) := 'NOTIFICATION_CONTROL';
23 c_entity_type_PRICE_ADJ CONSTANT VARCHAR2(30) := 'PRICE_ADJUSTMENT';
24 --UCA Project - CLMR4 Changes Begin
25 c_entity_type_LINE_UCAS CONSTANT VARCHAR2(30) := 'PO_LINE_UCAS';
26 --UCA Project - CLMR4 Changes End
27 
28 ---------------------------------------------------------------
29 -- Public subroutines.
30 ---------------------------------------------------------------
31 
32 FUNCTION next_result_set_id
33 RETURN NUMBER;
34 
35 FUNCTION result_type_rank(
36   p_result_type IN VARCHAR2
37 )
38 RETURN NUMBER;
39 
40 PROCEDURE delete_result_set_auto(
41   p_result_set_id IN NUMBER
42 );
43 
44 PROCEDURE validate_unit_price_change(
45   p_line_id_tbl   IN PO_TBL_NUMBER
46 , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
47  -- <Bug 13503748 : Encumbrance ER : Parameter p_amount_changed_flag_tbl
48  -- identify if the amount on the distributions of the line has been changed
49 , p_amount_changed_flag_tbl  IN PO_TBL_VARCHAR1
50 , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
51 , x_result_type   OUT NOCOPY VARCHAR2
52 , x_result_set_id IN OUT NOCOPY NUMBER
53 , x_results       IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
54 );
55 
56 PROCEDURE validate_html_order(
57   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL
58 , p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL
59 , p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
60 , p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
61 , p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL
62 , p_price_adjustments     IN PO_PRICE_ADJS_VAL_TYPE DEFAULT NULL --Enhanced Pricing
63 , p_po_line_ucas          IN PO_LINE_UCAS_VAL_TYPE DEFAULT NULL --UCA Project
64 , x_result_type           OUT NOCOPY VARCHAR2
65 , x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
66 );
67 
68 PROCEDURE validate_html_agreement(
69   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL
70 , p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL
71 , p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
72 , p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
73 , p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL
74 , p_ga_org_assignments    IN PO_GA_ORG_ASSIGN_VAL_TYPE DEFAULT NULL
75 , p_notification_controls IN PO_NOTIFICATION_CTRL_VAL_TYPE DEFAULT NULL
76 , p_price_adjustments     IN PO_PRICE_ADJS_VAL_TYPE DEFAULT NULL --Enhanced Pricing
77 , x_result_type           OUT NOCOPY VARCHAR2
78 , x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
79 );
80 
81 PROCEDURE validate_pdoi(
82   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL,
83   p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL,
84   p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL,
85   p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL,
86   p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
87   p_doc_type              IN VARCHAR2 DEFAULT NULL,
88   p_action                IN VARCHAR2 DEFAULT 'CREATE',
89   p_parameter_name_tbl    IN PO_TBL_VARCHAR2000 DEFAULT NULL,
90   p_parameter_value_tbl   IN PO_TBL_VARCHAR2000 DEFAULT NULL,
91   x_result_type           OUT NOCOPY VARCHAR2,
92   x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
93 );
94 
95 PROCEDURE validate_modification_sync( --CLM Modifications project
96   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL
97 , p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL
98 , p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
99 , p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
100 , p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL
101 , p_price_adjustments     IN PO_PRICE_ADJS_VAL_TYPE DEFAULT NULL
102 , p_doc_type              IN VARCHAR2 DEFAULT NULL
103 , p_action                IN VARCHAR2 DEFAULT NULL
104 , x_result_type           OUT NOCOPY VARCHAR2
105 , x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
106 );
107 
108 PROCEDURE log_validation_results_gt(
109   p_module_base   IN VARCHAR2
110 , p_position      IN NUMBER
111 , p_result_set_id IN NUMBER
112 );
113 
114 -- Bug 13503748 : Encumbrance ER
115 PROCEDURE check_encumbered_amount
116 (
117  p_po_header_id   IN  NUMBER,
118  x_return_status  OUT NOCOPY VARCHAR2,
119  x_return_message OUT NOCOPY VARCHAR2
120 );
121 
122 END PO_VALIDATIONS;