1 PACKAGE OKS_CHANGE_STATUS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKSVCSTS.pls 120.4 2011/07/29 09:25:35 vgujarat ship $ */
3
4 /*cgopinee bugfix 9259068*/
5 G_HEADER_STATUS_CHANGED VARCHAR2(1):='N';
6
7 subtype chrv_tbl_type is OKC_CONTRACT_PUB.chrv_tbl_type;
8 subtype clev_tbl_type is OKC_CONTRACT_PUB.clev_tbl_type;
9 subtype control_rec_type is okc_util.okc_control_tbl_type;
10 Type Num_Tbl_Type is table of NUMBER index by BINARY_INTEGER ;
11 TYPE VC30_Tbl_Type is TABLE of VARCHAR2(30) index by BINARY_INTEGER ;
12 subtype wf_attr_details is OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;
13
14
15 procedure Update_header_status(x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_data OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 p_init_msg_list in varchar2 default FND_API.G_FALSE,
19 p_chrv_tbl in OUT NOCOPY chrv_tbl_type,
20 p_canc_reason_code in varchar2,
21 p_comments in varchar2 default FND_API.G_MISS_CHAR,
22 p_term_cancel_source in varchar2 default 'MANUAL',
23 p_date_cancelled in date default sysdate,
24 p_validate_status in varchar2 default 'Y');
25
26 procedure Update_header_status(x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 p_init_msg_list in varchar2 default FND_API.G_FALSE,
30 p_id in number,
31 p_new_sts_code in varchar2,
32 p_canc_reason_code in varchar2,
33 p_old_sts_code in varchar2 default FND_API.G_MISS_CHAR,
34 p_comments in varchar2 default FND_API.G_MISS_CHAR,
35 p_term_cancel_source in varchar2 default 'MANUAL',
36 p_date_cancelled in date default sysdate,
37 p_validate_status in varchar2 default 'Y');
38
39 procedure Update_line_status ( x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 p_init_msg_list in varchar2 default FND_API.G_FALSE,
43 p_id in number,
44 p_cle_id in number,
45 p_new_sts_code in varchar2,
46 p_canc_reason_code in varchar2,
47 p_old_sts_code in varchar2 default FND_API.G_MISS_CHAR,
48 p_old_ste_code in varchar2 default FND_API.G_MISS_CHAR,
49 p_new_ste_code in varchar2 default FND_API.G_MISS_CHAR,
50 p_term_cancel_source in varchar2 default 'MANUAL',
51 p_date_cancelled in Date default sysdate,
52 p_comments in Varchar2 default FND_API.G_MISS_CHAR,
53 p_validate_status in varchar2 default 'Y');
54
55
56 procedure VALIDATE_STATUS( x_return_status out NOCOPY varchar2,
57 x_msg_count out NOCOPY number,
58 x_msg_data out NOCOPY varchar2,
59 p_id in number,
60 p_new_ste_code in varchar2,
61 p_old_ste_code in varchar2,
62 p_new_sts_code in varchar2,
63 p_old_sts_code in varchar2,
64 p_cle_id in number,
65 p_validate_status in varchar2 default 'Y');
66
67 procedure check_allowed_status( x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_id IN NUMBER,
71 p_cle_id IN NUMBER,
72 p_new_sts_code IN VARCHAR2,
73 p_old_sts_code IN OUT NOCOPY VARCHAR2,
74 p_old_ste_code IN OUT NOCOPY VARCHAR2,
75 p_new_ste_code IN OUT NOCOPY VARCHAR2);
76
77
78
79 Procedure UPDATE_CONTRACT_TAX_AMOUNT(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 p_id IN NUMBER,
83 p_from_ste_code IN VARCHAR2,
84 p_to_ste_code IN VARCHAR2,
85 p_cle_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2 );
89
90
91 Procedure UPDATE_SUBSCRIPTION_TAX_AMOUNT(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN varchar2 default FND_API.G_FALSE,
94 p_id IN NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2);
98
99
100 function Renewed_YN (p_id in number) return boolean;
101
102 function get_source_list (p_id in Number, p_cle_id in Number default FND_API.G_MISS_NUM)
103 return varchar2;
104
105 function get_target_list (p_id in number, p_cle_id in number default FND_API.G_MISS_NUM)
106 return varchar2;
107
108 function target_cancelled(p_id in number, p_cle_id in number default FND_API.G_MISS_NUM)
109 return boolean;
110
111 function Is_Entered (p_id in Number, p_cle_id in Number default FND_API.G_MISS_NUM)
112 return boolean;
113
114 function is_not_entered_cancelled (p_id in number, p_cle_id in Number default FND_API.G_MISS_NUM)
115 return boolean;
116
117 PROCEDURE populate_table(x_chrv_tbl in out NOCOPY chrv_tbl_type, i in number);
118
119 function TARGET_EXISTS(p_id in number, p_cle_id in Number default FND_API.G_MISS_NUM)
120 return boolean;
121
122 function get_tax_for_subs_line(p_id in number, p_cle_id in number default FND_API.G_MISS_NUM)
123 return number;
124
125 end;