4: PROCEDURE open_party_cursor(
5: p_party_type IN VARCHAR2,
6: p_worker_number IN NUMBER,
7: p_num_workers IN NUMBER,
8: x_party_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
9:
10: PROCEDURE open_contact_cursor(
11: p_worker_number IN NUMBER,
12: p_num_workers IN NUMBER,
9:
10: PROCEDURE open_contact_cursor(
11: p_worker_number IN NUMBER,
12: p_num_workers IN NUMBER,
13: x_contact_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
14:
15: PROCEDURE open_party_site_cursor(
16: p_worker_number IN NUMBER,
17: p_num_workers IN NUMBER,
14:
15: PROCEDURE open_party_site_cursor(
16: p_worker_number IN NUMBER,
17: p_num_workers IN NUMBER,
18: x_party_site_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
19:
20: PROCEDURE open_contact_pt_cursor(
21: p_worker_number IN NUMBER,
22: p_num_workers IN NUMBER,
19:
20: PROCEDURE open_contact_pt_cursor(
21: p_worker_number IN NUMBER,
22: p_num_workers IN NUMBER,
23: x_contact_pt_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
24:
25: PROCEDURE update_stage_parties (
26: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp);
27:
22: p_num_workers IN NUMBER,
23: x_contact_pt_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
24:
25: PROCEDURE update_stage_parties (
26: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp);
27:
28: PROCEDURE update_stage_contacts (
29: p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp);
30:
25: PROCEDURE update_stage_parties (
26: p_party_cur IN HZ_PARTY_STAGE.StageCurTyp);
27:
28: PROCEDURE update_stage_contacts (
29: p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp);
30:
31: PROCEDURE update_stage_party_sites (
32: p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp);
33:
28: PROCEDURE update_stage_contacts (
29: p_contact_cur IN HZ_PARTY_STAGE.StageCurTyp);
30:
31: PROCEDURE update_stage_party_sites (
32: p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp);
33:
34: PROCEDURE update_stage_contact_pts (
35: p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp);
36: END HZ_STAGE_MAP_TRANSFORM_UPD;
31: PROCEDURE update_stage_party_sites (
32: p_party_site_cur IN HZ_PARTY_STAGE.StageCurTyp);
33:
34: PROCEDURE update_stage_contact_pts (
35: p_contact_pt_cur IN HZ_PARTY_STAGE.StageCurTyp);
36: END HZ_STAGE_MAP_TRANSFORM_UPD;