DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_P_UTIL

Line 215: -- l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());

211:
212: IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
213: l_cle_ctr := l_cle_ctr + 1;
214:
215: -- l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());
216: l_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_TBL(i);
217: l_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_TBL(i);
218: l_clev_tbl_in(l_cle_ctr).Last_Updated_By := Line_Last_Updated_By_TBL(i);
219: l_clev_tbl_in(l_cle_ctr).Last_Update_Date := Line_Last_Update_Date_TBL(i);

Line 597: l_ctzv_tbl_in(l_ctz_rec).Id := okc_p_util.raw_to_number(sys_guid());

593:
594: FOR get_time_zone_ID_Rec IN Csr_get_time_zone_ID(l_rule_ID) LOOP
595:
596:
597: l_ctzv_tbl_in(l_ctz_rec).Id := okc_p_util.raw_to_number(sys_guid());
598:
599:
600: l_ctzv_tbl_in(l_ctz_rec).Created_By := get_time_zone_ID_Rec.Times_Created_By;
601: l_ctzv_tbl_in(l_ctz_rec).Last_Updated_By := get_time_zone_ID_Rec.Times_Last_Updated_By;

Line 696: -- l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());

692: IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
693: l_cle_ctr := l_cle_ctr + 1;
694:
695:
696: -- l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());
697: l_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_TBL(i);
698: l_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_Tbl(i);
699: l_clev_tbl_in(l_cle_ctr).Last_Updated_By := Line_Last_Updated_By_TBL(i);
700: l_clev_tbl_in(l_cle_ctr).Last_Update_Date := Line_Last_Update_Date_TBL(i);

Line 1064: l_cvtv_tbl_in(l_cvt_rec).ID := okc_p_util.raw_to_number(sys_guid());

1060:
1061: l_cvt_rec := l_cvt_rec + 1;
1062:
1063:
1064: l_cvtv_tbl_in(l_cvt_rec).ID := okc_p_util.raw_to_number(sys_guid());
1065:
1066:
1067: l_cvtv_tbl_in(l_cvt_rec).COV_TZE_LINE_ID := TimeZone_ID_Tbl(i);
1068: l_cvtv_tbl_in(l_cvt_rec).DNZ_CHR_ID := DNZ_CHR_ID_TBL(i);

Line 1392: l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());

1388:
1389: IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
1390: l_cle_ctr := l_cle_ctr + 1;
1391:
1392: l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());
1393:
1394: l_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_TBL(i);
1395: l_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_TBL(i);
1396: l_clev_tbl_in(l_cle_ctr).Last_Updated_By := Line_Last_Updated_By_TBL(i);

Line 1422: l_actv_tbl_in(l_act_ctr).Id := okc_p_util.raw_to_number(sys_guid());

1418: END IF; --IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
1419:
1420: l_act_ctr := l_act_ctr + 1;
1421:
1422: l_actv_tbl_in(l_act_ctr).Id := okc_p_util.raw_to_number(sys_guid());
1423: l_actv_tbl_in(l_act_ctr).Created_By := -9999;
1424: l_actv_tbl_in(l_act_ctr).Last_Updated_By := -9999;
1425: l_actv_tbl_in(l_act_ctr).Last_Update_Date := sysdate;
1426: l_actv_tbl_in(l_act_ctr).Last_Update_Login := -9999;

Line 1653: l_acmv_tbl_in(l_acm_ctr).ID := okc_p_util.raw_to_number(sys_guid());

1649: l_acmv_tbl_in(l_acm_ctr).PROGRAM_ID := NULL;
1650: l_acmv_tbl_in(l_acm_ctr).PROGRAM_UPDATE_DATE := NULL;
1651: l_acmv_tbl_in(l_acm_ctr).REQUEST_ID := NULL;
1652:
1653: l_acmv_tbl_in(l_acm_ctr).ID := okc_p_util.raw_to_number(sys_guid());
1654: l_acmv_tbl_in(l_acm_ctr).COV_ACTION_TYPE_ID := Action_Type_ID_TBL(i);
1655: l_acmv_tbl_in(l_acm_ctr).CLE_ID := Action_Type_Cle_ID_TBL(i);
1656: l_acmv_tbl_in(l_acm_ctr).Dnz_chr_id := Action_Type_Dnz_ID_TBL(i);
1657: l_acmv_tbl_in(l_acm_ctr).UOM_CODE := UOM_CODE_TBL(i);

Line 1969: l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());

1965: IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
1966: l_cle_ctr := l_cle_ctr + 1;
1967: END IF;
1968:
1969: l_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());
1970: l_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_tbl(i);
1971: l_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_TBL(i);
1972: l_clev_tbl_in(l_cle_ctr).Last_Updated_By :=
1973: Line_Last_Updated_By_TBL(i);

Line 3486: i_ctzv_tbl_in(l_ctz_rec).Id := okc_p_util.raw_to_number(sys_guid());

3482:
3483: FOR get_time_zone_ID_Rec IN get_time_zone_ID_Cur(l_rule_ID) LOOP
3484:
3485:
3486: i_ctzv_tbl_in(l_ctz_rec).Id := okc_p_util.raw_to_number(sys_guid());
3487:
3488:
3489: i_ctzv_tbl_in(l_ctz_rec).Created_By := get_time_zone_ID_Rec.Times_Created_By;
3490: i_ctzv_tbl_in(l_ctz_rec).Last_Updated_By := get_time_zone_ID_Rec.Times_Last_Updated_By;

Line 3996: --okc_p_util.raw_to_number(sys_guid());

3992: l_cvt_rec := l_cvt_rec + 1;
3993:
3994:
3995: i_cvtv_tbl_in(l_cvt_rec).ID := Times_Id_tbl(i);
3996: --okc_p_util.raw_to_number(sys_guid());
3997:
3998: i_cvtv_tbl_in(l_cvt_rec).COV_TZE_LINE_ID := TimeZone_ID_Tbl(i);
3999: i_cvtv_tbl_in(l_cvt_rec).DNZ_CHR_ID := DNZ_CHR_ID_TBL(i);
4000:

Line 4487: i_clev_tbl_in(l_cle_ctr).Id := k_line_id_tbl(i); --okc_p_util.raw_to_number(sys_guid());

4483:
4484: IF (L_OLD_CLE_ID <> L_CLE_ID) THEN
4485: l_cle_ctr := l_cle_ctr + 1;
4486:
4487: i_clev_tbl_in(l_cle_ctr).Id := k_line_id_tbl(i); --okc_p_util.raw_to_number(sys_guid());
4488: l_line_id := LINE_ID_TBL(i);
4489: i_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_TBL(i);
4490: i_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_TBL(i);
4491: i_clev_tbl_in(l_cle_ctr).Last_Updated_By := Line_Last_Updated_By_TBL(i);

Line 4785: i_acmv_tbl_in(l_acm_ctr).ID := okc_p_util.raw_to_number(sys_guid());

4781: i_acmv_tbl_in(l_acm_ctr).PROGRAM_ID := NULL;
4782: i_acmv_tbl_in(l_acm_ctr).PROGRAM_UPDATE_DATE := NULL;
4783: i_acmv_tbl_in(l_acm_ctr).REQUEST_ID := NULL;
4784:
4785: i_acmv_tbl_in(l_acm_ctr).ID := okc_p_util.raw_to_number(sys_guid());
4786: i_acmv_tbl_in(l_acm_ctr).COV_ACTION_TYPE_ID := Action_Type_ID_TBL(i);
4787: i_acmv_tbl_in(l_acm_ctr).CLE_ID := Action_Type_Cle_ID_TBL(i);
4788: i_acmv_tbl_in(l_acm_ctr).Dnz_chr_id := Action_Type_Dnz_ID_TBL(i);
4789: i_acmv_tbl_in(l_acm_ctr).UOM_CODE := UOM_CODE_TBL(i);

Line 5213: i_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());

5209: l_cle_ctr := l_cle_ctr + 1;
5210: END IF;
5211: l_line_id := LINE_ID_TBL(i);
5212:
5213: i_clev_tbl_in(l_cle_ctr).Id := okc_p_util.raw_to_number(sys_guid());
5214: i_clev_tbl_in(l_cle_ctr).Created_By := Line_Created_By_tbl(i);
5215: i_clev_tbl_in(l_cle_ctr).Creation_Date := Line_Creation_Date_TBL(i);
5216: i_clev_tbl_in(l_cle_ctr).Last_Updated_By :=
5217: Line_Last_Updated_By_TBL(i);