[Home] [Help]
PACKAGE: APPS.OKS_EXTWAR_UTIL_PUB
Source
1 PACKAGE OKS_EXTWAR_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPUTLS.pls 120.1 2005/06/06 13:43:44 appldev $ */
3
4 SUBTYPE War_tbl IS OKS_EXTWAR_UTIL_PVT.War_tbl;
5
6 -- GLOBAL VARIABLES
7 ----------------------------------------------------------------------------
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_EXTWAR_UTIL_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_WAR_TBL war_tbl;
11 G_PTR NUMBER := 1;
12 ----------------------------------------------------------------------------
13
14 -- GLOBAL_MESSAGE_CONSTANTS
15 ---------------------------------------------------------------------------
16 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
17 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
18 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
19 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
20 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
30 ---------------------------------------------------------------------------
31
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35 ---------------------------------------------------------------------------
36
37 -- Constants used for Message Logging
38 G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
39 G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40 -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41 G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42 G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45 G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46 G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_extwar_util_pub';
47
48
49 TYPE contact_dtl_rec IS RECORD
50 (
51 contact_id NUMBER,
52 contact_first_name VARCHAR2(2000),
53 contact_name VARCHAR2(2000),
54 party_id NUMBER,
55 party_name VARCHAR2(2000),
56 email_point_id NUMBER,
57 email VARCHAR2(2000),
58 phone_point_id NUMBER,
59 phone VARCHAR2(2000),
60 fax_point_id NUMBER,
61 fax VARCHAR2(2000),
62 quote_site_id NUMBER,
63 quote_address VARCHAR2(2000),
64 quote_city VARCHAR2(2000),
65 quote_country VARCHAR2(2000)
66
67 );
68
69 Procedure Get_Warranty_Info
70 (
71 p_api_version IN Number,
72 p_init_msg_list IN Varchar2,
73 p_Org_id IN Number,
74 p_prod_item_id IN Number,
75 p_date IN Date DEFAULT SYSDATE,
76 x_return_status OUT NOCOPY Varchar2,
77 x_msg_count OUT NOCOPY Number,
78 x_msg_data OUT NOCOPY Varchar2,
79 x_warranty_tbl OUT NOCOPY War_tbl
80 ) ;
81
82 Procedure Update_Hdr_Amount
83 (
84 p_api_version IN Number,
85 p_init_msg_list IN Varchar2,
86 p_chr_id IN Number,
87 x_return_status OUT NOCOPY Varchar2,
88 x_msg_count OUT NOCOPY Number,
89 x_msg_data OUT NOCOPY Varchar2
90 ) ;
91
92
93
94 /*PROCEDURE SUBMIT_CONTACT_CREATION(ERRBUF OUT NOCOPY VARCHAR2,
95 RETCODE OUT NOCOPY NUMBER); */
96
97
98
99 PROCEDURE GET_OKS_RESOURCE (
100 p_party_id IN NUMBER,
101 x_return_status OUT NOCOPY Varchar2,
102 x_msg_count OUT NOCOPY Number,
103 x_msg_data OUT NOCOPY Varchar2,
104 x_winning_res_id OUT NOCOPY NUMBER, --l_salesrep_id,
105 x_winning_user_id OUT NOCOPY NUMBER
106 );
107 FUNCTION GET_PARTY_ID ( p_contract_id IN NUMBER) RETURN NUMBER;
108 FUNCTION GET_SALESREP_ID (p_resource_id IN Number,p_org_id IN Number ) RETURN NUMBER;
109
110
111 FUNCTION GET_RESOURCE_NAME (p_resource_id IN NUMBER) RETURN VARCHAR2;
112
113
114 FUNCTION GET_PARTY_NAME(p_party_id IN NUMBER) RETURN VARCHAR2;
115
116 PROCEDURE REASSIGNCONTACT (
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_contract_header_id IN NUMBER,
123 p_contract_number IN VARCHAR2,
124 p_contract_number_modifier IN VARCHAR2,
125 p_cro_code IN VARCHAR2,
126 p_salesrep_id IN NUMBER,
127 p_user_id IN NUMBER,
128 p_sales_group_id IN NUMBER
129 );
130 PROCEDURE DELETE_CONTACT (
131 x_return_status OUT NOCOPY VARCHAR2,
132 p_contact_id IN NUMBER
133 );
134
135 PROCEDURE CREATE_CONTACT(
136 x_return_status OUT NOCOPY VARCHAR2,
137 p_cpl_id IN NUMBER,
138 p_dnz_chr_id IN NUMBER,
139 p_cro_code IN VARCHAR2,
140 p_jtot_object1_code IN VARCHAR2,
141 p_object1_id1 IN NUMBER,
142 p_sales_group_id IN NUMBER
143 );
144
145 PROCEDURE SET_MSG (x_return_Status OUT Nocopy Varchar2, p_msg Varchar2);
146
147 PROCEDURE NOTIFY
148 (
149 p_type IN VARCHAR2,
150 p_notify_id IN Number,
151 p_chr_id IN Number,
152 p_contract_number IN VARCHAR2,
153 p_contract_number_modifier IN VARCHAR2,
154 p_mesg IN VARCHAR2);
155
156 FUNCTION GET_FND_MESSAGE RETURN VARCHAR2;
157 PROCEDURE NOTIFY_SETUP_ADMIN;
158 PROCEDURE NOTIFY_TERRITORY_ADMIN(p_chr_id IN Number, p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2,p_mesg IN VARCHAR2);
159 PROCEDURE NOTIFY_CONTRACT_ADMIN(p_chr_id IN Number, p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2,p_mesg IN VARCHAR2);
160 PROCEDURE NOTIFY_SALESREP(p_user_id IN NUMBER, p_chr_id IN Number,p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2,p_mesg IN VARCHAR2);
161
162 PROCEDURE LOG_MESSAGES(p_mesg IN VARCHAR2);
163
164
165 FUNCTION def_sts_code(p_ste_code VARCHAR2) RETURN VARCHAR2;
166 FUNCTION get_ste_code(p_sts_code VARCHAR2) RETURN VARCHAR2;
167
168 FUNCTION Create_Timevalue (p_chr_id IN NUMBER,p_start_date IN DATE)
169 RETURN NUMBER;
170
171 Procedure get_duration( p_line_start_date IN DATE,
172 p_line_end_date IN DATE,
173 x_line_duration OUT NOCOPY NUMBER,
174 x_line_timeunit OUT NOCOPY VARCHAR2,
175 x_return_status OUT NOCOPY VARCHAR2,
176 p_init_msg_list IN VARCHAR2);
177
178 PROCEDURE SUBMIT_CONTACT_CREATION(ERRBUF OUT NOCOPY VARCHAR2,
179 RETCODE OUT NOCOPY NUMBER,
180 p_contract_hdr_id IN NUMBER,
181 p_status_code IN VARCHAR2,
182 p_org_id IN NUMBER,
183 p_salesrep_id IN NUMBER );
184
185 END OKS_EXTWAR_UTIL_PUB;
186
187
188