APPS.FND_INDUSTRIES_PKG dependencies on FND_INDUSTRIES

Line 1: package body FND_INDUSTRIES_PKG as

1: package body FND_INDUSTRIES_PKG as
2: /* $Header: AFINDSTB.pls 115.1 2004/08/20 14:11:40 dbowles noship $ */
3:
4: -- TRANSLATE_ROW and LOAD_ROW is identical code. Two procedures were
5: -- written to accomodate NLS standards.

Line 34: FROM FND_INDUSTRIES

30: -- Translate creator to f_creator
31: f_creator := fnd_load_util.owner_id(X_CREATED_BY);
32: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
33: into db_luby, db_ludate
34: FROM FND_INDUSTRIES
35: WHERE INDUSTRY_ID = X_INDUSTRY_ID AND
36: CREATED_BY = f_creator AND
37: LANGUAGE = userenv('LANG');
38: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 40: update fnd_industries set

36: CREATED_BY = f_creator AND
37: LANGUAGE = userenv('LANG');
38: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
39: db_ludate, X_CUSTOM_MODE)) then
40: update fnd_industries set
41: industry_name = X_INDUSTRY_NAME,
42: description = X_DESCRIPTION,
43: last_update_date = f_ludate,
44: last_updated_by = f_luby,

Line 82: FROM FND_INDUSTRIES

78: f_creator := fnd_load_util.owner_id(X_CREATED_BY);
79: BEGIN
80: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
81: into db_luby, db_ludate
82: FROM FND_INDUSTRIES
83: WHERE INDUSTRY_ID = X_INDUSTRY_ID AND
84: CREATED_BY = f_creator AND
85: LANGUAGE = userenv('LANG');
86: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 88: update fnd_industries set

84: CREATED_BY = f_creator AND
85: LANGUAGE = userenv('LANG');
86: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
87: db_ludate, X_CUSTOM_MODE)) then
88: update fnd_industries set
89: industry_name = X_INDUSTRY_NAME,
90: description = X_DESCRIPTION,
91: last_update_date = f_ludate,
92: last_updated_by = f_luby,

Line 99: insert into fnd_industries(

95: AND userenv('LANG') in (language, source_lang);
96: END IF;
97: EXCEPTION
98: when NO_DATA_FOUND then
99: insert into fnd_industries(
100: industry_id,
101: industry_name,
102: description,
103: created_by,

Line 126: from fnd_industries t

122: fnd_languages l
123: where l.installed_flag in ('I', 'B')
124: and not exists
125: (select null
126: from fnd_industries t
127: where t.industry_id = x_industry_id
128: and t.language = l.language_code);
129:
130: END;

Line 137: insert into fnd_industries(

133:
134: PROCEDURE ADD_LANGUAGE IS
135:
136: BEGIN
137: insert into fnd_industries(
138: industry_id,
139: industry_name,
140: description,
141: created_by,

Line 159: from fnd_industries b, fnd_languages l

155: b.last_updated_by,
156: b.last_update_login,
157: b.source_lang,
158: l.language_code
159: from fnd_industries b, fnd_languages l
160: where l.INSTALLED_FLAG in ('I', 'B')
161: and b.language = userenv('LANG')
162: and not exists
163: (select NULL

Line 164: from fnd_industries t

160: where l.INSTALLED_FLAG in ('I', 'B')
161: and b.language = userenv('LANG')
162: and not exists
163: (select NULL
164: from fnd_industries t
165: where t.industry_id = b.industry_id
166: and t.language = l.language_code);
167:
168:

Line 172: END FND_INDUSTRIES_PKG;

168:
169:
170: end ADD_LANGUAGE;
171:
172: END FND_INDUSTRIES_PKG;