1 PACKAGE por_view_reqs_pkg AUTHID CURRENT_USER as
2 /* $Header: PORVRQSS.pls 120.6.12020000.2 2013/06/06 09:38:54 bpulivar ship $ */
3
4 function get_requester(req_Header_Id IN NUMBER) RETURN VARCHAR2;
5 function get_deliver_to(req_Header_Id IN NUMBER) RETURN VARCHAR2;
6 function get_note_to_agent(req_Header_Id IN NUMBER) RETURN VARCHAR2;
7 function get_req_total(req_Header_Id IN NUMBER) RETURN NUMBER;
8 function get_account_number(req_line_id IN NUMBER) RETURN VARCHAR2;
9 function get_project_number(req_line_id IN NUMBER) RETURN VARCHAR2;
10 function get_task_name(req_line_id IN NUMBER) RETURN VARCHAR2;
11 function get_expenditure_type(req_line_id IN NUMBER) RETURN VARCHAR2;
12 function get_supplier_name(req_header_id IN NUMBER) return VARCHAR2;
13 function is_placedOnPO(req_header_id IN NUMBER) return VARCHAR2;
14 function is_placedOnSO(req_header_id IN NUMBER) return VARCHAR2;
15 function is_placedOnNG(req_header_id IN NUMBER) return VARCHAR2;
16 /** bgu, Apr. 09, 1999
17 * Used to retrieve approver name for view por_approval_status_lines_v
18 */
19 function get_approver_name(approver_id IN NUMBER) RETURN VARCHAR2;
20 function get_approver_email(approver_id IN NUMBER) RETURN VARCHAR2;
21 function get_business_group_name(approver_id IN NUMBER) RETURN VARCHAR2;
22 function get_shipment_number(req_line_id IN NUMBER) RETURN VARCHAR2;
23 --Added additional parameter p_prefix_so_number
24 function get_so_number_status(req_line_id NUMBER,p_prefix_so_number VARCHAR2 DEFAULT 'Y') RETURN VARCHAR2;
25 --Overloaded method to handle the Case if cinvoked from Lifecycle Page
26 function get_so_number_status(req_line_id NUMBER,p_prefix_so_number VARCHAR2 DEFAULT 'Y',p_line_id IN NUMBER) RETURN VARCHAR2;
27 function get_so_number_status_code(p_status_code IN VARCHAR2, p_line_id IN NUMBER, p_so_number IN NUMBER,p_prefix_so_number VARCHAR2 DEFAULT 'Y')
28 RETURN VARCHAR2;
29
30 function get_so_status(req_line_id NUMBER) RETURN VARCHAR2;
31 procedure getLineInfo( reqHeaderId IN NUMBER,
32 currencyFormat IN VARCHAR2,
33 reqTotal OUT NOCOPY varchar2,
34 supplierName OUT NOCOPY VARCHAR2,
35 placedOnPoFlag OUT NOCOPY VARCHAR2 );
36
37 procedure getUnformattedLineInfo( reqHeaderId IN NUMBER,
38 currencyFormat IN VARCHAR2,
39 reqTotal OUT NOCOPY NUMBER,
40 supplierName OUT NOCOPY VARCHAR2,
41 placedOnPoFlag OUT NOCOPY VARCHAR2 );
42
43 function get_urgent_flag(req_header_id IN NUMBER) RETURN VARCHAR2;
44
45 procedure getDistributionInfo(req_line_id IN NUMBER,
46 date_format IN VARCHAR2,
47 account_number OUT NOCOPY VARCHAR2,
48 project_id OUT NOCOPY NUMBER,
49 project_number OUT NOCOPY VARCHAR2,
50 task_id OUT NOCOPY NUMBER,
51 task_number OUT NOCOPY VARCHAR2,
52 expenditure_type OUT NOCOPY VARCHAR2,
53 expenditure_org_id OUT NOCOPY NUMBER,
54 expenditure_org OUT NOCOPY VARCHAR2,
55 expenditure_item_date OUT NOCOPY VARCHAR2);
56
57 function get_line_total(req_line_id IN NUMBER, currency_code IN VARCHAR2) RETURN VARCHAR2;
58
59 function is_req_modified_by_buyer(reqHeaderId IN NUMBER) return varchar2;
60
61 FUNCTION get_line_nonrec_tax_total(ReqLineId IN NUMBER) RETURN NUMBER;
62 FUNCTION get_nonrec_tax_total(ReqHeaderId IN NUMBER) RETURN NUMBER;
63 FUNCTION get_line_rec_tax_total(ReqLineId IN NUMBER) RETURN NUMBER;
64
65 pragma restrict_references(get_approver_name, WNDS, WNPS);
66
67 pragma restrict_references(get_requester, WNDS, WNPS);
68 pragma restrict_references(get_req_total, WNDS, WNPS);
69 pragma restrict_references(get_note_to_agent, WNDS, WNPS);
70 pragma restrict_references(get_account_number, WNDS, WNPS);
71 pragma restrict_references(get_project_number, WNDS, WNPS);
72 --16918428
73 --pragma restrict_references(get_task_name, WNDS, WNPS);
74 pragma restrict_references(get_expenditure_type, WNDS, WNPS);
75 pragma restrict_references(is_placedOnPO, WNDS, WNPS);
76 pragma restrict_references(get_urgent_flag, WNDS);
77 pragma restrict_references(get_line_total, WNDS, WNPS);
78 pragma restrict_references(is_req_modified_by_buyer, WNDS, WNPS);
79
80 -- FPJ new functions
81 --FUNCTION GET_ORDER_NUM(p_req_header_id in number) RETURN varchar2;
82 --FUNCTION GET_ORDER_SOURCE_TYPE(p_req_header_id in number) RETURN varchar2;
83 FUNCTION GET_PO_RELEASE_ID(p_req_header_id in number) RETURN number;
84 FUNCTION GET_PO_HEADER_ID(p_req_header_id in number) RETURN number;
85 FUNCTION GET_CANCEL_FLAG(p_req_header_id IN NUMBER) RETURN VARCHAR2;
86 FUNCTION GET_RETURN_FLAG(p_txn_id IN NUMBER) RETURN VARCHAR2;
87 FUNCTION GET_PURCHASING_ORG(p_req_header_id in number) RETURN varchar2;
88 FUNCTION GET_PURCH_ORG_FOR_LINE(p_req_line_id in number) RETURN varchar2;
89 function get_labor_line_supplier_name(req_line_id IN number) return varchar2;
90
91 PROCEDURE GET_PO_INFO(p_req_header_id in number,
92 p_po_header_id out NOCOPY number,
93 p_po_release_id out NOCOPY number);
94
95 --PROCEDURE GET_ORDER_INFO(p_req_header_id in number,
96 -- order_number out NOCOPY varchar2,
97 -- order_source_type out NOCOPY varchar2);
98
99 PROCEDURE GET_ORDER_RELATED_INFO(p_req_header_id in number,
100 p_federal IN VARCHAR2,
101 order_number out NOCOPY varchar2,
102 order_source_type out NOCOPY varchar2,
103 header_id out NOCOPY number,
104 po_release_id out NOCOPY number,
105 purchasing_org out NOCOPY varchar2,
106 placed_on_po_flag out NOCOPY varchar2,
107 order_status out NOCOPY varchar2);
108 PROCEDURE GET_LINE_ORDER_RELATED_INFO(p_req_line_id IN NUMBER,
109 order_number OUT NOCOPY VARCHAR2,
110 order_header_id OUT NOCOPY NUMBER,
111 purchasing_org OUT NOCOPY VARCHAR2,
112 order_status OUT NOCOPY VARCHAR2,
113 order_cancel_flag OUT NOCOPY VARCHAR2,
114 order_hold_flag OUT NOCOPY VARCHAR2 ,
115 buyer OUT NOCOPY VARCHAR2);
116
117
118 -- FUNCTION GET_ORDER_TYPE(p_req_header_id in number) RETURN varchar2;
119
120 PROCEDURE getCurrentApproverInfo(req_header_id IN NUMBER,
121 full_name OUT NOCOPY VARCHAR2,
122 email_address OUT NOCOPY VARCHAR2,
123 phone OUT NOCOPY VARCHAR2,
124 date_notified OUT NOCOPY DATE);
125
126 END por_view_reqs_pkg;
127