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:
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;
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,
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,
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,
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,
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,