APPS.FLM_SEQ_ATTRIBUTES_PKG dependencies on FLM_SEQ_ATTRIBUTES

Line 1: package body FLM_SEQ_ATTRIBUTES_PKG as

1: package body FLM_SEQ_ATTRIBUTES_PKG as
2: /* $Header: FLMSQATB.pls 120.1 2006/11/03 02:25:44 ksuleman noship $ */
3:
4: procedure LOAD_SEED_ROW(
5: x_upload_mode in varchar2,

Line 18: FLM_SEQ_ATTRIBUTES_PKG.TRANSLATE_ROW(

14: x_owner in varchar2,
15: x_last_update_date in varchar2) is
16: begin
17: if (x_upload_mode = 'NLS') then
18: FLM_SEQ_ATTRIBUTES_PKG.TRANSLATE_ROW(
19: x_custom_mode,
20: x_attribute_id,
21: x_description,
22: x_owner,

Line 25: FLM_SEQ_ATTRIBUTES_PKG.LOAD_ROW(

21: x_description,
22: x_owner,
23: x_last_update_date);
24: else
25: FLM_SEQ_ATTRIBUTES_PKG.LOAD_ROW(
26: x_custom_mode,
27: x_attribute_id,
28: x_attribute_name,
29: x_description,

Line 58: from FLM_SEQ_ATTRIBUTES

54:
55: -- Row exists, test if it should be over-written.
56: select LAST_UPDATED_BY, LAST_UPDATE_DATE
57: into db_luby, db_ludate
58: from FLM_SEQ_ATTRIBUTES
59: where ATTRIBUTE_ID = x_attribute_id;
60:
61: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
62: db_ludate, x_custom_mode)) then

Line 63: update FLM_SEQ_ATTRIBUTES set

59: where ATTRIBUTE_ID = x_attribute_id;
60:
61: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
62: db_ludate, x_custom_mode)) then
63: update FLM_SEQ_ATTRIBUTES set
64: DESCRIPTION = x_description,
65: LAST_UPDATED_BY = user_id,
66: LAST_UPDATE_DATE = f_ludate,
67: LAST_UPDATE_LOGIN = 0

Line 105: from FLM_SEQ_ATTRIBUTES

101: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
102:
103: select count(*)
104: into other_att
105: from FLM_SEQ_ATTRIBUTES
106: where ATTRIBUTE_NAME = x_attribute_name
107: and ATTRIBUTE_ID > 1000;
108:
109: if other_att > 0 then

Line 115: from FLM_SEQ_ATTRIBUTES

111: end if;
112:
113: select LAST_UPDATED_BY, LAST_UPDATE_DATE
114: into db_luby, db_ludate
115: from FLM_SEQ_ATTRIBUTES
116: where ATTRIBUTE_ID = x_attribute_id;
117:
118: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
119: db_ludate, x_custom_mode)) then

Line 120: update FLM_SEQ_ATTRIBUTES set

116: where ATTRIBUTE_ID = x_attribute_id;
117:
118: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
119: db_ludate, x_custom_mode)) then
120: update FLM_SEQ_ATTRIBUTES set
121: ATTRIBUTE_NAME = x_attribute_name,
122: DESCRIPTION = x_description,
123: USER_DEFINED_FLAG = x_user_defined_flag,
124: ATTRIBUTE_TYPE = x_attribute_type,

Line 136: insert into FLM_SEQ_ATTRIBUTES (

132:
133: exception
134: when no_data_found then
135: -- Row doesn't exist yet. Now this insert statement is placed here.
136: insert into FLM_SEQ_ATTRIBUTES (
137: ATTRIBUTE_ID,
138: ATTRIBUTE_NAME,
139: DESCRIPTION,
140: USER_DEFINED_FLAG,

Line 168: end FLM_SEQ_ATTRIBUTES_PKG;

164:
165: end LOAD_ROW;
166:
167:
168: end FLM_SEQ_ATTRIBUTES_PKG;