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 1370: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);

1366:
1367: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1368:
1369: IF l_command = 'ESTIMATE_SIZE' THEN
1370: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);
1371: reco_staging_party_sites := ceil(get_size('HZ_PARTY_SITES') * 3.0 * safety_factor);
1372: reco_staging_contacts := ceil(get_size('HZ_ORG_CONTACTS') * 2.5 * safety_factor);
1373: reco_staging_contact_points := ceil(get_size('HZ_CONTACT_POINTS') * 2.0 * safety_factor);
1374: reco_index_size := 0.85 * (reco_staging_parties + reco_staging_party_sites + reco_staging_contacts + reco_staging_contact_points);

Line 1578: p_step=>'HZ_PARTIES');

1574: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1575: IF l_rebuild_party_idx THEN
1576: create_log(
1577: p_operation=>'CREATE_INDEXES',
1578: p_step=>'HZ_PARTIES');
1579: ELSE
1580: create_log(
1581: p_operation=>'CREATE_INDEXES',
1582: p_step=>'HZ_PARTIES_BTREE');

Line 1582: p_step=>'HZ_PARTIES_BTREE');

1578: p_step=>'HZ_PARTIES');
1579: ELSE
1580: create_log(
1581: p_operation=>'CREATE_INDEXES',
1582: p_step=>'HZ_PARTIES_BTREE');
1583: END IF;
1584:
1585: IF l_rebuild_psite_idx THEN
1586: create_log(

Line 1619: AND step like 'HZ_PARTIES%';

1615: ELSE
1616: SELECT step INTO l_step
1617: FROM HZ_DQM_STAGE_LOG
1618: WHERE OPERATION = 'CREATE_INDEXES'
1619: AND step like 'HZ_PARTIES%';
1620:
1621: IF l_step ='HZ_PARTIES' THEN
1622: l_rebuild_party_idx:=TRUE;
1623: ELSE

Line 1621: IF l_step ='HZ_PARTIES' THEN

1617: FROM HZ_DQM_STAGE_LOG
1618: WHERE OPERATION = 'CREATE_INDEXES'
1619: AND step like 'HZ_PARTIES%';
1620:
1621: IF l_step ='HZ_PARTIES' THEN
1622: l_rebuild_party_idx:=TRUE;
1623: ELSE
1624: l_rebuild_party_idx:=FALSE;
1625: END IF;

Line 1684: l_index := 'HZ_PARTIES';

1680: l_req_id := l_sub_requests(1);
1681:
1682: IF l_req_id>0 THEN
1683: IF l_rebuild_party_idx THEN
1684: l_index := 'HZ_PARTIES';
1685: ELSE
1686: l_index := 'HZ_PARTIES_BTREE';
1687: END IF;
1688: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

Line 1686: l_index := 'HZ_PARTIES_BTREE';

1682: IF l_req_id>0 THEN
1683: IF l_rebuild_party_idx THEN
1684: l_index := 'HZ_PARTIES';
1685: ELSE
1686: l_index := 'HZ_PARTIES_BTREE';
1687: END IF;
1688: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1689: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1690: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),

Line 1906: p_step=>'HZ_PARTIES');

1902: END LOOP;
1903: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1904: create_log(
1905: p_operation=>'CREATE_INDEXES',
1906: p_step=>'HZ_PARTIES');
1907: create_log(
1908: p_operation=>'CREATE_INDEXES',
1909: p_step=>'HZ_PARTY_SITES');
1910: create_log(

Line 1942: l_index := 'HZ_PARTIES';

1938:
1939: l_req_id := l_sub_requests(1);
1940:
1941: IF l_req_id>0 THEN
1942: l_index := 'HZ_PARTIES';
1943: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1944: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1945: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1946: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),

Line 2023: p_step=>'HZ_PARTIES');

2019: generate_datastore_prefs;
2020: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2021: create_log(
2022: p_operation=>'CREATE_INDEXES',
2023: p_step=>'HZ_PARTIES');
2024: create_log(
2025: p_operation=>'CREATE_INDEXES',
2026: p_step=>'HZ_PARTY_SITES');
2027: create_log(

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

2045: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2046: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),
2047: to_char(l_sub_requests(7)), to_char(l_sub_requests(8)),
2048: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2049: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2050: IF l_req_id = 0 THEN
2051: log('Error submitting request');
2052: log(fnd_message.get);
2053: ELSE

Line 2130: p_step=>'HZ_PARTIES');

2126: generate_datastore_prefs;
2127: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2128: create_log(
2129: p_operation=>'CREATE_INDEXES',
2130: p_step=>'HZ_PARTIES');
2131: create_log(
2132: p_operation=>'CREATE_INDEXES',
2133: p_step=>'HZ_PARTY_SITES');
2134: create_log(

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

2150: EXCEPTION
2151: WHEN NO_DATA_FOUND THEN
2152: UPDATE HZ_DQM_STAGE_LOG
2153: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2154: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTIES';
2155: WHEN OTHERS THEN
2156: BEGIN
2157: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_stage_parties_t1 FORCE';
2158: log('Dropped hz_stage_parties_t1');

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

2167: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2168: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),
2169: to_char(l_sub_requests(7)), to_char(l_sub_requests(8)),
2170: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2171: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2172: IF l_req_id = 0 THEN
2173: log('Error submitting request');
2174: log(fnd_message.get);
2175: ELSE

Line 2306: l_index := 'HZ_PARTIES_BTREE';

2302: FOR I in 1..10 LOOP
2303: l_sub_requests(i) := 1;
2304: END LOOP;
2305:
2306: l_index := 'HZ_PARTIES_BTREE';
2307: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2308: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2309: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2310: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),

Line 2487: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

2483: WHERE OPERATION = p_command
2484: AND WORKER_NUMBER = l_worker_number AND step = l_step);
2485:
2486: l_party_id NUMBER;
2487: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
2488:
2489: l_party_staged VARCHAR2(1);
2490: l_temp_party_id NUMBER;
2491: l_worker_number NUMBER;

Line 3223: ELSIF p_index = 'HZ_PARTIES'

3219: THEN
3220: CREATE_ALL_BTREE_INDEXES := TRUE ;
3221: index_build_type := 'CREATE' ;
3222:
3223: ELSIF p_index = 'HZ_PARTIES'
3224: THEN
3225: CREATE_PARTY_TEXT_INDEX := TRUE ;
3226: index_build_type := 'CREATE' ;
3227:

Line 3244: ELSIF p_index = 'HZ_PARTIES_BTREE'

3240: THEN
3241: CREATE_CPT_TEXT_INDEX := TRUE ;
3242: index_build_type := 'CREATE' ;
3243:
3244: ELSIF p_index = 'HZ_PARTIES_BTREE'
3245: THEN
3246: SYNC_PARTY_TEXT_INDEX := TRUE ;
3247: index_build_type := 'SYNC' ;
3248:

Line 3541: AND step = 'HZ_PARTIES';

3537: BEGIN
3538: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3539: FROM HZ_DQM_STAGE_LOG
3540: WHERE OPERATION = 'CREATE_INDEXES'
3541: AND step = 'HZ_PARTIES';
3542: EXCEPTION
3543: WHEN no_data_found THEN
3544: l_start_flag:=NULL;
3545: l_end_flag:=NULL;

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

3560: '.hz_stage_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3561: log('Index Successfully built');
3562:
3563: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3564: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3565: COMMIT;
3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN

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

3581: END IF;
3582:
3583: IF nvl(l_start_flag,'N') = 'N' THEN
3584: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3585: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3586: COMMIT;
3587:
3588: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';
3589:

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

3617: log('Done creating hz_stage_parties_t1');
3618: END IF;
3619:
3620: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3621: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3622: COMMIT;
3623: END IF;
3624: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));
3625:

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

4827: l(' ,' || l_org_select(I));
4828: END IF;
4829: END LOOP;
4830:
4831: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
4832: l(' ,HZ_ORGANIZATION_PROFILES op ');
4833: l(' WHERE p.request_id = bd.main_conc_req_id ');
4834: l(' AND bd.batch_id = ps.batch_id ');
4835: l(' AND p.PARTY_TYPE = ''ORGANIZATION'' ');

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

4851: l(' ,' || l_per_select(I));
4852: END IF;
4853: END LOOP;
4854:
4855: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
4856: l(' ,HZ_PERSON_PROFILES pe ');
4857: l(' WHERE p.request_id = bd.main_conc_req_id ');
4858: l(' AND bd.batch_id = ps.batch_id ');
4859: l(' AND p.PARTY_TYPE = ''PERSON'' ');

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

4874: l(' ,' || l_oth_select(I));
4875: END IF;
4876: END LOOP;
4877:
4878: l(' FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd ');
4879: l(' WHERE p.request_id = bd.main_conc_req_id ');
4880: l(' AND bd.batch_id = ps.batch_id ');
4881: l(' AND p.party_id = ps.party_id ');
4882: l(' AND ps.batch_id = p_batch_id ');

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

5053: l(' ,' || l_org_select(I));
5054: END IF;
5055: END LOOP;
5056:
5057: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi ');
5058: l(' WHERE p.party_id = op.party_id ');
5059: l(' AND p.party_id = dsi.party_id ');
5060: l(' AND p.PARTY_TYPE = ''ORGANIZATION'' ');
5061: l(' AND dsi.entity = ''PARTY'' ');

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

5073: l(' ,' || l_per_select(I));
5074: END IF;
5075: END LOOP;
5076:
5077: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi ');
5078: l(' WHERE p.party_id = pe.party_id ');
5079: l(' AND p.party_id = dsi.party_id ');
5080: l(' AND p.PARTY_TYPE = ''PERSON'' ');
5081: l(' AND dsi.entity = ''PARTY'' ');

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

5093: l(' ,' || l_oth_select(I));
5094: END IF;
5095: END LOOP;
5096:
5097: l(' FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi ');
5098: l(' WHERE p.party_id = dsi.party_id ');
5099: l(' AND dsi.entity = ''PARTY'' ');
5100: l(' AND dsi.staged_flag = ''N'' ');
5101: l(' AND dsi.operation = p_operation ');

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

5546: l(' ,' || l_org_select(I));
5547: END IF;
5548: END LOOP;
5549:
5550: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5551: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5552: l(' AND p.party_id = op.party_id ');
5553: l(' AND op.effective_end_date is NULL ');
5554: l(' AND p.PARTY_TYPE =''ORGANIZATION''; ');

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

5559: IF l_per_select(I) <> 'N' THEN
5560: l(' ,' || l_per_select(I));
5561: END IF;
5562: END LOOP;
5563: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5564: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5565: l(' AND p.party_id = pe.party_id ');
5566: l(' AND pe.effective_end_date is NULL ');
5567: l(' AND p.PARTY_TYPE =''PERSON''; ');

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

5572: IF l_oth_select(I) <> 'N' THEN
5573: l(' ,' || l_oth_select(I));
5574: END IF;
5575: END LOOP;
5576: l(' FROM HZ_PARTIES p ');
5577: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5578: l(' AND p.party_type <> ''PERSON'' ');
5579: l(' AND p.party_type <> ''ORGANIZATION'' ');
5580: l(' AND p.party_type <> ''PARTY_RELATIONSHIP''; ');

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

5588: l(' ,' || l_org_select(I));
5589: END IF;
5590: END LOOP;
5591:
5592: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5593: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5594: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5595: l(' WHERE sp.party_id = p.party_id) ' );
5596: l(' AND p.party_id = op.party_id ');

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

5603: IF l_per_select(I) <> 'N' THEN
5604: l(' ,' || l_per_select(I));
5605: END IF;
5606: END LOOP;
5607: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5608: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5609: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5610: l(' WHERE sp.party_id = p.party_id) ' );
5611: l(' AND p.party_id = pe.party_id ');

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

5618: IF l_oth_select(I) <> 'N' THEN
5619: l(' ,' || l_oth_select(I));
5620: END IF;
5621: END LOOP;
5622: l(' FROM HZ_PARTIES p ');
5623: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
5624: l(' AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp ');
5625: l(' WHERE sp.party_id = p.party_id) ' );
5626: l(' AND p.party_type <> ''PERSON'' ');

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

5807: l_custom_list(I) = 'N' THEN
5808: l(' , H_TX'||I||'(1)');
5809: END IF;
5810: END LOOP;
5811: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
5812: l(' WHERE p.party_id = p_party_id ');
5813: l(' AND p.party_id = op.party_id ');
5814: l(' AND (p.status = ''M'' or op.effective_end_date is NULL) AND ROWNUM=1; ');
5815: l(' ELSIF p_party_type = ''PERSON'' THEN');

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

5825: l_custom_list(I) = 'N' THEN
5826: l(' , H_TX'||I||'(1)');
5827: END IF;
5828: END LOOP;
5829: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
5830: l(' WHERE p.party_id = p_party_id ');
5831: l(' AND p.party_id = pe.party_id ');
5832: l(' AND (p.status = ''M'' or pe.effective_end_date is NULL) AND ROWNUM=1;');
5833: l(' ELSE');

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

5844: l_custom_list(I) = 'N' THEN
5845: l(' , H_TX'||I||'(1)');
5846: END IF;
5847: END LOOP;
5848: l(' FROM HZ_PARTIES p ');
5849: l(' WHERE p.party_id = p_party_id;');
5850: l(' END IF;');
5851: -- VJN INTRODUCED CODE FOR GENERATING THE POPULATION
5852: -- OF THE GLOBAL CONDITION RECORD

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

5972: l(' SELECT oc.org_contact_id ');
5973: l(' FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc ');
5974: l(' WHERE pr.relationship_id = oc.party_relationship_id ');
5975: l(' AND pr.subject_id = p_party_id ');
5976: l(' AND pr.subject_table_name = ''HZ_PARTIES'' ');
5977: l(' AND pr.object_table_name = ''HZ_PARTIES'' ');
5978: l(' AND pr.directional_flag = ''F''; ');
5979: l('');
5980: l(' BEGIN');

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

5973: l(' FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc ');
5974: l(' WHERE pr.relationship_id = oc.party_relationship_id ');
5975: l(' AND pr.subject_id = p_party_id ');
5976: l(' AND pr.subject_table_name = ''HZ_PARTIES'' ');
5977: l(' AND pr.object_table_name = ''HZ_PARTIES'' ');
5978: l(' AND pr.directional_flag = ''F''; ');
5979: l('');
5980: l(' BEGIN');
5981: l('');

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

5980: l(' BEGIN');
5981: l('');
5982: l(' -- Get party_type ');
5983: l(' SELECT party_type INTO l_party_type ');
5984: l(' FROM hz_parties WHERE party_id = p_party_id; ');
5985: l('');
5986: l(' -- Set global G_PARTY_TYPE variable value');
5987: l(' hz_trans_pkg.set_party_type(l_party_type); ');
5988: l('');

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

6021: l_custom_list(I) = 'N' THEN
6022: l(' , H_TX'||I||'(1)');
6023: END IF;
6024: END LOOP;
6025: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
6026: l(' WHERE p.party_id = p_party_id ');
6027: l(' AND p.party_id = op.party_id ');
6028: l(' AND (p.status = ''M'' or op.effective_end_date is NULL) AND ROWNUM=1; ');
6029: l(' ELSIF l_party_type = ''PERSON'' THEN');

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

6039: l_custom_list(I) = 'N' THEN
6040: l(' , H_TX'||I||'(1)');
6041: END IF;
6042: END LOOP;
6043: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
6044: l(' WHERE p.party_id = p_party_id ');
6045: l(' AND p.party_id = pe.party_id ');
6046: l(' AND (p.status = ''M'' or pe.effective_end_date is NULL) AND ROWNUM=1;');
6047: l(' ELSE');

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

6058: l_custom_list(I) = 'N' THEN
6059: l(' , H_TX'||I||'(1)');
6060: END IF;
6061: END LOOP;
6062: l(' FROM HZ_PARTIES p ');
6063: l(' WHERE p.party_id = p_party_id;');
6064: l(' END IF;');
6065: l('');
6066: -- VJN INTRODUCED CODE FOR GENERATING THE POPULATION

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

7257: l(' l_org_contact_id := -1; ');
7258: l('');
7259: l(' BEGIN ');
7260: l(' SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type ');
7261: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');
7262: l(' WHERE party_site_id = p_party_site_id ');
7263: l(' AND p.PARTY_ID = ps.PARTY_ID; ');
7264: l(' -- take care of invalid party ids ');
7265: l(' EXCEPTION ');

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

7274: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
7275: l(' WHERE r.party_id = l_party_id1 '); -- Fix for bug 5207194
7276: l(' AND r.relationship_id = oc.party_relationship_id ');
7277: l(' AND r.directional_flag = ''F'' ');
7278: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7279: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
7280: l(' -- take care of invalid identifiers ');
7281: l(' EXCEPTION ');
7282: l(' WHEN NO_DATA_FOUND THEN ');

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

7275: l(' WHERE r.party_id = l_party_id1 '); -- Fix for bug 5207194
7276: l(' AND r.relationship_id = oc.party_relationship_id ');
7277: l(' AND r.directional_flag = ''F'' ');
7278: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7279: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
7280: l(' -- take care of invalid identifiers ');
7281: l(' EXCEPTION ');
7282: l(' WHEN NO_DATA_FOUND THEN ');
7283: l(' -- dbms_output.put_line ( ''Exception caught in party_rel ''); ');

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

7600: l(' AND oc.request_id = bd.main_conc_req_id ');
7601: l(' AND bd.batch_id = ocsg.batch_id ');
7602: l(' AND r.subject_id = pp.party_id ');
7603: l(' AND r.subject_type = ''PERSON'' ');
7604: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7605: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7606: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7607: l(' AND ocsg.action_flag = p_operation ');
7608: l(' AND pp.effective_end_date IS NULL ');

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

7601: l(' AND bd.batch_id = ocsg.batch_id ');
7602: l(' AND r.subject_id = pp.party_id ');
7603: l(' AND r.subject_type = ''PERSON'' ');
7604: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7605: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7606: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7607: l(' AND ocsg.action_flag = p_operation ');
7608: l(' AND pp.effective_end_date IS NULL ');
7609: l(' AND ocsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');

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

7636: l(' AND r.directional_flag = ''F'' ');
7637: l(' AND r.subject_id = pp.party_id ');
7638: l(' AND r.subject_type = ''PERSON'' ');
7639: l(' AND r.object_type = ''ORGANIZATION'' ');
7640: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7641: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7642: l(' AND rsg.action_flag = p_operation ');
7643: l(' AND pp.effective_end_date IS NULL ');
7644: l(' AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');

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

7637: l(' AND r.subject_id = pp.party_id ');
7638: l(' AND r.subject_type = ''PERSON'' ');
7639: l(' AND r.object_type = ''ORGANIZATION'' ');
7640: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7641: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
7642: l(' AND rsg.action_flag = p_operation ');
7643: l(' AND pp.effective_end_date IS NULL ');
7644: l(' AND rsg.sub_orig_system_reference BETWEEN p_from_osr AND p_to_osr ');
7645: l(' AND (oc.status IS NULL OR oc.status = ''A'' OR oc.status = ''I'')');

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

7798: l(' WHERE oc.party_relationship_id = r.relationship_id ');
7799: l(' AND dsi.record_id = oc.org_contact_id ');
7800: l(' AND r.subject_id = pp.party_id ');
7801: l(' AND r.subject_type = ''PERSON'' ');
7802: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7803: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7804: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7805: l(' AND pp.effective_end_date is NULL ');
7806: l(' AND dsi.entity = ''CONTACTS'' ');

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

7799: l(' AND dsi.record_id = oc.org_contact_id ');
7800: l(' AND r.subject_id = pp.party_id ');
7801: l(' AND r.subject_type = ''PERSON'' ');
7802: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
7803: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
7804: l(' AND DIRECTIONAL_FLAG = ''F'' ');
7805: l(' AND pp.effective_end_date is NULL ');
7806: l(' AND dsi.entity = ''CONTACTS'' ');
7807: l(' AND dsi.operation = p_operation ');

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

8235: l(' HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp');
8236: l(' WHERE oc.party_relationship_id = r.relationship_id ');
8237: l(' AND r.object_id = g.party_id ');
8238: l(' AND r.subject_id = pp.party_id ');
8239: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8240: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8241: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8242: l(' AND pp.effective_end_date is NULL ');
8243: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8236: l(' WHERE oc.party_relationship_id = r.relationship_id ');
8237: l(' AND r.object_id = g.party_id ');
8238: l(' AND r.subject_id = pp.party_id ');
8239: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8240: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8241: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8242: l(' AND pp.effective_end_date is NULL ');
8243: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8244: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'');');

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

8426: l(' AND oc.org_contact_id = p_org_contact_id');
8427: l(' AND oc.org_contact_id = d.RECORD_ID');
8428: l(' AND oc.party_relationship_id = r.relationship_id ');
8429: l(' AND r.subject_id = pp.party_id ');
8430: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8431: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8432: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8433: l(' AND pp.effective_end_date is NULL ');
8434: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8427: l(' AND oc.org_contact_id = d.RECORD_ID');
8428: l(' AND oc.party_relationship_id = r.relationship_id ');
8429: l(' AND r.subject_id = pp.party_id ');
8430: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8431: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8432: l(' AND DIRECTIONAL_FLAG= ''F'' ');
8433: l(' AND pp.effective_end_date is NULL ');
8434: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8435: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'')');

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

8568: l(' SELECT r.object_id INTO l_party_id ');
8569: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
8570: l(' WHERE oc.org_contact_id = p_org_contact_id ');
8571: l(' AND oc.party_relationship_id = r.relationship_id ');
8572: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8573: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8574: l(' AND subject_type = ''PERSON'' ');
8575: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8576: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'') ');

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

8569: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
8570: l(' WHERE oc.org_contact_id = p_org_contact_id ');
8571: l(' AND oc.party_relationship_id = r.relationship_id ');
8572: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8573: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
8574: l(' AND subject_type = ''PERSON'' ');
8575: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8576: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'') ');
8577: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'') ; ');

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

8595: l(' WHERE ');
8596: l(' oc.org_contact_id = p_org_contact_id');
8597: l(' AND oc.party_relationship_id = r.relationship_id ');
8598: l(' AND r.subject_id = pp.party_id ');
8599: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8600: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8601: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8602: l(' AND pp.effective_end_date is NULL ');
8603: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

8596: l(' oc.org_contact_id = p_org_contact_id');
8597: l(' AND oc.party_relationship_id = r.relationship_id ');
8598: l(' AND r.subject_id = pp.party_id ');
8599: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
8600: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
8601: l(' AND DIRECTIONAL_FLAG = ''F'' ');
8602: l(' AND pp.effective_end_date is NULL ');
8603: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
8604: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'')');

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

9516: END IF;
9517: END LOOP;
9518: l(' FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp');
9519: l(' WHERE cp.owner_table_id = g.owner_id ');
9520: l(' AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,''HZ_PARTIES'') ');
9521: l(' AND (cp.status is null OR cp.status = ''A'' or cp.status = ''I''); ');
9522: l('');
9523: l(' BEGIN');
9524: l(' OPEN contact_pt_cur;');

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

9854: l('');
9855: l(' IF l_ot_table = ''HZ_PARTY_SITES'' THEN ');
9856: l(' SELECT p.party_id, ps.party_site_id, party_type ');
9857: l(' INTO l_party_id1, l_party_site_id, l_party_type ');
9858: l(' FROM HZ_PARTY_SITES ps, HZ_PARTIES p ');
9859: l(' WHERE party_site_id = l_ot_id ');
9860: l(' AND p.party_id = ps.party_id; ');
9861: l('');
9862: l(' IF l_party_type = ''PARTY_RELATIONSHIP'' THEN ');

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

9865: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
9866: l(' WHERE r.party_id = l_party_id1 ');
9867: l(' AND r.relationship_id = oc.party_relationship_id ');
9868: l(' AND r.directional_flag = ''F'' ');
9869: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
9870: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
9871: l(' EXCEPTION ');
9872: l(' WHEN NO_DATA_FOUND THEN ');
9873: l(' RETURN; ');

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

9866: l(' WHERE r.party_id = l_party_id1 ');
9867: l(' AND r.relationship_id = oc.party_relationship_id ');
9868: l(' AND r.directional_flag = ''F'' ');
9869: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
9870: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
9871: l(' EXCEPTION ');
9872: l(' WHEN NO_DATA_FOUND THEN ');
9873: l(' RETURN; ');
9874: l(' END; ');

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

9876: l(' l_party_id:=l_party_id1; ');
9877: l(' l_org_contact_id:=NULL; ');
9878: l(' END IF; ');
9879: l('');
9880: l(' ELSIF l_ot_table = ''HZ_PARTIES'' THEN ');
9881: l(' l_party_site_id := NULL; ');
9882: l(' SELECT party_type INTO l_party_type ');
9883: l(' FROM hz_parties ');
9884: l(' WHERE party_id = l_ot_id; ');

Line 9883: l(' FROM hz_parties ');

9879: l('');
9880: l(' ELSIF l_ot_table = ''HZ_PARTIES'' THEN ');
9881: l(' l_party_site_id := NULL; ');
9882: l(' SELECT party_type INTO l_party_type ');
9883: l(' FROM hz_parties ');
9884: l(' WHERE party_id = l_ot_id; ');
9885: l('');
9886: l(' IF l_party_type <> ''PARTY_RELATIONSHIP'' THEN ');
9887: l(' l_party_id := l_ot_id; ');

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

9892: l(' FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r ');
9893: l(' WHERE r.party_id = l_ot_id ');
9894: l(' AND r.relationship_id = oc.party_relationship_id ');
9895: l(' AND r.directional_flag = ''F'' ');
9896: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
9897: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
9898: l(' EXCEPTION ');
9899: l(' WHEN NO_DATA_FOUND THEN ');
9900: l(' RETURN; ');

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

9893: l(' WHERE r.party_id = l_ot_id ');
9894: l(' AND r.relationship_id = oc.party_relationship_id ');
9895: l(' AND r.directional_flag = ''F'' ');
9896: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES'' ');
9897: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''; ');
9898: l(' EXCEPTION ');
9899: l(' WHEN NO_DATA_FOUND THEN ');
9900: l(' RETURN; ');
9901: l(' END; ');

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

10200: FOR I in 1..l_org_select.COUNT LOOP
10201: l(' ,' || l_org_select(I));
10202: END LOOP;
10203:
10204: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
10205: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10206: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10207: l(' AND p.party_id = op.party_id ');
10208: l(' AND op.effective_end_date is NULL; ');

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

10211: l(' SELECT p.PARTY_ID ');
10212: FOR I in 1..l_per_select.COUNT LOOP
10213: l(' ,' || l_per_select(I));
10214: END LOOP;
10215: l(' FROM HZ_STAGED_PARTIES s,HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
10216: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10217: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10218: l(' AND p.party_id = pe.party_id ');
10219: l(' AND pe.effective_end_date is NULL; ');

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

10222: l(' SELECT p.PARTY_ID ');
10223: FOR I in 1..l_oth_select.COUNT LOOP
10224: l(' ,' || l_oth_select(I));
10225: END LOOP;
10226: l(' FROM HZ_STAGED_PARTIES s, HZ_PARTIES p ');
10227: l(' WHERE s.PARTY_ID = p.PARTY_ID ');
10228: l(' AND mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
10229: l(' AND p.party_type <> ''PERSON'' ');
10230: l(' AND p.party_type <> ''ORGANIZATION'' ');

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

10454: l(' AND s.ORG_CONTACT_ID=oc.ORG_CONTACT_ID');
10455: l(' AND oc.party_relationship_id = r.relationship_id ');
10456: l(' AND r.object_id = s.party_id ');
10457: l(' AND r.subject_id = pp.party_id ');
10458: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
10459: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
10460: l(' AND DIRECTIONAL_FLAG= ''F'' ');
10461: l(' AND pp.effective_end_date is NULL ');
10462: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');

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

10455: l(' AND oc.party_relationship_id = r.relationship_id ');
10456: l(' AND r.object_id = s.party_id ');
10457: l(' AND r.subject_id = pp.party_id ');
10458: l(' AND r.SUBJECT_TABLE_NAME = ''HZ_PARTIES''');
10459: l(' AND r.OBJECT_TABLE_NAME = ''HZ_PARTIES''');
10460: l(' AND DIRECTIONAL_FLAG= ''F'' ');
10461: l(' AND pp.effective_end_date is NULL ');
10462: l(' AND (oc.status is null OR oc.status = ''A'' or oc.status = ''I'')');
10463: l(' AND (r.status is null OR r.status = ''A'' or r.status = ''I'');');

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

11100: l(' FROM HZ_CONTACT_POINTS cp, HZ_STAGED_CONTACT_POINTS s ');
11101: l(' WHERE mod(s.PARTY_ID, p_num_workers) = p_worker_number ');
11102: l(' AND cp.contact_point_id = s.contact_point_id ');
11103: l(' AND cp.owner_table_id = s.PARTY_ID ');
11104: l(' AND cp.OWNER_TABLE_NAME = ''HZ_PARTIES'' ');
11105: l(' AND (cp.status is null OR cp.status = ''A'' or cp.status = ''I''); ');
11106: l(' END;');
11107: END IF;
11108: l('');