DBA Data[Home] [Help]

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_PARTY_STAGE

Line 445: x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS

441: p_worker_number IN NUMBER,
442: p_num_workers IN NUMBER,
443: p_party_id IN NUMBER,
444: p_continue IN VARCHAR2,
445: x_party_cur IN OUT HZ_PARTY_STAGE.StageCurTyp) IS
446:
447: l_party_type VARCHAR2(255);
448: BEGIN
449: IF p_select_type = 'SINGLE_PARTY' THEN

Line 594: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS

590: END;
591:
592: PROCEDURE insert_stage_parties (
593: p_continue IN VARCHAR2,
594: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
595: l_limit NUMBER := 200;
596: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
597: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
598: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

Line 596: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

592: PROCEDURE insert_stage_parties (
593: p_continue IN VARCHAR2,
594: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
595: l_limit NUMBER := 200;
596: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
597: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
598: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
599: l_last_fetch BOOLEAN := FALSE;
600: call_status BOOLEAN;

Line 597: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;

593: p_continue IN VARCHAR2,
594: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
595: l_limit NUMBER := 200;
596: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
597: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
598: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
599: l_last_fetch BOOLEAN := FALSE;
600: call_status BOOLEAN;
601: rphase varchar2(255);

Line 598: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

594: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp) IS
595: l_limit NUMBER := 200;
596: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
597: l_cpt_cur HZ_PARTY_STAGE.StageCurTyp;
598: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
599: l_last_fetch BOOLEAN := FALSE;
600: call_status BOOLEAN;
601: rphase varchar2(255);
602: rstatus varchar2(255);