APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKC_CONTACTS

Line 553: FROM okc_contacts

549:
550:
551: CURSOR c_get_contact_id(b_chr_id NUMBER,b_salesrep_ctrol VARCHAR2,b_object_id VARCHAR2) is
552: SELECT id
553: FROM okc_contacts
554: WHERE dnz_chr_id = b_chr_id
555: AND cro_code = b_salesrep_ctrol
556: AND object1_id1=b_object_id
557: AND rownum = 1;

Line 626: --in OKC_CONTACTS

622: END IF;
623:
624: /*********** contact creation no longer needed ***********
625: --each SALESREP_ID from the quote (or order) is created as a contact
626: --in OKC_CONTACTS
627: --OKC_K_SALES_CREDITS.CTC_ID is a foreign key pointing to
628: --OKC_CONTACTS.ID
629: OPEN c_get_contact_id(p_chr_id,G_SALESREP_CTROL,l_source_sales_credit_rec.salesrep_id);
630: FETCH c_get_contact_id into g_sales_credit_tab(i).ctc_id;

Line 628: --OKC_CONTACTS.ID

624: /*********** contact creation no longer needed ***********
625: --each SALESREP_ID from the quote (or order) is created as a contact
626: --in OKC_CONTACTS
627: --OKC_K_SALES_CREDITS.CTC_ID is a foreign key pointing to
628: --OKC_CONTACTS.ID
629: OPEN c_get_contact_id(p_chr_id,G_SALESREP_CTROL,l_source_sales_credit_rec.salesrep_id);
630: FETCH c_get_contact_id into g_sales_credit_tab(i).ctc_id;
631: IF c_get_contact_id%NOTFOUND then
632: SELECT id into l_supplier_role_id FROM OKC_K_PARTY_ROLES_B