3:
4: --
5: -- Public procedures/functions
6: --
7: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
10: p_trh_id OUT NOCOPY ar_transaction_history.transaction_history_id%TYPE );
11: --
5: -- Public procedures/functions
6: --
7: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
10: p_trh_id OUT NOCOPY ar_transaction_history.transaction_history_id%TYPE );
11: --
12: --
13: -- New update_p procedure
6: --
7: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
10: p_trh_id OUT NOCOPY ar_transaction_history.transaction_history_id%TYPE );
11: --
12: --
13: -- New update_p procedure
14: --
11: --
12: --
13: -- New update_p procedure
14: --
15: PROCEDURE update_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
16: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
17:
18: PROCEDURE delete_p(
19: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
12: --
13: -- New update_p procedure
14: --
15: PROCEDURE update_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
16: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
17:
18: PROCEDURE delete_p(
19: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
20:
15: PROCEDURE update_p( p_trh_rec IN ar_transaction_history%ROWTYPE,
16: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
17:
18: PROCEDURE delete_p(
19: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
20:
21: PROCEDURE delete_p(
22: p_trx_id IN ra_customer_trx.customer_trx_id%TYPE );
23: --
21: PROCEDURE delete_p(
22: p_trx_id IN ra_customer_trx.customer_trx_id%TYPE );
23: --
24: PROCEDURE lock_p(
25: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
26:
27: PROCEDURE lock_fetch_p(
28: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
29:
24: PROCEDURE lock_p(
25: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
26:
27: PROCEDURE lock_fetch_p(
28: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
29:
30: --
31: PROCEDURE nowaitlock_fetch_p(
32: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
28: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
29:
30: --
31: PROCEDURE nowaitlock_fetch_p(
32: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
33:
34: --
35: PROCEDURE nowaitlock_p(
36: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
32: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
33:
34: --
35: PROCEDURE nowaitlock_p(
36: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
37:
38: --
39: PROCEDURE fetch_p(
40: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE,
36: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE );
37:
38: --
39: PROCEDURE fetch_p(
40: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE,
41: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
42:
43: PROCEDURE fetch_f_trx_id(
44: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE);
37:
38: --
39: PROCEDURE fetch_p(
40: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE,
41: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
42:
43: PROCEDURE fetch_f_trx_id(
44: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE);
45:
40: p_trh_id IN ar_transaction_history.transaction_history_id%TYPE,
41: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE );
42:
43: PROCEDURE fetch_f_trx_id(
44: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE);
45:
46: PROCEDURE lock_f_trx_id(
47: p_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
48:
51: p_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
52:
53: --
54: PROCEDURE lock_fetch_f_trx_id(
55: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
56:
57:
58: --
59: PROCEDURE nowaitlock_fetch_f_trx_id(
56:
57:
58: --
59: PROCEDURE nowaitlock_fetch_f_trx_id(
60: p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE );
61:
62:
63: END ARP_TRANSACTION_HISTORY_PKG;