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_TRANS_PKG

Line 2566: HZ_TRANS_PKG.set_staging_context('Y');

2562: log('');
2563: log('Stage Parties begin');
2564:
2565: FND_MSG_PUB.initialize;
2566: HZ_TRANS_PKG.set_staging_context('Y');
2567: IF p_command='STAGE_ALL_DATA' THEN
2568:
2569: SELECT SYSDATE INTO l_startdate FROM DUAL;
2570:

Line 2639: HZ_TRANS_PKG.set_party_type('ORGANIZATION');

2635: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2636: --COMMIT;
2637:
2638:
2639: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2640: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2641: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2642: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2643:

Line 2650: HZ_TRANS_PKG.set_party_type('PERSON');

2646: WHERE OPERATION = p_command
2647: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2648: COMMIT;
2649:
2650: HZ_TRANS_PKG.set_party_type('PERSON');
2651: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2652: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2653: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2654:

Line 2661: HZ_TRANS_PKG.set_party_type('OTHER');

2657: WHERE OPERATION = p_command
2658: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2659: COMMIT;
2660:
2661: HZ_TRANS_PKG.set_party_type('OTHER');
2662: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2663: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N',l_start_rowid,l_end_rowid, l_party_cur);
2664: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2665:

Line 2667: HZ_TRANS_PKG.set_party_type('ORGANIZATION');

2663: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N',l_start_rowid,l_end_rowid, l_party_cur);
2664: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2665:
2666: ELSE
2667: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2668: log(' Continue for Org cursor');
2669: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2670: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid,l_party_cur);
2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);

Line 2674: HZ_TRANS_PKG.set_party_type('PERSON');

2670: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid,l_party_cur);
2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2672:
2673: log(' Continue for Per cursor');
2674: HZ_TRANS_PKG.set_party_type('PERSON');
2675: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2676: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'Y', l_start_rowid,l_end_rowid,l_party_cur);
2677: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2678:

Line 2681: HZ_TRANS_PKG.set_party_type('OTHER');

2677: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2678:
2679: log(' Continue for Oth cursor');
2680:
2681: HZ_TRANS_PKG.set_party_type('OTHER');
2682: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2683: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid, l_party_cur);
2684: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2685:

Line 2796: HZ_TRANS_PKG.set_party_type('ORGANIZATION');

2792: COMMIT;
2793:
2794: END IF;
2795:
2796: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2797: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2798: 'ORGANIZATION',l_worker_number, l_num_workers, l_party_cur);
2799: IF l_party_cur IS NOT NULL THEN
2800: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

Line 2830: HZ_TRANS_PKG.set_party_type('PERSON');

2826: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2827:
2828: END IF;
2829:
2830: HZ_TRANS_PKG.set_party_type('PERSON');
2831: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2832: 'PERSON',l_worker_number, l_num_workers, l_party_cur);
2833:
2834: IF l_party_cur IS NOT NULL THEN

Line 2864: HZ_TRANS_PKG.set_party_type('OTHER');

2860: WHERE OPERATION = p_command
2861: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2862: END IF;
2863:
2864: HZ_TRANS_PKG.set_party_type('OTHER');
2865: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2866: 'OTHER',l_worker_number, l_num_workers, l_party_cur);
2867:
2868: IF l_party_cur IS NOT NULL THEN

Line 5044: l(' hz_trans_pkg.set_party_type(p_party_type); ');

5040: l(' AND p.party_type <> ''PARTY_RELATIONSHIP'' ');
5041: l(' AND ps.party_orig_system_reference between p_from_osr and p_to_osr; ');
5042: l(' END IF;');
5043: l('');
5044: l(' hz_trans_pkg.set_party_type(p_party_type); ');
5045: l('');
5046: l(' END open_bulk_imp_sync_party_cur;');
5047: l('');
5048: END gen_bulk_imp_sync_party_query;

Line 5260: l(' hz_trans_pkg.set_party_type(p_party_type); ');

5256: l(' AND p.party_type <> ''PERSON'' ');
5257: l(' AND p.party_type <> ''ORGANIZATION'' ');
5258: l(' AND p.party_type <> ''PARTY_RELATIONSHIP''; ');
5259: l(' END IF;');
5260: l(' hz_trans_pkg.set_party_type(p_party_type); ');
5261: l(' END;');
5262:
5263: l('');
5264: l(' PROCEDURE sync_all_parties ( ');

Line 6141: l(' hz_trans_pkg.set_party_type(l_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('');
6143: l(' IF l_party_type = ''PERSON'' THEN ');
6144: l(' ---------------------------------- ');
6145: l(' -- Take care of CONTACT INFORMATION ');