DBA Data[Home] [Help]

APPS.ASO_SUP_TEMPLATE_PKG dependencies on FND_LOAD_UTIL

Line 687: last_updated_by = fnd_load_util.owner_id(X_OWNER),

683: set TEMPLATE_NAME = P_TEMPLATE_NAME,
684: DESCRIPTION = P_DESCRIPTION,
685: source_lang = userenv('LANG'),
686: last_update_date = sysdate,
687: last_updated_by = fnd_load_util.owner_id(X_OWNER),
688: last_update_login = 0
689: where TEMPLATE_ID = P_TEMPLATE_ID
690: and userenv('LANG') in (language, source_lang);
691:

Line 745: if (fnd_load_util.owner_id(P_OWNER) = 120 ) then

741: X_OWNER => P_OWNER);
742:
743: else
744:
745: if (fnd_load_util.owner_id(P_OWNER) = 120 ) then
746:
747: open get_templates;
748: loop
749: fetch get_templates into l_template_id;

Line 755: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,

751: -- this means template already exists
752: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (
753: P_TEMPLATE_ID => PX_TEMPLATE_ID,
754: P_LAST_UPDATE_DATE => sysdate ,
755: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
756: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,
757: P_TEMPLATE_NAME => P_TEMPLATE_NAME,
758: P_DESCRIPTION => P_DESCRIPTION,
759: P_TEMPLATE_LEVEL => P_TEMPLATE_LEVEL,

Line 756: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,

752: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (
753: P_TEMPLATE_ID => PX_TEMPLATE_ID,
754: P_LAST_UPDATE_DATE => sysdate ,
755: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
756: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,
757: P_TEMPLATE_NAME => P_TEMPLATE_NAME,
758: P_DESCRIPTION => P_DESCRIPTION,
759: P_TEMPLATE_LEVEL => P_TEMPLATE_LEVEL,
760: P_TEMPLATE_CONTEXT => P_TEMPLATE_CONTEXT,

Line 791: P_CREATED_BY => fnd_load_util.owner_id(P_OWNER) ,

787: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (
788: PX_ROWID => row_id,
789: PX_TEMPLATE_ID => l_TEMPLATE_ID,
790: P_CREATION_DATE => sysdate ,
791: P_CREATED_BY => fnd_load_util.owner_id(P_OWNER) ,
792: P_LAST_UPDATE_DATE => sysdate ,
793: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
794: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,
795: P_TEMPLATE_NAME => P_TEMPLATE_NAME,

Line 793: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,

789: PX_TEMPLATE_ID => l_TEMPLATE_ID,
790: P_CREATION_DATE => sysdate ,
791: P_CREATED_BY => fnd_load_util.owner_id(P_OWNER) ,
792: P_LAST_UPDATE_DATE => sysdate ,
793: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
794: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,
795: P_TEMPLATE_NAME => P_TEMPLATE_NAME,
796: P_DESCRIPTION => P_DESCRIPTION,
797: P_TEMPLATE_LEVEL => P_TEMPLATE_LEVEL,

Line 794: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,

790: P_CREATION_DATE => sysdate ,
791: P_CREATED_BY => fnd_load_util.owner_id(P_OWNER) ,
792: P_LAST_UPDATE_DATE => sysdate ,
793: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
794: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,
795: P_TEMPLATE_NAME => P_TEMPLATE_NAME,
796: P_DESCRIPTION => P_DESCRIPTION,
797: P_TEMPLATE_LEVEL => P_TEMPLATE_LEVEL,
798: P_TEMPLATE_CONTEXT => P_TEMPLATE_CONTEXT,