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