16: --
17:
18: PROCEDURE create_contract (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
17:
18: PROCEDURE create_contract (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
22: p_quote_id IN NUMBER,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
30: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
23: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
30: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
31: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
30: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
31: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
25: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
30: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
31: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
27: p_party_id IN NUMBER := fnd_api.g_miss_num,
28: p_resource_id IN NUMBER := fnd_api.g_miss_num,
29: p_template_id IN NUMBER := fnd_api.g_miss_num,
30: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
31: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
34: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
39: -- this procedure is used to update a contract from a quote.
40:
41: PROCEDURE update_contract (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_commit IN VARCHAR2 := fnd_api.g_false,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
40:
41: PROCEDURE update_contract (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_commit IN VARCHAR2 := fnd_api.g_false,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_commit IN VARCHAR2 := fnd_api.g_false,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
49: p_party_id IN NUMBER := fnd_api.g_miss_num,
50: p_resource_id IN NUMBER := fnd_api.g_miss_num,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_commit IN VARCHAR2 := fnd_api.g_false,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
49: p_party_id IN NUMBER := fnd_api.g_miss_num,
50: p_resource_id IN NUMBER := fnd_api.g_miss_num,
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
44: p_commit IN VARCHAR2 := fnd_api.g_false,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
49: p_party_id IN NUMBER := fnd_api.g_miss_num,
50: p_resource_id IN NUMBER := fnd_api.g_miss_num,
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
45: p_quote_id IN NUMBER,
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
49: p_party_id IN NUMBER := fnd_api.g_miss_num,
50: p_resource_id IN NUMBER := fnd_api.g_miss_num,
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
53: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46: p_contract_id IN NUMBER := fnd_api.g_miss_num,
47: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
48: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
49: p_party_id IN NUMBER := fnd_api.g_miss_num,
50: p_resource_id IN NUMBER := fnd_api.g_miss_num,
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
53: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54: );
64: --
65:
66: PROCEDURE notify_contract_change (
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
69: p_commit IN VARCHAR2 := fnd_api.g_false,
70: p_quote_id IN NUMBER,
71: p_notification_type IN VARCHAR2,
72: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
65:
66: PROCEDURE notify_contract_change (
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
69: p_commit IN VARCHAR2 := fnd_api.g_false,
70: p_quote_id IN NUMBER,
71: p_notification_type IN VARCHAR2,
72: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
73: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
68: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
69: p_commit IN VARCHAR2 := fnd_api.g_false,
70: p_quote_id IN NUMBER,
71: p_notification_type IN VARCHAR2,
72: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
73: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
74: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: p_commit IN VARCHAR2 := fnd_api.g_false,
70: p_quote_id IN NUMBER,
71: p_notification_type IN VARCHAR2,
72: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
73: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
74: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: );
78:
79:
80: -- vtariker
81: PROCEDURE Check_Customer_Accounts(
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_qte_header_id IN NUMBER,
84: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
86: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2