1 PACKAGE por_view_reqs_pkg as
2 /* $Header: PORVRQSS.pls 120.5 2006/04/27 06:02:35 mkohale noship $ */
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 pragma restrict_references(get_task_name, WNDS, WNPS);
73 pragma restrict_references(get_expenditure_type, WNDS, WNPS);
74 pragma restrict_references(is_placedOnPO, WNDS, WNPS);
75 pragma restrict_references(get_urgent_flag, WNDS);
76 pragma restrict_references(get_line_total, WNDS, WNPS);
77 pragma restrict_references(is_req_modified_by_buyer, WNDS, WNPS);
78
79 -- FPJ new functions
80 --FUNCTION GET_ORDER_NUM(p_req_header_id in number) RETURN varchar2;
81 --FUNCTION GET_ORDER_SOURCE_TYPE(p_req_header_id in number) RETURN varchar2;
82 FUNCTION GET_PO_RELEASE_ID(p_req_header_id in number) RETURN number;
83 FUNCTION GET_PO_HEADER_ID(p_req_header_id in number) RETURN number;
84 FUNCTION GET_CANCEL_FLAG(p_req_header_id IN NUMBER) RETURN VARCHAR2;
85 FUNCTION GET_RETURN_FLAG(p_txn_id IN NUMBER) RETURN VARCHAR2;
86 FUNCTION GET_PURCHASING_ORG(p_req_header_id in number) RETURN varchar2;
87 FUNCTION GET_PURCH_ORG_FOR_LINE(p_req_line_id in number) RETURN varchar2;
88 function get_labor_line_supplier_name(req_line_id IN number) return varchar2;
89
90 PROCEDURE GET_PO_INFO(p_req_header_id in number,
91 p_po_header_id out NOCOPY number,
92 p_po_release_id out NOCOPY number);
93
94 --PROCEDURE GET_ORDER_INFO(p_req_header_id in number,
95 -- order_number out NOCOPY varchar2,
96 -- order_source_type out NOCOPY varchar2);
97
98 PROCEDURE GET_ORDER_RELATED_INFO(p_req_header_id in number,
99 order_number out NOCOPY varchar2,
100 order_source_type out NOCOPY varchar2,
101 header_id out NOCOPY number,
102 po_release_id out NOCOPY number,
103 purchasing_org out NOCOPY varchar2,
104 placed_on_po_flag out NOCOPY varchar2,
105 order_status out NOCOPY varchar2);
106
107 -- FUNCTION GET_ORDER_TYPE(p_req_header_id in number) RETURN varchar2;
108
109 PROCEDURE getCurrentApproverInfo(req_header_id IN NUMBER,
110 full_name OUT NOCOPY VARCHAR2,
111 email_address OUT NOCOPY VARCHAR2,
112 phone OUT NOCOPY VARCHAR2,
113 date_notified OUT NOCOPY DATE);
114
115 END por_view_reqs_pkg;
116