APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES

Line 1397: --Proceudre copy_governances - Makes a copy of the okc_governances.

1393: /*******************************************************************************
1394: This used to make a copy of goverances only at the header level
1395: We have replaced it by code that copies at both header and line level
1396: --------------------------------------------------------------------------
1397: --Proceudre copy_governances - Makes a copy of the okc_governances.
1398: --------------------------------------------------------------------------
1399: PROCEDURE copy_governances(
1400: p_api_version IN NUMBER,
1401: p_init_msg_list IN VARCHAR2 ,

Line 1414: FROM okc_governances_v

1410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1411:
1412: CURSOR c_governances IS
1413: SELECT id
1414: FROM okc_governances_v
1415: WHERE dnz_chr_id = p_from_chr_id
1416: AND cle_id is null;
1417:
1418: ----------------------------------------------------------------------------

Line 1436: FROM OKC_GOVERNANCES

1432: CLE_ID,
1433: CHR_ID_REFERRED,
1434: CLE_ID_REFERRED,
1435: COPIED_ONLY_YN
1436: FROM OKC_GOVERNANCES
1437: WHERE ID = p_gve_id;
1438: BEGIN
1439: OPEN c_gvev_rec;
1440: FETCH c_gvev_rec

Line 2364: FROM OKC_GOVERNANCES

2360: CLE_ID,
2361: CHR_ID_REFERRED,
2362: CLE_ID_REFERRED,
2363: COPIED_ONLY_YN
2364: FROM OKC_GOVERNANCES
2365: WHERE ID = p_gve_id;
2366: BEGIN
2367: OPEN c_gvev_rec;
2368: FETCH c_gvev_rec

Line 2397: --Procedure copy_governances - Makes a copy of the okc_governances

2393: END get_gvev_rec;
2394:
2395:
2396: --------------------------------------------------------------------------
2397: --Procedure copy_governances - Makes a copy of the okc_governances
2398: --------------------------------------------------------------------------
2399: PROCEDURE copy_governances(
2400: p_api_version IN NUMBER,
2401: p_init_msg_list IN VARCHAR2 ,

Line 3718: FROM okc_governances_v

3714:
3715: -- cursor for governances
3716: CURSOR c_governances IS
3717: SELECT id
3718: FROM okc_governances_v
3719: WHERE cle_id = p_from_cle_id
3720: AND G_COPY_HISTORY_YN = 'N'
3721: UNION ALL
3722: SELECT id

Line 3723: FROM okc_governances_hv

3719: WHERE cle_id = p_from_cle_id
3720: AND G_COPY_HISTORY_YN = 'N'
3721: UNION ALL
3722: SELECT id
3723: FROM okc_governances_hv
3724: WHERE cle_id = p_from_cle_id
3725: AND major_version = G_FROM_VERSION_NUMBER
3726: AND G_COPY_HISTORY_YN = 'Y';
3727:

Line 5344: FROM okc_governances_v

5340: --
5341: -- cursor for goverances
5342: CURSOR c_governances IS
5343: SELECT id
5344: FROM okc_governances_v
5345: WHERE dnz_chr_id = p_from_chr_id
5346: AND cle_id is null
5347: AND G_COPY_HISTORY_YN = 'N'
5348: UNION ALL

Line 5350: FROM okc_governances_hv

5346: AND cle_id is null
5347: AND G_COPY_HISTORY_YN = 'N'
5348: UNION ALL
5349: SELECT id
5350: FROM okc_governances_hv
5351: WHERE dnz_chr_id = p_from_chr_id
5352: AND cle_id is null
5353: AND major_version = G_FROM_VERSION_NUMBER
5354: AND G_COPY_HISTORY_YN = 'Y';