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_USER_BINS

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