DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_CONTACTS

Line 5104: /*update status in okc_contacts table*/

5100: date_signed = NULL
5101: WHERE ID = qa_contract_id ;
5102:
5103: /* cgopinee bugfix for 6882512*/
5104: /*update status in okc_contacts table*/
5105: OKC_CTC_PVT.update_contact_stecode(p_chr_id => qa_contract_id,
5106: x_return_status=>l_return_status);
5107:
5108: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 8123: UPDATE okc_contacts

8119:
8120: --Update status in contacts table
8121: /*cgopinee bugfix for 6882512*/
8122: FORALL i IN 1 .. header_id.COUNT
8123: UPDATE okc_contacts
8124: SET dnz_ste_code =get_ste_code(get_status (Hdr_new_Sdate(i), Hdr_new_edate(i)))
8125: WHERE dnz_chr_id=header_id(i);
8126:
8127: -- Create records in version history table OKC_K_VERS_NUMBERS_H