APPS.ZX_RULES_PKG dependencies on ZX_RULES_TL

Line 540: insert into ZX_RULES_TL (

536: X_GEOGRAPHY_ID ,
537: X_TAX_LAW_REF_CODE ,
538: X_LAST_UPDATE_MODE_FLAG ,
539: X_NEVER_BEEN_ENABLED_FLAG);
540: insert into ZX_RULES_TL (
541: TAX_RULE_ID,
542: TAX_RULE_NAME,
543: TAX_RULE_DESC,
544: CREATION_DATE,

Line 568: from ZX_RULES_TL T

564: from FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and not exists
567: (select NULL
568: from ZX_RULES_TL T
569: where T.TAX_RULE_ID = X_TAX_RULE_ID
570: and T.LANGUAGE = L.LANGUAGE_CODE);
571:
572: open c;

Line 660: from ZX_RULES_TL

656: TAX_RULE_NAME,
657: TAX_RULE_DESC,
658: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG ,
659: TAX_LAW_REF_DESC
660: from ZX_RULES_TL
661: where TAX_RULE_ID = X_TAX_RULE_ID
662: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
663: for update of TAX_RULE_ID nowait;
664:

Line 830: update ZX_RULES_TL set

826: if (sql%notfound) then
827: raise no_data_found;
828: end if;
829:
830: update ZX_RULES_TL set
831: TAX_RULE_NAME = X_TAX_RULE_NAME,
832: TAX_RULE_DESC = X_TAX_RULE_DESC,
833: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
834: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 854: delete from ZX_RULES_TL

850: procedure DELETE_ROW (
851: X_TAX_RULE_ID in NUMBER) is
852:
853: begin
854: delete from ZX_RULES_TL
855: where TAX_RULE_ID = X_TAX_RULE_ID;
856:
857: if (sql%notfound) then
858: raise no_data_found;

Line 876: delete from ZX_RULES_TL T

872: end DELETE_ROW;
873:
874: procedure ADD_LANGUAGE is
875: begin
876: delete from ZX_RULES_TL T
877: where not exists
878: (select NULL
879: from ZX_RULES_B B
880: where B.TAX_RULE_ID = T.TAX_RULE_ID);

Line 881: update ZX_RULES_TL T set (

877: where not exists
878: (select NULL
879: from ZX_RULES_B B
880: where B.TAX_RULE_ID = T.TAX_RULE_ID);
881: update ZX_RULES_TL T set (
882: TAX_RULE_NAME,
883: TAX_RULE_DESC) = (select B.TAX_RULE_NAME,
884: B.TAX_RULE_DESC
885: from ZX_RULES_TL B

Line 885: from ZX_RULES_TL B

881: update ZX_RULES_TL T set (
882: TAX_RULE_NAME,
883: TAX_RULE_DESC) = (select B.TAX_RULE_NAME,
884: B.TAX_RULE_DESC
885: from ZX_RULES_TL B
886: where B.TAX_RULE_ID = T.TAX_RULE_ID
887: and B.LANGUAGE = T.SOURCE_LANG)
888: where (T.TAX_RULE_ID, T.LANGUAGE) in
889: (select SUBT.TAX_RULE_ID,

Line 891: from ZX_RULES_TL SUBB, ZX_RULES_TL SUBT

887: and B.LANGUAGE = T.SOURCE_LANG)
888: where (T.TAX_RULE_ID, T.LANGUAGE) in
889: (select SUBT.TAX_RULE_ID,
890: SUBT.LANGUAGE
891: from ZX_RULES_TL SUBB, ZX_RULES_TL SUBT
892: where SUBB.TAX_RULE_ID = SUBT.TAX_RULE_ID
893: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
894: and (SUBB.TAX_RULE_NAME <> SUBT.TAX_RULE_NAME
895: or SUBB.TAX_RULE_DESC <> SUBT.TAX_RULE_DESC

Line 899: insert into ZX_RULES_TL (

895: or SUBB.TAX_RULE_DESC <> SUBT.TAX_RULE_DESC
896: or (SUBB.TAX_RULE_DESC is null and SUBT.TAX_RULE_DESC is not null)
897: or (SUBB.TAX_RULE_DESC is not null and SUBT.TAX_RULE_DESC is null) ));
898:
899: insert into ZX_RULES_TL (
900: TAX_RULE_ID,
901: TAX_RULE_NAME,
902: TAX_RULE_DESC,
903: CREATION_DATE,

Line 921: from ZX_RULES_TL B, FND_LANGUAGES L

917: B.LAST_UPDATED_BY,
918: B.LAST_UPDATE_LOGIN,
919: L.LANGUAGE_CODE,
920: B.SOURCE_LANG
921: from ZX_RULES_TL B, FND_LANGUAGES L
922: where L.INSTALLED_FLAG in ('I', 'B')
923: and B.LANGUAGE = userenv('LANG')
924: and not exists
925: (select NULL

Line 926: from ZX_RULES_TL T

922: where L.INSTALLED_FLAG in ('I', 'B')
923: and B.LANGUAGE = userenv('LANG')
924: and not exists
925: (select NULL
926: from ZX_RULES_TL T
927: where T.TAX_RULE_ID = B.TAX_RULE_ID
928: and T.LANGUAGE = L.LANGUAGE_CODE);
929:
930: EXCEPTION

Line 1008: INSERT INTO ZX_RULES_TL (TAX_RULE_ID,

1004: fnd_global.conc_login_id
1005: );
1006:
1007: forall i in x_tax_rule_id.first..x_tax_rule_id.last
1008: INSERT INTO ZX_RULES_TL (TAX_RULE_ID,
1009: TAX_RULE_NAME,
1010: TAX_RULE_DESC,
1011: CREATED_BY ,
1012: CREATION_DATE ,

Line 1033: from ZX_RULES_TL T

1029: from FND_LANGUAGES L
1030: where L.INSTALLED_FLAG in ('I', 'B')
1031: and not exists
1032: (select 1
1033: from ZX_RULES_TL T
1034: where T.TAX_RULE_ID = X_TAX_RULE_ID(i)
1035: and T.LANGUAGE = L.LANGUAGE_CODE);
1036: end if;
1037: