DBA Data[Home] [Help]

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_PARTY_STAGE

Line 471: x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS

467: p_party_id IN NUMBER,
468: p_continue IN VARCHAR2,
469: p_start_rowid IN ROWID,
470: p_end_rowid IN ROWID,
471: x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS
472:
473: l_party_type VARCHAR2(255);
474: BEGIN
475: IF p_select_type = 'SINGLE_PARTY' THEN

Line 620: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS

616: END;
617:
618: PROCEDURE insert_stage_parties (
619: p_continue IN VARCHAR2,
620: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
621: l_limit NUMBER := 200;
622: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
623: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
624: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

Line 622: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

618: PROCEDURE insert_stage_parties (
619: p_continue IN VARCHAR2,
620: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
621: l_limit NUMBER := 200;
622: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
623: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
624: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
625: l_last_fetch BOOLEAN := FALSE;
626: call_status BOOLEAN;

Line 623: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;

619: p_continue IN VARCHAR2,
620: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
621: l_limit NUMBER := 200;
622: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
623: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
624: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
625: l_last_fetch BOOLEAN := FALSE;
626: call_status BOOLEAN;
627: rphase varchar2(255);

Line 624: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

620: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
621: l_limit NUMBER := 200;
622: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
623: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
624: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
625: l_last_fetch BOOLEAN := FALSE;
626: call_status BOOLEAN;
627: rphase varchar2(255);
628: rstatus varchar2(255);