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,
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,
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),
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));
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:
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;
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;
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:
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;
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;
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;
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;
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';
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';
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';
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';
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';
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,