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 dependencies on HZ_PARTIES

Line 1382: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);

1378:
1379: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1380:
1381: IF l_command = 'ESTIMATE_SIZE' THEN
1382: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);
1383: reco_staging_party_sites := ceil(get_size('HZ_PARTY_SITES') * 3.0 * safety_factor);
1384: reco_staging_contacts := ceil(get_size('HZ_ORG_CONTACTS') * 2.5 * safety_factor);
1385: reco_staging_contact_points := ceil(get_size('HZ_CONTACT_POINTS') * 2.0 * safety_factor);
1386: reco_index_size := 0.85 * (reco_staging_parties + reco_staging_party_sites + reco_staging_contacts + reco_staging_contact_points);

Line 1590: p_step=>'HZ_PARTIES');

1586: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1587: IF l_rebuild_party_idx THEN
1588: create_log(
1589: p_operation=>'CREATE_INDEXES',
1590: p_step=>'HZ_PARTIES');
1591: ELSE
1592: create_log(
1593: p_operation=>'CREATE_INDEXES',
1594: p_step=>'HZ_PARTIES_BTREE');

Line 1594: p_step=>'HZ_PARTIES_BTREE');

1590: p_step=>'HZ_PARTIES');
1591: ELSE
1592: create_log(
1593: p_operation=>'CREATE_INDEXES',
1594: p_step=>'HZ_PARTIES_BTREE');
1595: END IF;
1596:
1597: IF l_rebuild_psite_idx THEN
1598: create_log(

Line 1631: AND step like 'HZ_PARTIES%';

1627: ELSE
1628: SELECT step INTO l_step
1629: FROM HZ_DQM_STAGE_LOG
1630: WHERE OPERATION = 'CREATE_INDEXES'
1631: AND step like 'HZ_PARTIES%';
1632:
1633: IF l_step ='HZ_PARTIES' THEN
1634: l_rebuild_party_idx:=TRUE;
1635: ELSE

Line 1633: IF l_step ='HZ_PARTIES' THEN

1629: FROM HZ_DQM_STAGE_LOG
1630: WHERE OPERATION = 'CREATE_INDEXES'
1631: AND step like 'HZ_PARTIES%';
1632:
1633: IF l_step ='HZ_PARTIES' THEN
1634: l_rebuild_party_idx:=TRUE;
1635: ELSE
1636: l_rebuild_party_idx:=FALSE;
1637: END IF;

Line 1696: l_index := 'HZ_PARTIES';

1692: l_req_id := l_sub_requests(1);
1693:
1694: IF l_req_id>0 THEN
1695: IF l_rebuild_party_idx THEN
1696: l_index := 'HZ_PARTIES';
1697: ELSE
1698: l_index := 'HZ_PARTIES_BTREE';
1699: END IF;
1700: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

Line 1698: l_index := 'HZ_PARTIES_BTREE';

1694: IF l_req_id>0 THEN
1695: IF l_rebuild_party_idx THEN
1696: l_index := 'HZ_PARTIES';
1697: ELSE
1698: l_index := 'HZ_PARTIES_BTREE';
1699: END IF;
1700: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1701: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1702: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),

Line 1878: WHERE TABLE_NAME = 'HZ_PARTIES' AND script_name = 'HZ_TCA_DQM_STAGING_PROGRAM';

1874: l_num_workers := l_last_num_workers;
1875: END IF;
1876:
1877: DELETE FROM AD_PARALLEL_UPDATES
1878: WHERE TABLE_NAME = 'HZ_PARTIES' AND script_name = 'HZ_TCA_DQM_STAGING_PROGRAM';
1879:
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN
1882: l_continue := 'N';

Line 1922: p_step=>'HZ_PARTIES');

1918: END LOOP;
1919: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1920: create_log(
1921: p_operation=>'CREATE_INDEXES',
1922: p_step=>'HZ_PARTIES');
1923: create_log(
1924: p_operation=>'CREATE_INDEXES',
1925: p_step=>'HZ_PARTY_SITES');
1926: create_log(

Line 1958: l_index := 'HZ_PARTIES';

1954:
1955: l_req_id := l_sub_requests(1);
1956:
1957: IF l_req_id>0 THEN
1958: l_index := 'HZ_PARTIES';
1959: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1960: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1961: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1962: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),

Line 2039: p_step=>'HZ_PARTIES');

2035: generate_datastore_prefs;
2036: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2037: create_log(
2038: p_operation=>'CREATE_INDEXES',
2039: p_step=>'HZ_PARTIES');
2040: create_log(
2041: p_operation=>'CREATE_INDEXES',
2042: p_step=>'HZ_PARTY_SITES');
2043: create_log(

Line 2065: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');

2061: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2062: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),
2063: to_char(l_sub_requests(7)), to_char(l_sub_requests(8)),
2064: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2065: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2066: IF l_req_id = 0 THEN
2067: log('Error submitting request');
2068: log(fnd_message.get);
2069: ELSE

Line 2146: p_step=>'HZ_PARTIES');

2142: generate_datastore_prefs;
2143: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2144: create_log(
2145: p_operation=>'CREATE_INDEXES',
2146: p_step=>'HZ_PARTIES');
2147: create_log(
2148: p_operation=>'CREATE_INDEXES',
2149: p_step=>'HZ_PARTY_SITES');
2150: create_log(

Line 2170: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTIES';

2166: EXCEPTION
2167: WHEN NO_DATA_FOUND THEN
2168: UPDATE HZ_DQM_STAGE_LOG
2169: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2170: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTIES';
2171: WHEN OTHERS THEN
2172: BEGIN
2173: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_stage_parties_t1 FORCE';
2174: log('Dropped hz_stage_parties_t1');

Line 2187: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');

2183: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2184: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),
2185: to_char(l_sub_requests(7)), to_char(l_sub_requests(8)),
2186: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2187: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2188: IF l_req_id = 0 THEN
2189: log('Error submitting request');
2190: log(fnd_message.get);
2191: ELSE

Line 2322: l_index := 'HZ_PARTIES_BTREE';

2318: FOR I in 1..10 LOOP
2319: l_sub_requests(i) := 1;
2320: END LOOP;
2321:
2322: l_index := 'HZ_PARTIES_BTREE';
2323: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2324: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2325: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2326: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),

Line 2505: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

2501: WHERE OPERATION = p_command
2502: AND WORKER_NUMBER = l_worker_number AND step = l_step);
2503:
2504: l_party_id NUMBER;
2505: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
2506:
2507: l_party_staged VARCHAR2(1);
2508: l_temp_party_id NUMBER;
2509: l_worker_number NUMBER;

Line 2533: l_table_name varchar2(30) := 'HZ_PARTIES';

2529:
2530: l_log_step VARCHAR2(30);
2531:
2532: l_product varchar2(30) := 'AR';
2533: l_table_name varchar2(30) := 'HZ_PARTIES';
2534: l_update_name varchar2(30) := 'HZ_TCA_DQM_STAGING_PROGRAM';
2535: l_industry varchar2(30);
2536: l_retstatus boolean;
2537: l_table_owner varchar2(30);

Line 3343: ELSIF p_index = 'HZ_PARTIES'

3339: THEN
3340: CREATE_ALL_BTREE_INDEXES := TRUE ;
3341: index_build_type := 'CREATE' ;
3342:
3343: ELSIF p_index = 'HZ_PARTIES'
3344: THEN
3345: CREATE_PARTY_TEXT_INDEX := TRUE ;
3346: index_build_type := 'CREATE' ;
3347:

Line 3364: ELSIF p_index = 'HZ_PARTIES_BTREE'

3360: THEN
3361: CREATE_CPT_TEXT_INDEX := TRUE ;
3362: index_build_type := 'CREATE' ;
3363:
3364: ELSIF p_index = 'HZ_PARTIES_BTREE'
3365: THEN
3366: SYNC_PARTY_TEXT_INDEX := TRUE ;
3367: index_build_type := 'SYNC' ;
3368:

Line 3661: AND step = 'HZ_PARTIES';

3657: BEGIN
3658: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3659: FROM HZ_DQM_STAGE_LOG
3660: WHERE OPERATION = 'CREATE_INDEXES'
3661: AND step = 'HZ_PARTIES';
3662: EXCEPTION
3663: WHEN no_data_found THEN
3664: l_start_flag:=NULL;
3665: l_end_flag:=NULL;

Line 3684: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';

3680: '.hz_stage_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3681: log('Index Successfully built');
3682:
3683: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3684: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3685: COMMIT;
3686:
3687: EXCEPTION
3688: WHEN OTHERS THEN

Line 3705: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';

3701: END IF;
3702:
3703: IF nvl(l_start_flag,'N') = 'N' THEN
3704: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3705: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3706: COMMIT;
3707:
3708: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';
3709:

Line 3743: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';

3739: log('Done creating hz_stage_parties_t1');
3740: END IF;
3741:
3742: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3743: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3744: COMMIT;
3745: END IF;
3746: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));
3747:

Line 4983: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');

4979: l(' ,' || l_org_select(I));
4980: END IF;
4981: END LOOP;
4982:
4983: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
4984: l(' ,HZ_ORGANIZATION_PROFILES op ');
4985: l(' WHERE p.request_id = bd.main_conc_req_id ');
4986: l(' AND bd.batch_id = ps.batch_id ');
4987: l(' AND p.PARTY_TYPE = ''ORGANIZATION'' ');

Line 5007: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');

5003: l(' ,' || l_per_select(I));
5004: END IF;
5005: END LOOP;
5006:
5007: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
5008: l(' ,HZ_PERSON_PROFILES pe ');
5009: l(' WHERE p.request_id = bd.main_conc_req_id ');
5010: l(' AND bd.batch_id = ps.batch_id ');
5011: l(' AND p.PARTY_TYPE = ''PERSON'' ');

Line 5030: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');

5026: l(' ,' || l_oth_select(I));
5027: END IF;
5028: END LOOP;
5029:
5030: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
5031: l(' WHERE p.request_id = bd.main_conc_req_id ');
5032: l(' AND bd.batch_id = ps.batch_id ');
5033: l(' AND p.party_id = ps.party_id ');
5034: l(' AND ps.batch_id = p_batch_id ');

Line 5209: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi ');

5205: l(' ,' || l_org_select(I));
5206: END IF;
5207: END LOOP;
5208:
5209: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi ');
5210: l(' WHERE p.party_id = op.party_id ');
5211: l(' AND p.party_id = dsi.party_id ');
5212: l(' AND p.PARTY_TYPE = ''ORGANIZATION'' ');
5213: l(' AND dsi.entity = ''PARTY'' ');

Line 5229: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi ');

5225: l(' ,' || l_per_select(I));
5226: END IF;
5227: END LOOP;
5228:
5229: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi ');
5230: l(' WHERE p.party_id = pe.party_id ');
5231: l(' AND p.party_id = dsi.party_id ');
5232: l(' AND p.PARTY_TYPE = ''PERSON'' ');
5233: l(' AND dsi.entity = ''PARTY'' ');

Line 5249: l(' FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi ');

5245: l(' ,' || l_oth_select(I));
5246: END IF;
5247: END LOOP;
5248:
5249: l(' FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi ');
5250: l(' WHERE p.party_id = dsi.party_id ');
5251: l(' AND dsi.entity = ''PARTY'' ');
5252: l(' AND dsi.staged_flag = ''N'' ');
5253: l(' AND dsi.operation = p_operation ');

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

5700: l(' ,' || l_org_select(I));
5701: END IF;
5702: END LOOP;
5703:
5704: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5705: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5706: l(' AND p.party_id = op.party_id ');
5707: l(' AND op.effective_end_date is NULL ');
5708: l(' AND p.PARTY_TYPE =''ORGANIZATION''; ');

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

5713: IF l_per_select(I) <> 'N' THEN
5714: l(' ,' || l_per_select(I));
5715: END IF;
5716: END LOOP;
5717: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5718: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5719: l(' AND p.party_id = pe.party_id ');
5720: l(' AND pe.effective_end_date is NULL ');
5721: l(' AND p.PARTY_TYPE =''PERSON''; ');

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

5726: IF l_oth_select(I) <> 'N' THEN
5727: l(' ,' || l_oth_select(I));
5728: END IF;
5729: END LOOP;
5730: l(' FROM HZ_PARTIES p ');
5731: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5732: l(' AND p.party_type <> ''PERSON'' ');
5733: l(' AND p.party_type <> ''ORGANIZATION'' ');
5734: l(' AND p.party_type <> ''PARTY_RELATIONSHIP''; ');

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

5742: l(' ,' || l_org_select(I));
5743: END IF;
5744: END LOOP;
5745:
5746: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5747: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5748: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5749: l(' WHERE sp.party_id = p.party_id) ' );
5750: l(' AND p.party_id = op.party_id ');

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

5757: IF l_per_select(I) <> 'N' THEN
5758: l(' ,' || l_per_select(I));
5759: END IF;
5760: END LOOP;
5761: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5762: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5763: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5764: l(' WHERE sp.party_id = p.party_id) ' );
5765: l(' AND p.party_id = pe.party_id ');

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

5772: IF l_oth_select(I) <> 'N' THEN
5773: l(' ,' || l_oth_select(I));
5774: END IF;
5775: END LOOP;
5776: l(' FROM HZ_PARTIES p ');
5777: l(' WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid ');
5778: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5779: l(' WHERE sp.party_id = p.party_id) ' );
5780: l(' AND p.party_type <> ''PERSON'' ');

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

5961: l_custom_list(I) = 'N' THEN
5962: l(' , H_TX'||I||'(1)');
5963: END IF;
5964: END LOOP;
5965: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5966: l(' WHERE p.party_id = p_party_id ');
5967: l(' AND p.party_id = op.party_id ');
5968: l(' AND (p.status = ''M'' or op.effective_end_date is NULL) AND ROWNUM=1; ');
5969: l(' ELSIF p_party_type = ''PERSON'' THEN');

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

5979: l_custom_list(I) = 'N' THEN
5980: l(' , H_TX'||I||'(1)');
5981: END IF;
5982: END LOOP;
5983: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5984: l(' WHERE p.party_id = p_party_id ');
5985: l(' AND p.party_id = pe.party_id ');
5986: l(' AND (p.status = ''M'' or pe.effective_end_date is NULL) AND ROWNUM=1;');
5987: l(' ELSE');

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

5998: l_custom_list(I) = 'N' THEN
5999: l(' , H_TX'||I||'(1)');
6000: END IF;
6001: END LOOP;
6002: l(' FROM HZ_PARTIES p ');
6003: l(' WHERE p.party_id = p_party_id;');
6004: l(' END IF;');
6005: -- VJN INTRODUCED CODE FOR GENERATING THE POPULATION
6006: -- OF THE GLOBAL CONDITION RECORD

Line 6130: l(' AND pr.subject_table_name = ''HZ_PARTIES'' ');

6126: l(' SELECT oc.org_contact_id ');
6127: l(' FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc ');
6128: l(' WHERE pr.relationship_id = oc.party_relationship_id ');
6129: l(' AND pr.subject_id = p_party_id ');
6130: l(' AND pr.subject_table_name = ''HZ_PARTIES'' ');
6131: l(' AND pr.object_table_name = ''HZ_PARTIES'' ');
6132: l(' AND pr.directional_flag = ''F''; ');
6133: l('');
6134: l(' BEGIN');

Line 6131: l(' AND pr.object_table_name = ''HZ_PARTIES'' ');

6127: l(' FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc ');
6128: l(' WHERE pr.relationship_id = oc.party_relationship_id ');
6129: l(' AND pr.subject_id = p_party_id ');
6130: l(' AND pr.subject_table_name = ''HZ_PARTIES'' ');
6131: l(' AND pr.object_table_name = ''HZ_PARTIES'' ');
6132: l(' AND pr.directional_flag = ''F''; ');
6133: l('');
6134: l(' BEGIN');
6135: l('');

Line 6138: l(' FROM hz_parties WHERE party_id = p_party_id; ');

6134: l(' BEGIN');
6135: l('');
6136: l(' -- Get party_type ');
6137: l(' SELECT party_type INTO l_party_type ');
6138: l(' FROM hz_parties WHERE party_id = p_party_id; ');
6139: l('');
6140: l(' -- Set global G_PARTY_TYPE variable value');
6141: l(' hz_trans_pkg.set_party_type(l_party_type); ');
6142: l('');

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

6175: l_custom_list(I) = 'N' THEN
6176: l(' , H_TX'||I||'(1)');
6177: END IF;
6178: END LOOP;
6179: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
6180: l(' WHERE p.party_id = p_party_id ');
6181: l(' AND p.party_id = op.party_id ');
6182: l(' AND (p.status = ''M'' or op.effective_end_date is NULL) AND ROWNUM=1; ');
6183: l(' ELSIF l_party_type = ''PERSON'' THEN');

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

6193: l_custom_list(I) = 'N' THEN
6194: l(' , H_TX'||I||'(1)');
6195: END IF;
6196: END LOOP;
6197: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
6198: l(' WHERE p.party_id = p_party_id ');
6199: l(' AND p.party_id = pe.party_id ');
6200: l(' AND (p.status = ''M'' or pe.effective_end_date is NULL) AND ROWNUM=1;');
6201: l(' ELSE');

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

6212: l_custom_list(I) = 'N' THEN
6213: l(' , H_TX'||I||'(1)');
6214: END IF;
6215: END LOOP;
6216: l(' FROM HZ_PARTIES p ');
6217: l(' WHERE p.party_id = p_party_id;');
6218: l(' END IF;');
6219: l('');
6220: -- VJN INTRODUCED CODE FOR GENERATING THE POPULATION

Line 7415: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');

7411: l(' l_org_contact_id := -1; ');
7412: l('');
7413: l(' BEGIN ');
7414: l(' SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type ');
7415: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');
7416: l(' WHERE party_site_id = p_party_site_id ');
7417: l(' AND p.PARTY_ID = ps.PARTY_ID; ');
7418: l(' -- take care of invalid party ids ');
7419: l(' EXCEPTION ');

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

7428: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
7429: l(' WHERE r.party_id = l_party_id1 '); -- Fix for bug 5207194
7430: l(' AND r.relationship_id = oc.party_relationship_id ');
7431: l(' AND r.directional_flag = ''F'' ');
7432: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7433: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
7434: l(' -- take care of invalid identifiers ');
7435: l(' EXCEPTION ');
7436: l(' WHEN NO_DATA_FOUND THEN ');

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

7429: l(' WHERE r.party_id = l_party_id1 '); -- Fix for bug 5207194
7430: l(' AND r.relationship_id = oc.party_relationship_id ');
7431: l(' AND r.directional_flag = ''F'' ');
7432: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7433: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
7434: l(' -- take care of invalid identifiers ');
7435: l(' EXCEPTION ');
7436: l(' WHEN NO_DATA_FOUND THEN ');
7437: l(' -- dbms_output.put_line ( ''Exception caught in party_rel ''); ');

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

7754: l(' AND oc.request_id = bd.main_conc_req_id ');
7755: l(' AND bd.batch_id = ocsg.batch_id ');
7756: l(' AND r.subject_id = pp.party_id ');
7757: l(' AND r.subject_type = ''PERSON'' ');
7758: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7759: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7760: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7761: l(' AND ocsg.action_flag = p_operation ');
7762: l(' AND pp.effective_end_date IS NULL ');

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

7755: l(' AND bd.batch_id = ocsg.batch_id ');
7756: l(' AND r.subject_id = pp.party_id ');
7757: l(' AND r.subject_type = ''PERSON'' ');
7758: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7759: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7760: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7761: l(' AND ocsg.action_flag = p_operation ');
7762: l(' AND pp.effective_end_date IS NULL ');
7763: l(' AND ocsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');

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

7790: l(' AND r.directional_flag = ''F'' ');
7791: l(' AND r.subject_id = pp.party_id ');
7792: l(' AND r.subject_type = ''PERSON'' ');
7793: l(' AND r.object_type = ''ORGANIZATION'' ');
7794: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7795: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7796: l(' AND rsg.action_flag = p_operation ');
7797: l(' AND pp.effective_end_date IS NULL ');
7798: l(' AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');

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

7791: l(' AND r.subject_id = pp.party_id ');
7792: l(' AND r.subject_type = ''PERSON'' ');
7793: l(' AND r.object_type = ''ORGANIZATION'' ');
7794: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7795: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7796: l(' AND rsg.action_flag = p_operation ');
7797: l(' AND pp.effective_end_date IS NULL ');
7798: l(' AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');
7799: l(' AND (oc.status IS NULL OR oc.status = ''A'' OR oc.status = ''I'')');

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

7952: l(' WHERE oc.party_relationship_id = r.relationship_id ');
7953: l(' AND dsi.record_id = oc.org_contact_id ');
7954: l(' AND r.subject_id = pp.party_id ');
7955: l(' AND r.subject_type = ''PERSON'' ');
7956: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7957: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7958: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7959: l(' AND pp.effective_end_date is NULL ');
7960: l(' AND dsi.entity = ''CONTACTS'' ');

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

7953: l(' AND dsi.record_id = oc.org_contact_id ');
7954: l(' AND r.subject_id = pp.party_id ');
7955: l(' AND r.subject_type = ''PERSON'' ');
7956: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7957: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7958: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7959: l(' AND pp.effective_end_date is NULL ');
7960: l(' AND dsi.entity = ''CONTACTS'' ');
7961: l(' AND dsi.operation = p_operation ');

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

8389: l(' HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp');
8390: l(' WHERE oc.party_relationship_id = r.relationship_id ');
8391: l(' AND r.object_id = g.party_id ');
8392: l(' AND r.subject_id = pp.party_id ');
8393: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8394: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8395: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8396: l(' AND pp.effective_end_date is NULL ');
8397: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8390: l(' WHERE oc.party_relationship_id = r.relationship_id ');
8391: l(' AND r.object_id = g.party_id ');
8392: l(' AND r.subject_id = pp.party_id ');
8393: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8394: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8395: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8396: l(' AND pp.effective_end_date is NULL ');
8397: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8398: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'');');

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

8580: l(' AND oc.org_contact_id = p_org_contact_id');
8581: l(' AND oc.org_contact_id = d.RECORD_ID');
8582: l(' AND oc.party_relationship_id = r.relationship_id ');
8583: l(' AND r.subject_id = pp.party_id ');
8584: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8585: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8586: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8587: l(' AND pp.effective_end_date is NULL ');
8588: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8581: l(' AND oc.org_contact_id = d.RECORD_ID');
8582: l(' AND oc.party_relationship_id = r.relationship_id ');
8583: l(' AND r.subject_id = pp.party_id ');
8584: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8585: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8586: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8587: l(' AND pp.effective_end_date is NULL ');
8588: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8589: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'')');

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

8722: l(' SELECT r.object_id INTO l_party_id ');
8723: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
8724: l(' WHERE oc.org_contact_id = p_org_contact_id ');
8725: l(' AND oc.party_relationship_id = r.relationship_id ');
8726: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8727: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8728: l(' AND subject_type = ''PERSON'' ');
8729: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8730: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'') ');

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

8723: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
8724: l(' WHERE oc.org_contact_id = p_org_contact_id ');
8725: l(' AND oc.party_relationship_id = r.relationship_id ');
8726: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8727: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8728: l(' AND subject_type = ''PERSON'' ');
8729: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8730: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'') ');
8731: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'') ; ');

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

8749: l(' WHERE ');
8750: l(' oc.org_contact_id = p_org_contact_id');
8751: l(' AND oc.party_relationship_id = r.relationship_id ');
8752: l(' AND r.subject_id = pp.party_id ');
8753: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8754: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8755: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8756: l(' AND pp.effective_end_date is NULL ');
8757: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8750: l(' oc.org_contact_id = p_org_contact_id');
8751: l(' AND oc.party_relationship_id = r.relationship_id ');
8752: l(' AND r.subject_id = pp.party_id ');
8753: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8754: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8755: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8756: l(' AND pp.effective_end_date is NULL ');
8757: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8758: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'')');

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

9670: END IF;
9671: END LOOP;
9672: l(' FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp');
9673: l(' WHERE cp.owner_table_id = g.owner_id ');
9674: l(' AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,''HZ_PARTIES'') ');
9675: l(' AND (cp.status is null OR cp.status = ''A'' or cp.status = ''I''); ');
9676: l('');
9677: l(' BEGIN');
9678: l(' OPEN contact_pt_cur;');

Line 10012: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');

10008: l('');
10009: l(' IF l_ot_table = ''HZ_PARTY_SITES'' THEN ');
10010: l(' SELECT p.party_id, ps.party_site_id, party_type ');
10011: l(' INTO l_party_id1, l_party_site_id, l_party_type ');
10012: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');
10013: l(' WHERE party_site_id = l_ot_id ');
10014: l(' AND p.party_id = ps.party_id; ');
10015: l('');
10016: l(' IF l_party_type = ''PARTY_RELATIONSHIP'' THEN ');

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

10019: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
10020: l(' WHERE r.party_id = l_party_id1 ');
10021: l(' AND r.relationship_id = oc.party_relationship_id ');
10022: l(' AND r.directional_flag = ''F'' ');
10023: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
10024: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
10025: l(' EXCEPTION ');
10026: l(' WHEN NO_DATA_FOUND THEN ');
10027: l(' RETURN; ');

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

10020: l(' WHERE r.party_id = l_party_id1 ');
10021: l(' AND r.relationship_id = oc.party_relationship_id ');
10022: l(' AND r.directional_flag = ''F'' ');
10023: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
10024: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
10025: l(' EXCEPTION ');
10026: l(' WHEN NO_DATA_FOUND THEN ');
10027: l(' RETURN; ');
10028: l(' END; ');

Line 10034: l(' ELSIF l_ot_table = ''HZ_PARTIES'' THEN ');

10030: l(' l_party_id:=l_party_id1; ');
10031: l(' l_org_contact_id:=NULL; ');
10032: l(' END IF; ');
10033: l('');
10034: l(' ELSIF l_ot_table = ''HZ_PARTIES'' THEN ');
10035: l(' l_party_site_id := NULL; ');
10036: l(' SELECT party_type INTO l_party_type ');
10037: l(' FROM hz_parties ');
10038: l(' WHERE party_id = l_ot_id; ');

Line 10037: l(' FROM hz_parties ');

10033: l('');
10034: l(' ELSIF l_ot_table = ''HZ_PARTIES'' THEN ');
10035: l(' l_party_site_id := NULL; ');
10036: l(' SELECT party_type INTO l_party_type ');
10037: l(' FROM hz_parties ');
10038: l(' WHERE party_id = l_ot_id; ');
10039: l('');
10040: l(' IF l_party_type <> ''PARTY_RELATIONSHIP'' THEN ');
10041: l(' l_party_id := l_ot_id; ');

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

10046: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
10047: l(' WHERE r.party_id = l_ot_id ');
10048: l(' AND r.relationship_id = oc.party_relationship_id ');
10049: l(' AND r.directional_flag = ''F'' ');
10050: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
10051: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
10052: l(' EXCEPTION ');
10053: l(' WHEN NO_DATA_FOUND THEN ');
10054: l(' RETURN; ');

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

10047: l(' WHERE r.party_id = l_ot_id ');
10048: l(' AND r.relationship_id = oc.party_relationship_id ');
10049: l(' AND r.directional_flag = ''F'' ');
10050: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
10051: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
10052: l(' EXCEPTION ');
10053: l(' WHEN NO_DATA_FOUND THEN ');
10054: l(' RETURN; ');
10055: l(' END; ');

Line 10358: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');

10354: FOR I in 1..l_org_select.COUNT LOOP
10355: l(' ,' || l_org_select(I));
10356: END LOOP;
10357:
10358: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
10359: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10360: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10361: l(' AND p.party_id = op.party_id ');
10362: l(' AND op.effective_end_date is NULL; ');

Line 10369: l(' FROM HZ_STAGED_PARTIES s,HZ_PARTIES p, HZ_PERSON_PROFILES pe ');

10365: l(' SELECT p.PARTY_ID ');
10366: FOR I in 1..l_per_select.COUNT LOOP
10367: l(' ,' || l_per_select(I));
10368: END LOOP;
10369: l(' FROM HZ_STAGED_PARTIES s,HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
10370: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10371: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10372: l(' AND p.party_id = pe.party_id ');
10373: l(' AND pe.effective_end_date is NULL; ');

Line 10380: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p ');

10376: l(' SELECT p.PARTY_ID ');
10377: FOR I in 1..l_oth_select.COUNT LOOP
10378: l(' ,' || l_oth_select(I));
10379: END LOOP;
10380: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p ');
10381: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10382: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10383: l(' AND p.party_type <> ''PERSON'' ');
10384: l(' AND p.party_type <> ''ORGANIZATION'' ');

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

10608: l(' AND s.ORG_CONTACT_ID=oc.ORG_CONTACT_ID');
10609: l(' AND oc.party_relationship_id = r.relationship_id ');
10610: l(' AND r.object_id = s.party_id ');
10611: l(' AND r.subject_id = pp.party_id ');
10612: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
10613: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
10614: l(' AND DIRECTIONAL_FLAG= ''F'' ');
10615: l(' AND pp.effective_end_date is NULL ');
10616: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

10609: l(' AND oc.party_relationship_id = r.relationship_id ');
10610: l(' AND r.object_id = s.party_id ');
10611: l(' AND r.subject_id = pp.party_id ');
10612: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
10613: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
10614: l(' AND DIRECTIONAL_FLAG= ''F'' ');
10615: l(' AND pp.effective_end_date is NULL ');
10616: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
10617: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'');');

Line 11258: l(' AND cp.OWNER_TABLE_NAME = ''HZ_PARTIES'' ');

11254: l(' FROM HZ_CONTACT_POINTS cp, HZ_STAGED_CONTACT_POINTS s ');
11255: l(' WHERE mod(s.PARTY_ID, p_num_workers) = p_worker_number ');
11256: l(' AND cp.contact_point_id = s.contact_point_id ');
11257: l(' AND cp.owner_table_id = s.PARTY_ID ');
11258: l(' AND cp.OWNER_TABLE_NAME = ''HZ_PARTIES'' ');
11259: l(' AND (cp.status is null OR cp.status = ''A'' or cp.status = ''I''); ');
11260: l(' END;');
11261: END IF;
11262: l('');