11:
12:
13: PROCEDURE quote_contract_renewal (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_commit IN VARCHAR2 := fnd_api.g_false,
17: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12:
13: PROCEDURE quote_contract_renewal (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_commit IN VARCHAR2 := fnd_api.g_false,
17: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: p_quote_id IN NUMBER,
22: );
23:
24: PROCEDURE contract_renewal (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
27: p_commit IN VARCHAR2 := fnd_api.g_false,
28: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23:
24: PROCEDURE contract_renewal (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
27: p_commit IN VARCHAR2 := fnd_api.g_false,
28: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: p_contract_id IN NUMBER,
35: );
36:
37: PROCEDURE quote_is_renewal (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
40: p_commit IN VARCHAR2 := fnd_api.g_false,
41: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
43: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
36:
37: PROCEDURE quote_is_renewal (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
40: p_commit IN VARCHAR2 := fnd_api.g_false,
41: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
43: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
44: p_quote_id IN NUMBER,
46: );
47:
48: PROCEDURE quote_contract_is_ordered (
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_commit IN VARCHAR2 := fnd_api.g_false,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
54: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
47:
48: PROCEDURE quote_contract_is_ordered (
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_commit IN VARCHAR2 := fnd_api.g_false,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
54: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55: p_quote_id IN NUMBER,
61: -- the input needed are the quote id and the template id.
62:
63: PROCEDURE create_contract (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66: p_commit IN VARCHAR2 := fnd_api.g_false,
67: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62:
63: PROCEDURE create_contract (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66: p_commit IN VARCHAR2 := fnd_api.g_false,
67: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70: p_quote_id IN NUMBER,
76:
77: -- hyang okc
78: PROCEDURE create_contract (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
81: p_commit IN VARCHAR2 := fnd_api.g_false,
82: p_quote_id IN NUMBER,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
77: -- hyang okc
78: PROCEDURE create_contract (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
81: p_commit IN VARCHAR2 := fnd_api.g_false,
82: p_quote_id IN NUMBER,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
81: p_commit IN VARCHAR2 := fnd_api.g_false,
82: p_quote_id IN NUMBER,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
81: p_commit IN VARCHAR2 := fnd_api.g_false,
82: p_quote_id IN NUMBER,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
82: p_quote_id IN NUMBER,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
90: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
83: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
90: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
91: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
84: p_rel_type IN VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
90: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
91: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
92: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
90: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
91: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
92: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
87: p_party_id IN NUMBER := fnd_api.g_miss_num,
88: p_resource_id IN NUMBER := fnd_api.g_miss_num,
89: p_template_id IN NUMBER := fnd_api.g_miss_num,
90: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
91: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
92: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
94: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
99: -- this procedure is used to update a contract from a quote.
100:
101: PROCEDURE update_contract (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
100:
101: PROCEDURE update_contract (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
109: p_party_id IN NUMBER := fnd_api.g_miss_num,
110: p_resource_id IN NUMBER := fnd_api.g_miss_num,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
109: p_party_id IN NUMBER := fnd_api.g_miss_num,
110: p_resource_id IN NUMBER := fnd_api.g_miss_num,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
109: p_party_id IN NUMBER := fnd_api.g_miss_num,
110: p_resource_id IN NUMBER := fnd_api.g_miss_num,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
105: p_quote_id IN NUMBER,
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
109: p_party_id IN NUMBER := fnd_api.g_miss_num,
110: p_resource_id IN NUMBER := fnd_api.g_miss_num,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
113: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: p_contract_id IN NUMBER := fnd_api.g_miss_num,
107: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
108: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
109: p_party_id IN NUMBER := fnd_api.g_miss_num,
110: p_resource_id IN NUMBER := fnd_api.g_miss_num,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
113: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114: );
114: );
115:
116: PROCEDURE notify_contract_change (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_quote_id IN NUMBER,
121: p_notification_type IN VARCHAR2,
122: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
115:
116: PROCEDURE notify_contract_change (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_quote_id IN NUMBER,
121: p_notification_type IN VARCHAR2,
122: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
123: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_quote_id IN NUMBER,
121: p_notification_type IN VARCHAR2,
122: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
123: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
125: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
126: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_quote_id IN NUMBER,
121: p_notification_type IN VARCHAR2,
122: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
123: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
125: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
126: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127: );
129:
130:
131: -- vtariker
132: PROCEDURE Check_Customer_Accounts(
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_qte_header_id IN NUMBER,
135: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
137: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2