APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORG_PROFILES_EXT_SG

Line 961: INSERT INTO hz_org_profiles_ext_sg (

957:
958: IF p_entity_name = C_ORG THEN
959: -- insert into org staging table
960: --
961: INSERT INTO hz_org_profiles_ext_sg (
962: old_profile_id,
963: new_profile_id,
964: work_unit_number,
965: status

Line 1057: UPDATE hz_org_profiles_ext_sg

1053:
1054: IF p_entity_name = C_ORG THEN
1055: -- update org staging table
1056: --
1057: UPDATE hz_org_profiles_ext_sg
1058: SET status = p_status
1059: WHERE work_unit_number = p_work_unit_number;
1060:
1061: ELSIF p_entity_name = C_PER THEN

Line 1225: hz_org_profiles_ext_sg sg

1221: d_ext_attr9,
1222: d_ext_attr10,
1223: extension_id
1224: FROM hz_org_profiles_ext_b b,
1225: hz_org_profiles_ext_sg sg
1226: WHERE
1227: sg.work_unit_number = p_work_unit_number
1228: AND b.organization_profile_id = sg.old_profile_id;
1229:

Line 1307: hz_org_profiles_ext_sg sg

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

Line 1596: FROM hz_org_profiles_ext_sg

1592: ) IS
1593:
1594: CURSOR c_org_work_unit IS
1595: SELECT work_unit_number
1596: FROM hz_org_profiles_ext_sg
1597: WHERE status = 'N'
1598: AND ROWNUM =1;
1599:
1600: CURSOR c_per_work_unit IS

Line 1610: FROM hz_org_profiles_ext_sg

1606: CURSOR c_lock_org_records (
1607: p_work_unit_number NUMBER
1608: ) IS
1609: SELECT *
1610: FROM hz_org_profiles_ext_sg
1611: WHERE status = 'N'
1612: AND work_unit_number = p_work_unit_number
1613: FOR UPDATE NOWAIT;
1614:

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

1825: Write_Log('l_owner = '||l_owner);
1826:
1827: l_sql := 'truncate table '||l_owner||'.';
1828: IF p_entity_name = C_ORG THEN
1829: l_sql := l_sql||'HZ_ORG_PROFILES_EXT_SG';
1830: ELSE
1831: l_sql := l_sql||'HZ_PER_PROFILES_EXT_SG';
1832: END IF;
1833: execute immediate l_sql;