1: PACKAGE ARP_CR_ICR_LINES_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARRIICLS.pls 115.6 2002/12/17 23:14:54 anukumar ship $*/
3: PROCEDURE set_to_dummy( p_icr_lines_rec OUT NOCOPY
4: ar_interim_cash_receipt_lines%rowtype);
5: --
6: PROCEDURE insert_p(
7: p_row_id OUT NOCOPY VARCHAR2,
8: p_cr_line_id OUT NOCOPY
5: --
6: PROCEDURE insert_p(
7: p_row_id OUT NOCOPY VARCHAR2,
8: p_cr_line_id OUT NOCOPY
9: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
10: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE );
11: PROCEDURE insert_p(
12: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
13: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
6: PROCEDURE insert_p(
7: p_row_id OUT NOCOPY VARCHAR2,
8: p_cr_line_id OUT NOCOPY
9: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
10: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE );
11: PROCEDURE insert_p(
12: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
13: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_icr_line_id OUT NOCOPY
8: p_cr_line_id OUT NOCOPY
9: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
10: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE );
11: PROCEDURE insert_p(
12: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
13: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_icr_line_id OUT NOCOPY
15: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
16: --
11: PROCEDURE insert_p(
12: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
13: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_icr_line_id OUT NOCOPY
15: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
16: --
17: PROCEDURE update_p(
18: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
19: p_cash_receipt_line_id IN
14: p_icr_line_id OUT NOCOPY
15: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
16: --
17: PROCEDURE update_p(
18: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
19: p_cash_receipt_line_id IN
20: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
21: p_batch_id IN
22: ar_interim_cash_receipt_lines.batch_id%TYPE,
16: --
17: PROCEDURE update_p(
18: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
19: p_cash_receipt_line_id IN
20: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
21: p_batch_id IN
22: ar_interim_cash_receipt_lines.batch_id%TYPE,
23: p_cash_receipt_id IN
24: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE
18: p_icr_lines_rec IN ar_interim_cash_receipt_lines%ROWTYPE,
19: p_cash_receipt_line_id IN
20: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
21: p_batch_id IN
22: ar_interim_cash_receipt_lines.batch_id%TYPE,
23: p_cash_receipt_id IN
24: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE
25: );
26: --
20: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
21: p_batch_id IN
22: ar_interim_cash_receipt_lines.batch_id%TYPE,
23: p_cash_receipt_id IN
24: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE
25: );
26: --
27: PROCEDURE delete_p(
28: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
26: --
27: PROCEDURE delete_p(
28: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
29: p_icr_line_id IN
30: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
31: PROCEDURE delete_fk(
32: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );
33: --
34: PROCEDURE lock_p( p_icr_line_id IN
31: PROCEDURE delete_fk(
32: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );
33: --
34: PROCEDURE lock_p( p_icr_line_id IN
35: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
36: --
37: PROCEDURE nowaitlock_p( p_icr_line_id IN
38: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
39: --
34: PROCEDURE lock_p( p_icr_line_id IN
35: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
36: --
37: PROCEDURE nowaitlock_p( p_icr_line_id IN
38: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
39: --
40: PROCEDURE fetch_p(
41: p_icr_line_id IN
42: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
38: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
39: --
40: PROCEDURE fetch_p(
41: p_icr_line_id IN
42: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
43: p_icr_lines_rec OUT NOCOPY ar_interim_cash_receipt_lines%ROWTYPE );
44: --
45: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
46: ar_interim_cash_receipt_lines%ROWTYPE );
39: --
40: PROCEDURE fetch_p(
41: p_icr_line_id IN
42: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
43: p_icr_lines_rec OUT NOCOPY ar_interim_cash_receipt_lines%ROWTYPE );
44: --
45: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
46: ar_interim_cash_receipt_lines%ROWTYPE );
47: --
42: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
43: p_icr_lines_rec OUT NOCOPY ar_interim_cash_receipt_lines%ROWTYPE );
44: --
45: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
46: ar_interim_cash_receipt_lines%ROWTYPE );
47: --
48: PROCEDURE nowaitlock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
49: ar_interim_cash_receipt_lines%ROWTYPE );
50:
45: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
46: ar_interim_cash_receipt_lines%ROWTYPE );
47: --
48: PROCEDURE nowaitlock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
49: ar_interim_cash_receipt_lines%ROWTYPE );
50:
51: END ARP_CR_ICR_LINES_PKG;
52: --