DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_CTC_PVT

Line 2546: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chrid,

2542: SET sts_code = l_sts_code
2543: WHERE ID = l_chrid;
2544: /*bugfix for 6882512*/
2545: /* Updating the status in okc_contacts table.*/
2546: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chrid,
2547: x_return_status=>l_return_status);
2548:
2549: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2550: RAISE g_exception_halt_validation;

Line 12801: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,

12797: date_signed = NULL
12798: WHERE ID = l_merge_chr_id;
12799: /*bugfix for 6882512*/
12800: /*update status in okc_contacts table*/
12801: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,
12802: x_return_status=>l_return_status);
12803:
12804: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
12805: RAISE g_exception_halt_validation;

Line 13345: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,

13341: date_signed = NULL
13342: WHERE ID = l_merge_chr_id;
13343: /*bugfix for 6882512*/
13344: /*update status in okc_contacts table*/
13345: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,
13346: x_return_status=>l_return_status);
13347: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13348: RAISE g_exception_halt_validation;
13349: END IF;

Line 13892: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chr_id,

13888: date_signed = NULL
13889: WHERE ID = l_chr_id;
13890: /* bugfix for 6882512*/
13891: /*update status in okc_contacts table*/
13892: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chr_id,
13893: x_return_status=>l_return_status);
13894:
13895: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13896: RAISE g_exception_halt_validation;