[Home] [Help]
PACKAGE: APPS.OKS_RENCON_PVT
Source
1 PACKAGE OKS_RENCON_PVT AS
2 /* $Header: OKSRENCS.pls 120.3.12000000.1 2007/01/16 22:10:21 appldev ship $*/
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7
8 TYPE sources_rec_type IS RECORD (
9 contract_id NUMBER := OKC_API.G_MISS_NUM,
10 line_id NUMBER := OKC_API.G_MISS_NUM,
11 subline_id NUMBER := OKC_API.G_MISS_NUM,
12 operation_lines_id NUMBER := OKC_API.G_MISS_NUM,
13 parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
14 oie_id NUMBER := OKC_API.G_MISS_NUM,
15 select_yn VARCHAR2(3),
16 ol_status VARCHAR2(200));
17
18 TYPE sources_tbl_type IS TABLE OF sources_rec_type INDEX BY BINARY_INTEGER;
19
20 TYPE merge_rec_type IS RECORD (
21 line_id NUMBER,
22 inventory_item_id VARCHAR2(200),
23 inv_organization_id VARCHAR2(200),
24 lrt_rule VARCHAR2(200),
25 bto_id VARCHAR2(200),
26 start_date DATE,
27 end_date DATE);
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL MESSAGE CONSTANTS
31 ---------------------------------------------------------------------------
32 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
33 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
34 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
35 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
36 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
37
38 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
46 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
47 G_PROGRAM_NAME CONSTANT VARCHAR2(200) := 'OKS_RENCON_PVT';
48 G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
49
50 ---------------------------------------------------------------------------
51 -- GLOBAL VARIABLES
52 ---------------------------------------------------------------------------
53 G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
54 G_PROGRAM_APPLICATION_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
55 G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
56 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_RENCON_PVT';
57 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
58 G_NOT_SELECTED CONSTANT VARCHAR2(200) := 'NOT_SELECTED';
59 G_SELECTED CONSTANT VARCHAR2(200) := 'SELECTED';
60 G_PROCESSED CONSTANT VARCHAR2(200) := 'PROCESSED';
61 G_REJECTED CONSTANT VARCHAR2(200) := 'REJECTED';
62 G_INVALID_OL CONSTANT VARCHAR2(200) := 'INVALID_OL';
63 G_OI_STATUS_CODE CONSTANT VARCHAR2(200) := 'ENTERED';
64 G_TARGET_VALID CONSTANT VARCHAR2(200) := 'C';
65 G_TARGET_INVALID CONSTANT VARCHAR2(200) := 'S';
66
67 ---------------------------------------------------------------------------
68 -- GLOBAL VARIABLES
69 ---------------------------------------------------------------------------
70 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
71
72 ---------------------------------------------------------------------------
73 -- Procedures and Functions
74 ---------------------------------------------------------------------------
75
76 PROCEDURE GET_VALID_OPER_LINE_SOURCES (p_target_id IN NUMBER,
77 x_sources_tbl OUT NOCOPY sources_tbl_type,
78 x_return_status OUT NOCOPY VARCHAR2,
79 p_conc_program IN VARCHAR2,
80 p_select_yn IN VARCHAR2 DEFAULT 'N');
81
82 PROCEDURE GET_VALID_LINE_SOURCES (p_target_id IN NUMBER,
83 x_sources_tbl OUT NOCOPY sources_tbl_type,
84 x_return_status OUT NOCOPY VARCHAR2,
85 p_conc_program IN VARCHAR2,
86 p_select_yn IN VARCHAR2 DEFAULT 'N');
87
88 PROCEDURE CREATE_OPERATION_INSTANCES (p_target_chr_id IN NUMBER,
89 p_oie_id out NOCOPY NUMBER);
90
91 PROCEDURE CREATE_OPERATION_LINES (p_target_chr_id IN NUMBER,
92 p_oie_id IN NUMBER,
93 p_sources_tbl_type IN OUT NOCOPY OKS_RENCON_PVT.sources_tbl_type,
94 p_select_yn IN VARCHAR2 DEFAULT 'N');
95
96 FUNCTION FIND_OL_STATUS(p_object_cle_id IN NUMBER) RETURN VARCHAR2;
97
98 FUNCTION IS_VALID_TARGET(p_target_id IN NUMBER) RETURN BOOLEAN;
99
100 FUNCTION GET_PARENT_LINE_ID(p_parent_ole_id IN NUMBER) RETURN NUMBER;
101
102 FUNCTION GET_LRT_RULE(p_line_id IN NUMBER) RETURN VARCHAR2;
103
104 PROCEDURE GET_LINE_DETAILS(p_line_id IN NUMBER, x_line_details OUT NOCOPY OKS_RENCON_PVT.merge_rec_type);
105
106 FUNCTION MERGE_ELIGIBLE_YN(p_source_line_details IN OKS_RENCON_PVT.merge_rec_type,
107 p_target_line_details IN OKS_RENCON_PVT.merge_rec_type) RETURN VARCHAR2;
108
109 PROCEDURE MERGE(p_source_line_id IN NUMBER,
110 p_target_contract_id IN NUMBER,
111 x_target_line_id OUT NOCOPY NUMBER);
112
113 PROCEDURE SUBMIT_CONC(ERRBUF OUT NOCOPY VARCHAR2,
114 RETCODE OUT NOCOPY NUMBER,
115 p_oie_id IN NUMBER);
116
117 FUNCTION SUBMIT_FORM_CONC(p_oie_id IN NUMBER) RETURN NUMBER;
118
119 PROCEDURE SUBMIT(ERRBUF OUT NOCOPY VARCHAR2,
120 RETCODE OUT NOCOPY NUMBER,
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_conc_program IN VARCHAR2,
127 p_oie_id IN NUMBER);
128
129 PROCEDURE UPDATE_CONTRACT_AMOUNT(p_header_id IN NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2);
131
132
133 PROCEDURE LOG_MESSAGES(p_mesg IN VARCHAR2);
134
135 END OKS_RENCON_PVT;