APPS.OKC_REP_STATUS_UPDATE_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 61: FROM okc_rep_contracts_all

57: SELECT
58: contract_id, contract_version_num,
59: contract_number,
60: contract_name
61: FROM okc_rep_contracts_all
62: WHERE termination_date is not null
63: AND contract_status_code = G_REP_CON_STATUS_SIGNED
64: AND trunc(termination_date) <= TRUNC(SYSDATE);
65:

Line 78: TYPE NumList IS TABLE OF okc_rep_contracts_all.contract_id%TYPE NOT NULL

74: AND trunc(termination_date) <= trunc(SYSDATE);
75:
76: TYPE selected_contracts_tbl IS TABLE OF contracts_cur%ROWTYPE;
77: TYPE selected_vers_contracts_tbl IS TABLE OF contract_vers_cur%ROWTYPE;
78: TYPE NumList IS TABLE OF okc_rep_contracts_all.contract_id%TYPE NOT NULL
79: INDEX BY PLS_INTEGER;
80: TYPE VersionNumList IS TABLE OF okc_rep_contracts_all.contract_version_num%TYPE NOT NULL
81: INDEX BY PLS_INTEGER;
82:

Line 80: TYPE VersionNumList IS TABLE OF okc_rep_contracts_all.contract_version_num%TYPE NOT NULL

76: TYPE selected_contracts_tbl IS TABLE OF contracts_cur%ROWTYPE;
77: TYPE selected_vers_contracts_tbl IS TABLE OF contract_vers_cur%ROWTYPE;
78: TYPE NumList IS TABLE OF okc_rep_contracts_all.contract_id%TYPE NOT NULL
79: INDEX BY PLS_INTEGER;
80: TYPE VersionNumList IS TABLE OF okc_rep_contracts_all.contract_version_num%TYPE NOT NULL
81: INDEX BY PLS_INTEGER;
82:
83: selected_contracts selected_contracts_tbl;
84: selected_vers_contracts selected_vers_contracts_tbl;

Line 179: UPDATE okc_rep_contracts_all

175:
176: END LOOP;
177:
178: FORALL j IN NVL(selected_contract_ids.FIRST,0)..NVL(selected_contract_ids.LAST,-1)
179: UPDATE okc_rep_contracts_all
180: SET contract_status_code = p_status,
181: last_update_date = sysdate,
182: last_updated_by = Fnd_Global.User_Id,
183: last_update_login = Fnd_Global.Login_Id