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.77.12000000.2 2007/04/19 10:31:07 rarajend ship $ */
3:
4:
5: g_batch_size NUMBER := 200;

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

3983: l('FUNCTION ' || p_proc_name || '( ');
3984: l(' p_record_id NUMBER,');
3985: IF p_entity = 'PARTY' THEN
3986: l(' p_search_rec HZ_PARTY_SEARCH.party_search_rec_type');
3987: l(' ) RETURN HZ_PARTY_STAGE.party_stage_rec_type IS ');
3988: l('l_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;');
3989: l('BEGIN');
3990: l(' l_stage_rec.party_id := p_record_id;');
3991: l(' l_stage_rec.status := p_search_rec.STATUS;');

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

3984: l(' p_record_id NUMBER,');
3985: IF p_entity = 'PARTY' THEN
3986: l(' p_search_rec HZ_PARTY_SEARCH.party_search_rec_type');
3987: l(' ) RETURN HZ_PARTY_STAGE.party_stage_rec_type IS ');
3988: l('l_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;');
3989: l('BEGIN');
3990: l(' l_stage_rec.party_id := p_record_id;');
3991: l(' l_stage_rec.status := p_search_rec.STATUS;');
3992: ELSIF p_entity = 'PARTY_SITES' THEN

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

3991: l(' l_stage_rec.status := p_search_rec.STATUS;');
3992: ELSIF p_entity = 'PARTY_SITES' THEN
3993: l(' p_party_id NUMBER,');
3994: l(' p_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type');
3995: l(' ) RETURN HZ_PARTY_STAGE.party_site_stage_rec_type IS ');
3996: l('l_stage_rec HZ_PARTY_STAGE.party_site_stage_rec_type;');
3997: l('BEGIN');
3998: l(' l_stage_rec.party_id := p_party_id;');
3999: l(' l_stage_rec.party_site_id := p_record_id;');

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

3992: ELSIF p_entity = 'PARTY_SITES' THEN
3993: l(' p_party_id NUMBER,');
3994: l(' p_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type');
3995: l(' ) RETURN HZ_PARTY_STAGE.party_site_stage_rec_type IS ');
3996: l('l_stage_rec HZ_PARTY_STAGE.party_site_stage_rec_type;');
3997: l('BEGIN');
3998: l(' l_stage_rec.party_id := p_party_id;');
3999: l(' l_stage_rec.party_site_id := p_record_id;');
4000: ELSIF p_entity = 'CONTACTS' THEN

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

3999: l(' l_stage_rec.party_site_id := p_record_id;');
4000: ELSIF p_entity = 'CONTACTS' THEN
4001: l(' p_party_id NUMBER,');
4002: l(' p_search_rec HZ_PARTY_SEARCH.contact_search_rec_type');
4003: l(' ) RETURN HZ_PARTY_STAGE.contact_stage_rec_type IS ');
4004: l('l_stage_rec HZ_PARTY_STAGE.contact_stage_rec_type;');
4005: l('BEGIN');
4006: l(' l_stage_rec.party_id := p_party_id;');
4007: l(' l_stage_rec.org_contact_id := p_record_id;');

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

4000: ELSIF p_entity = 'CONTACTS' THEN
4001: l(' p_party_id NUMBER,');
4002: l(' p_search_rec HZ_PARTY_SEARCH.contact_search_rec_type');
4003: l(' ) RETURN HZ_PARTY_STAGE.contact_stage_rec_type IS ');
4004: l('l_stage_rec HZ_PARTY_STAGE.contact_stage_rec_type;');
4005: l('BEGIN');
4006: l(' l_stage_rec.party_id := p_party_id;');
4007: l(' l_stage_rec.org_contact_id := p_record_id;');
4008: ELSIF p_entity = 'CONTACT_POINTS' THEN

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

4007: l(' l_stage_rec.org_contact_id := p_record_id;');
4008: ELSIF p_entity = 'CONTACT_POINTS' THEN
4009: l(' p_party_id NUMBER,');
4010: l(' p_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type');
4011: l(' ) RETURN HZ_PARTY_STAGE.contact_pt_stage_rec_type IS ');
4012: l('l_stage_rec HZ_PARTY_STAGE.contact_pt_stage_rec_type;');
4013: l('BEGIN');
4014: l(' l_stage_rec.party_id := p_party_id;');
4015: l(' l_stage_rec.contact_point_id := p_record_id;');

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

4008: ELSIF p_entity = 'CONTACT_POINTS' THEN
4009: l(' p_party_id NUMBER,');
4010: l(' p_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type');
4011: l(' ) RETURN HZ_PARTY_STAGE.contact_pt_stage_rec_type IS ');
4012: l('l_stage_rec HZ_PARTY_STAGE.contact_pt_stage_rec_type;');
4013: l('BEGIN');
4014: l(' l_stage_rec.party_id := p_party_id;');
4015: l(' l_stage_rec.contact_point_id := p_record_id;');
4016: l(' l_stage_rec.contact_point_type := p_search_rec.CONTACT_POINT_TYPE;');

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

5400: l(' p_worker_number IN NUMBER,');
5401: l(' p_num_workers IN NUMBER,');
5402: l(' p_party_id IN NUMBER,');
5403: l(' p_continue IN VARCHAR2,');
5404: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
5405: l('');
5406: l(' l_party_type VARCHAR2(255);');
5407: l(' BEGIN');
5408:

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

5633:
5634: l('');
5635: l(' PROCEDURE insert_stage_parties ( ');
5636: l(' p_continue IN VARCHAR2, ');
5637: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5638: l(' l_limit NUMBER := ' || g_batch_size || ';');
5639: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5640: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5641: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');

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

5635: l(' PROCEDURE insert_stage_parties ( ');
5636: l(' p_continue IN VARCHAR2, ');
5637: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5638: l(' l_limit NUMBER := ' || g_batch_size || ';');
5639: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5640: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5641: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5642: l(' l_last_fetch BOOLEAN := FALSE;');
5643: l(' call_status BOOLEAN;');

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

5636: l(' p_continue IN VARCHAR2, ');
5637: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5638: l(' l_limit NUMBER := ' || g_batch_size || ';');
5639: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5640: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5641: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5642: l(' l_last_fetch BOOLEAN := FALSE;');
5643: l(' call_status BOOLEAN;');
5644: l(' rphase varchar2(255);');

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

5637: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
5638: l(' l_limit NUMBER := ' || g_batch_size || ';');
5639: l(' l_contact_cur HZ_PARTY_STAGE.StageCurTyp;');
5640: l(' l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;');
5641: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;');
5642: l(' l_last_fetch BOOLEAN := FALSE;');
5643: l(' call_status BOOLEAN;');
5644: l(' rphase varchar2(255);');
5645: l(' rstatus varchar2(255);');

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

10091: l(' PROCEDURE open_party_cursor( ');
10092: l(' p_party_type IN VARCHAR2,');
10093: l(' p_worker_number IN NUMBER,');
10094: l(' p_num_workers IN NUMBER,');
10095: l(' x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10096: l('');
10097: l(' l_party_type VARCHAR2(255);');
10098: l(' BEGIN');
10099:

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

10233: l(' END;');
10234: END IF;
10235: l('');
10236: l(' PROCEDURE update_stage_parties ( ');
10237: l(' p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10238: l(' l_limit NUMBER := ' || g_batch_size || ';');
10239: l(' l_last_fetch BOOLEAN := FALSE;');
10240: l('');
10241: l(' BEGIN');

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

10354: l('');
10355: l(' PROCEDURE open_contact_cursor( ');
10356: l(' p_worker_number IN NUMBER,');
10357: l(' p_num_workers IN NUMBER,');
10358: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10359: l('');
10360: l(' BEGIN');
10361:
10362: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

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

10464: l(' END;');
10465: END IF;
10466: l('');
10467: l(' PROCEDURE update_stage_contacts ( ');
10468: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10469: l(' l_limit NUMBER := ' || g_batch_size || ';');
10470: l(' H_DENORM_PARTY_ID NumberList ;');
10471: l(' H_DENORM_VALUE CharList ;');
10472: l(' H_ROW_OFFSET Number ;');

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

10595: l('');
10596: l(' PROCEDURE open_contact_cursor( ');
10597: l(' p_worker_number IN NUMBER,');
10598: l(' p_num_workers IN NUMBER,');
10599: l(' x_contact_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10600: l('');
10601: l(' BEGIN');
10602: l(' open x_contact_cur FOR');
10603: l(' SELECT ct.PARTY_ID,');

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

10607: l(' END;');
10608:
10609: l('');
10610: l(' PROCEDURE update_stage_contacts ( ');
10611: l(' p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10612: l(' l_limit NUMBER := ' || g_batch_size || ';');
10613: l(' H_DENORM_PARTY_ID NumberList ;');
10614: l(' H_DENORM_VALUE CharList ;');
10615: l(' H_ROW_OFFSET Number ;');

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

10691: l('');
10692: l(' PROCEDURE open_party_site_cursor( ');
10693: l(' p_worker_number IN NUMBER,');
10694: l(' p_num_workers IN NUMBER,');
10695: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10696: l('');
10697: l(' BEGIN');
10698:
10699: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

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

10793: END IF;
10794:
10795: l('');
10796: l(' PROCEDURE update_stage_party_sites ( ');
10797: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10798: l(' l_limit NUMBER := ' || g_batch_size || ';');
10799: l(' H_DENORM_PARTY_ID NumberList ;');
10800: l(' H_DENORM_VALUE CharList ;');
10801: l(' H_ROW_OFFSET Number ;');

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

10921: l('');
10922: l(' PROCEDURE open_party_site_cursor( ');
10923: l(' p_worker_number IN NUMBER,');
10924: l(' p_num_workers IN NUMBER,');
10925: l(' x_party_site_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
10926: l('');
10927: l(' BEGIN');
10928: l(' open x_party_site_cur FOR');
10929: l(' SELECT ps.PARTY_ID,');

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

10932: l(' WHERE mod(ps.PARTY_ID, p_num_workers) = p_worker_number ; ');
10933: l(' END;');
10934:
10935: l(' PROCEDURE update_stage_party_sites ( ');
10936: l(' p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
10937: l(' l_limit NUMBER := ' || g_batch_size || ';');
10938: l(' H_DENORM_PARTY_ID NumberList ;');
10939: l(' H_DENORM_VALUE CharList ;');
10940: l(' H_ROW_OFFSET Number ;');

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

11010: l('');
11011: l(' PROCEDURE open_contact_pt_cursor( ');
11012: l(' p_worker_number IN NUMBER,');
11013: l(' p_num_workers IN NUMBER,');
11014: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
11015: l('');
11016: l(' BEGIN');
11017:
11018: FOR ATTRS IN (SELECT a.ATTRIBUTE_ID,

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

11106: l(' END;');
11107: END IF;
11108: l('');
11109: l(' PROCEDURE update_stage_contact_pts ( ');
11110: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
11111: l(' l_limit NUMBER := ' || g_batch_size || ';');
11112: l(' H_DENORM_PARTY_ID NumberList ;');
11113: l(' H_DENORM_VALUE CharList ;');
11114: l(' H_ROW_OFFSET Number ;');

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

11236: l('');
11237: l(' PROCEDURE open_contact_pt_cursor( ');
11238: l(' p_worker_number IN NUMBER,');
11239: l(' p_num_workers IN NUMBER,');
11240: l(' x_contact_pt_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS ');
11241: l('');
11242: l(' BEGIN');
11243: l(' open x_contact_pt_cur FOR');
11244: l(' SELECT cpt.PARTY_ID,');

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

11247: l(' WHERE mod(cpt.PARTY_ID, p_num_workers) = p_worker_number ; ');
11248: l(' END;');
11249:
11250: l(' PROCEDURE update_stage_contact_pts ( ');
11251: l(' p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp) IS ');
11252: l(' l_limit NUMBER := ' || g_batch_size || ';');
11253: l(' H_DENORM_PARTY_ID NumberList ;');
11254: l(' H_DENORM_VALUE CharList ;');
11255: l(' H_ROW_OFFSET Number ;');

Line 11604: END HZ_PARTY_STAGE;

11600: BEGIN
11601: g_schema_name := hz_utility_v2pub.get_appsschemaname;
11602:
11603:
11604: END HZ_PARTY_STAGE;
11605: