DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PARTY_PVT dependencies on OKC_CVM_PVT

Line 31: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_ctcv_rec IN ctcv_rec_type,
29: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
30: --V
31: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
32: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
33: --V
34: begin
35: okc_ctc_pvt.insert_row(p_api_version => p_api_version,

Line 32: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

28: p_ctcv_rec IN ctcv_rec_type,
29: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
30: --V
31: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
32: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
33: --V
34: begin
35: okc_ctc_pvt.insert_row(p_api_version => p_api_version,
36: p_init_msg_list => p_init_msg_list,

Line 47: OKC_CVM_PVT.update_contract_version(

43: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
44: return;
45: end if;
46: l_cvmv_rec.chr_id := p_ctcv_rec.DNZ_CHR_ID;
47: OKC_CVM_PVT.update_contract_version(
48: p_api_version => p_api_version,
49: p_init_msg_list => OKC_API.G_FALSE,
50: x_return_status => x_return_status,
51: x_msg_count => x_msg_count,

Line 74: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_ctcv_rec IN ctcv_rec_type,
72: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
73: --V
74: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
75: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
76: cursor dnz_csr is
77: select dnz_chr_id
78: from OKC_CONTACTS_V

Line 75: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

71: p_ctcv_rec IN ctcv_rec_type,
72: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
73: --V
74: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
75: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
76: cursor dnz_csr is
77: select dnz_chr_id
78: from OKC_CONTACTS_V
79: where id = p_ctcv_rec.id;

Line 96: OKC_CVM_PVT.update_contract_version(

92: end if;
93: open dnz_csr;
94: fetch dnz_csr into l_cvmv_rec.chr_id;
95: close dnz_csr;
96: OKC_CVM_PVT.update_contract_version(
97: p_api_version => p_api_version,
98: p_init_msg_list => OKC_API.G_FALSE,
99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,

Line 122: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_ctcv_rec IN ctcv_rec_type) is
121: --V
122: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
123: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
124: cursor dnz_csr is
125: select dnz_chr_id
126: from OKC_contacts_V

Line 123: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_ctcv_rec IN ctcv_rec_type) is
121: --V
122: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
123: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
124: cursor dnz_csr is
125: select dnz_chr_id
126: from OKC_contacts_V
127: where id = p_ctcv_rec.id;

Line 149: OKC_CVM_PVT.update_contract_version(

145: --V
146: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
147: return;
148: end if;
149: OKC_CVM_PVT.update_contract_version(
150: p_api_version => p_api_version,
151: p_init_msg_list => OKC_API.G_FALSE,
152: x_return_status => x_return_status,
153: x_msg_count => x_msg_count,

Line 222: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_cplv_rec IN cplv_rec_type,
220: x_cplv_rec OUT NOCOPY cplv_rec_type) is
221: --V
222: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
223: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
224: --V
225: begin
226: okc_cpl_pvt.insert_row(p_api_version => p_api_version,

Line 223: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

219: p_cplv_rec IN cplv_rec_type,
220: x_cplv_rec OUT NOCOPY cplv_rec_type) is
221: --V
222: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
223: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
224: --V
225: begin
226: okc_cpl_pvt.insert_row(p_api_version => p_api_version,
227: p_init_msg_list => p_init_msg_list,

Line 238: OKC_CVM_PVT.update_contract_version(

234: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
235: return;
236: end if;
237: l_cvmv_rec.chr_id := p_cplv_rec.DNZ_CHR_ID;
238: OKC_CVM_PVT.update_contract_version(
239: p_api_version => p_api_version,
240: p_init_msg_list => OKC_API.G_FALSE,
241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,

Line 288: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_cplv_rec IN cplv_rec_type,
286: x_cplv_rec OUT NOCOPY cplv_rec_type) is
287: --V
288: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
289: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
290: cursor dnz_csr is
291: select dnz_chr_id
292: from OKC_K_PARTY_ROLES_B

Line 289: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

285: p_cplv_rec IN cplv_rec_type,
286: x_cplv_rec OUT NOCOPY cplv_rec_type) is
287: --V
288: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
289: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
290: cursor dnz_csr is
291: select dnz_chr_id
292: from OKC_K_PARTY_ROLES_B
293: where id = p_cplv_rec.id;

Line 310: OKC_CVM_PVT.update_contract_version(

306: end if;
307: open dnz_csr;
308: fetch dnz_csr into l_cvmv_rec.chr_id;
309: close dnz_csr;
310: OKC_CVM_PVT.update_contract_version(
311: p_api_version => p_api_version,
312: p_init_msg_list => OKC_API.G_FALSE,
313: x_return_status => x_return_status,
314: x_msg_count => x_msg_count,

Line 341: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

337: select 'x'
338: from OKC_CONTACTS_V
339: where CPL_id = p_cplv_rec.id;
340: --V
341: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
342: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
343: cursor dnz_csr is
344: select dnz_chr_id
345: from OKC_K_PARTY_ROLES_B

Line 342: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

338: from OKC_CONTACTS_V
339: where CPL_id = p_cplv_rec.id;
340: --V
341: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
342: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
343: cursor dnz_csr is
344: select dnz_chr_id
345: from OKC_K_PARTY_ROLES_B
346: where id = p_cplv_rec.id;

Line 377: OKC_CVM_PVT.update_contract_version(

373: --V
374: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
375: return;
376: end if;
377: OKC_CVM_PVT.update_contract_version(
378: p_api_version => p_api_version,
379: p_init_msg_list => OKC_API.G_FALSE,
380: x_return_status => x_return_status,
381: x_msg_count => x_msg_count,