3:
4: --
5: -- Public procedures/functions
6: --
7: PROCEDURE set_to_dummy( p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
10: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
11: --
5: -- Public procedures/functions
6: --
7: PROCEDURE set_to_dummy( p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
10: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
11: --
12: --
13: -- New update_p procedure
6: --
7: PROCEDURE set_to_dummy( p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
8: --
9: PROCEDURE insert_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
10: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
11: --
12: --
13: -- New update_p procedure
14: --
11: --
12: --
13: -- New update_p procedure
14: --
15: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
16: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
17: --
18: -- Old update_p procedure retianed for compatibiltiy sake
19: --
12: --
13: -- New update_p procedure
14: --
15: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
16: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
17: --
18: -- Old update_p procedure retianed for compatibiltiy sake
19: --
20: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE );
16: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
17: --
18: -- Old update_p procedure retianed for compatibiltiy sake
19: --
20: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE );
21: --
22: PROCEDURE delete_p(
23: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
24:
19: --
20: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE );
21: --
22: PROCEDURE delete_p(
23: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
24:
25: PROCEDURE delete_p_cr(
26: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE );
27: --
25: PROCEDURE delete_p_cr(
26: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE );
27: --
28: PROCEDURE lock_p(
29: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
30:
31: --
32: PROCEDURE lock_f_batch_id(
33: p_batch_id IN ar_batches.batch_id%TYPE);
37: p_batch_id IN ar_batches.batch_id%TYPE);
38:
39: --
40: PROCEDURE lock_fetch_p(
41: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
42:
43: --
44: PROCEDURE nowaitlock_fetch_p(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
41: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
42:
43: --
44: PROCEDURE nowaitlock_fetch_p(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
46:
47: --
48: PROCEDURE nowaitlock_p(
49: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
46:
47: --
48: PROCEDURE nowaitlock_p(
49: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
50:
51: --
52: PROCEDURE fetch_p(
53: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
49: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
50:
51: --
52: PROCEDURE fetch_p(
53: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
54: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
55:
56: PROCEDURE fetch_f_crid(
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
50:
51: --
52: PROCEDURE fetch_p(
53: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
54: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
55:
56: PROCEDURE fetch_f_crid(
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
58: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE);
54: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
55:
56: PROCEDURE fetch_f_crid(
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
58: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE);
59:
60: PROCEDURE fetch_f_cr_id(
61: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE);
62:
57: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
58: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE);
59:
60: PROCEDURE fetch_f_cr_id(
61: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE);
62:
63: PROCEDURE lock_f_cr_id(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE);
65:
68: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE);
69:
70: --
71: PROCEDURE lock_fetch_f_cr_id(
72: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
73:
74:
75: --
76: PROCEDURE nowaitlock_fetch_f_cr_id(
73:
74:
75: --
76: PROCEDURE nowaitlock_fetch_f_cr_id(
77: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
78:
79: PROCEDURE lock_hist_compare_p(
80: p_crh_rec IN ar_cash_receipt_history%ROWTYPE); /* Bug fix 2742388 */
81:
76: PROCEDURE nowaitlock_fetch_f_cr_id(
77: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE );
78:
79: PROCEDURE lock_hist_compare_p(
80: p_crh_rec IN ar_cash_receipt_history%ROWTYPE); /* Bug fix 2742388 */
81:
82: --
83: END ARP_CR_HISTORY_PKG;