[Home] [Help]
508: header.contract_number AS contract_number,
509: doc_type_tl.name AS document_type,
510: hr.name AS operating_unit,
511: header.owner_id AS contract_admin_id
512: FROM okc_rep_contracts header,
513: Hr_all_organization_units_tl hr,
514: Okc_bus_doc_types_b doc_type_b,
515: Okc_bus_doc_types_tl doc_type_tl
516: WHERE (p_cust_id IS NULL OR EXISTS (
560: TYPE selected_so_tbl IS TABLE OF selected_so_csr%ROWTYPE;
561: TYPE selected_quote_tbl IS TABLE OF selected_quote_csr%ROWTYPE;
562: TYPE selected_rep_tbl IS TABLE OF selected_rep_csr%ROWTYPE;
563:
564: TYPE NumList IS TABLE OF okc_rep_contracts_all.contract_id%TYPE NOT NULL
565: INDEX BY PLS_INTEGER;
566:
567: TYPE NamesList IS TABLE OF hz_parties.party_name%TYPE NOT NULL
568: INDEX BY PLS_INTEGER;
1076: END IF;
1077:
1078: FORALL i IN NVL(selected_rep_con_ids.FIRST,0)..NVL(selected_rep_con_ids.LAST,-1)
1079:
1080: UPDATE okc_rep_contracts_all
1081: SET owner_id = p_new_con_admin_user_id
1082: WHERE contract_id = selected_rep_con_ids(i);
1083:
1084: /* ---- Per CR, Contract Admin is now version specific.