DBA Data[Home] [Help]

APPS.IEU_SEED_DATA_LOADER_PKG dependencies on FND_LOAD_UTIL

Line 24: user_id := fnd_load_util.owner_id(P_OWNER);

20: --if (P_OWNER = 'SEED') then
21: -- user_id := 1;
22: --end if;
23:
24: user_id := fnd_load_util.owner_id(P_OWNER);
25:
26: update IEU_UWQ_SVR_MPS_MMAPS b
27: set b.LAST_UPDATED_BY = user_id,
28: b.LAST_UPDATE_DATE = SYSDATE,

Line 83: user_id := fnd_load_util.owner_id(P_OWNER);

79: --if (P_OWNER = 'SEED') then
80: -- user_id := 1;
81: --end if;
82:
83: user_id := fnd_load_util.owner_id(P_OWNER);
84:
85: update IEU_UWQ_CLI_MED_PLUGINS b
86: set b.LAST_UPDATED_BY = user_id,
87: b.LAST_UPDATE_DATE = SYSDATE,

Line 141: user_id := fnd_load_util.owner_id(P_OWNER);

137: --if (P_OWNER = 'SEED') then
138: -- user_id := 1;
139: --end if;
140:
141: user_id := fnd_load_util.owner_id(P_OWNER);
142:
143: update IEU_UWQ_SVR_MPS_PLUGINS b
144: set b.LAST_UPDATED_BY = user_id,
145: b.LAST_UPDATE_DATE = SYSDATE,

Line 200: user_id := fnd_load_util.owner_id(P_OWNER);

196: --if (P_OWNER = 'SEED') then
197: -- user_id := 1;
198: -- end if;
199:
200: user_id := fnd_load_util.owner_id(P_OWNER);
201:
202: update IEU_UWQ_SEL_ENUMERATORS b
203: set b.LAST_UPDATED_BY = user_id,
204: b.LAST_UPDATE_DATE = SYSDATE,

Line 290: l_user_id := fnd_load_util.owner_id(P_OWNER);

286: --if (P_OWNER = 'SEED') then
287: -- l_user_id := 1;
288: --end if;
289:
290: l_user_id := fnd_load_util.owner_id(P_OWNER);
291:
292: begin
293:
294: -- if we're uploading IEU data, then we don't want to over-write

Line 472: l_user_id := fnd_load_util.owner_id(P_OWNER);

468: --if (:OWNER = 'SEED') then
469: -- l_user_id := 1;
470: --end if;
471:
472: l_user_id := fnd_load_util.owner_id(P_OWNER);
473:
474: update IEU_UWQ_NODE_DS m
475: set
476: m.LAST_UPDATED_BY = l_user_id,

Line 535: l_user_id := fnd_load_util.owner_id(P_OWNER);

531: --if (:OWNER = 'SEED') then
532: -- l_user_id := 1;
533: --end if;
534:
535: l_user_id := fnd_load_util.owner_id(P_OWNER);
536:
537: begin
538: update IEU_UWQ_RES_CAT_ENM_MAPS m
539: set

Line 599: user_id := fnd_load_util.owner_id(P_OWNER);

595: --IF (P_OWNER = 'SEED') then
596: --user_id := 1;
597: --END IF;
598:
599: user_id := fnd_load_util.owner_id(P_OWNER);
600:
601: UPDATE IEU_CLI_PROV_PLUGINS cliprov
602: SET
603: cliprov.LAST_UPDATED_BY = user_id,

Line 664: user_id := fnd_load_util.owner_id(P_OWNER);

660: --IF (P_OWNER = 'SEED') then
661: -- user_id := 1;
662: -- END IF;
663:
664: user_id := fnd_load_util.owner_id(P_OWNER);
665:
666: UPDATE IEU_CLI_PROV_PLUGIN_MED_MAPS clipmmap
667: SET
668: clipmmap.LAST_UPDATED_BY = user_id,

Line 725: user_id := fnd_load_util.owner_id(P_OWNER);

721: --if (p_owner = 'SEED') then
722: -- user_id := 1;
723: --end if;
724:
725: user_id := fnd_load_util.owner_id(P_OWNER);
726:
727: if (p_upload_mode = 'NLS') then
728: update IEU_WP_SECTIONS_TL
729: set source_lang = userenv('LANG'),

Line 849: user_id := fnd_load_util.owner_id(P_OWNER);

845: -- user_id := 1;
846: -- created_id := -1;
847: --end if;
848:
849: user_id := fnd_load_util.owner_id(P_OWNER);
850:
851: update ieu_wp_action_params
852: set LAST_UPDATED_BY = user_id,
853: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),

Line 919: user_id := fnd_load_util.owner_id(P_OWNER);

915: -- user_id := 1;
916: -- created_id := -1;
917: --end if;
918:
919: user_id := fnd_load_util.owner_id(P_OWNER);
920:
921: update IEU_UWQ_NONMEDIA_ACTIONS
922: set LAST_UPDATED_BY = user_id,
923: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),

Line 1009: user_id := fnd_load_util.owner_id(P_OWNER);

1005: -- user_id := 1;
1006: -- created_id := -1;
1007: --end if;
1008:
1009: user_id := fnd_load_util.owner_id(P_OWNER);
1010:
1011: select last_updated_by into l_last_updated_by
1012: from ieu_wp_action_maps
1013: where wp_action_map_id = P_WP_ACTION_MAP_ID;