APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_K_VERS_NUMBERS

Line 25: --| OKC_K_VERS_NUMBERS | X | | X | | | |

21: --| OKC_K_ITEMS | X | X | | | |X |
22: --+---------------------------------+---+---+---+---+---+----------------------+
23: --| OKS_RENEW_UTIL_PVT | | | | | |X |
24: --+---------------------------------+---+---+---+---+---+----------------------+
25: --| OKC_K_VERS_NUMBERS | X | | X | | | |
26: --+---------------------------------+---+---+---+---+---+----------------------+
27: --| FND_ATTACHED_DOCUMENTS | | | | | |X |
28: --+---------------------------------+---+---+---+---+---+----------------------+
29: --| okc_k_headers_all_b | X | | X | | | |

Line 1038: FROM okc_k_vers_numbers

1034: IS
1035: CURSOR l_cvm_csr
1036: IS
1037: SELECT TO_CHAR (major_version)
1038: FROM okc_k_vers_numbers
1039: WHERE chr_id = p_chr_id;
1040:
1041: x_from_version fnd_attached_documents.pk2_value%TYPE := NULL;
1042: BEGIN

Line 8127: -- Create records in version history table OKC_K_VERS_NUMBERS_H

8123: UPDATE okc_contacts
8124: SET dnz_ste_code =get_ste_code(get_status (Hdr_new_Sdate(i), Hdr_new_edate(i)))
8125: WHERE dnz_chr_id=header_id(i);
8126:
8127: -- Create records in version history table OKC_K_VERS_NUMBERS_H
8128:
8129: If header_id.count > 0
8130: Then
8131: FORALL i IN header_id.first .. header_id.last

Line 8132: INSERT INTO OKC_K_VERS_NUMBERS_H (

8128:
8129: If header_id.count > 0
8130: Then
8131: FORALL i IN header_id.first .. header_id.last
8132: INSERT INTO OKC_K_VERS_NUMBERS_H (
8133: chr_id,
8134: major_version,
8135: minor_version,
8136: object_version_number,

Line 8153: FROM OKC_K_VERS_NUMBERS

8149: , SYSDATE
8150: , fnd_global.user_id
8151: , SYSDATE
8152: , fnd_global.login_id
8153: FROM OKC_K_VERS_NUMBERS
8154: WHERE chr_id = header_id(i)
8155: );
8156: End If;
8157: -- Update the minor version and object version numbers

Line 8159: UPDATE OKC_K_VERS_NUMBERS

8155: );
8156: End If;
8157: -- Update the minor version and object version numbers
8158: FORALL i IN 1 .. header_id.COUNT
8159: UPDATE OKC_K_VERS_NUMBERS
8160: SET minor_version = minor_version+1,
8161: object_version_number = object_version_number+1,
8162: last_updated_by = fnd_global.user_id,
8163: last_update_date = SYSDATE,