PACKAGE: APPS.PO_PDOI_MAINPROC_UTL_PVT

Source

1 PACKAGE PO_PDOI_MAINPROC_UTL_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_MAINPROC_UTL_PVT.pls 120.4 2005/12/05 23:06 jinwang noship $ */
3 
4 PROCEDURE cleanup;
5 
6 FUNCTION get_quotation_class_code
7 (
8   p_doc_subtype IN VARCHAR2
9 ) RETURN VARCHAR2;
10 
11 PROCEDURE default_who_columns(
12   x_last_update_date_tbl       IN OUT NOCOPY PO_TBL_DATE,
13   x_last_updated_by_tbl        IN OUT NOCOPY PO_TBL_NUMBER,
14   x_last_update_login_tbl      IN OUT NOCOPY PO_TBL_NUMBER,
15   x_creation_date_tbl          IN OUT NOCOPY PO_TBL_DATE,
16   x_created_by_tbl             IN OUT NOCOPY PO_TBL_NUMBER,
17   x_request_id_tbl             IN OUT NOCOPY PO_TBL_NUMBER,
18   x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19   x_program_id_tbl             IN OUT NOCOPY PO_TBL_NUMBER,
20   x_program_update_date_tbl    IN OUT NOCOPY PO_TBL_DATE
21 );
22 
23 -- line related utility method
24 PROCEDURE calculate_max_line_num
25 (
26   p_po_header_id_tbl    IN PO_TBL_NUMBER,
27   p_draft_id_tbl        IN PO_TBL_NUMBER
28 );
29 
30 FUNCTION get_next_line_num
31 (
32   p_po_header_id        IN NUMBER
33 ) RETURN NUMBER;
34 
35 FUNCTION get_next_po_line_id
36 RETURN NUMBER;
37 
38 PROCEDURE check_line_num_unique
39 (
40   p_po_header_id_tbl    IN PO_TBL_NUMBER,
41   p_draft_id_tbl        IN PO_TBL_NUMBER,
42   p_intf_line_id_tbl    IN PO_TBL_NUMBER,
43   p_line_num_tbl        IN PO_TBL_NUMBER,
44   x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45 );
46 
47 -- location related utility method
48 PROCEDURE calculate_max_shipment_num
49 (
50   p_po_line_id_tbl      IN PO_TBL_NUMBER,
51   p_draft_id_tbl        IN PO_TBL_NUMBER
52 );
53 
54 FUNCTION get_next_shipment_num
55 (
56   p_po_line_id          IN NUMBER
57 ) RETURN NUMBER;
58 
59 FUNCTION get_next_line_loc_id
60 RETURN NUMBER;
61 
62 PROCEDURE check_shipment_num_unique
63 (
64   p_po_line_id_tbl          IN PO_TBL_NUMBER,
65   p_draft_id_tbl            IN PO_TBL_NUMBER,
66   p_intf_line_loc_id_tbl    IN PO_TBL_NUMBER,
67   p_shipment_num_tbl        IN PO_TBL_NUMBER,
68   x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69 );
70 
71 -- Distribution related utility method
72 PROCEDURE calculate_max_dist_num
73 (
74   p_line_loc_id_tbl      IN PO_TBL_NUMBER,
75   p_draft_id_tbl         IN PO_TBL_NUMBER
76 );
77 
78 FUNCTION get_next_dist_num
79 (
80   p_line_loc_id          IN NUMBER
81 ) RETURN NUMBER;
82 
83 FUNCTION get_next_dist_id
84 RETURN NUMBER;
85 
86 PROCEDURE check_dist_num_unique
87 (
88   p_line_loc_id_tbl     IN PO_TBL_NUMBER,
89   p_draft_id_tbl        IN PO_TBL_NUMBER,
90   p_intf_dist_id_tbl    IN PO_TBL_NUMBER,
91   p_dist_num_tbl        IN PO_TBL_NUMBER,
92   x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93 );
94 
95 -- Price Differential related utility method
96 PROCEDURE calculate_max_price_diff_num
97 (
98   p_entity_type_tbl      IN PO_TBL_VARCHAR30,
99   p_entity_id_tbl        IN PO_TBL_NUMBER,
100   p_draft_id_tbl         IN PO_TBL_NUMBER,
101   p_price_diff_num_tbl   IN PO_TBL_NUMBER
102 );
103 
104 FUNCTION get_next_price_diff_num
105 (
106   p_entity_type IN VARCHAR2,
107   p_entity_id   IN NUMBER
108 )
109 RETURN NUMBER;
110 
111 PROCEDURE check_price_diff_num_unique
112 (
113   p_entity_type_tbl            IN PO_TBL_VARCHAR30,
114   p_entity_id_tbl              IN PO_TBL_NUMBER,
115   p_draft_id_tbl               IN PO_TBL_NUMBER,
116   p_intf_price_diff_id_tbl     IN PO_TBL_NUMBER,
117   p_price_diff_num_tbl         IN PO_TBL_NUMBER,
118   x_price_diff_num_unique_tbl  OUT NOCOPY PO_TBL_VARCHAR1
119 );
120 
121 -- utility method used in item creation
122 FUNCTION get_next_set_process_id
123 RETURN NUMBER;
124 
125 -- utility method to get precision from currency
126 FUNCTION get_currency_precision
127 (
128   p_currency_code         IN VARCHAR2,
129   x_precision_tbl         IN OUT NOCOPY PO_PDOI_TYPES.varchar_index_tbl_type
130 ) RETURN NUMBER;
131 
132 END PO_PDOI_MAINPROC_UTL_PVT;