PACKAGE: APPS.PO_VALIDATIONS

Source

1 PACKAGE PO_VALIDATIONS AS
2 -- $Header: PO_VALIDATIONS.pls 120.3 2005/08/08 17:39:21 jjessup noship $
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 
17 c_entity_type_HEADER CONSTANT VARCHAR2(30) := 'HEADER';
18 c_entity_type_LINE CONSTANT VARCHAR2(30) := 'LINE';
19 c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := 'LINE_LOCATION';
20 c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := 'DISTRIBUTION';
21 c_entity_type_PRICE_DIFF CONSTANT VARCHAR2(30) := 'PRICE_DIFFERENTIAL';
22 c_entity_type_GA_ORG_ASSIGN CONSTANT VARCHAR2(30) := 'GA_ORG_ASSIGNMENT';
23 c_entity_type_NOTIF_CTRL CONSTANT VARCHAR2(30) := 'NOTIFICATION_CONTROL';
24 
25 ---------------------------------------------------------------
26 -- Public subroutines.
27 ---------------------------------------------------------------
28 
29 FUNCTION next_result_set_id
30 RETURN NUMBER;
31 
32 FUNCTION result_type_rank(
33   p_result_type IN VARCHAR2
34 )
35 RETURN NUMBER;
36 
37 PROCEDURE delete_result_set_auto(
38   p_result_set_id IN NUMBER
39 );
40 
41 PROCEDURE validate_unit_price_change(
42   p_line_id_tbl   IN PO_TBL_NUMBER
43 , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
44 , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
45 , x_result_type   OUT NOCOPY VARCHAR2
46 , x_result_set_id IN OUT NOCOPY NUMBER
47 , x_results       IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
48 );
49 
50 PROCEDURE validate_html_order(
51   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL
52 , p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL
53 , p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
54 , p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
55 , p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL
56 , x_result_type           OUT NOCOPY VARCHAR2
57 , x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
58 );
59 
60 PROCEDURE validate_html_agreement(
61   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL
62 , p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL
63 , p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
64 , p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
65 , p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL
66 , p_ga_org_assignments    IN PO_GA_ORG_ASSIGN_VAL_TYPE DEFAULT NULL
67 , p_notification_controls IN PO_NOTIFICATION_CTRL_VAL_TYPE DEFAULT NULL
68 , x_result_type           OUT NOCOPY VARCHAR2
69 , x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
70 );
71 
72 PROCEDURE validate_pdoi(
73   p_headers               IN PO_HEADERS_VAL_TYPE DEFAULT NULL,
74   p_lines                 IN PO_LINES_VAL_TYPE DEFAULT NULL,
75   p_line_locations        IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL,
76   p_distributions         IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL,
77   p_price_differentials   IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
78   p_doc_type              IN VARCHAR2 DEFAULT NULL,
79   p_action                IN VARCHAR2 DEFAULT 'CREATE',
80   p_parameter_name_tbl    IN PO_TBL_VARCHAR2000 DEFAULT NULL,
81   p_parameter_value_tbl   IN PO_TBL_VARCHAR2000 DEFAULT NULL,
82   x_result_type           OUT NOCOPY VARCHAR2,
83   x_results               OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
84 );
85 
86 PROCEDURE log_validation_results_gt(
87   p_module_base   IN VARCHAR2
88 , p_position      IN NUMBER
89 , p_result_set_id IN NUMBER
90 );
91 
92 END PO_VALIDATIONS;