APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_COVERAGE_TIMEZONES

Line 578: FROM OKS_COVERAGE_TIMEZONES

574: AND rownum = 1;
575:
576: CURSOR Csr_get_count_time_zone_ID(k_cle_Id IN NUMBER,k_dnz_Id IN NUMBER) IS
577: SELECT COUNT(*) NCOUNT
578: FROM OKS_COVERAGE_TIMEZONES
579: WHERE cle_id = k_cle_Id
580: AND dnz_chr_Id = k_dnz_Id;
581:
582: BEGIN

Line 807: p_oks_coverage_timezones_v_tbl => l_ctzv_tbl_in,

803: IF l_ctzv_tbl_in.COUNT > 0 THEN
804: OKS_CTZ_PVT.insert_row
805: (
806: x_return_status => l_return_status,
807: p_oks_coverage_timezones_v_tbl => l_ctzv_tbl_in,
808: p_api_version =>1,
809: p_init_msg_list => null, --standard
810: x_msg_count => x_msg_count,
811: x_msg_data => x_msg_data,

Line 812: x_oks_coverage_timezones_v_tbl => x_ctzv_tbl_in

808: p_api_version =>1,
809: p_init_msg_list => null, --standard
810: x_msg_count => x_msg_count,
811: x_msg_data => x_msg_data,
812: x_oks_coverage_timezones_v_tbl => x_ctzv_tbl_in
813: );
814: END IF;
815: -- -- dbms_output.put_line('OKS_CTZ_PVT Value of l_return_status='||l_return_status);
816:

Line 984: FROM OKS_COVERAGE_TIMEZONES CTZ,

980: Times.Last_Updated_By Times_Last_Updated_By,
981: Times.Last_Update_Date Times_Last_Update_Date,
982: Times.Last_Update_Login Times_Last_Update_Login,
983: Times.Attribute15 Times_Attribute15
984: FROM OKS_COVERAGE_TIMEZONES CTZ,
985: OKC_RULE_GROUPS_B RGP,
986: OKC_RULES_B RUL,
987: OKC_COVER_TIMES CVT,
988: OKC_TIMEVALUES_B TIMES

Line 3469: FROM OKS_COVERAGE_TIMEZONES

3465: AND rownum = 1;
3466:
3467: CURSOR get_count_time_zone_ID_Cur (cle_Id IN NUMBER,dnz_Id IN NUMBER) IS
3468: SELECT COUNT(*) NCOUNT
3469: FROM OKS_COVERAGE_TIMEZONES
3470: WHERE cle_id = cle_Id
3471: AND dnz_chr_Id = dnz_Id;
3472:
3473: BEGIN

Line 3714: INSERT INTO OKS_COVERAGE_TIMEZONES_H(

3710: l_status := 'Before Insert';
3711:
3712: FORALL I IN 1 .. l_tabsize
3713:
3714: INSERT INTO OKS_COVERAGE_TIMEZONES_H(
3715: ID,
3716: DNZ_CHR_ID,
3717: CLE_ID,
3718: DEFAULT_YN,

Line 3865: FROM OKS_COVERAGE_TIMEZONES CTZ,

3861: Times.Last_Update_Login Times_Last_Update_Login,
3862: Times.Attribute15 Times_Attribute15,
3863: Times.object_version_number Times_object_version_number,
3864: Times.major_version Times_major_version
3865: FROM OKS_COVERAGE_TIMEZONES CTZ,
3866: OKC_RULE_GROUPS_BH RGP,
3867: OKC_RULES_BH RUL,
3868: OKC_COVER_TIMES_H CVT,
3869: OKC_TIMEVALUES_BH TIMES