APPS.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_TLH

Line 975: DELETE FROM OKC_RULE_GROUPS_TLH T

971: FROM OKC_RULE_GROUPS_TL T
972: WHERE T.ID = B.ID
973: AND T.LANGUAGE = L.LANGUAGE_CODE
974: );
975: DELETE FROM OKC_RULE_GROUPS_TLH T
976: WHERE NOT EXISTS (
977: SELECT NULL
978: FROM OKC_RULE_GROUPS_BH B
979: WHERE B.ID = T.ID

Line 983: UPDATE OKC_RULE_GROUPS_TLH T SET (

979: WHERE B.ID = T.ID
980: AND B.MAJOR_VERSION = T.MAJOR_VERSION
981: );
982:
983: UPDATE OKC_RULE_GROUPS_TLH T SET (
984: COMMENTS) = (SELECT
985: B.COMMENTS
986: FROM OKC_RULE_GROUPS_TLH B
987: WHERE B.ID = T.ID

Line 986: FROM OKC_RULE_GROUPS_TLH B

982:
983: UPDATE OKC_RULE_GROUPS_TLH T SET (
984: COMMENTS) = (SELECT
985: B.COMMENTS
986: FROM OKC_RULE_GROUPS_TLH B
987: WHERE B.ID = T.ID
988: AND B.MAJOR_VERSION = T.MAJOR_VERSION
989: AND B.LANGUAGE = T.SOURCE_LANG)
990: WHERE (

Line 998: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT

994: IN (SELECT
995: SUBT.ID,
996: SUBT.MAJOR_VERSION,
997: SUBT.LANGUAGE
998: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT
999: WHERE SUBB.ID = SUBT.ID
1000: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
1001: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1002: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 1007: INSERT INTO OKC_RULE_GROUPS_TLH (

1003: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
1004: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
1005: ));
1006:
1007: INSERT INTO OKC_RULE_GROUPS_TLH (
1008: ID,
1009: LANGUAGE,
1010: MAJOR_VERSION,
1011: SOURCE_LANG,

Line 1031: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L

1027: B.CREATION_DATE,
1028: B.LAST_UPDATED_BY,
1029: B.LAST_UPDATE_DATE,
1030: B.LAST_UPDATE_LOGIN
1031: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L
1032: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1033: AND B.LANGUAGE = USERENV('LANG')
1034: AND NOT EXISTS(
1035: SELECT NULL

Line 1036: FROM OKC_RULE_GROUPS_TLH T

1032: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1033: AND B.LANGUAGE = USERENV('LANG')
1034: AND NOT EXISTS(
1035: SELECT NULL
1036: FROM OKC_RULE_GROUPS_TLH T
1037: WHERE T.ID = B.ID
1038: AND T.MAJOR_VERSION = B.MAJOR_VERSION
1039: AND T.LANGUAGE = L.LANGUAGE_CODE
1040: );

Line 3923: INSERT INTO okc_rule_groups_tlh

3919: -------------------------------
3920: -- Versioning TL Table
3921: -------------------------------
3922:
3923: INSERT INTO okc_rule_groups_tlh
3924: (
3925: major_version,
3926: id,
3927: language,

Line 4009: FROM okc_rule_groups_tlh

4005: creation_date,
4006: last_updated_by,
4007: last_update_date,
4008: last_update_login
4009: FROM okc_rule_groups_tlh
4010: WHERE id in (SELECT id
4011: FROM okc_rule_groups_bh
4012: WHERE dnz_chr_id = p_chr_id)
4013: AND major_version = p_major_version;