1 PACKAGE OKC_PHI_PVT AS
2 /* $Header: OKCRPHIS.pls 120.0 2005/05/26 09:56:49 appldev noship $ */
3
4 --
5 -- Global constants
6 --
7 -------------------------------------------------------------------------------------------------------------------------
8 -- Procedure : Process_price_hold
9 -- Input Parameter : p_chr_id Contract Id of contract which has price hold on it.
10 -- P_opreation_code Possible value UPDATE and TERMINATE
11 -- P_termination_date
12 --
13 -- If this API is called for a contract for the first time with operation UPDATE then it creates a Modifier and Pricing Agreement in QP.
14 --
15 -- If this API is called for a contract for the another time with operation UPDATE then it updates a Modifier and Pricing Agreement
16 -- in QP and creates new Modifier line if new liens have been added to contract.
17 --
18 -- If this API is called for a contract with operation TERMINATE then it de-activates a Modifier and Pricing Agreement in QP.
19
20 -- This API will be called whenever a contract/contract line is activated or Terminated or cancelled.
21 --------------------------------------------------------------------------------------------------------------------------------
22
23 PROCEDURE process_price_hold(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
24 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
25 ,p_chr_id IN OKC_K_HEADERS_V.id%TYPE -- Price Hold Contract Id
26 ,p_operation_code IN VARCHAR2 -- Operation UPDATE/TERMINATE
27 ,p_termination_date IN DATE
28 ,p_unconditional_call IN varchar2 Default 'N'
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 -------------------------------------------------------------------------------------------------------------------------
35 --Procedure : extend_price_hold
36 -- Input Parameter : p_cle_id Contract Line Id of price hold topline.
37 --
38 -- This API is called whenever a price hold line is extended.What it does is that it extends
39 -- modifier,modifier line and price agreements in QP
40 --
41 ---------------------------------------------------------------------------------------------------------------------------------
42
43 PROCEDURE extend_price_hold(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
44 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45 ,p_cle_id IN OKC_K_LINES_V.id%TYPE -- Price Hold Topline Id
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 -------------------------------------------------------------------------------------------------------------------------
52 --Procedure : COPY_LINES
53 -- Input Parameter : p_cle_id - Contract Line Id of price hold topline.
54 -- p_chr_id - Contract Header ID
55 -- p_delete_before_yn - delete current lines before copying
56 -- p_commit_changes_yn - commit changes after copying
57 --
58 -- This procedure copies Not Price Hold contract lines as sublines for Price Hold TopLine.
59 ---------------------------------------------------------------------------------------------------------------------------------
60 PROCEDURE COPY_LINES(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_chr_id IN NUMBER, -- Contract Header ID
67 p_cle_id in number, -- Price Hold TopLine ID
68 p_restricted_update in VARCHAR2,
69 p_delete_before_yn in VARCHAR2 DEFAULT 'N',-- delete current lines before copying
70 p_commit_changes_yn in VARCHAR2 DEFAULT 'N', -- commit changes after copying
71 x_recs_copied OUT NOCOPY NUMBER);
72
73 END OKC_PHI_PVT;