APPS.XDO_CURRENCY_FORMAT_SETS_PKG dependencies on XDO_CURRENCY_FORMAT_SETS_TL

Line 30: insert into XDO_CURRENCY_FORMAT_SETS_TL (

26: P_LAST_UPDATED_BY,
27: P_LAST_UPDATE_LOGIN
28: );
29:
30: insert into XDO_CURRENCY_FORMAT_SETS_TL (
31: FORMAT_SET_CODE,
32: FORMAT_SET_NAME,
33: CREATION_DATE,
34: CREATED_BY,

Line 53: from XDO_CURRENCY_FORMAT_SETS_TL T

49: from FND_LANGUAGES L
50: where L.INSTALLED_FLAG in ('I', 'B')
51: and not exists
52: (select NULL
53: from XDO_CURRENCY_FORMAT_SETS_TL T
54: where T.FORMAT_SET_CODE = P_FORMAT_SET_CODE
55: and T.LANGUAGE = L.LANGUAGE_CODE);
56:
57: end INSERT_ROW;

Line 78: update XDO_CURRENCY_FORMAT_SETS_TL set

74: if (sql%notfound) then
75: raise no_data_found;
76: end if;
77:
78: update XDO_CURRENCY_FORMAT_SETS_TL set
79: FORMAT_SET_NAME = P_FORMAT_SET_NAME,
80: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
81: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
82: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 96: insert into XDO_CURRENCY_FORMAT_SETS_TL (

92:
93:
94: procedure ADD_LANGUAGE is
95: begin
96: insert into XDO_CURRENCY_FORMAT_SETS_TL (
97: FORMAT_SET_CODE,
98: CREATED_BY,
99: CREATION_DATE,
100: LAST_UPDATED_BY,

Line 114: from XDO_CURRENCY_FORMAT_SETS_TL B, FND_LANGUAGES L

110: B.LAST_UPDATE_DATE,
111: B.LAST_UPDATE_LOGIN,
112: L.LANGUAGE_CODE,
113: B.SOURCE_LANG
114: from XDO_CURRENCY_FORMAT_SETS_TL B, FND_LANGUAGES L
115: where L.INSTALLED_FLAG in ('I', 'B')
116: and B.LANGUAGE = userenv('LANG')
117: and not exists
118: (select NULL

Line 119: from XDO_CURRENCY_FORMAT_SETS_TL T

115: where L.INSTALLED_FLAG in ('I', 'B')
116: and B.LANGUAGE = userenv('LANG')
117: and not exists
118: (select NULL
119: from XDO_CURRENCY_FORMAT_SETS_TL T
120: where T.FORMAT_SET_CODE = B.FORMAT_SET_CODE
121: and T.LANGUAGE = L.LANGUAGE_CODE);
122: end ADD_LANGUAGE;
123: