APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORG_PROFILES_EXT_SG

Line 965: INSERT INTO hz_org_profiles_ext_sg (

961: hz_common_pub.disable_cont_source_security;
962: IF p_entity_name = C_ORG THEN
963: -- insert into org staging table
964: --
965: INSERT INTO hz_org_profiles_ext_sg (
966: old_profile_id,
967: new_profile_id,
968: work_unit_number,
969: status

Line 1065: UPDATE hz_org_profiles_ext_sg

1061:
1062: IF p_entity_name = C_ORG THEN
1063: -- update org staging table
1064: --
1065: UPDATE hz_org_profiles_ext_sg
1066: SET status = p_status
1067: WHERE work_unit_number = p_work_unit_number;
1068:
1069: ELSIF p_entity_name = C_PER THEN

Line 1233: hz_org_profiles_ext_sg sg

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

Line 1315: hz_org_profiles_ext_sg sg

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
1319: AND tl.extension_id = b.old_extension_id;

Line 1604: FROM hz_org_profiles_ext_sg

1600: ) IS
1601:
1602: CURSOR c_org_work_unit IS
1603: SELECT work_unit_number
1604: FROM hz_org_profiles_ext_sg
1605: WHERE status = 'N'
1606: AND ROWNUM =1;
1607:
1608: CURSOR c_per_work_unit IS

Line 1618: FROM hz_org_profiles_ext_sg

1614: CURSOR c_lock_org_records (
1615: p_work_unit_number NUMBER
1616: ) IS
1617: SELECT *
1618: FROM hz_org_profiles_ext_sg
1619: WHERE status = 'N'
1620: AND work_unit_number = p_work_unit_number
1621: FOR UPDATE NOWAIT;
1622:

Line 1837: l_sql := l_sql||'HZ_ORG_PROFILES_EXT_SG';

1833: Write_Log('l_owner = '||l_owner);
1834:
1835: l_sql := 'truncate table '||l_owner||'.';
1836: IF p_entity_name = C_ORG THEN
1837: l_sql := l_sql||'HZ_ORG_PROFILES_EXT_SG';
1838: ELSE
1839: l_sql := l_sql||'HZ_PER_PROFILES_EXT_SG';
1840: END IF;
1841: execute immediate l_sql;