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_K_REL_OBJS_PUB dependencies on OKC_K_REL_OBJS

Line 1: Package OKC_K_REL_OBJS_PUB AS

1: Package OKC_K_REL_OBJS_PUB AS
2: /* $Header: OKCPCRJS.pls 120.0 2005/05/25 18:38:20 appldev noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------

Line 33: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

29: */
30: TYPE crj_rel_hdr_rec_type IS RECORD -- all contract and object (and line) data for rel. create
31: /* (
32: chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
34: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
35: )
36: */ (
37: chr_id NUMBER

Line 34: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

30: TYPE crj_rel_hdr_rec_type IS RECORD -- all contract and object (and line) data for rel. create
31: /* (
32: chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
34: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
35: )
36: */ (
37: chr_id NUMBER
38: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

Line 38: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

34: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
35: )
36: */ (
37: chr_id NUMBER
38: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
39: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
40: )
41: ;
42: g_miss_crj_rel_hdr_rec crj_rel_hdr_rec_type;

Line 39: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE

35: )
36: */ (
37: chr_id NUMBER
38: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
39: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
40: )
41: ;
42: g_miss_crj_rel_hdr_rec crj_rel_hdr_rec_type;
43:

Line 47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

43:
44: TYPE crj_rel_hdr_full_rec_type IS RECORD -- all contract and object (and line) data for rel. create
45: /* (
46: chr_id NUMBER := OKC_API.G_MISS_NUM
47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

44: TYPE crj_rel_hdr_full_rec_type IS RECORD -- all contract and object (and line) data for rel. create
45: /* (
46: chr_id NUMBER := OKC_API.G_MISS_NUM
47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: )

Line 49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR

45: /* (
46: chr_id NUMBER := OKC_API.G_MISS_NUM
47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: )
53: */ (

Line 50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR

46: chr_id NUMBER := OKC_API.G_MISS_NUM
47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: )
53: */ (
54: chr_id NUMBER

Line 51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR

47: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
48: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
49: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
50: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: )
53: */ (
54: chr_id NUMBER
55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

Line 55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

51: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
52: )
53: */ (
54: chr_id NUMBER
55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE

Line 56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE

52: )
53: */ (
54: chr_id NUMBER
55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE
60: )

Line 57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE

53: */ (
54: chr_id NUMBER
55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE
60: )
61: ;

Line 58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE

54: chr_id NUMBER
55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE
60: )
61: ;
62: g_miss_crj_rel_hdr_full_rec crj_rel_hdr_full_rec_type;

Line 59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE

55: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
56: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
57: ,jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
58: ,line_jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE
59: ,rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE
60: )
61: ;
62: g_miss_crj_rel_hdr_full_rec crj_rel_hdr_full_rec_type;
63:

Line 67: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

63:
64: TYPE crj_rel_line_rec_type IS RECORD -- of contract and related object lines
65: /* (
66: cle_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: )
70: */ (
71: cle_id NUMBER

Line 68: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

64: TYPE crj_rel_line_rec_type IS RECORD -- of contract and related object lines
65: /* (
66: cle_id NUMBER := OKC_API.G_MISS_NUM
67: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: )
70: */ (
71: cle_id NUMBER
72: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

Line 72: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE

68: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69: )
70: */ (
71: cle_id NUMBER
72: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
73: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
74: )
75: ;
76: g_miss_crj_rel_line_rec crj_rel_line_rec_type;

Line 73: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE

69: )
70: */ (
71: cle_id NUMBER
72: ,object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE
73: ,object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE
74: )
75: ;
76: g_miss_crj_rel_line_rec crj_rel_line_rec_type;
77: TYPE crj_rel_line_tbl_type IS TABLE OF crj_rel_line_rec_type INDEX BY BINARY_INTEGER;

Line 103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_REL_OBJS_PUB';

99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_REL_OBJS_PUB';
104: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
105: ---------------------------------------------------------------------------
106: -- Procedures and Functions
107: ---------------------------------------------------------------------------

Line 177: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE

173: ,x_msg_count OUT NOCOPY NUMBER
174: ,x_msg_data OUT NOCOPY VARCHAR2
175: ,p_crj_rel_hdr_rec IN crj_rel_hdr_rec_type
176: ,p_crj_rel_line_tbl IN crj_rel_line_tbl_type
177: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
178: ,x_crj_rel_hdr_rec OUT NOCOPY crj_rel_hdr_rec_type
179: ,x_crj_rel_line_tbl OUT NOCOPY crj_rel_line_tbl_type
180: );
181:

Line 412: END OKC_K_REL_OBJS_PUB;

408: ,p_crjv_rec IN crjv_rec_type
409: ,x_true_false out nocopy varchar2
410: );
411:
412: END OKC_K_REL_OBJS_PUB;