[Home] [Help]
PACKAGE: APPS.PO_CLM_CAR_UTIL
Source
1 PACKAGE PO_CLM_CAR_UTIL AUTHID CURRENT_USER AS
2 /*$Header: POCARUTS.pls 120.4.12020000.2 2013/02/10 12:59:18 vegajula ship $*/
3
4 e_single_car_violation EXCEPTION;
5 e_existing_car_in_clm EXCEPTION;
6
7 PROCEDURE sync_clm_car
8 (
9 p_api_version IN NUMBER,
10 p_car_id IN NUMBER,
11 p_po_header_id IN NUMBER,
12 p_po_draft_id IN NUMBER,
13 p_award_idv_type IN VARCHAR2,
14 p_car_status IN VARCHAR2,
15 p_car_description IN VARCHAR2,
16 p_car_xml IN CLOB,
17 p_commit IN VARCHAR2,
18 p_validation_level IN VARCHAR2,
19 x_car_id OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_error_msg OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE sync_clm_car
25 (
26 p_api_version IN NUMBER,
27 p_clm_car_row IN PO_CLM_CAR_REC,
28 p_commit IN VARCHAR2,
29 p_validation_level IN VARCHAR2,
30 x_car_id OUT NOCOPY NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_error_msg OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE link_car
36 (
37 p_api_version IN NUMBER,
38 p_car_id IN NUMBER,
39 p_po_header_id IN NUMBER,
40 p_po_draft_id IN NUMBER,
41 p_award_idv_type IN VARCHAR2,
42 p_car_status IN VARCHAR2,
43 p_car_description IN VARCHAR2,
44 p_commit IN VARCHAR2,
45 p_validation_level IN VARCHAR2,
46 x_car_id OUT NOCOPY NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_error_msg OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE delete_clm_car
52 (
53 p_api_version IN NUMBER,
54 p_car_id IN NUMBER,
55 p_po_header_id IN NUMBER,
56 p_po_draft_id IN NUMBER,
57 p_commit IN VARCHAR2,
58 p_validation_level IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_error_msg OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE log_clm_car_messages
64 (
65 p_api_version IN NUMBER,
66 p_car_id IN NUMBER,
67 p_po_header_id IN NUMBER,
68 p_po_draft_id IN NUMBER,
69 p_clm_car_log_tab IN PO_CLM_CAR_LOG_TAB,
70 p_overwrite IN VARCHAR2,
71 p_commit IN VARCHAR2,
72 p_validation_level IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_error_msg OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE check_doc_number (
78 p_api_version IN NUMBER,
79 p_car_id IN NUMBER,
80 p_po_header_id IN NUMBER,
81 p_po_draft_id IN NUMBER,
82 p_validation_level IN VARCHAR2,
83 x_is_matching OUT NOCOPY VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_error_msg OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE get_referenced_IDV_info(
89 p_api_version IN NUMBER,
90 p_po_header_id IN NUMBER,
91 p_validation_level IN VARCHAR2,
92 x_ref_idv_agency_id OUT NOCOPY VARCHAR2,
93 x_ref_idv_piid OUT NOCOPY VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_error_msg OUT NOCOPY VARCHAR2
96 );
97
98 FUNCTION get_car_status(
99 p_car_id IN NUMBER,
100 p_po_header_id IN NUMBER,
101 p_po_draft_id IN NUMBER
102 ) RETURN VARCHAR2;
103
104 FUNCTION get_report_type
105 (
106 p_po_header_id IN NUMBER
107 ) RETURN VARCHAR2;
108
109 FUNCTION get_car_number
110 (
111 p_po_header_id IN NUMBER,
112 p_draft_id IN NUMBER
113 ) RETURN VARCHAR2;
114
115 FUNCTION get_PIID
116 (
117 p_po_header_id IN NUMBER,
118 p_draft_id IN NUMBER
119 ) RETURN VARCHAR2;
120
121 FUNCTION get_modification_segment
122 (
123 p_po_header_id IN NUMBER,
124 p_draft_id IN NUMBER
125 ) RETURN VARCHAR2;
126
127 FUNCTION get_agency_id
128 (
129 p_org_id IN NUMBER --CLM Controls Project Changes
130 )
131 RETURN VARCHAR2;
132
133 FUNCTION get_contr_office_agency_id
134 (
135 p_org_id IN NUMBER --CLM Controls Project Changes
136 )
137 RETURN VARCHAR2;
138
139 FUNCTION get_prepared_user RETURN VARCHAR2;
140
141 FUNCTION GET_FPDSNG_IDV_MOD_XML_SRC
142 (
143 p_org_id IN NUMBER --CLM Controls Project Changes
144 )
145 RETURN VARCHAR2;
146
147 FUNCTION GET_FPDSNG_IDV_XML_SOURCE
148 (
149 p_org_id IN NUMBER --CLM Controls Project Changes
150 )
151 RETURN VARCHAR2;
152
153 FUNCTION GET_FPDSNG_AWD_MOD_XML_SRC
154 (
155 p_org_id IN NUMBER --CLM Controls Project Changes
156 )
157 RETURN VARCHAR2;
158
159 FUNCTION GET_FPDSNG_AWD_XML_SOURCE
160 (
161 p_org_id IN NUMBER --CLM Controls Project Changes
162 )
163 RETURN VARCHAR2;
164
165 PROCEDURE reset_car_status
166 (
167 p_po_header_id IN NUMBER,
168 p_po_draft_id IN NUMBER
169 );
170
171 procedure insert_mod_default_car
172 (
173 p_po_header_id IN NUMBER,
174 p_draft_id IN NUMBER,
175 p_invoked_from IN VARCHAR2 DEFAULT 'CREATE_MOD_UI',
176 p_rel_without_rpt_reason IN VARCHAR2 DEFAULT NULL
177 );
178
179 -- Added for Sunset memo : Contingency Contract
180 PROCEDURE car_for_control_type(p_po_header_id IN NUMBER,
181 p_draft_id IN NUMBER,
182 p_special_contract_type IN VARCHAR2);
183
184 END PO_CLM_CAR_UTIL;