DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PUB dependencies on OKC_CONTRACT_PUB

Line 10: subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;

6: subtype cle_rec_type is oke_contract_pvt.cle_rec_type;
7: subtype cle_tbl_type is oke_contract_pvt.cle_tbl_type;
8: subtype del_rec_type is oke_deliverable_pvt.del_rec_type;
9: subtype del_tbl_type is oke_deliverable_pvt.del_tbl_type;
10: subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;
11: subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;
12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14:

Line 11: subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;

7: subtype cle_tbl_type is oke_contract_pvt.cle_tbl_type;
8: subtype del_rec_type is oke_deliverable_pvt.del_rec_type;
9: subtype del_tbl_type is oke_deliverable_pvt.del_tbl_type;
10: subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;
11: subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;
12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PUB';

Line 12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;

8: subtype del_rec_type is oke_deliverable_pvt.del_rec_type;
9: subtype del_tbl_type is oke_deliverable_pvt.del_tbl_type;
10: subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;
11: subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;
12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PUB';
16: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;

Line 13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;

9: subtype del_tbl_type is oke_deliverable_pvt.del_tbl_type;
10: subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;
11: subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;
12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PUB';
16: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
17:

Line 33: p_chrv_rec IN okc_contract_pub.chrv_rec_type,

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_chr_rec IN oke_chr_pvt.chr_rec_type,
33: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
34: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
35: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
36:
37: PROCEDURE create_contract_header(

Line 35: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);

31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_chr_rec IN oke_chr_pvt.chr_rec_type,
33: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
34: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
35: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
36:
37: PROCEDURE create_contract_header(
38:
39: p_api_version IN NUMBER,

Line 46: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,

42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44:
45: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
46: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
47: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
48: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
49:
50: PROCEDURE update_contract_header(

Line 48: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);

44:
45: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
46: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
47: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
48: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
49:
50: PROCEDURE update_contract_header(
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 58: p_chrv_rec IN okc_contract_pub.chrv_rec_type,

54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
57: p_chr_rec IN oke_chr_pvt.chr_rec_type,
58: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
59:
60: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
61: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
62:

Line 61: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);

57: p_chr_rec IN oke_chr_pvt.chr_rec_type,
58: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
59:
60: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
61: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
62:
63: PROCEDURE update_contract_header(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 71: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,

67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
70: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
71: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
72:
73: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
74: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
75:

Line 74: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);

70: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
71: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
72:
73: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
74: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
75:
76: PROCEDURE delete_contract_header(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 83: p_chrv_rec IN okc_contract_pub.chrv_rec_type);

79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_chr_rec IN oke_chr_pvt.chr_rec_type,
83: p_chrv_rec IN okc_contract_pub.chrv_rec_type);
84:
85: PROCEDURE delete_contract_header(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 92: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);

88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
92: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);
93:
94:
95:
96: PROCEDURE validate_contract_header(

Line 103: p_chrv_rec IN okc_contract_pub.chrv_rec_type);

99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_chr_rec IN oke_chr_pvt.chr_rec_type,
103: p_chrv_rec IN okc_contract_pub.chrv_rec_type);
104:
105: PROCEDURE validate_contract_header(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 112: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);

108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
112: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);
113:
114: PROCEDURE create_contract_line(
115:
116: p_api_version IN NUMBER,

Line 123: p_clev_rec IN okc_contract_pub.clev_rec_type,

119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
122: p_cle_rec IN oke_cle_pvt.cle_rec_type,
123: p_clev_rec IN okc_contract_pub.clev_rec_type,
124: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
125: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
126:
127: PROCEDURE create_contract_line(

Line 125: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);

121: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
122: p_cle_rec IN oke_cle_pvt.cle_rec_type,
123: p_clev_rec IN okc_contract_pub.clev_rec_type,
124: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
125: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
126:
127: PROCEDURE create_contract_line(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 135: p_clev_tbl IN okc_contract_pub.clev_tbl_type,

131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
134: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
135: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
136: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
137: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
138:
139: PROCEDURE update_contract_line(

Line 137: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);

133: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
134: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
135: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
136: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
137: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
138:
139: PROCEDURE update_contract_line(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 147: p_clev_rec IN okc_contract_pub.clev_rec_type,

143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
146: p_cle_rec IN oke_cle_pvt.cle_rec_type,
147: p_clev_rec IN okc_contract_pub.clev_rec_type,
148:
149: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
150: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
151:

Line 150: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);

146: p_cle_rec IN oke_cle_pvt.cle_rec_type,
147: p_clev_rec IN okc_contract_pub.clev_rec_type,
148:
149: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
150: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
151:
152: PROCEDURE update_contract_line(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 160: p_clev_tbl IN okc_contract_pub.clev_tbl_type,

156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
159: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
160: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
161:
162: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
163: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
164:

Line 163: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);

159: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
160: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
161:
162: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
163: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
164:
165: PROCEDURE delete_contract_line(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 172: p_clev_rec IN okc_contract_pub.clev_rec_type);

168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_cle_rec IN oke_cle_pvt.cle_rec_type,
172: p_clev_rec IN okc_contract_pub.clev_rec_type);
173:
174: PROCEDURE delete_contract_line(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 181: p_clev_tbl IN okc_contract_pub.clev_tbl_type);

177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
181: p_clev_tbl IN okc_contract_pub.clev_tbl_type);
182:
183: PROCEDURE delete_contract_line(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 199: p_clev_rec IN okc_contract_pub.clev_rec_type);

195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cle_rec IN oke_cle_pvt.cle_rec_type,
199: p_clev_rec IN okc_contract_pub.clev_rec_type);
200:
201: PROCEDURE validate_contract_line(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 208: p_clev_tbl IN okc_contract_pub.clev_tbl_type);

204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
208: p_clev_tbl IN okc_contract_pub.clev_tbl_type);
209:
210: PROCEDURE create_deliverable(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,