3:
4: --
5: -- Public procedures/functions
6: --
7: PROCEDURE insert_p( p_dist_rec IN ar_distributions%ROWTYPE,
8: p_line_id OUT NOCOPY ar_distributions.line_id%TYPE );
9:
10: PROCEDURE update_p( p_dist_rec IN ar_distributions%ROWTYPE );
11:
4: --
5: -- Public procedures/functions
6: --
7: PROCEDURE insert_p( p_dist_rec IN ar_distributions%ROWTYPE,
8: p_line_id OUT NOCOPY ar_distributions.line_id%TYPE );
9:
10: PROCEDURE update_p( p_dist_rec IN ar_distributions%ROWTYPE );
11:
12: PROCEDURE delete_p( p_line_id IN ar_distributions.line_id%TYPE );
6: --
7: PROCEDURE insert_p( p_dist_rec IN ar_distributions%ROWTYPE,
8: p_line_id OUT NOCOPY ar_distributions.line_id%TYPE );
9:
10: PROCEDURE update_p( p_dist_rec IN ar_distributions%ROWTYPE );
11:
12: PROCEDURE delete_p( p_line_id IN ar_distributions.line_id%TYPE );
13:
14: PROCEDURE lock_p( p_line_id IN ar_distributions.line_id%TYPE );
8: p_line_id OUT NOCOPY ar_distributions.line_id%TYPE );
9:
10: PROCEDURE update_p( p_dist_rec IN ar_distributions%ROWTYPE );
11:
12: PROCEDURE delete_p( p_line_id IN ar_distributions.line_id%TYPE );
13:
14: PROCEDURE lock_p( p_line_id IN ar_distributions.line_id%TYPE );
15:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
10: PROCEDURE update_p( p_dist_rec IN ar_distributions%ROWTYPE );
11:
12: PROCEDURE delete_p( p_line_id IN ar_distributions.line_id%TYPE );
13:
14: PROCEDURE lock_p( p_line_id IN ar_distributions.line_id%TYPE );
15:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
12: PROCEDURE delete_p( p_line_id IN ar_distributions.line_id%TYPE );
13:
14: PROCEDURE lock_p( p_line_id IN ar_distributions.line_id%TYPE );
15:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
13:
14: PROCEDURE lock_p( p_line_id IN ar_distributions.line_id%TYPE );
15:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
15:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
16: PROCEDURE fetch_p( p_line_id IN ar_distributions.line_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
17: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
18:
19: PROCEDURE fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
20: p_source_table IN ar_distributions.source_table%TYPE,
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
21: p_source_type IN ar_distributions.source_type%TYPE,
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
22: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
23:
24: PROCEDURE lock_fetch_pk( p_source_id IN ar_distributions.source_id%TYPE,
25: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
31: p_source_table IN ar_distributions.source_table%TYPE,
26: p_source_type IN ar_distributions.source_type%TYPE,
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
31: p_source_table IN ar_distributions.source_table%TYPE,
32: p_source_type IN ar_distributions.source_type%TYPE,
33: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
34:
27: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
31: p_source_table IN ar_distributions.source_table%TYPE,
32: p_source_type IN ar_distributions.source_type%TYPE,
33: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
34:
35:
28:
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
31: p_source_table IN ar_distributions.source_table%TYPE,
32: p_source_type IN ar_distributions.source_type%TYPE,
33: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
34:
35:
36: END ARP_DISTRIBUTIONS_PKG;
29: PROCEDURE nowaitlock_fetch_pk( p_source_id
30: IN ar_distributions.source_id%TYPE,
31: p_source_table IN ar_distributions.source_table%TYPE,
32: p_source_type IN ar_distributions.source_type%TYPE,
33: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE );
34:
35:
36: END ARP_DISTRIBUTIONS_PKG;