1 PACKAGE OE_Blanket_Pricing_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXQPBLS.pls 120.1 2006/03/29 16:46:10 spooruli noship $ */
3
4
5 FUNCTION IS_BLANKET_PRICE_LIST(p_price_list_id NUMBER
6 -- 11i10 Pricing Change
7 ,p_blanket_header_id NUMBER DEFAULT NULL)
8 RETURN BOOLEAN;
9
10 --------------------------------------------------------------------------
11 -- 11i10 Pricing Changes
12 -- Procedure to create modifier header and lines
13 -- Common procedure to process requests of type 'CREATE_MODIFIER_LIST'
14 -- and 'ADD_MODIFIER_LIST_LINE'
15 --------------------------------------------------------------------------
16 PROCEDURE Create_Modifiers
17 (p_index IN NUMBER,
18 x_return_status OUT NOCOPY VARCHAR2
19 );
20
21 --------------------------------------------------------------------------
22 -- Procedure called to deactivate price list/modifier list when
23 -- blanket header or blanket line is deleted.
24 --------------------------------------------------------------------------
25 PROCEDURE Deactivate_Pricing
26 (p_blanket_header_id IN NUMBER DEFAULT NULL
27 ,p_blanket_line_id IN NUMBER DEFAULT NULL
28 ,x_return_status IN OUT NOCOPY VARCHAR2
29 );
30
31
32 --------------------------------------------------------------------------
33 -- Sourcing APIs for 11i10 blanket qualifier attributes
34 --------------------------------------------------------------------------
35 FUNCTION Get_Blanket_Header_ID
36 ( p_blanket_number IN NUMBER
37 )RETURN NUMBER;
38
39 FUNCTION Get_Blanket_Line_ID
40 ( p_blanket_number IN NUMBER
41 , p_blanket_line_number IN NUMBER
42 )RETURN NUMBER;
43
44 -- Sourcing API for QP Internal Pricing Attribute
45 FUNCTION Get_List_Line_ID
46 ( p_blanket_number IN NUMBER
47 , p_blanket_line_number IN NUMBER
48 )RETURN NUMBER;
49
50 --------------------------------------------------------------------------
51 -- Sourcing APIs for blanket accumulation attributes
52 --------------------------------------------------------------------------
53 FUNCTION Get_Blanket_Rel_Amt
54 ( p_blanket_number IN NUMBER
55 , p_blanket_line_number IN NUMBER
56 , p_line_id IN NUMBER DEFAULT NULL
57 , p_header_id IN NUMBER DEFAULT NULL
58 , p_transaction_phase_code IN VARCHAR2 DEFAULT NULL
59 )RETURN NUMBER;
60
61 FUNCTION Get_Bl_Line_Rel_Amt
62 ( p_blanket_number IN NUMBER
63 , p_blanket_line_number IN NUMBER
64 , p_line_id IN NUMBER DEFAULT NULL
65 , p_header_id IN NUMBER DEFAULT NULL
66 , p_transaction_phase_code IN VARCHAR2 DEFAULT NULL
67 )RETURN NUMBER;
68
69 FUNCTION Get_Bl_Line_Rel_Qty
70 ( p_blanket_number IN NUMBER
71 , p_blanket_line_number IN NUMBER
72 , p_line_id IN NUMBER DEFAULT NULL
73 , p_header_id IN NUMBER DEFAULT NULL
74 , p_transaction_phase_code IN VARCHAR2 DEFAULT NULL
75 )RETURN NUMBER;
76
77 END OE_Blanket_Pricing_Util;