PACKAGE: APPS.PO_PDOI_PRICE_TOLERANCE_PVT

Source

1 PACKAGE PO_PDOI_PRICE_TOLERANCE_PVT AS
2 /* $Header: PO_PDOI_PRICE_TOLERANCE_PVT.pls 120.1 2005/08/20 02:32 jinwang noship $ */
3 
4 PROCEDURE start_price_tolerance_wf
5 (
6   p_intf_header_id    IN  NUMBER,
7   p_po_header_id      IN  NUMBER,
8   p_document_num      IN  VARCHAR2,
9   p_batch_id          IN  NUMBER,
10   p_document_type     IN  VARCHAR2,
11   p_document_subtype  IN  VARCHAR2,
12   p_commit_interval   IN  NUMBER,
13   p_any_line_updated  IN  VARCHAR2,
14   p_buyer_id          IN  NUMBER,
15   p_agent_id          IN  NUMBER,
16   p_vendor_id         IN  NUMBER,
17   p_vendor_name       IN  VARCHAR2
18 );
19 
20 PROCEDURE get_price_tolerance
21 (
22   p_index_tbl                  IN DBMS_SQL.NUMBER_TABLE,
23   p_po_header_id_tbl           IN PO_TBL_NUMBER,
24   p_item_id_tbl                IN PO_TBL_NUMBER,
25   p_category_id_tbl            IN PO_TBL_NUMBER,
26   p_vendor_id_tbl              IN PO_TBL_NUMBER,
27   x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
28 );
29 
30 FUNCTION exceed_tolerance_check
31 (
32   p_price_tolerance IN NUMBER,
33   p_old_price       IN NUMBER,
34   p_new_price       IN NUMBER
35 ) RETURN VARCHAR2;
36 
37 END PO_PDOI_PRICE_TOLERANCE_PVT;