1 PACKAGE pa_expenditure_inquiry As
2 -- $Header: PAXEXINS.pls 120.1 2005/08/11 10:11:44 eyefimov noship $
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 -- This function will be used in the view to determine the mode
14
15 FUNCTION Get_Mode RETURN VARCHAR2 ;
16 pragma RESTRICT_REFERENCES ( Get_Mode, WNDS, WNPS );
17
18 -- The procedure that will be used to pass the value of the mode
19 -- from the form
20
21 -- This function will be used in the view to determine the Query criteria (Bug# 680401)
22
23 FUNCTION Get_Criteria RETURN VARCHAR2 ;
24 pragma RESTRICT_REFERENCES ( Get_Criteria, WNDS, WNPS );
25
26 -- The procedure that will be used to pass the value of the mode
27 -- from the form
28
29 PROCEDURE pa_expenditure_inquiry_driver (
30 x_Mode IN VARCHAR2);
31
32 -- The procedure that will be used to pass the value of the Query Criteria
33 -- from the form (Bug#680401)
34
35 PROCEDURE pa_expenditure_criteria_driver (
36 x_Criteria IN VARCHAR2);
37
38 PROCEDURE pa_get_cdl_details( p_expenditure_item_id IN NUMBER,
39 x_vendor_id IN OUT NOCOPY NUMBER,
40 x_system_reference2 IN OUT NOCOPY VARCHAR2,
41 x_vendor_name IN OUT NOCOPY VARCHAR2,
42 x_vendor_number IN OUT NOCOPY VARCHAR2,
43 x_burden_sum_rej_code IN OUT NOCOPY VARCHAR2) ;
44
45 END pa_expenditure_inquiry ;