DBA Data[Home] [Help]

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 559: l_supplier_role_id OKC_K_PARTY_ROLES_B.ID%TYPE;

555: AND cro_code = b_salesrep_ctrol
556: AND object1_id1=b_object_id
557: AND rownum = 1;
558:
559: l_supplier_role_id OKC_K_PARTY_ROLES_B.ID%TYPE;
560: l_source_sales_credit_rec c_source_sales_credit_rec%ROWTYPE;
561: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
562:
563: BEGIN

Line 632: SELECT id into l_supplier_role_id FROM OKC_K_PARTY_ROLES_B

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
633: WHERE dnz_chr_id = p_chr_id
634: AND rle_code = 'SUPPLIER';
635:
636: OKO_OM_INT_OTK_PVT.create_contact_for_contract(