DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on OKC_API

Line 9: contract_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 10: line_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,

Line 11: subline_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),

Line 12: operation_lines_id NUMBER := OKC_API.G_MISS_NUM,

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));

Line 13: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,

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:

Line 14: oie_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;

Line 32: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 33: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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:

Line 34: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 35: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 36: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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';

Line 40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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';

Line 41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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';

Line 42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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';

Line 57: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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';

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,