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_PARTY_STAGE

Line 1: PACKAGE BODY HZ_PARTY_STAGE AS

1: PACKAGE BODY HZ_PARTY_STAGE AS
2: /*$Header: ARHDSTGB.pls 120.86 2012/02/03 06:09:25 amstephe ship $ */
3:
4:
5: g_batch_size NUMBER := 200;

Line 4115: l(' ) RETURN HZ_PARTY_STAGE.party_stage_rec_type IS ');

4111: l('FUNCTION ' || p_proc_name || '( ');
4112: l(' p_record_id NUMBER,');
4113: IF p_entity = 'PARTY' THEN
4114: l(' p_search_rec HZ_PARTY_SEARCH.party_search_rec_type');
4115: l(' ) RETURN HZ_PARTY_STAGE.party_stage_rec_type IS ');
4116: l('l_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;');
4117: l('BEGIN');
4118: l(' l_stage_rec.party_id := p_record_id;');
4119: l(' l_stage_rec.status := p_search_rec.STATUS;');

Line 4116: l('l_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;');

4112: l(' p_record_id NUMBER,');
4113: IF p_entity = 'PARTY' THEN
4114: l(' p_search_rec HZ_PARTY_SEARCH.party_search_rec_type');
4115: l(' ) RETURN HZ_PARTY_STAGE.party_stage_rec_type IS ');
4116: l('l_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;');
4117: l('BEGIN');
4118: l(' l_stage_rec.party_id := p_record_id;');
4119: l(' l_stage_rec.status := p_search_rec.STATUS;');
4120: ELSIF p_entity = 'PARTY_SITES' THEN

Line 4123: l(' ) RETURN HZ_PARTY_STAGE.party_site_stage_rec_type IS ');

4119: l(' l_stage_rec.status := p_search_rec.STATUS;');
4120: ELSIF p_entity = 'PARTY_SITES' THEN
4121: l(' p_party_id NUMBER,');
4122: l(' p_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type');
4123: l(' ) RETURN HZ_PARTY_STAGE.party_site_stage_rec_type IS ');
4124: l('l_stage_rec HZ_PARTY_STAGE.party_site_stage_rec_type;');
4125: l('BEGIN');
4126: l(' l_stage_rec.party_id := p_party_id;');
4127: l(' l_stage_rec.party_site_id := p_record_id;');

Line 4124: l('l_stage_rec HZ_PARTY_STAGE.party_site_stage_rec_type;');

4120: ELSIF p_entity = 'PARTY_SITES' THEN
4121: l(' p_party_id NUMBER,');
4122: l(' p_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type');
4123: l(' ) RETURN HZ_PARTY_STAGE.party_site_stage_rec_type IS ');
4124: l('l_stage_rec HZ_PARTY_STAGE.party_site_stage_rec_type;');
4125: l('BEGIN');
4126: l(' l_stage_rec.party_id := p_party_id;');
4127: l(' l_stage_rec.party_site_id := p_record_id;');
4128: ELSIF p_entity = 'CONTACTS' THEN

Line 4131: l(' ) RETURN HZ_PARTY_STAGE.contact_stage_rec_type IS ');

4127: l(' l_stage_rec.party_site_id := p_record_id;');
4128: ELSIF p_entity = 'CONTACTS' THEN
4129: l(' p_party_id NUMBER,');
4130: l(' p_search_rec HZ_PARTY_SEARCH.contact_search_rec_type');
4131: l(' ) RETURN HZ_PARTY_STAGE.contact_stage_rec_type IS ');
4132: l('l_stage_rec HZ_PARTY_STAGE.contact_stage_rec_type;');
4133: l('BEGIN');
4134: l(' l_stage_rec.party_id := p_party_id;');
4135: l(' l_stage_rec.org_contact_id := p_record_id;');

Line 4132: l('l_stage_rec HZ_PARTY_STAGE.contact_stage_rec_type;');

4128: ELSIF p_entity = 'CONTACTS' THEN
4129: l(' p_party_id NUMBER,');
4130: l(' p_search_rec HZ_PARTY_SEARCH.contact_search_rec_type');
4131: l(' ) RETURN HZ_PARTY_STAGE.contact_stage_rec_type IS ');
4132: l('l_stage_rec HZ_PARTY_STAGE.contact_stage_rec_type;');
4133: l('BEGIN');
4134: l(' l_stage_rec.party_id := p_party_id;');
4135: l(' l_stage_rec.org_contact_id := p_record_id;');
4136: ELSIF p_entity = 'CONTACT_POINTS' THEN

Line 4139: l(' ) RETURN HZ_PARTY_STAGE.contact_pt_stage_rec_type IS ');

4135: l(' l_stage_rec.org_contact_id := p_record_id;');
4136: ELSIF p_entity = 'CONTACT_POINTS' THEN
4137: l(' p_party_id NUMBER,');
4138: l(' p_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type');
4139: l(' ) RETURN HZ_PARTY_STAGE.contact_pt_stage_rec_type IS ');
4140: l('l_stage_rec HZ_PARTY_STAGE.contact_pt_stage_rec_type;');
4141: l('BEGIN');
4142: l(' l_stage_rec.party_id := p_party_id;');
4143: l(' l_stage_rec.contact_point_id := p_record_id;');

Line 4140: l('l_stage_rec HZ_PARTY_STAGE.contact_pt_stage_rec_type;');

4136: ELSIF p_entity = 'CONTACT_POINTS' THEN
4137: l(' p_party_id NUMBER,');
4138: l(' p_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type');
4139: l(' ) RETURN HZ_PARTY_STAGE.contact_pt_stage_rec_type IS ');
4140: l('l_stage_rec HZ_PARTY_STAGE.contact_pt_stage_rec_type;');
4141: l('BEGIN');
4142: l(' l_stage_rec.party_id := p_party_id;');
4143: l(' l_stage_rec.contact_point_id := p_record_id;');
4144: l(' l_stage_rec.contact_point_type := p_search_rec.CONTACT_POINT_TYPE;');

Line 5558: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

5554: l(' p_party_id IN NUMBER,');
5555: l(' p_continue IN VARCHAR2,');
5556: l(' p_start_rowid IN ROWID,');
5557: l(' p_end_rowid IN ROWID,');
5558: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
5559: l('');
5560: l(' l_party_type VARCHAR2(255);');
5561: l(' BEGIN');
5562:

Line 5791: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

5787:
5788: l('');
5789: l(' PROCEDURE insert_stage_parties ( ');
5790: l(' p_continue IN VARCHAR2, ');
5791: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5792: l(' l_limit NUMBER := ' || g_batch_size || ';');
5793: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5794: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5795: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');

Line 5793: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');

5789: l(' PROCEDURE insert_stage_parties ( ');
5790: l(' p_continue IN VARCHAR2, ');
5791: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5792: l(' l_limit NUMBER := ' || g_batch_size || ';');
5793: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5794: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5795: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5796: l(' l_last_fetch BOOLEAN := FALSE;');
5797: l(' call_status BOOLEAN;');

Line 5794: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');

5790: l(' p_continue IN VARCHAR2, ');
5791: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5792: l(' l_limit NUMBER := ' || g_batch_size || ';');
5793: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5794: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5795: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5796: l(' l_last_fetch BOOLEAN := FALSE;');
5797: l(' call_status BOOLEAN;');
5798: l(' rphase varchar2(255);');

Line 5795: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');

5791: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5792: l(' l_limit NUMBER := ' || g_batch_size || ';');
5793: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5794: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5795: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5796: l(' l_last_fetch BOOLEAN := FALSE;');
5797: l(' call_status BOOLEAN;');
5798: l(' rphase varchar2(255);');
5799: l(' rstatus varchar2(255);');

Line 10249: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

10245: l(' PROCEDURE open_party_cursor( ');
10246: l(' p_party_type IN VARCHAR2,');
10247: l(' p_worker_number IN NUMBER,');
10248: l(' p_num_workers IN NUMBER,');
10249: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10250: l('');
10251: l(' l_party_type VARCHAR2(255);');
10252: l(' BEGIN');
10253:

Line 10391: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

10387: l(' END;');
10388: END IF;
10389: l('');
10390: l(' PROCEDURE update_stage_parties ( ');
10391: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10392: l(' l_limit NUMBER := ' || g_batch_size || ';');
10393: l(' l_last_fetch BOOLEAN := FALSE;');
10394: l('');
10395: l(' BEGIN');

Line 10512: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

10508: l('');
10509: l(' PROCEDURE open_contact_cursor( ');
10510: l(' p_worker_number IN NUMBER,');
10511: l(' p_num_workers IN NUMBER,');
10512: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10513: l('');
10514: l(' BEGIN');
10515:
10516: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

Line 10622: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

10618: l(' END;');
10619: END IF;
10620: l('');
10621: l(' PROCEDURE update_stage_contacts ( ');
10622: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10623: l(' l_limit NUMBER := ' || g_batch_size || ';');
10624: l(' H_DENORM_PARTY_ID NumberList ;');
10625: l(' H_DENORM_VALUE CharList ;');
10626: l(' H_ROW_OFFSET Number ;');

Line 10753: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

10749: l('');
10750: l(' PROCEDURE open_contact_cursor( ');
10751: l(' p_worker_number IN NUMBER,');
10752: l(' p_num_workers IN NUMBER,');
10753: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10754: l('');
10755: l(' BEGIN');
10756: l(' open x_contact_cur FOR');
10757: l(' SELECT ct.PARTY_ID,');

Line 10765: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

10761: l(' END;');
10762:
10763: l('');
10764: l(' PROCEDURE update_stage_contacts ( ');
10765: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10766: l(' l_limit NUMBER := ' || g_batch_size || ';');
10767: l(' H_DENORM_PARTY_ID NumberList ;');
10768: l(' H_DENORM_VALUE CharList ;');
10769: l(' H_ROW_OFFSET Number ;');

Line 10849: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

10845: l('');
10846: l(' PROCEDURE open_party_site_cursor( ');
10847: l(' p_worker_number IN NUMBER,');
10848: l(' p_num_workers IN NUMBER,');
10849: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10850: l('');
10851: l(' BEGIN');
10852:
10853: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

Line 10951: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

10947: END IF;
10948:
10949: l('');
10950: l(' PROCEDURE update_stage_party_sites ( ');
10951: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10952: l(' l_limit NUMBER := ' || g_batch_size || ';');
10953: l(' H_DENORM_PARTY_ID NumberList ;');
10954: l(' H_DENORM_VALUE CharList ;');
10955: l(' H_ROW_OFFSET Number ;');

Line 11079: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

11075: l('');
11076: l(' PROCEDURE open_party_site_cursor( ');
11077: l(' p_worker_number IN NUMBER,');
11078: l(' p_num_workers IN NUMBER,');
11079: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
11080: l('');
11081: l(' BEGIN');
11082: l(' open x_party_site_cur FOR');
11083: l(' SELECT ps.PARTY_ID,');

Line 11090: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

11086: l(' WHERE mod(ps.PARTY_ID, p_num_workers) = p_worker_number ; ');
11087: l(' END;');
11088:
11089: l(' PROCEDURE update_stage_party_sites ( ');
11090: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
11091: l(' l_limit NUMBER := ' || g_batch_size || ';');
11092: l(' H_DENORM_PARTY_ID NumberList ;');
11093: l(' H_DENORM_VALUE CharList ;');
11094: l(' H_ROW_OFFSET Number ;');

Line 11168: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

11164: l('');
11165: l(' PROCEDURE open_contact_pt_cursor( ');
11166: l(' p_worker_number IN NUMBER,');
11167: l(' p_num_workers IN NUMBER,');
11168: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
11169: l('');
11170: l(' BEGIN');
11171:
11172: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

Line 11264: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

11260: l(' END;');
11261: END IF;
11262: l('');
11263: l(' PROCEDURE update_stage_contact_pts ( ');
11264: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
11265: l(' l_limit NUMBER := ' || g_batch_size || ';');
11266: l(' H_DENORM_PARTY_ID NumberList ;');
11267: l(' H_DENORM_VALUE CharList ;');
11268: l(' H_ROW_OFFSET Number ;');

Line 11394: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');

11390: l('');
11391: l(' PROCEDURE open_contact_pt_cursor( ');
11392: l(' p_worker_number IN NUMBER,');
11393: l(' p_num_workers IN NUMBER,');
11394: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
11395: l('');
11396: l(' BEGIN');
11397: l(' open x_contact_pt_cur FOR');
11398: l(' SELECT cpt.PARTY_ID,');

Line 11405: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');

11401: l(' WHERE mod(cpt.PARTY_ID, p_num_workers) = p_worker_number ; ');
11402: l(' END;');
11403:
11404: l(' PROCEDURE update_stage_contact_pts ( ');
11405: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
11406: l(' l_limit NUMBER := ' || g_batch_size || ';');
11407: l(' H_DENORM_PARTY_ID NumberList ;');
11408: l(' H_DENORM_VALUE CharList ;');
11409: l(' H_ROW_OFFSET Number ;');

Line 11758: END HZ_PARTY_STAGE;

11754: BEGIN
11755: g_schema_name := hz_utility_v2pub.get_appsschemaname;
11756:
11757:
11758: END HZ_PARTY_STAGE;
11759: