1 PACKAGE OE_AUDIT_HISTORY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXPPCHS.pls 120.10.12020000.1 2012/06/26 09:14:30 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 -- Function Added for bug 8547934
68 FUNCTION Inventory_Item
69 ( p_inventory_item_id IN NUMBER,
70 p_org_id IN NUMBER DEFAULT NULL)
71
72 RETURN VARCHAR2;
73
74
75
76 FUNCTION Get_translated_value(p_flexfield_name IN varchar2,
77 p_appl_column_name IN varchar2,
78 p_column_value IN varchar2,
79 p_context_value IN Varchar2 DEFAULT NULL )
80 RETURN VARCHAR2;
81
82 PROCEDURE Compare_Credit_Card
83 ( p_attribute_id IN NUMBER
84 , p_header_id IN NUMBER
85 , p_old_hist_creation_date IN DATE
86 , p_new_hist_creation_date IN DATE
87 , x_old_attribute_value OUT NOCOPY VARCHAR2
88 , x_new_attribute_value OUT NOCOPY VARCHAR2
89 , x_card_number_equal OUT NOCOPY VARCHAR2
90 );
91
92 FUNCTION Get_Card_Attribute_Value
93 ( p_instr_flag IN VARCHAR2
94 , p_attribute_id IN NUMBER
95 , p_instrument_id IN NUMBER)
96 RETURN VARCHAR2;
97
98 END OE_AUDIT_HISTORY_PVT;