PACKAGE: APPS.ARP_DISTRIBUTIONS_PKG

Source

1 PACKAGE ARP_DISTRIBUTIONS_PKG AS
2 /*$Header: ARJIDSTS.pls 120.3 2002/12/17 23:13:32 anukumar ship $*/
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 
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,
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
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;