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: (
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
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: (
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: (
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: (
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: (
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: (
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: (
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: (
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: (
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: (
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
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:
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;
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;