1 PACKAGE PO_PRICE_HELPER AUTHID CURRENT_USER AS
2 -- $Header: PO_PRICE_HELPER.pls 120.1.12020000.2 2013/03/15 21:26:16 pla ship $
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 --<Enhanced Pricing Start>
37 , p_draft_id IN NUMBER DEFAULT NULL
38 , p_src_flag IN VARCHAR2 DEFAULT NULL
39 , p_doc_sub_type IN VARCHAR2 DEFAULT NULL
40 --<Enhanced Pricing End>
41 -- <Bug : Encumbrance ER : 13503748: Parameter to identify if the amount on the distributions of the line has been changed
42 ,p_amount_changed_flag IN VARCHAR2 DEFAULT NULL
43
44 , x_base_unit_price OUT NOCOPY NUMBER
45 , x_price_break_id OUT NOCOPY NUMBER
46 , x_price OUT NOCOPY NUMBER
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_from_advanced_pricing OUT NOCOPY VARCHAR2
49 , x_system_allows_update OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE attempt_man_mod_pricing(
53 p_order_quantity IN NUMBER
54 , p_ship_to_org IN NUMBER
55 , p_ship_to_loc IN NUMBER
56 , p_po_line_id IN NUMBER
57 , p_need_by_date IN DATE
58 , p_line_location_id IN NUMBER
59 , p_contract_id IN NUMBER
60 , p_org_id IN NUMBER
61 , p_supplier_id IN NUMBER
62 , p_supplier_site_id IN NUMBER
63 , p_creation_date IN DATE
64 , p_order_header_id IN NUMBER
65 , p_order_line_id IN NUMBER
66 , p_line_type_id IN NUMBER
67 , p_item_revision IN VARCHAR2
68 , p_item_id IN NUMBER
69 , p_category_id IN NUMBER
70 , p_supplier_item_num IN VARCHAR2
71 , p_uom IN VARCHAR2
72 , p_in_price IN NUMBER
73 , p_currency_code IN VARCHAR2
74 , p_price_break_lookup_code IN VARCHAR2
75 --<Enhanced Pricing Start: Parameters to identify calls with or without source docuemnt and document type (standard or blanket)>
76 , p_src_flag IN VARCHAR2 DEFAULT NULL
77 , p_doc_sub_type IN VARCHAR2 DEFAULT NULL
78 --<Enhanced Pricing End>
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_system_allows_update OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE check_system_allows_update(
84 p_po_line_id IN NUMBER
85 , p_price_break_lookup_code IN VARCHAR2
86 -- <Bug : Encumbrance ER : 13503748: Parameter to identify if the amount on the distributions of the line has been changed
87 ,p_amount_changed_flag IN VARCHAR2 DEFAULT NULL
88 , x_system_allows_update OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE no_dists_reserved(
92 p_line_id_tbl IN PO_TBL_NUMBER
93 -- <Bug : Encumbrance ER : 13503748: Parameter to identify if the amount on the distributions of the line has been changed
94 ,p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 DEFAULT NULL
95 , x_result_set_id IN OUT NOCOPY NUMBER
96 , x_result_type OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE accruals_allow_update(
100 p_line_id_tbl IN PO_TBL_NUMBER
101 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
102 , x_result_type OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE no_timecards_exist(
106 p_line_id_tbl IN PO_TBL_NUMBER
107 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
108 , x_result_type OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE no_pending_receipts(
112 p_line_id_tbl IN PO_TBL_NUMBER
113 , x_result_set_id IN OUT NOCOPY NUMBER
114 , x_result_type OUT NOCOPY VARCHAR2
115 );
116
117 PROCEDURE retro_account_allows_update(
118 p_line_id_tbl IN PO_TBL_NUMBER
119 , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
120 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121 , x_result_type OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE warn_amt_based_notif_ctrls(
125 p_line_id_tbl IN PO_TBL_NUMBER
126 , x_result_set_id IN OUT NOCOPY NUMBER
127 , x_result_type OUT NOCOPY VARCHAR2
128 );
129
130 END PO_PRICE_HELPER;