APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORG_PROFILES_EXT_B

Line 704: INSERT INTO hz_org_profiles_ext_b (

700: -- When the record is copied the original extension_id is stored
701: -- in the old_extension_id column of the record, so that it can be
702: -- used by the CPUI componenet.
703:
704: INSERT INTO hz_org_profiles_ext_b (
705: extension_id,
706: organization_profile_id,
707: attr_group_id,
708: created_by,

Line 824: FROM hz_org_profiles_ext_b

820: d_ext_attr8,
821: d_ext_attr9,
822: d_ext_attr10,
823: extension_id
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 (

Line 891: FROM hz_org_profiles_ext_b b,

887: tl.tl_ext_attr17,
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;

Line 985: FROM hz_org_profiles_ext_b ext

981: AND p1.actual_content_source IN ('SST','USER_ENTERED')
982: AND p2.actual_content_source IN ('SST','USER_ENTERED')
983: AND NOT EXISTS (
984: SELECT null
985: FROM hz_org_profiles_ext_b ext
986: WHERE p1.organization_profile_id = ext.organization_profile_id)
987: AND p2.party_id = p1.party_id
988: AND p2.organization_profile_id <> p1.organization_profile_id
989: AND EXISTS (

Line 991: FROM hz_org_profiles_ext_b ext

987: AND p2.party_id = p1.party_id
988: AND p2.organization_profile_id <> p1.organization_profile_id
989: AND EXISTS (
990: SELECT null
991: FROM hz_org_profiles_ext_b ext
992: WHERE p2.organization_profile_id = ext.organization_profile_id)
993: GROUP BY p1.organization_profile_id);
994:
995: ELSIF p_entity_name = C_PER THEN

Line 1112: INSERT INTO hz_org_profiles_ext_b ext (

1108: BEGIN
1109:
1110: -- insert into _b table
1111: --
1112: INSERT INTO hz_org_profiles_ext_b ext (
1113: extension_id,
1114: organization_profile_id,
1115: attr_group_id,
1116: created_by,

Line 1232: FROM hz_org_profiles_ext_b b,

1228: d_ext_attr8,
1229: d_ext_attr9,
1230: d_ext_attr10,
1231: extension_id
1232: FROM hz_org_profiles_ext_b b,
1233: hz_org_profiles_ext_sg sg
1234: WHERE
1235: sg.work_unit_number = p_work_unit_number
1236: AND b.organization_profile_id = sg.old_profile_id;

Line 1246: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');

1242: END IF;
1243:
1244: -- gather table statistics
1245: --
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 (

Line 1313: FROM hz_org_profiles_ext_b b,

1309: tl.tl_ext_attr17,
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

Line 1774: FROM hz_org_profiles_ext_b

1770: ) IS
1771:
1772: CURSOR c_org_extension_exists IS
1773: SELECT 'Y'
1774: FROM hz_org_profiles_ext_b
1775: WHERE rownum = 1;
1776:
1777: CURSOR c_per_extension_exists IS
1778: SELECT 'Y'