[Home] [Help]
PACKAGE: APPS.HZ_STAGE_MAP_TRANSFORM_UPD
Source
1 package HZ_STAGE_MAP_TRANSFORM_UPD AUTHID CURRENT_USER AS
2 /* $Header: ARHDQMUS.pls 120.3 2005/06/16 21:11:06 jhuang noship $ */
3
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,
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,
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,
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
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;