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 1034: FROM okc_k_vers_numbers

1030: IS
1031: CURSOR l_cvm_csr
1032: IS
1033: SELECT TO_CHAR (major_version)
1034: FROM okc_k_vers_numbers
1035: WHERE chr_id = p_chr_id;
1036:
1037: x_from_version fnd_attached_documents.pk2_value%TYPE := NULL;
1038: BEGIN

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

8083: end_date = Hdr_new_edate(i),
8084: sts_code = get_status (Hdr_new_Sdate(i), Hdr_new_edate(i))
8085: WHERE ID = header_id(i);
8086:
8087: -- Create records in version history table OKC_K_VERS_NUMBERS_H
8088:
8089:
8090:
8091:

Line 8095: INSERT INTO OKC_K_VERS_NUMBERS_H (

8091:
8092: If header_id.count > 0
8093: Then
8094: FORALL i IN header_id.first .. header_id.last
8095: INSERT INTO OKC_K_VERS_NUMBERS_H (
8096: chr_id,
8097: major_version,
8098: minor_version,
8099: object_version_number,

Line 8116: FROM OKC_K_VERS_NUMBERS

8112: , SYSDATE
8113: , fnd_global.user_id
8114: , SYSDATE
8115: , fnd_global.login_id
8116: FROM OKC_K_VERS_NUMBERS
8117: WHERE chr_id = header_id(i)
8118: );
8119: End If;
8120: -- Update the minor version and object version numbers

Line 8122: UPDATE OKC_K_VERS_NUMBERS

8118: );
8119: End If;
8120: -- Update the minor version and object version numbers
8121: FORALL i IN 1 .. header_id.COUNT
8122: UPDATE OKC_K_VERS_NUMBERS
8123: SET minor_version = minor_version+1,
8124: object_version_number = object_version_number+1
8125: WHERE chr_ID = header_id(i);
8126: