APPS.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_TLH

Line 971: DELETE FROM OKC_RULE_GROUPS_TLH T

967: FROM OKC_RULE_GROUPS_TL T
968: WHERE T.ID = B.ID
969: AND T.LANGUAGE = L.LANGUAGE_CODE
970: );
971: DELETE FROM OKC_RULE_GROUPS_TLH T
972: WHERE NOT EXISTS (
973: SELECT NULL
974: FROM OKC_RULE_GROUPS_BH B
975: WHERE B.ID = T.ID

Line 979: UPDATE OKC_RULE_GROUPS_TLH T SET (

975: WHERE B.ID = T.ID
976: AND B.MAJOR_VERSION = T.MAJOR_VERSION
977: );
978:
979: UPDATE OKC_RULE_GROUPS_TLH T SET (
980: COMMENTS) = (SELECT
981: B.COMMENTS
982: FROM OKC_RULE_GROUPS_TLH B
983: WHERE B.ID = T.ID

Line 982: FROM OKC_RULE_GROUPS_TLH B

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

Line 994: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT

990: IN (SELECT
991: SUBT.ID,
992: SUBT.MAJOR_VERSION,
993: SUBT.LANGUAGE
994: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT
995: WHERE SUBB.ID = SUBT.ID
996: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
997: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
998: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 1003: INSERT INTO OKC_RULE_GROUPS_TLH (

999: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
1000: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
1001: ));
1002:
1003: INSERT INTO OKC_RULE_GROUPS_TLH (
1004: ID,
1005: LANGUAGE,
1006: MAJOR_VERSION,
1007: SOURCE_LANG,

Line 1027: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L

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

Line 1032: FROM OKC_RULE_GROUPS_TLH T

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

Line 3919: INSERT INTO okc_rule_groups_tlh

3915: -------------------------------
3916: -- Versioning TL Table
3917: -------------------------------
3918:
3919: INSERT INTO okc_rule_groups_tlh
3920: (
3921: major_version,
3922: id,
3923: language,

Line 4005: FROM okc_rule_groups_tlh

4001: creation_date,
4002: last_updated_by,
4003: last_update_date,
4004: last_update_login
4005: FROM okc_rule_groups_tlh
4006: WHERE id in (SELECT id
4007: FROM okc_rule_groups_bh
4008: WHERE dnz_chr_id = p_chr_id)
4009: AND major_version = p_major_version;