1 PACKAGE PO_ReqChangeRequestNotif_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVRCNS.pls 120.3 2006/07/10 07:57:04 yqian noship $ */
3
4 /*************************************************************************
5 * +=======================================================================+
6 * | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
7 * | All rights reserved. |
8 * +=======================================================================+
9 * | FILE NAME: POXVRCNS.pls |
10 * | |
11 * | PACKAGE NAME: PO_ReqChangeRequestNotif_PVT |
12 * | |
13 * | DESCRIPTION: |
14 * | PO_ReqChangeRequestNotif_PVT is a private level package. |
15 * | It contains 3 public procedure which are used to generate |
16 * | notifications used in requester change order workflows. |
17 * | |
18 * | PROCEDURES: |
19 * | Get_Req_Chg_Approval_Notif |
20 * | generate the req change approval notification |
21 * | Get_Req_Chg_Response_Notif |
22 * | generate the notification to requester about the response |
23 * | to the change request |
24 * | Get_Po_Chg_Approval_Notif |
25 * | generate the notification to the buyer of the PO |
26 * | for buyer's approval |
27 * | FUNCTIONS: |
28 * | none |
29 * | |
30 * +=======================================================================+
31 */
32
33 PROCEDURE Get_Req_Chg_Approval_Notif(document_id in varchar2,
34 display_type in varchar2,
35 document in out nocopy clob,
36 document_type in out nocopy varchar2);
37 PROCEDURE Get_Req_Chg_Response_Notif(document_id in varchar2,
38 display_type in varchar2,
39 document in out nocopy clob,
40 document_type in out nocopy varchar2);
41 PROCEDURE Get_Po_Chg_Approval_Notif(document_id IN varchar2,
42 display_type in Varchar2,
43 document in out nocopy clob,
44 document_type in out nocopy varchar2);
45
46 function get_goods_shipment_new_amount(p_group_id in number,
47 p_po_line_id in number,
48 p_po_shipment_id in number,
49 p_old_price in number,
50 p_old_quantity in number
51 )
52 return number;
53
54
55
56 FUNCTION get_goods_shipment_new_amount(p_org_id in number,
57 p_group_id in number,
58 p_line_id in number,
59 p_item_id in number,
60 p_line_uom in varchar2,
61 p_old_price in number,
62 p_line_location_id in number
63 )
64 return number;
65
66
67 FUNCTION Get_PO_Price_Break_Grp(p_org_id in number,
68 p_group_id in number,
69 p_line_id in number,
70 p_item_id in number,
71 p_line_uom in varchar2,
72 p_old_price in number,
73 p_line_location_id number)
74 return number;
75
76 FUNCTION Get_Price(p_org_id in number,
77 p_group_id in number,
78 p_line_id in number,
79 p_item_id in number,
80 p_line_uom in varchar2,
81 p_old_price in number,
82 p_line_location_id in number)
83 return number;
84
85 PROCEDURE Get_Currency_Info ( p_po_header_id IN NUMBER,
86 p_org_id IN NUMBER,
87 x_po_in_txn_currency OUT NOCOPY VARCHAR2,
88 x_rate OUT NOCOPY NUMBER
89 ) ;
90
91 end PO_ReqChangeRequestNotif_PVT;