[Home] [Help]
PACKAGE: APPS.OKL_AM_SERVICE_K_INT_WF
Source
1 PACKAGE OKL_AM_SERVICE_K_INT_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRKWFS.pls 115.1 2003/12/24 01:12:23 rmunjulu noship $ */
3
4
5 ---------------------------------------------------------------------------
6 -- GLOBAL VARIABLES
7 ---------------------------------------------------------------------------
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_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SERVICE_K_INT_WF';
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15 G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19 G_API_VERSION CONSTANT NUMBER := 1;
20 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
25
26 -- Rec Type and Tbl Type to store Asset Schedule details
27 TYPE kle_rec_type IS RECORD (
28 asset_number OKC_K_LINES_TL.name%TYPE,
29 item_number OKC_K_LINES_B.line_number%TYPE,
30 item_description OKC_K_LINES_TL.item_description%TYPE,
31 install_base_number CSI_ITEM_INSTANCES.instance_number%TYPE,
32 serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
33 asset_quantity CSI_ITEM_INSTANCES.quantity%TYPE);
34
35 TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER;
36
37 ---------------------------------------------------------------------------
38 -- PROCEDURES
39 ---------------------------------------------------------------------------
40
41 PROCEDURE get_assets_schedule (
42 p_kle_id IN NUMBER,
43 x_asset_schedule_tbl OUT NOCOPY kle_tbl_type);
44
45 PROCEDURE get_assets_schedule (
46 p_khr_id IN NUMBER,
47 p_quote_id IN NUMBER,
48 x_asset_schedule_tbl OUT NOCOPY kle_tbl_type);
49
50 PROCEDURE raise_service_k_int_event (
51 p_transaction_id IN VARCHAR2,
52 p_source IN VARCHAR2,
53 p_quote_id IN VARCHAR2 DEFAULT NULL,
54 p_oks_contract IN VARCHAR2 DEFAULT NULL, --RMUNJULU 23-DEC-03 SERVICE K UPDATES
55 p_transaction_date IN DATE);
56
57 PROCEDURE populate_attributes(
58 itemtype IN VARCHAR2,
59 itemkey IN VARCHAR2,
60 actid IN NUMBER,
61 funcmode IN VARCHAR2,
62 resultout OUT NOCOPY VARCHAR2);
63
64 PROCEDURE pop_return_noti_dtls(
65 document_id IN VARCHAR2,
66 display_type IN VARCHAR2,
67 document IN OUT NOCOPY VARCHAR2,
68 document_type IN OUT NOCOPY VARCHAR2);
69
70 PROCEDURE pop_dispose_noti_dtls(
71 document_id IN VARCHAR2,
72 display_type IN VARCHAR2,
73 document IN OUT NOCOPY VARCHAR2,
74 document_type IN OUT NOCOPY VARCHAR2);
75
76 PROCEDURE pop_term_noti_dtls(
77 document_id IN VARCHAR2,
78 display_type IN VARCHAR2,
79 document IN OUT NOCOPY VARCHAR2,
80 document_type IN OUT NOCOPY VARCHAR2);
81
82 PROCEDURE pop_delink_err_noti_dtls(
83 document_id IN VARCHAR2,
84 display_type IN VARCHAR2,
85 document IN OUT NOCOPY VARCHAR2,
86 document_type IN OUT NOCOPY VARCHAR2);
87
88 PROCEDURE pop_delink_noti_dtls(
89 document_id IN VARCHAR2,
90 display_type IN VARCHAR2,
91 document IN OUT NOCOPY VARCHAR2,
92 document_type IN OUT NOCOPY VARCHAR2);
93
94 PROCEDURE check_source(
95 itemtype IN VARCHAR2,
96 itemkey IN VARCHAR2,
97 actid IN NUMBER,
98 funcmode IN VARCHAR2,
99 resultout OUT NOCOPY VARCHAR2);
100
101 END OKL_AM_SERVICE_K_INT_WF;