eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_K_HEADERS

Line 302: UPDATE oke_k_headers

298: CLOSE c_children;
299:
300: IF l_chld_exist='!' THEN RETURN; END IF;
301: IF p_diff <> 0 OR p_diff_u <> 0 THEN
302: UPDATE oke_k_headers
303: SET line_value_total = line_value_total - Nvl(p_diff,0)
304: ,undef_line_value_total = undef_line_value_total - Nvl(p_diff_u,0)
305: WHERE k_header_id = p_chr_id;
306: END IF;

Line 1708: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by

1704:
1705: -- Added code to update who columns. neccessary for security to work after import process.
1706:
1707: IF p_chr_rec.created_by <> OKE_API.G_MISS_NUM AND p_chr_rec.created_by IS NOT NULL THEN
1708: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
1709: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1710: END IF;
1711: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
1712: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

Line 1712: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

1708: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
1709: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1710: END IF;
1711: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
1712: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
1713: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1714: END IF;
1715: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
1716: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

Line 1716: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

1712: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
1713: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1714: END IF;
1715: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
1716: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
1717: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1718: END IF;
1719: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
1720: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

Line 1720: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

1716: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
1717: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1718: END IF;
1719: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
1720: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
1721: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1722: END IF;
1723: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
1724: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

Line 1724: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

1720: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
1721: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1722: END IF;
1723: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
1724: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date
1725: WHERE K_HEADER_ID = l_out_chr.k_header_id;
1726: END IF;
1727:
1728: -- Added code to update who columns. neccessary for security to work after import process.

Line 3014: from oke_k_headers

3010: l_default_flag VARCHAR2(1) := '?';
3011:
3012: CURSOR c_k_header_id IS
3013: select 'x'
3014: from oke_k_headers
3015: where k_header_id = p_bill_rec.k_header_id;
3016:
3017: CURSOR c_billing_method_code IS
3018: select 'x'

Line 3540: FROM okc_k_lines_b cl, oke_k_lines l, oke_k_headers kh

3536: l.undef_line_value_total
3537: INTO L_sts_code, L_object_version_number
3538: ,l_chr_id,l_line_value_total,
3539: l_undef_line_value_total
3540: FROM okc_k_lines_b cl, oke_k_lines l, oke_k_headers kh
3541: WHERE cl.id=l.k_line_id
3542: AND kh.k_header_id=cl.dnz_chr_id
3543: and l.k_line_id=p_contract_line_id;
3544: EXCEPTION

Line 3608: UPDATE oke_k_headers

3604: START WITH id = p_contract_line_id
3605: CONNECT BY PRIOR CLE_ID = ID );
3606:
3607: -- Update Header Amount
3608: UPDATE oke_k_headers
3609: SET line_value_total = Nvl(line_value_total,0) - Nvl(l_line_value_total,0)
3610: ,undef_line_value_total = Nvl(undef_line_value_total,0) - Nvl(l_undef_line_value_total,0)
3611: WHERE k_header_id=l_chr_id;
3612:

Line 5893: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by

5889:
5890: -- Added code to update who columns. neccessary for security to work after import process.
5891:
5892: IF p_chr_rec.created_by <> OKE_API.G_MISS_NUM AND p_chr_rec.created_by IS NOT NULL THEN
5893: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
5894: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5895: END IF;
5896: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
5897: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

Line 5897: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

5893: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
5894: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5895: END IF;
5896: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
5897: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
5898: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5899: END IF;
5900: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
5901: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

Line 5901: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

5897: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
5898: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5899: END IF;
5900: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
5901: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
5902: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5903: END IF;
5904: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
5905: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

Line 5905: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

5901: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
5902: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5903: END IF;
5904: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
5905: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
5906: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5907: END IF;
5908: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
5909: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

Line 5909: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

5905: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
5906: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5907: END IF;
5908: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
5909: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date
5910: WHERE K_HEADER_ID = l_out_chr.k_header_id;
5911: END IF;
5912:
5913: -- Added code to update who columns. neccessary for security to work after import process.

Line 6143: FROM oke_k_headers_full_v

6139:
6140:
6141: CURSOR get_k IS
6142: SELECT k_type,k_number
6143: FROM oke_k_headers_full_v
6144: WHERE k_header_id = p_chr_id;
6145:
6146: BEGIN
6147: -- call START_ACTIVITY to create savepoint, check compatibility