DBA Data[Home] [Help]

APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORG_PROFILES_EXT_TL

Line 828: INSERT INTO hz_org_profiles_ext_tl (

824: FROM hz_org_profiles_ext_b
825: WHERE organization_profile_id = p_old_profile_id;
826:
827: IF (SQL%ROWCOUNT > 0) THEN
828: INSERT INTO hz_org_profiles_ext_tl (
829: extension_id,
830: organization_profile_id,
831: attr_group_id,
832: source_lang,

Line 892: hz_org_profiles_ext_tl tl

888: tl.tl_ext_attr18,
889: tl.tl_ext_attr19,
890: tl.tl_ext_attr20
891: FROM hz_org_profiles_ext_b b,
892: hz_org_profiles_ext_tl tl
893: WHERE b.organization_profile_id = p_new_profile_id
894: AND tl.extension_id = b.old_extension_id;
895: END IF;
896:

Line 1250: INSERT INTO hz_org_profiles_ext_tl ext (

1246: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');
1247:
1248: -- insert into _tl table
1249: --
1250: INSERT INTO hz_org_profiles_ext_tl ext (
1251: extension_id,
1252: organization_profile_id,
1253: attr_group_id,
1254: source_lang,

Line 1314: hz_org_profiles_ext_tl tl,

1310: tl.tl_ext_attr18,
1311: tl.tl_ext_attr19,
1312: tl.tl_ext_attr20
1313: FROM hz_org_profiles_ext_b b,
1314: hz_org_profiles_ext_tl tl,
1315: hz_org_profiles_ext_sg sg
1316: WHERE
1317: sg.work_unit_number = p_work_unit_number
1318: AND b.organization_profile_id = sg.new_profile_id

Line 1325: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_TL');

1321: Write_Log(SQL%ROWCOUNT||' records inserted into org tl table.');
1322:
1323: -- gather table statistics
1324: --
1325: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_TL');
1326:
1327: END copy_org_extension;
1328:
1329: