APPS.AR_VAT_TAX_PKG dependencies on AR_VAT_TAX_ALL_TL

Line 269: insert into AR_VAT_TAX_ALL_TL (

265: );
266:
267: /* bug 1722260 : modify where clause of t.org_id */
268:
269: insert into AR_VAT_TAX_ALL_TL (
270: ORG_ID,
271: VAT_TAX_ID,
272: PRINTED_TAX_NAME,
273: LAST_UPDATE_DATE,

Line 295: from AR_VAT_TAX_ALL_TL T

291: from FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and not exists
294: (select NULL
295: from AR_VAT_TAX_ALL_TL T
296: where T.VAT_TAX_ID = X_VAT_TAX_ID
297: and T.LANGUAGE = L.LANGUAGE_CODE
298: and T.ORG_ID = X_ORG_ID);
299: /*and NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),

Line 646: from AR_VAT_TAX_ALL_TL

642:
643: cursor c1 is select
644: PRINTED_TAX_NAME,
645: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
646: from AR_VAT_TAX_ALL_TL
647: where VAT_TAX_ID = X_VAT_TAX_ID
648: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
649: /* and ORG_ID = X_ORG_ID
650: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 979: update AR_VAT_TAX_ALL_TL set

975: if (sql%notfound) then
976: raise no_data_found;
977: end if;
978:
979: update AR_VAT_TAX_ALL_TL set
980: PRINTED_TAX_NAME = X_PRINTED_TAX_NAME,
981: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
982: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
983: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1089: delete from AR_VAT_TAX_ALL_TL

1085: procedure DELETE_ROW (
1086: X_VAT_TAX_ID in NUMBER
1087: ) is
1088: begin
1089: delete from AR_VAT_TAX_ALL_TL
1090: where VAT_TAX_ID = X_VAT_TAX_ID;
1091: /* moac yk and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1092: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
1093: NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 1115: delete from AR_VAT_TAX_ALL_TL T

1111:
1112: procedure ADD_LANGUAGE
1113: is
1114: begin
1115: delete from AR_VAT_TAX_ALL_TL T
1116: where not exists
1117: (select NULL
1118: from AR_VAT_TAX_ALL_B B
1119: where B.VAT_TAX_ID = T.VAT_TAX_ID

Line 1126: update AR_VAT_TAX_ALL_TL T set (

1122: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1123: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) */
1124: );
1125:
1126: update AR_VAT_TAX_ALL_TL T set (
1127: PRINTED_TAX_NAME
1128: ) = (select
1129: B.PRINTED_TAX_NAME
1130: from AR_VAT_TAX_ALL_TL B

Line 1130: from AR_VAT_TAX_ALL_TL B

1126: update AR_VAT_TAX_ALL_TL T set (
1127: PRINTED_TAX_NAME
1128: ) = (select
1129: B.PRINTED_TAX_NAME
1130: from AR_VAT_TAX_ALL_TL B
1131: where B.VAT_TAX_ID = T.VAT_TAX_ID
1132: and B.LANGUAGE = T.SOURCE_LANG
1133: /* moac yk3 and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1134: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 1143: from AR_VAT_TAX_ALL_TL SUBB, AR_VAT_TAX_ALL_TL SUBT

1139: T.LANGUAGE
1140: ) in (select
1141: SUBT.VAT_TAX_ID,
1142: SUBT.LANGUAGE
1143: from AR_VAT_TAX_ALL_TL SUBB, AR_VAT_TAX_ALL_TL SUBT
1144: where SUBB.VAT_TAX_ID = SUBT.VAT_TAX_ID
1145: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1146: /* moac yk4 and NVL(SUBB.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1147: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 1155: insert into AR_VAT_TAX_ALL_TL (

1151: or (SUBB.PRINTED_TAX_NAME is null and SUBT.PRINTED_TAX_NAME is not null)
1152: or (SUBB.PRINTED_TAX_NAME is not null and SUBT.PRINTED_TAX_NAME is null)
1153: ));
1154:
1155: insert into AR_VAT_TAX_ALL_TL (
1156: ORG_ID,
1157: VAT_TAX_ID,
1158: PRINTED_TAX_NAME,
1159: LAST_UPDATE_DATE,

Line 1177: from AR_VAT_TAX_ALL_TL B, FND_LANGUAGES L

1173: B.LAST_UPDATED_BY,
1174: B.LAST_UPDATE_LOGIN,
1175: L.LANGUAGE_CODE,
1176: B.SOURCE_LANG
1177: from AR_VAT_TAX_ALL_TL B, FND_LANGUAGES L
1178: where L.INSTALLED_FLAG in ('I', 'B')
1179: and B.LANGUAGE = userenv('LANG')
1180: and not exists
1181: (select NULL

Line 1182: from AR_VAT_TAX_ALL_TL T

1178: where L.INSTALLED_FLAG in ('I', 'B')
1179: and B.LANGUAGE = userenv('LANG')
1180: and not exists
1181: (select NULL
1182: from AR_VAT_TAX_ALL_TL T
1183: where T.VAT_TAX_ID = B.VAT_TAX_ID
1184: and T.LANGUAGE = L.LANGUAGE_CODE
1185: /* moac yk5 and NVL(T.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1186: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 1455: update AR_VAT_TAX_ALL_TL

1451: -- note org_id is not used here because in NLS mode it is important
1452: -- update a line id across all orgs because data will be translated
1453: -- only once for a single org
1454:
1455: update AR_VAT_TAX_ALL_TL
1456: set PRINTED_TAX_NAME = X_PRINTED_TAX_NAME,
1457: source_lang = userenv('LANG'),
1458: last_update_date = sysdate,
1459: last_updated_by = decode(X_OWNER, 'SEED', -1, 0),