[Home] [Help]
PACKAGE: APPS.OKS_INTEGRATION_UTIL_PUB
Source
1 Package OKS_INTEGRATION_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSRIUTS.pls 120.0 2005/05/25 18:32:12 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
16
17 ------------------------------------------------------------------------------------
18 -- GLOBAL EXCEPTION
19 ---------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21
22 -- GLOBAL VARIABLES
23 ---------------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKSOMINT';
25 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
26
27 G_JTF_ORDER_HDR CONSTANT VARCHAR2(200) := 'OKX_ORDERHEAD';
28 G_JTF_ORDER_LN CONSTANT VARCHAR2(200) := 'OKX_ORDERLINE';
29
30 G_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'BILLING';
31 G_RULE_GROUP_CODE CONSTANT VARCHAR2(200) := 'SVC_K';
32
33 G_JTF_EXTWARR CONSTANT VARCHAR2(200) := 'OKX_SERVICE';
34 G_JTF_WARR CONSTANT VARCHAR2(200) := 'OKX_WARRANTY';
35 G_JTF_PARTY CONSTANT VARCHAR2(200) := 'OKX_PARTY';
36 G_JTF_PARTY_VENDOR CONSTANT VARCHAR2(200) := 'OKX_OPERUNIT';
37 G_JTF_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'OKX_PCONTACT';
38 G_JTF_BILLTO CONSTANT VARCHAR2(200) := 'OKX_BILLTO';
39 G_JTF_SHIPTO CONSTANT VARCHAR2(200) := 'OKX_SHIPTO';
40 G_JTF_ARL CONSTANT VARCHAR2(200) := 'OKX_ACCTRULE';
41 G_JTF_IRE CONSTANT VARCHAR2(200) := 'OKX_INVRULE';
42 G_JTF_CUSTPROD CONSTANT VARCHAR2(200) := 'OKX_CUSTPROD';
43 G_JTF_CUSTACCT CONSTANT VARCHAR2(200) := 'OKX_CUSTACCT';
44 G_JTF_PRICE CONSTANT VARCHAR2(200) := 'OKX_PRICE';
45 G_JTF_PAYMENT_TERM CONSTANT VARCHAR2(200) := 'OKX_PPAYTERM';
46 G_JTF_CONV_TYPE CONSTANT VARCHAR2(200) := 'OKX_CONVTYPE';
47
48 ---------------------------------------------------------------------------
49
50
51 Procedure Create_K_Order_Details
52 (
53 p_header_id IN NUMBER
54 , x_return_status OUT NOCOPY Varchar2
55 , x_msg_count OUT NOCOPY Number
56 , x_msg_data OUT NOCOPY Varchar2
57 );
58
59 -------------- Procedures for fixing date format ------------------------
60
61 PROCEDURE Get_Dates(p_from_id IN Number DEFAULT NULL,
62 p_to_id IN Number DEFAULT NULL
63 );
64
65 /**
66 PROCEDURE Convert_Dates(p_category_code IN VARCHAR2,
67 p_format IN VARCHAR2,
68 p_date IN VARCHAR2,
69 p_rule_num IN NUMBER,
70 p_rule_id IN NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER
74 );
75 ***/
76
77 Procedure Debug_Log(p_error_msg IN VARCHAR2 DEFAULT NULL,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82 -- Added for performance tuning
83 procedure upgrade_rule_dates(x_return_status out NOCOPY varchar2);
84
85 -- Added for performance tuning
86 function generate_ranges (
87 p_lo number,
88 p_hi number,
89 p_avg number,
90 p_stddev number,
91 p_total number) return integer;
92
93 End OKS_INTEGRATION_UTIL_PUB;