[Home] [Help]
PACKAGE: APPS.OKS_UTIL_PUB
Source
1 Package OKS_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSUTPRS.pls 120.3 2006/03/13 16:46:20 jakuruvi noship $ */
3
4 G_PRODUCT_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR;
5 G_VALIDATE_FLAG boolean :=TRUE;
6 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_RENEW_UNEXPECTED_ERROR';
7 G_EXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_RENEW_ERROR';
8 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12
13 G_APP_ID CONSTANT NUMBER := 515;
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_UTIL_PUB';
15
16 PROCEDURE get_valueset_id(p_flexfield_name In varchar2,
17 p_context IN VARCHAR2 ,
18 p_seg IN VARCHAR2 ,
19 x_vsid OUT NOCOPY number,
20 x_format_type OUT NOCOPY varchar2,
21 x_validation_type OUT NOCOPY VARCHAR2
22 );
23 PROCEDURE validate_oks_flexfield(flexfield_name IN VARCHAR2,
24 context IN VARCHAR2,
25 attribute IN VARCHAR2,
26 value IN VARCHAR2,
27 application_short_name IN VARCHAR2,
28 context_flag OUT NOCOPY VARCHAR2,
29 attribute_flag OUT NOCOPY VARCHAR2,
30 value_flag OUT NOCOPY VARCHAR2,
31 datatype OUT NOCOPY VARCHAR2,
32 precedence OUT NOCOPY VARCHAR2,
33 error_code OUT NOCOPY NUMBER ,
34 check_enabled IN BOOLEAN := TRUE);
35
36 FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
37 p_value VARCHAR2,
38 x_id OUT NOCOPY VARCHAR2,
39 x_value OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
40
41 FUNCTION Get_OKS_Status
42 RETURN VARCHAR2;
43
44 FUNCTION Resp_Org_id RETURN NUMBER;
45
46 PROCEDURE UPDATE_CONTACTS_SALESGROUP
47 ( ERRBUF OUT NOCOPY VARCHAR2,
48 RETCODE OUT NOCOPY NUMBER,
49 P_CONTRACT_ID IN NUMBER,
50 P_GROUP_ID IN NUMBER);
51
52 FUNCTION get_line_name( p_lty_code IN VARCHAR2,
53 p_object1_id1 IN VARCHAR2,
54 p_object1_id2 IN VARCHAR2 ) RETURN VARCHAR2;
55
56 FUNCTION get_line_name( p_subline_id IN NUMBER ) RETURN VARCHAR2;
57
58 Procedure create_transaction_extension(P_Api_Version IN NUMBER
59 ,P_Init_Msg_List IN VARCHAR2
60 ,P_Header_ID IN NUMBER
61 ,P_Line_ID IN NUMBER
62 ,P_Source_Trx_Ext_ID IN NUMBER
63 ,P_Cust_Acct_ID IN NUMBER
64 ,P_Bill_To_Site_Use_ID IN NUMBER
65 ,x_entity_id OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_return_status OUT NOCOPY VARCHAR2);
69
70 END; -- Package Specification OKS_UTIL