[Home] [Help]
PACKAGE: APPS.PO_PDOI_LINE_PROCESS_PVT
Source
1 PACKAGE PO_PDOI_LINE_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_LINE_PROCESS_PVT.pls 120.7 2006/07/24 19:30:07 bao noship $ */
3
4 PROCEDURE reject_dup_lines_for_spo;
5
6 PROCEDURE reject_invalid_action_lines;
7
8 PROCEDURE open_lines
9 (
10 p_data_set_type IN NUMBER,
11 p_max_intf_line_id IN NUMBER,
12 x_lines_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
13 );
14
15 PROCEDURE fetch_lines
16 (
17 x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
18 x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
19 );
20
21 PROCEDURE derive_lines
22 (
23 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
24 );
25
26 PROCEDURE derive_lines_for_update
27 (
28 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
29 );
30
31 PROCEDURE default_lines_for_update
32 (
33 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
34 );
35
36 PROCEDURE default_lines
37 (
38 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
39 );
40
41 PROCEDURE validate_lines
42 (
43 p_action IN VARCHAR2 DEFAULT 'CREATE',
44 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
45 );
46
47 PROCEDURE match_lines
48 (
49 p_data_set_type IN NUMBER, -- bug5129752
50 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
51 );
52
53 PROCEDURE check_line_locations
54 (
55 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
56 );
57
58 PROCEDURE update_line_intf_tbl
59 (
60 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
61 );
62
63 PROCEDURE uniqueness_check
64 (
65 p_type IN NUMBER,
66 p_group_num IN NUMBER,
67 x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
68 x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
69 x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
70 );
71
72 PROCEDURE split_lines
73 (
74 p_group_num IN NUMBER,
75 p_lines IN PO_PDOI_TYPES.lines_rec_type,
76 x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
77 x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
78 );
79
80 END PO_PDOI_LINE_PROCESS_PVT;