DBA Data[Home] [Help]

APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on OKC_TEMPLATE_USAGES

Line 419: okc_template_usages t,

415: doc_type.name AS document_type,
416: hr.name AS operating_unit,
417: t.contract_admin_id AS contract_admin_id
418: FROM oe_blanket_headers header,
419: okc_template_usages t,
420: hz_parties customer,
421: hz_cust_accounts hzc,
422: okc_bus_doc_types_tl doc_type,
423: hr_all_organization_units_tl hr

Line 449: okc_template_usages t,

445: doc_type.name AS document_type,
446: hr.name AS operating_unit,
447: t.contract_admin_id AS contract_admin_id
448: FROM oe_order_headers header,
449: okc_template_usages t,
450: hz_parties customer,
451: hz_cust_accounts hzc,
452: okc_bus_doc_types_tl doc_type,
453: hr_all_organization_units_tl hr

Line 479: okc_template_usages t,

475: doc_type.name document_type,
476: hr.name AS operating_unit,
477: t.contract_admin_id AS contract_admin_id
478: FROM aso_quote_headers header,
479: okc_template_usages t,
480: hz_parties customer,
481: okc_bus_doc_types_tl doc_type,
482: aso_quote_statuses_vl quote_status,
483: hr_all_organization_units_tl hr

Line 579: l_new_con_admin_user_id okc_template_usages.contract_admin_id%TYPE;

575: l_selected_doc_ids OKC_TERMS_UTIL_PVT.doc_ids_tbl;
576: l_selected_doc_types OKC_TERMS_UTIL_PVT.doc_types_tbl;
577: l_new_con_admin_user_ids OKC_TERMS_UTIL_PVT.new_con_admin_user_ids_tbl;
578: l_doc_index NUMBER(4) := 0;
579: l_new_con_admin_user_id okc_template_usages.contract_admin_id%TYPE;
580: l_new_con_admin_user_name per_all_people_f.full_name%TYPE;
581:
582: l_batch_size number(4) := 1000;
583: l_cust_names varchar2(4000);