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