eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_UBL_PVT dependencies on OKC_API

Line 7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ubn_rec_type IS RECORD (
7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,
8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ubn_rec_type IS RECORD (
7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,
8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE ubn_rec_type IS RECORD (
7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,
8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,

Line 10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

6: TYPE ubn_rec_type IS RECORD (
7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,
8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,

Line 11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

7: id OKC_USER_BINS.ID%TYPE, -- := OKC_API.G_MISS_NUM,
8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,

8: contract_id OKC_USER_BINS.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);

Line 13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,

9: contract_number OKC_USER_BINS.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
17:

Line 14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,

10: bin_type OKC_USER_BINS.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
17:
18: g_miss_ubn_rec ubn_rec_type;

Line 15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,

11: contract_type OKC_USER_BINS.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
17:
18: g_miss_ubn_rec ubn_rec_type;
19:

Line 16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);

12: program_name OKC_USER_BINS.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
13: created_by OKC_USER_BINS.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
14: creation_date OKC_USER_BINS.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
15: contract_number_modifier OKC_USER_BINS.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
16: short_description OKC_USER_BINS.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
17:
18: g_miss_ubn_rec ubn_rec_type;
19:
20: TYPE ubn_tbl_type IS TABLE OF ubn_rec_type

Line 24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,

20: TYPE ubn_tbl_type IS TABLE OF ubn_rec_type
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,

21: INDEX BY BINARY_INTEGER;
22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,

22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,

Line 27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,

Line 28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,

24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,

Line 29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,

25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);

Line 30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,

26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:

Line 31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,

27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;

Line 32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,

28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;
36:

Line 33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);

29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;
36:
37: TYPE ubnv_tbl_type IS TABLE OF ubnv_rec_type

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

38: INDEX BY BINARY_INTEGER;
39: ---------------------------------------------------------------------------
40: -- GLOBAL MESSAGE CONSTANTS
41: ---------------------------------------------------------------------------
42: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

39: ---------------------------------------------------------------------------
40: -- GLOBAL MESSAGE CONSTANTS
41: ---------------------------------------------------------------------------
42: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

40: -- GLOBAL MESSAGE CONSTANTS
41: ---------------------------------------------------------------------------
42: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

41: ---------------------------------------------------------------------------
42: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

42: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
52: ---------------------------------------------------------------------------

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

45: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
52: ---------------------------------------------------------------------------
53: -- GLOBAL VARIABLES

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

46: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
52: ---------------------------------------------------------------------------
53: -- GLOBAL VARIABLES
54: ---------------------------------------------------------------------------

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

47: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
52: ---------------------------------------------------------------------------
53: -- GLOBAL VARIABLES
54: ---------------------------------------------------------------------------
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_UBL_PVT';

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

52: ---------------------------------------------------------------------------
53: -- GLOBAL VARIABLES
54: ---------------------------------------------------------------------------
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_UBL_PVT';
56: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: ---------------------------------------------------------------------------
58: -- Procedures and Functions
59: ---------------------------------------------------------------------------
60:

Line 66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

62: PROCEDURE change_version;
63: PROCEDURE api_copy;
64: PROCEDURE insert_row(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_ubnv_rec IN ubnv_rec_type,

Line 75: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

71: x_ubnv_rec OUT NOCOPY ubnv_rec_type);
72:
73: PROCEDURE insert_row(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_ubnv_tbl IN ubnv_tbl_type,

Line 84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

80: x_ubnv_tbl OUT NOCOPY ubnv_tbl_type);
81:
82: PROCEDURE lock_row(
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_ubnv_rec IN ubnv_rec_type);

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: p_ubnv_rec IN ubnv_rec_type);
89:
90: PROCEDURE lock_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_ubnv_tbl IN ubnv_tbl_type);

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96: p_ubnv_tbl IN ubnv_tbl_type);
97:
98: PROCEDURE update_row(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_ubnv_rec IN ubnv_rec_type,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

105: x_ubnv_rec OUT NOCOPY ubnv_rec_type);
106:
107: PROCEDURE update_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_ubnv_tbl IN ubnv_tbl_type,

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

114: x_ubnv_tbl OUT NOCOPY ubnv_tbl_type);
115:
116: PROCEDURE delete_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_ubnv_rec IN ubnv_rec_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122: p_ubnv_rec IN ubnv_rec_type);
123:
124: PROCEDURE delete_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_ubnv_tbl IN ubnv_tbl_type);

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

130: p_ubnv_tbl IN ubnv_tbl_type);
131:
132: PROCEDURE validate_row(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_ubnv_rec IN ubnv_rec_type);

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

138: p_ubnv_rec IN ubnv_rec_type);
139:
140: PROCEDURE validate_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_ubnv_tbl IN ubnv_tbl_type);