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',
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:
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,
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');
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:
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,
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,
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,
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');
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,
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;
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;
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;
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;
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:
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;
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;