DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES

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

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

Line 1415: FROM okc_governances_v

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

Line 1437: FROM OKC_GOVERNANCES

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

Line 2365: FROM OKC_GOVERNANCES

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

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

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

Line 3719: FROM okc_governances_v

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

Line 3724: FROM okc_governances_hv

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

Line 5345: FROM okc_governances_v

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

Line 5351: FROM okc_governances_hv

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