1 PACKAGE PO_PRICE_HELPER AS
2 -- $Header: PO_PRICE_HELPER.pls 120.0 2005/06/07 16:24:11 appldev noship $
3
4 ---------------------------------------------------------------
5 -- Global constants and types.
6 ---------------------------------------------------------------
7
8
9 ---------------------------------------------------------------
10 -- Public subprograms.
11 ---------------------------------------------------------------
12
13 PROCEDURE attempt_line_price_update(
14 p_order_quantity IN NUMBER
15 , p_ship_to_org IN NUMBER
16 , p_ship_to_loc IN NUMBER
17 , p_po_line_id IN NUMBER
18 , p_need_by_date IN DATE
19 , p_line_location_id IN NUMBER
20 , p_contract_id IN NUMBER
21 , p_org_id IN NUMBER
22 , p_supplier_id IN NUMBER
23 , p_supplier_site_id IN NUMBER
24 , p_creation_date IN DATE
25 , p_order_header_id IN NUMBER
26 , p_order_line_id IN NUMBER
27 , p_line_type_id IN NUMBER
28 , p_item_revision IN VARCHAR2
29 , p_item_id IN NUMBER
30 , p_category_id IN NUMBER
31 , p_supplier_item_num IN VARCHAR2
32 , p_uom IN VARCHAR2
33 , p_in_price IN NUMBER
34 , p_currency_code IN VARCHAR2
35 , p_price_break_lookup_code IN VARCHAR2
36 , x_base_unit_price OUT NOCOPY NUMBER
37 , x_price_break_id OUT NOCOPY NUMBER
38 , x_price OUT NOCOPY NUMBER
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_from_advanced_pricing OUT NOCOPY VARCHAR2
41 , x_system_allows_update OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE check_system_allows_update(
45 p_po_line_id IN NUMBER
46 , p_price_break_lookup_code IN VARCHAR2
47 , x_system_allows_update OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE no_dists_reserved(
51 p_line_id_tbl IN PO_TBL_NUMBER
52 , x_result_set_id IN OUT NOCOPY NUMBER
53 , x_result_type OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE accruals_allow_update(
57 p_line_id_tbl IN PO_TBL_NUMBER
58 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
59 , x_result_type OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE no_timecards_exist(
63 p_line_id_tbl IN PO_TBL_NUMBER
64 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
65 , x_result_type OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE no_pending_receipts(
69 p_line_id_tbl IN PO_TBL_NUMBER
70 , x_result_set_id IN OUT NOCOPY NUMBER
71 , x_result_type OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE retro_account_allows_update(
75 p_line_id_tbl IN PO_TBL_NUMBER
76 , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
77 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
78 , x_result_type OUT NOCOPY VARCHAR2
79 );
80
81 PROCEDURE warn_amt_based_notif_ctrls(
82 p_line_id_tbl IN PO_TBL_NUMBER
83 , x_result_set_id IN OUT NOCOPY NUMBER
84 , x_result_type OUT NOCOPY VARCHAR2
85 );
86
87 END PO_PRICE_HELPER;
[Home] [Help]