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