1 PACKAGE pa_expenditure_inquiry AUTHID CURRENT_USER As
2 -- $Header: PAXEXINS.pls 120.2 2011/05/31 11:30:13 vbkumar ship $
3 -- Define the global package variable that will be returned by
4 -- the function Get_Mode
5
6 X_Calling_Mode VARCHAR2(20) ;
7
8 -- Define the global package variable that will be returned by
9 -- the function Get_Criteria (Bug#680401)
10
11 X_Query_criteria VARCHAR2(20) ;
12
13 X_expenditure_item_id NUMBER;
14
15 X_source_dist_type VARCHAR2(80) ;/* Added for 9929147*/
16
17 X_application_id NUMBER; /* Added for 9929147*/
18
19 -- This function will be used in the view to determine the mode
20
21 FUNCTION Get_Mode RETURN VARCHAR2 ;
22 pragma RESTRICT_REFERENCES ( Get_Mode, WNDS, WNPS );
23
24 FUNCTION Get_expenditure_item_id RETURN NUMBER ;
25 pragma RESTRICT_REFERENCES ( Get_expenditure_item_id, WNDS, WNPS );
26
27 -- The procedure that will be used to pass the value of the mode
28 -- from the form
29
30 -- This function will be used in the view to determine the Query criteria (Bug# 680401)
31
32 FUNCTION Get_Criteria RETURN VARCHAR2 ;
33 pragma RESTRICT_REFERENCES ( Get_Criteria, WNDS, WNPS );
34
35 -- The procedure that will be used to pass the value of the mode
36 -- from the form
37
38 PROCEDURE pa_expenditure_inquiry_driver (
39 x_Mode IN VARCHAR2);
40
41 PROCEDURE pa_expenditure_item_driver (
42 x_eiid IN NUMBER);
43
44 /*Added for bug#9929147 Starts*/
45 PROCEDURE pa_source_dist_type_driver (
46 p_source_dist_type IN VARCHAR2);
47
48 PROCEDURE pa_application_id_driver (
49 x_appid IN NUMBER);
50
51 FUNCTION Get_application_id RETURN NUMBER;
52
53 FUNCTION Get_source_dist_type RETURN VARCHAR2;
54 /* Added for bug#9929147 Ends*/
55
56 -- The procedure that will be used to pass the value of the Query Criteria
57 -- from the form (Bug#680401)
58
59 PROCEDURE pa_expenditure_criteria_driver (
60 x_Criteria IN VARCHAR2);
61
62 PROCEDURE pa_get_cdl_details( p_expenditure_item_id IN NUMBER,
63 x_vendor_id IN OUT NOCOPY NUMBER,
64 x_system_reference2 IN OUT NOCOPY VARCHAR2,
65 x_vendor_name IN OUT NOCOPY VARCHAR2,
66 x_vendor_number IN OUT NOCOPY VARCHAR2,
67 x_burden_sum_rej_code IN OUT NOCOPY VARCHAR2) ;
68
69 END pa_expenditure_inquiry ;