DBA Data[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;