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 1242: INSERT INTO hz_org_profiles_ext_tl ext (

1238: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');
1239:
1240: -- insert into _tl table
1241: --
1242: INSERT INTO hz_org_profiles_ext_tl ext (
1243: extension_id,
1244: organization_profile_id,
1245: attr_group_id,
1246: source_lang,

Line 1306: hz_org_profiles_ext_tl tl,

1302: tl.tl_ext_attr18,
1303: tl.tl_ext_attr19,
1304: tl.tl_ext_attr20
1305: FROM hz_org_profiles_ext_b b,
1306: hz_org_profiles_ext_tl tl,
1307: hz_org_profiles_ext_sg sg
1308: WHERE
1309: sg.work_unit_number = p_work_unit_number
1310: AND b.organization_profile_id = sg.new_profile_id

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

1313: Write_Log(SQL%ROWCOUNT||' records inserted into org tl table.');
1314:
1315: -- gather table statistics
1316: --
1317: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_TL');
1318:
1319: END copy_org_extension;
1320:
1321: