eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE_SHADOW dependencies on HZ_PARTIES

Line 974: p_step=>'HZ_PARTIES');

970: END LOOP;
971: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_POPULATE_THIN';
972: create_log(
973: p_operation=>'SHADOW_POPULATE_THIN',
974: p_step=>'HZ_PARTIES');
975: create_log(
976: p_operation=>'SHADOW_POPULATE_THIN',
977: p_step=>'HZ_PARTY_SITES');
978: create_log(

Line 988: p_step=>'HZ_PARTIES');

984:
985: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_CREATE_INDEXES';
986: create_log(
987: p_operation=>'SHADOW_CREATE_INDEXES',
988: p_step=>'HZ_PARTIES');
989: create_log(
990: p_operation=>'SHADOW_CREATE_INDEXES',
991: p_step=>'HZ_PARTY_SITES');
992: create_log(

Line 1085: AND step = 'HZ_PARTIES';

1081: BEGIN
1082: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1083: FROM HZ_DQM_STAGE_LOG
1084: WHERE OPERATION = 'SHADOW_POPULATE_THIN'
1085: AND step = 'HZ_PARTIES';
1086: EXCEPTION
1087: WHEN no_data_found THEN
1088: l_start_flag:=NULL;
1089: l_end_flag:=NULL;

Line 1098: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';

1094: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PARTIES';
1095: log('Done');
1096: end if;
1097: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1098: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';
1099: COMMIT;
1100: insert_into_thin_tables('PARTIES');
1101: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1102: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';

Line 1102: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';

1098: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';
1099: COMMIT;
1100: insert_into_thin_tables('PARTIES');
1101: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1102: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';
1103: COMMIT;
1104: END IF;
1105: BEGIN
1106: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag

Line 1209: l_index := 'HZ_PARTIES';

1205: else
1206: create_index_flag := false;
1207: end if;
1208: if I = 1 then
1209: l_index := 'HZ_PARTIES';
1210: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1211: BEGIN
1212: SELECT 1 INTO T FROM HZ_THIN_ST_PARTIES
1213: WHERE ROWNUM=1

Line 1219: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTIES';

1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: UPDATE HZ_DQM_STAGE_LOG
1218: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
1219: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTIES';
1220: log('hz_thin_st_parties_t1 is valid. No recreation necessary.');
1221: WHEN OTHERS THEN
1222: BEGIN
1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';

Line 1421: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

1417: WHERE OPERATION = p_command
1418: AND WORKER_NUMBER = l_worker_number AND step = l_step);
1419:
1420: l_party_id NUMBER;
1421: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
1422:
1423: l_party_staged VARCHAR2(1);
1424: l_temp_party_id NUMBER;
1425: l_worker_number NUMBER;

Line 1734: ELSIF p_index = 'HZ_PARTIES'

1730: CREATE_PARTY_INDEXES := TRUE ;
1731: CREATE_PS_INDEXES := TRUE ;
1732: CREATE_CONTACT_INDEXES := TRUE ;
1733: CREATE_CPT_INDEXES := TRUE ;
1734: ELSIF p_index = 'HZ_PARTIES'
1735: THEN
1736: CREATE_PARTY_INDEXES := TRUE ;
1737: log('Creating Party Indexes');
1738: ELSIF p_index = 'HZ_PARTY_SITES'

Line 1760: AND step = 'HZ_PARTIES';

1756: BEGIN
1757: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1758: FROM HZ_DQM_STAGE_LOG
1759: WHERE OPERATION = 'SHADOW_CREATE_INDEXES'
1760: AND step = 'HZ_PARTIES';
1761: EXCEPTION
1762: WHEN no_data_found THEN
1763: l_start_flag:=NULL;
1764: l_end_flag:=NULL;

Line 1784: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';

1780: '.hz_thin_st_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
1781: log('Index Successfully built');
1782:
1783: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1784: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';
1785: COMMIT;
1786:
1787: EXCEPTION
1788: WHEN OTHERS THEN

Line 1807: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';

1803: -- Regular Flow, We do not Continue from a previous Run of Staging
1804: IF nvl(l_start_flag,'N') = 'N' THEN
1805: log('regular creation of party indexes');
1806: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
1807: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';
1808: COMMIT;
1809:
1810: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';
1811:

Line 1824: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';

1820: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' ||
1821: p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';
1822:
1823: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1824: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';
1825: COMMIT;
1826: END IF;
1827:
1828: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 2696: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');

2692: IF l_org_select(I) <> 'N' THEN
2693: l(' ,' || l_org_select(I));
2694: END IF;
2695: END LOOP;
2696: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
2697: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2698: l(' AND p.party_id = op.party_id ');
2699: l(' AND op.effective_end_date is NULL ');
2700: l(' AND p.PARTY_TYPE =''ORGANIZATION'' ');

Line 2710: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');

2706: IF l_per_select(I) <> 'N' THEN
2707: l(' ,' || l_per_select(I));
2708: END IF;
2709: END LOOP;
2710: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
2711: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2712: l(' AND p.party_id = pe.party_id ');
2713: l(' AND pe.effective_end_date is NULL ');
2714: l(' AND p.PARTY_TYPE =''PERSON'' ');

Line 2724: l(' FROM HZ_PARTIES p ');

2720: IF l_oth_select(I) <> 'N' THEN
2721: l(' ,' || l_oth_select(I));
2722: END IF;
2723: END LOOP;
2724: l(' FROM HZ_PARTIES p ');
2725: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2726: l(' AND p.party_type <> ''PERSON'' ');
2727: l(' AND p.party_type <> ''ORGANIZATION'' ');
2728: l(' AND p.party_type <> ''PARTY_RELATIONSHIP'' ');

Line 2741: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');

2737: l(' ,' || l_org_select(I));
2738: END IF;
2739: END LOOP;
2740:
2741: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
2742: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2743: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2744: l(' WHERE sp.party_id = p.party_id) ' );
2745: l(' AND p.party_id = op.party_id ');

Line 2757: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');

2753: IF l_per_select(I) <> 'N' THEN
2754: l(' ,' || l_per_select(I));
2755: END IF;
2756: END LOOP;
2757: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
2758: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2759: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2760: l(' WHERE sp.party_id = p.party_id) ' );
2761: l(' AND p.party_id = pe.party_id ');

Line 2773: l(' FROM HZ_PARTIES p ');

2769: IF l_oth_select(I) <> 'N' THEN
2770: l(' ,' || l_oth_select(I));
2771: END IF;
2772: END LOOP;
2773: l(' FROM HZ_PARTIES p ');
2774: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2775: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2776: l(' WHERE sp.party_id = p.party_id) ' );
2777: l(' AND p.party_type <> ''PERSON'' ');

Line 2953: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');

2949: l_custom_list(I) = 'N' THEN
2950: l(' , H_TX'||I||'(1)');
2951: END IF;
2952: END LOOP;
2953: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
2954: l(' WHERE p.party_id = p_party_id ');
2955: l(' AND p.party_id = op.party_id ');
2956: l(' AND (p.status = ''M'' or op.effective_end_date is NULL) AND ROWNUM=1; ');
2957: l(' ELSIF p_party_type = ''PERSON'' THEN');

Line 2971: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');

2967: l_custom_list(I) = 'N' THEN
2968: l(' , H_TX'||I||'(1)');
2969: END IF;
2970: END LOOP;
2971: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
2972: l(' WHERE p.party_id = p_party_id ');
2973: l(' AND p.party_id = pe.party_id ');
2974: l(' AND (p.status = ''M'' or pe.effective_end_date is NULL) AND ROWNUM=1;');
2975: l(' ELSE');

Line 2990: l(' FROM HZ_PARTIES p ');

2986: l_custom_list(I) = 'N' THEN
2987: l(' , H_TX'||I||'(1)');
2988: END IF;
2989: END LOOP;
2990: l(' FROM HZ_PARTIES p ');
2991: l(' WHERE p.party_id = p_party_id;');
2992: l(' END IF;');
2993: -- VJN INTRODUCED CODE FOR GENERATING THE POPULATION
2994: -- OF THE GLOBAL CONDITION RECORD

Line 3664: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');

3660: l(' HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp');
3661: l(' WHERE oc.party_relationship_id = r.relationship_id ');
3662: l(' AND r.object_id = g.party_id ');
3663: l(' AND r.subject_id = pp.party_id ');
3664: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
3665: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
3666: l(' AND DIRECTIONAL_FLAG= ''F'' ');
3667: l(' AND pp.effective_end_date is NULL ');
3668: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

Line 3665: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');

3661: l(' WHERE oc.party_relationship_id = r.relationship_id ');
3662: l(' AND r.object_id = g.party_id ');
3663: l(' AND r.subject_id = pp.party_id ');
3664: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
3665: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
3666: l(' AND DIRECTIONAL_FLAG= ''F'' ');
3667: l(' AND pp.effective_end_date is NULL ');
3668: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
3669: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'');');

Line 3814: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');

3810: l(' AND oc.org_contact_id = p_org_contact_id');
3811: l(' AND oc.org_contact_id = d.RECORD_ID');
3812: l(' AND oc.party_relationship_id = r.relationship_id ');
3813: l(' AND r.subject_id = pp.party_id ');
3814: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
3815: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
3816: l(' AND DIRECTIONAL_FLAG= ''F'' ');
3817: l(' AND pp.effective_end_date is NULL ');
3818: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

Line 3815: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');

3811: l(' AND oc.org_contact_id = d.RECORD_ID');
3812: l(' AND oc.party_relationship_id = r.relationship_id ');
3813: l(' AND r.subject_id = pp.party_id ');
3814: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
3815: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
3816: l(' AND DIRECTIONAL_FLAG= ''F'' ');
3817: l(' AND pp.effective_end_date is NULL ');
3818: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
3819: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'')');

Line 4084: l(' AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,''HZ_PARTIES'') ');

4080: END IF;
4081: END LOOP;
4082: l(' FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp');
4083: l(' WHERE cp.owner_table_id = g.owner_id ');
4084: l(' AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,''HZ_PARTIES'') ');
4085: l(' AND (cp.status is null OR cp.status = ''A'' or cp.status = ''I''); ');
4086: l('');
4087: l(' BEGIN');
4088: l(' OPEN contact_pt_cur;');