[Home] [Help]
PACKAGE: APPS.ASO_CORE_CONTRACTS_INT
Source
1 PACKAGE aso_core_contracts_int AS
2 /* $Header: asoiokcs.pls 120.1 2005/06/29 12:34:13 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_core_contracts_INT
5 -- Purpose :
6 -- History :
7 -- 10-08-2002 hyang - new contracts integration.
8 -- NOTE :
9 -- End of Comments
10
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,
20 p_quote_id IN NUMBER,
21 x_contract_id OUT NOCOPY /* file.sql.39 change */ 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,
31 p_contract_id IN NUMBER,
32 p_start_date IN DATE,
33 p_end_date IN DATE,
34 x_contract_id OUT NOCOPY /* file.sql.39 change */ 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,
44 p_quote_id IN NUMBER,
45 x_true_false OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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,
55 p_quote_id IN NUMBER,
56 x_true_false OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 );
58
59
60 -- this procedure is used to create a contract from a quote.
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,
70 p_quote_id IN NUMBER,
71 p_template_id IN NUMBER,
72 x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
73 x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 );
75
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,
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,
94 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
95 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 );
97
98
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,
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 );
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,
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 );
128 -- end of hyang okc
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
138 );
139 -- vtariker
140
141
142 END aso_core_contracts_int;