APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKC_K_SALES_CREDITS

Line 605: -- okx_ord_sls_credits_v to OKC_K_SALES_CREDITS

601: FETCH c_source_sales_credit_rec INTO l_source_sales_credit_rec;
602: EXIT WHEN c_source_sales_credit_rec%NOTFOUND;
603:
604: -- map okx_qte_sls_credits_v or
605: -- okx_ord_sls_credits_v to OKC_K_SALES_CREDITS
606:
607: -- we don't need to enter the ID because it is automatically generated
608:
609: IF l_source_sales_credit_rec.source_header_id IS NOT NULL THEN

Line 627: --OKC_K_SALES_CREDITS.CTC_ID is a foreign key pointing to

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;
631: IF c_get_contact_id%NOTFOUND then

Line 811: OKC_K_SALES_CREDITS kscdt,

807: kscdt.cle_id,
808: kscdt.last_update_date
809: -- kscdt.object_version_number
810: FROM
811: OKC_K_SALES_CREDITS kscdt,
812: OKX_QTE_SLS_CREDITS_V qscdt,
813: OKX_SALESREPS_V sr
814: WHERE
815: b_q_flag = OKC_API.G_TRUE

Line 848: OKC_K_SALES_CREDITS kscdt,

844: kscdt.cle_id,
845: kscdt.last_update_date
846: -- kscdt.object_version_number
847: FROM
848: OKC_K_SALES_CREDITS kscdt,
849: OKX_ORD_SLS_CREDITS_V oscdt
850: -- OKX_SALESREPS_V sr
851: WHERE
852: b_o_flag = OKC_API.G_TRUE

Line 1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);

1265: IF x_k_sales_credit_tab.EXISTS(i) THEN
1266:
1267: IF (l_debug = 'Y') THEN
1268: okc_util.print_trace(1,'INDEX VALUE = '||i);
1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);
1270: okc_util.print_trace(1,'Level = '||x_k_sales_credit_tab(i).level);
1271: END IF;
1272:
1273: END IF;