DBA Data[Home] [Help]

PACKAGE: APPS.PO_PDOI_ATTR_PROCESS_PVT

Source


1 PACKAGE PO_PDOI_ATTR_PROCESS_PVT AS
2 /* $Header: PO_PDOI_ATTR_PROCESS_PVT.pls 120.1 2005/08/09 16:22 jinwang noship $ */
3 
4 PROCEDURE open_attr_values
5 (
6   p_max_intf_attr_values_id   IN NUMBER,
7   x_attr_values_csr           OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
8 );
9 
10 PROCEDURE fetch_attr_values
11 (
12   x_attr_values_csr          IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
13   x_attr_values              OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type
14 );
15 
16 PROCEDURE check_attr_actions
17 (
18   x_processing_row_tbl       IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
19   x_attr_values              IN OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type,
20   x_merge_row_tbl            OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
21   x_sync_attr_id_tbl         OUT NOCOPY PO_TBL_NUMBER,
22   x_sync_draft_id_tbl        OUT NOCOPY PO_TBL_NUMBER
23 );
24 
25 PROCEDURE open_attr_values_tlp
26 (
27   p_max_intf_attr_values_tlp_id   IN NUMBER,
28   x_attr_values_tlp_csr           IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
29 );
30 
31 PROCEDURE fetch_attr_values_tlp
32 (
33   x_attr_values_tlp_csr          IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
34   x_attr_values_tlp              IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type
35 );
36 
37 PROCEDURE check_attr_tlp_actions
38 (
39   x_processing_row_tbl       IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
40   x_attr_values_tlp          IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
41   x_merge_row_tbl            OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
42   x_sync_attr_tlp_id_tbl     OUT NOCOPY PO_TBL_NUMBER,
43   x_sync_draft_id_tbl        OUT NOCOPY PO_TBL_NUMBER
44 );
45 
46 PROCEDURE add_default_attrs;
47 
48 END PO_PDOI_ATTR_PROCESS_PVT;