PACKAGE: APPS.OE_VERSIONING_UTIL

Source

1 PACKAGE OE_Versioning_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUVERS.pls 120.1 2005/09/25 02:42:23 lkxu noship $ */
3 
4 G_Audit_Header_Hist_Code VARCHAR2(30);
5 G_Audit_Header_Reason_Required BOOLEAN := FALSE;
6 
7 G_UI_Called              BOOLEAN;
8 G_Temp_Reason_Code       VARCHAR2(30);
9 G_Temp_Reason_Comments   VARCHAR2(2000);
10 
11 TYPE Audit_Trail_Rec_Type IS RECORD
12 (entity_id NUMBER,
13 hist_type_code VARCHAR2(30),
14 reason_required BOOLEAN := FALSE);
15 
16 TYPE Audit_Trail_Tbl_Type IS TABLE OF Audit_Trail_Rec_Type
17             INDEX BY BINARY_INTEGER;
18 
19 G_Audit_Line_ID_Tbl Audit_Trail_Tbl_Type;
20 G_Audit_Header_Adj_ID_Tbl Audit_Trail_Tbl_Type;
21 G_Audit_Line_Adj_ID_Tbl Audit_Trail_Tbl_Type;
22 G_Audit_Header_Scredit_ID_Tbl Audit_Trail_Tbl_Type;
23 G_Audit_Line_Scredit_ID_Tbl Audit_Trail_Tbl_Type;
24 
25 Procedure Execute_Versioning_Request(
26 p_header_id IN NUMBER,
27 p_document_type IN VARCHAR2,
28 p_changed_attribute IN VARCHAR2 := null,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2
32 );
33 
34 Procedure Perform_Versioning (
35 p_header_id IN NUMBER,
36 p_document_type IN VARCHAR2,
37 p_changed_attribute IN VARCHAR2 := null,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2
41 );
42 
43 Procedure Record_Changed_Records(
44 p_version_flag IN VARCHAR2 := NULL,
45 p_phase_change_flag IN VARCHAR2 := NULL,
46 p_changed_attribute IN VARCHAR2 := NULL,
47 x_return_status OUT NOCOPY VARCHAR2
48 );
49 
50 Function Reset_Globals
51 Return BOOLEAN;
52 
53 Procedure Check_Security(
54 p_column_name IN VARCHAR2,
55 p_on_operation_action IN NUMBER);
56 
57 FUNCTION IS_REASON_RQD RETURN VARCHAR2;
58 
59 FUNCTION IS_AUDIT_REASON_CAPTURED
60 (p_entity_code IN VARCHAR2,
61  p_entity_id IN NUMBER) RETURN BOOLEAN;
62 
63 FUNCTION CAPTURED_REASON RETURN Varchar2;
64 
65 Procedure Capture_Audit_Info(
66 p_entity_code IN VARCHAR2,
67 p_entity_id IN NUMBER,
68 p_hist_type_code IN VARCHAR2
69 );
70 
71 Procedure Get_Reason_Info(
72 x_reason_code OUT NOCOPY VARCHAR2,
73 x_reason_comments OUT NOCOPY VARCHAR2
74 );
75 
76 -------------------------------
77 --  QUERY_ROW(S) Procedures have been moved to
78 --     OE_Version_History_Util (OEXHVERS/B.pls)
79 -------------------------------
80 
81 END OE_Versioning_Util;