PACKAGE: APPS.OE_AUDIT_HISTORY_PVT

Source

1 PACKAGE OE_AUDIT_HISTORY_PVT AS
2 /* $Header: OEXPPCHS.pls 120.9.12010000.1 2008/07/25 07:53:31 appldev ship $ */
3 
4 PROCEDURE set_attribute_history (
5    retcode           OUT NOCOPY /* file.sql.39 change */    varchar2,
6    errbuf            OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
7    p_org_id          IN     NUMBER   := NULL,
8    start_date        IN     VARCHAR2,
9    end_date          IN     VARCHAR2,
10    order_number_from IN     NUMBER,
11    order_number_to   IN     NUMBER,
12    audit_duration    IN     NUMBER);
13 
14 
15 --Added for bug#5631508
16 PROCEDURE RECORD_SET_HISTORY(
17 	p_header_id  IN number ,
18 	p_line_id    IN number,
19 	p_set_id     IN number,
20     	x_return_status OUT NOCOPY varchar2 );
21 
22 --Added for bug#5631508
23 PROCEDURE DELETE_SET_HISTORY(
24 	p_line_id    IN number,
25 	x_return_status OUT NOCOPY varchar2 );
26 
27 
28 FUNCTION id_to_value
29 (  p_attribute_id  IN NUMBER,
30    attribute_value  IN varchar2,
31    p_context_value IN VARCHAR2 DEFAULT NULL,
32    p_org_id IN NUMBER DEFAULT NULL
33 ) RETURN VARCHAR2;
34 
35 
36 PROCEDURE Get_Valueset_Id_r(p_flexfield_name  IN VARCHAR2,
37 			    p_context         IN VARCHAR2,
38                             p_seg             IN VARCHAR2,
39 	      		    x_vsid            OUT NOCOPY NUMBER,
40 			    x_format_type     OUT NOCOPY VARCHAR2,
41                             x_validation_type OUT NOCOPY VARCHAR2);
42 
43 
44 FUNCTION Get_Attribute_Value(p_FlexField_Name           IN VARCHAR2
45                             ,p_Context_Name             IN VARCHAR2
46 			    ,p_segment_name             IN VARCHAR2
47 			    ,p_attr_value               IN VARCHAR2
48 			    ,p_comparison_operator_code IN VARCHAR2 := NULL
49 			    ) RETURN VARCHAR2 ;
50 
51 FUNCTION value_exists_in_table(p_table_r  fnd_vset.table_r,
52 			       p_value    VARCHAR2,
53 			       x_id	  OUT NOCOPY VARCHAR2,
54 			       x_value    OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
55 
56 
57 FUNCTION Get_Display_Name(p_attribute_id IN NUMBER
58 			  ,p_context_value IN VARCHAR2 DEFAULT NULL
59 			  ,p_old_context_value IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
60 
61 FUNCTION Get_column_label(p_flexfield_name IN varchar2,
62                           p_appl_column_name IN varchar2,
63 			  p_context_value IN Varchar2 DEFAULT NULL,
64 			  p_old_context_value IN Varchar2 DEFAULT NULL)
65 RETURN VARCHAR2;
66 
67 
68 FUNCTION Get_translated_value(p_flexfield_name IN varchar2,
69                                p_appl_column_name IN varchar2,
70                                p_column_value IN varchar2,
71 			      p_context_value IN Varchar2  DEFAULT NULL )
72 RETURN VARCHAR2;
73 
74 PROCEDURE Compare_Credit_Card
75 (   p_attribute_id              IN NUMBER
76 ,   p_header_id                 IN NUMBER
77 ,   p_old_hist_creation_date    IN DATE
78 ,   p_new_hist_creation_date    IN DATE
79 ,   x_old_attribute_value       OUT NOCOPY VARCHAR2
80 ,   x_new_attribute_value       OUT NOCOPY VARCHAR2
81 ,   x_card_number_equal         OUT NOCOPY VARCHAR2
82 );
83 
84 FUNCTION Get_Card_Attribute_Value
85 ( p_instr_flag		IN VARCHAR2
86 , p_attribute_id 	IN NUMBER
87 , p_instrument_id  	IN NUMBER)
88 RETURN VARCHAR2;
89 
90 END OE_AUDIT_HISTORY_PVT;