[Home] [Help]
PACKAGE: APPS.QP_RESOLVE_INCOMPATABILITY_PVT
Source
1 PACKAGE QP_Resolve_Incompatability_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVINCS.pls 120.1.12010000.1 2008/07/28 11:58:45 appldev ship $ */
3
4 PROCEDURE Resolve_Incompatability(p_pricing_phase_id NUMBER,
5 p_processing_flag VARCHAR2,
6 p_list_price NUMBER,
7 p_line_index NUMBER,
8 x_return_status OUT NOCOPY VARCHAR2,
9 x_return_status_txt OUT NOCOPY VARCHAR2);
10
11 FUNCTION Precedence_For_List_Line(p_list_header_id NUMBER,
12 p_list_line_id NUMBER,
13 p_incomp_grp_id VARCHAR2,
14 p_line_index NUMBER,
15 p_pricing_phase_id NUMBER)
16 RETURN NUMBER;
17
18 TYPE precedence_rec_type IS RECORD
19 (created_from_list_line_id NUMBER:=NULL,
20 product_precedence NUMBER:=NULL,
21 original_precedence NUMBER:=NULL,
22 product_uom_code VARCHAR2(30) := NULL,
23 inventory_item_id VARCHAR2(30) := NULL,
24 incompatability_grp_code VARCHAR2(30) := NULL,
25 ask_for_flag VARCHAR2(1) := NULL);
26
27 TYPE precedence_tbl_type is TABLE OF precedence_rec_type INDEX BY BINARY_INTEGER;
28
29
30 PROCEDURE Best_Price_For_Phase(p_list_price NUMBER,
31 p_line_index NUMBER,
32 p_pricing_phase_id NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_return_status_txt OUT NOCOPY VARCHAR2);
35
36 PROCEDURE Determine_Pricing_UOM_And_Qty(p_line_index NUMBER,
37 p_order_uom_code VARCHAR2,
38 p_order_qty NUMBER,
39 p_pricing_phase_id NUMBER,
40 p_call_big_search BOOLEAN,
41 x_list_line_id OUT NOCOPY NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_return_status_txt OUT NOCOPY VARCHAR2);
44
45 PROCEDURE Delete_Ldets_Complete (p_line_detail_index_tbl IN QP_PREQ_GRP.NUMBER_TYPE,
46 p_pricing_status_text IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_return_status_txt OUT NOCOPY VARCHAR2);
49
50 PRAGMA RESTRICT_REFERENCES (Precedence_For_List_Line , WNDS);
51
52 END QP_Resolve_Incompatability_PVT ;