eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_BR_REMIT_BATCHES dependencies on AR_BATCHES

Line 13: p_batch_rec IN AR_BATCHES%ROWTYPE);

9:
10: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
11:
12: PROCEDURE validate_args_insert_remit(
13: p_batch_rec IN AR_BATCHES%ROWTYPE);
14:
15: PROCEDURE validate_args_update_remit(
16: p_batch_rec IN AR_BATCHES%ROWTYPE);
17:

Line 16: p_batch_rec IN AR_BATCHES%ROWTYPE);

12: PROCEDURE validate_args_insert_remit(
13: p_batch_rec IN AR_BATCHES%ROWTYPE);
14:
15: PROCEDURE validate_args_update_remit(
16: p_batch_rec IN AR_BATCHES%ROWTYPE);
17:
18: PROCEDURE validate_receipt_method(
19: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
20: p_batch_date IN AR_BATCHES.batch_date%TYPE);

Line 19: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

15: PROCEDURE validate_args_update_remit(
16: p_batch_rec IN AR_BATCHES%ROWTYPE);
17:
18: PROCEDURE validate_receipt_method(
19: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
20: p_batch_date IN AR_BATCHES.batch_date%TYPE);
21:
22: PROCEDURE validate_currency_code(
23: p_currency_code IN AR_BATCHES.currency_code%TYPE,

Line 20: p_batch_date IN AR_BATCHES.batch_date%TYPE);

16: p_batch_rec IN AR_BATCHES%ROWTYPE);
17:
18: PROCEDURE validate_receipt_method(
19: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
20: p_batch_date IN AR_BATCHES.batch_date%TYPE);
21:
22: PROCEDURE validate_currency_code(
23: p_currency_code IN AR_BATCHES.currency_code%TYPE,
24: p_batch_date IN AR_BATCHES.batch_date%TYPE);

Line 23: p_currency_code IN AR_BATCHES.currency_code%TYPE,

19: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
20: p_batch_date IN AR_BATCHES.batch_date%TYPE);
21:
22: PROCEDURE validate_currency_code(
23: p_currency_code IN AR_BATCHES.currency_code%TYPE,
24: p_batch_date IN AR_BATCHES.batch_date%TYPE);
25:
26: PROCEDURE validate_remit_bank_branch(
27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 24: p_batch_date IN AR_BATCHES.batch_date%TYPE);

20: p_batch_date IN AR_BATCHES.batch_date%TYPE);
21:
22: PROCEDURE validate_currency_code(
23: p_currency_code IN AR_BATCHES.currency_code%TYPE,
24: p_batch_date IN AR_BATCHES.batch_date%TYPE);
25:
26: PROCEDURE validate_remit_bank_branch(
27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
28: p_batch_date IN AR_BATCHES.batch_date%TYPE);

Line 27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

23: p_currency_code IN AR_BATCHES.currency_code%TYPE,
24: p_batch_date IN AR_BATCHES.batch_date%TYPE);
25:
26: PROCEDURE validate_remit_bank_branch(
27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
28: p_batch_date IN AR_BATCHES.batch_date%TYPE);
29:
30: PROCEDURE validate_remit_bank_account(
31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 28: p_batch_date IN AR_BATCHES.batch_date%TYPE);

24: p_batch_date IN AR_BATCHES.batch_date%TYPE);
25:
26: PROCEDURE validate_remit_bank_branch(
27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
28: p_batch_date IN AR_BATCHES.batch_date%TYPE);
29:
30: PROCEDURE validate_remit_bank_account(
31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
32: p_batch_date IN AR_BATCHES.batch_date%TYPE);

Line 31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

27: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
28: p_batch_date IN AR_BATCHES.batch_date%TYPE);
29:
30: PROCEDURE validate_remit_bank_account(
31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
32: p_batch_date IN AR_BATCHES.batch_date%TYPE);
33:
34: PROCEDURE validate_remit_method_code(
35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 32: p_batch_date IN AR_BATCHES.batch_date%TYPE);

28: p_batch_date IN AR_BATCHES.batch_date%TYPE);
29:
30: PROCEDURE validate_remit_bank_account(
31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
32: p_batch_date IN AR_BATCHES.batch_date%TYPE);
33:
34: PROCEDURE validate_remit_method_code(
35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
36: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE);

Line 35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

31: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
32: p_batch_date IN AR_BATCHES.batch_date%TYPE);
33:
34: PROCEDURE validate_remit_method_code(
35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
36: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE);
37:
38: PROCEDURE validate_auto_program(
39: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);

Line 36: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE);

32: p_batch_date IN AR_BATCHES.batch_date%TYPE);
33:
34: PROCEDURE validate_remit_method_code(
35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
36: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE);
37:
38: PROCEDURE validate_auto_program(
39: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
40:

Line 39: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);

35: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
36: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE);
37:
38: PROCEDURE validate_auto_program(
39: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
40:
41: /*------------------------ Public procedures ------------------------*/
42:
43:

Line 50: | remittance to insert the remittance batch row in the table AR_BATCHES |

46: | insert_remit |
47: | |
48: | DESCRIPTION |
49: | Procedure called during the process create bills receivable |
50: | remittance to insert the remittance batch row in the table AR_BATCHES |
51: | |
52: | SCOPE - PUBLIC |
53: | |
54: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 66: p_batch_date IN AR_BATCHES.batch_date%TYPE,

62: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
63: | |
64: +===========================================================================*/
65: PROCEDURE insert_remit(
66: p_batch_date IN AR_BATCHES.batch_date%TYPE,
67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 67: p_gl_date IN AR_BATCHES.gl_date%TYPE,

63: | |
64: +===========================================================================*/
65: PROCEDURE insert_remit(
66: p_batch_date IN AR_BATCHES.batch_date%TYPE,
67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 68: p_currency_code IN AR_BATCHES.currency_code%TYPE,

64: +===========================================================================*/
65: PROCEDURE insert_remit(
66: p_batch_date IN AR_BATCHES.batch_date%TYPE,
67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 69: p_comments IN AR_BATCHES.comments%TYPE,

65: PROCEDURE insert_remit(
66: p_batch_date IN AR_BATCHES.batch_date%TYPE,
67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

66: p_batch_date IN AR_BATCHES.batch_date%TYPE,
67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

67: p_gl_date IN AR_BATCHES.gl_date%TYPE,
68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

68: p_currency_code IN AR_BATCHES.currency_code%TYPE,
69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

69: p_comments IN AR_BATCHES.comments%TYPE,
70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

70: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

71: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

72: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

73: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

74: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

75: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

76: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 81: p_media_reference IN AR_BATCHES.media_reference%TYPE,

77: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

78: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

79: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

80: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

81: p_media_reference IN AR_BATCHES.media_reference%TYPE,
82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

82: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

83: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,

Line 88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

84: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,

Line 89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

85: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

Line 90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

86: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
94:

Line 91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,

87: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
94:
95:

Line 92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,

88: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
94:
95:
96: l_batch_rec AR_BATCHES%ROWTYPE;

Line 93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

89: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
90: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
91: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
94:
95:
96: l_batch_rec AR_BATCHES%ROWTYPE;
97: l_row_id varchar2(20) := NULL;

Line 96: l_batch_rec AR_BATCHES%ROWTYPE;

92: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
93: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
94:
95:
96: l_batch_rec AR_BATCHES%ROWTYPE;
97: l_row_id varchar2(20) := NULL;
98:
99:
100: BEGIN

Line 215: p_batch_rec IN AR_BATCHES%ROWTYPE) IS

211: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
212: | |
213: +===========================================================================*/
214: PROCEDURE validate_args_insert_remit(
215: p_batch_rec IN AR_BATCHES%ROWTYPE) IS
216:
217: l_row_id varchar2(20) := NULL;
218: l_field varchar2(30) := NULL;
219:

Line 323: p_currency_code IN AR_BATCHES.currency_code%TYPE,

319: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
320: | |
321: +===========================================================================*/
322: PROCEDURE validate_currency_code(
323: p_currency_code IN AR_BATCHES.currency_code%TYPE,
324: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
325:
326: NB number;
327:

Line 324: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS

320: | |
321: +===========================================================================*/
322: PROCEDURE validate_currency_code(
323: p_currency_code IN AR_BATCHES.currency_code%TYPE,
324: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
325:
326: NB number;
327:
328: BEGIN

Line 383: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

379: | defined, or the receipt_inherit_inv_num_flag has to be set to 'Y'. |
380: | |
381: +===========================================================================*/
382: PROCEDURE validate_receipt_method(
383: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
384: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
385:
386: CURSOR Receipt_method IS
387: SELECT NVL(MT.receipt_inherit_inv_num_flag,'N'), MT.name

Line 384: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS

380: | |
381: +===========================================================================*/
382: PROCEDURE validate_receipt_method(
383: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
384: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
385:
386: CURSOR Receipt_method IS
387: SELECT NVL(MT.receipt_inherit_inv_num_flag,'N'), MT.name
388: FROM AR_RECEIPT_METHODS MT,

Line 521: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

517: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
518: | |
519: +===========================================================================*/
520: PROCEDURE validate_remit_bank_branch(
521: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
522: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
523:
524: NB number;
525:

Line 522: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS

518: | |
519: +===========================================================================*/
520: PROCEDURE validate_remit_bank_branch(
521: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
522: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
523:
524: NB number;
525:
526: BEGIN

Line 578: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

574: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
575: | |
576: +===========================================================================*/
577: PROCEDURE validate_remit_bank_account(
578: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
579: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
580:
581: nb NUMBER;
582:

Line 579: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS

575: | |
576: +===========================================================================*/
577: PROCEDURE validate_remit_bank_account(
578: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
579: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
580:
581: nb NUMBER;
582:
583: CURSOR accounts (p_bank_acct_use_id NUMBER, p_date DATE) IS

Line 642: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

638: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
639: | |
640: +===========================================================================*/
641: PROCEDURE validate_remit_method_code(
642: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
643: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE) IS
644:
645:
646: BEGIN

Line 643: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE) IS

639: | |
640: +===========================================================================*/
641: PROCEDURE validate_remit_method_code(
642: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
643: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE) IS
644:
645:
646: BEGIN
647:

Line 694: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS

690: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
691: | |
692: +===========================================================================*/
693: PROCEDURE validate_auto_program(
694: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
695:
696: NB number;
697:
698: BEGIN

Line 738: | remittance to delete the remittance batch row in the table AR_BATCHES |

734: | delete_remit |
735: | |
736: | DESCRIPTION |
737: | Procedure called during the process delete bills receivable |
738: | remittance to delete the remittance batch row in the table AR_BATCHES |
739: | |
740: | SCOPE - PUBLIC |
741: | |
742: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 754: PROCEDURE delete_remit( p_batch_id IN ar_batches.batch_id%TYPE ) IS

750: | MODIFICATION HISTORY - Created as part of bug 9147689 |
751: | |
752: +===========================================================================*/
753:
754: PROCEDURE delete_remit( p_batch_id IN ar_batches.batch_id%TYPE ) IS
755: l_id NUMBER;
756: BEGIN
757: -- lock the records.
758: SELECT batch_id

Line 760: FROM ar_batches

756: BEGIN
757: -- lock the records.
758: SELECT batch_id
759: INTO l_id
760: FROM ar_batches
761: WHERE batch_id = p_batch_id
762: FOR UPDATE NOWAIT;
763:
764: ARP_CR_BATCHES_PKG.delete_p(p_batch_id);

Line 781: | remittance to update the remittance batch row in the table AR_BATCHES |

777: | update_remit |
778: | |
779: | DESCRIPTION |
780: | Procedure called during the process create bills receivable |
781: | remittance to update the remittance batch row in the table AR_BATCHES |
782: | |
783: | SCOPE - PUBLIC |
784: | |
785: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 804: p_batch_id IN AR_BATCHES.batch_id%TYPE,

800: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
801: x_return_status OUT NOCOPY VARCHAR2 ,
802: x_msg_count OUT NOCOPY NUMBER ,
803: x_msg_data OUT NOCOPY VARCHAR2 ,
804: p_batch_id IN AR_BATCHES.batch_id%TYPE,
805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

Line 805: p_status IN AR_BATCHES.status%TYPE,

801: x_return_status OUT NOCOPY VARCHAR2 ,
802: x_msg_count OUT NOCOPY NUMBER ,
803: x_msg_data OUT NOCOPY VARCHAR2 ,
804: p_batch_id IN AR_BATCHES.batch_id%TYPE,
805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,

Line 806: p_control_count IN AR_BATCHES.control_count%TYPE,

802: x_msg_count OUT NOCOPY NUMBER ,
803: x_msg_data OUT NOCOPY VARCHAR2 ,
804: p_batch_id IN AR_BATCHES.batch_id%TYPE,
805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 807: p_control_amount IN AR_BATCHES.control_amount%TYPE,

803: x_msg_data OUT NOCOPY VARCHAR2 ,
804: p_batch_id IN AR_BATCHES.batch_id%TYPE,
805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

Line 808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

804: p_batch_id IN AR_BATCHES.batch_id%TYPE,
805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 809: p_comments IN AR_BATCHES.comments%TYPE,

805: p_status IN AR_BATCHES.status%TYPE,
806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 810: p_media_reference IN AR_BATCHES.media_reference%TYPE,

806: p_control_count IN AR_BATCHES.control_count%TYPE,
807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

807: p_control_amount IN AR_BATCHES.control_amount%TYPE,
808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

808: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS

Line 813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

809: p_comments IN AR_BATCHES.comments%TYPE,
810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
817:

Line 814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

810: p_media_reference IN AR_BATCHES.media_reference%TYPE,
811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
817:
818: l_api_name CONSTANT varchar2(30) := 'update_remit';

Line 815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

811: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
817:
818: l_api_name CONSTANT varchar2(30) := 'update_remit';
819: l_api_version CONSTANT number := 1.0;

Line 816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS

812: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
813: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
814: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
815: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
816: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
817:
818: l_api_name CONSTANT varchar2(30) := 'update_remit';
819: l_api_version CONSTANT number := 1.0;
820:

Line 824: l_batch_rec AR_BATCHES%ROWTYPE;

820:
821: l_row_id varchar2(20) := NULL;
822: l_field varchar2(30);
823:
824: l_batch_rec AR_BATCHES%ROWTYPE;
825:
826: BEGIN
827:
828: IF PG_DEBUG in ('Y', 'C') THEN

Line 936: p_batch_rec IN AR_BATCHES%ROWTYPE) IS

932: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
933: | |
934: +===========================================================================*/
935: PROCEDURE validate_args_update_remit(
936: p_batch_rec IN AR_BATCHES%ROWTYPE) IS
937:
938: l_row_id varchar2(20) := NULL;
939: l_field varchar2(30) := NULL;
940:

Line 1014: | remittance to update the remittance batch row in the table AR_BATCHES |

1010: | cancel_remit |
1011: | |
1012: | DESCRIPTION |
1013: | Procedure called during the process create bills receivable |
1014: | remittance to update the remittance batch row in the table AR_BATCHES |
1015: | |
1016: | SCOPE - PUBLIC |
1017: | |
1018: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1030: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1026: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
1027: | |
1028: +===========================================================================*/
1029: PROCEDURE cancel_remit(
1030: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1031: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1032:
1033: l_batch_rec AR_BATCHES%ROWTYPE;
1034: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

Line 1031: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

1027: | |
1028: +===========================================================================*/
1029: PROCEDURE cancel_remit(
1030: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1031: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1032:
1033: l_batch_rec AR_BATCHES%ROWTYPE;
1034: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1035:

Line 1033: l_batch_rec AR_BATCHES%ROWTYPE;

1029: PROCEDURE cancel_remit(
1030: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1031: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1032:
1033: l_batch_rec AR_BATCHES%ROWTYPE;
1034: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1035:
1036: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1037:

Line 1106: | remittance to lock the remittance batch row in the table AR_BATCHES |

1102: | lock_remit |
1103: | |
1104: | DESCRIPTION |
1105: | Procedure called during the process create bills receivable |
1106: | remittance to lock the remittance batch row in the table AR_BATCHES |
1107: | |
1108: | SCOPE - PUBLIC |
1109: | |
1110: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1126: x_return_status OUT NOCOPY VARCHAR2 ,
1127: x_msg_count OUT NOCOPY NUMBER ,
1128: x_msg_data OUT NOCOPY VARCHAR2 ,
1129: p_rowid IN varchar2,
1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,

Line 1131: p_batch_name IN AR_BATCHES.name%TYPE,

1127: x_msg_count OUT NOCOPY NUMBER ,
1128: x_msg_data OUT NOCOPY VARCHAR2 ,
1129: p_rowid IN varchar2,
1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,

Line 1132: p_status IN AR_BATCHES.status%TYPE,

1128: x_msg_data OUT NOCOPY VARCHAR2 ,
1129: p_rowid IN varchar2,
1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,

Line 1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,

1129: p_rowid IN varchar2,
1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,

1130: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,

1131: p_batch_name IN AR_BATCHES.name%TYPE,
1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 1136: p_comments IN AR_BATCHES.comments%TYPE,

1132: p_status IN AR_BATCHES.status%TYPE,
1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

1133: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

1134: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

1135: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

1136: p_comments IN AR_BATCHES.comments%TYPE,
1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

1137: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

1138: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

1139: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

1140: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

1141: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

1142: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

1143: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,

1144: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

1145: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

1146: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

1147: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

1148: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

1149: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

1150: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS

Line 1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

1151: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1159:

Line 1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

1152: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1159:
1160: l_api_name CONSTANT varchar2(30) := 'lock_remit';

Line 1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

1153: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1159:
1160: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1161: l_api_version CONSTANT number := 1.0;

Line 1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS

1154: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1155: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1156: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1157: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1158: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1159:
1160: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1161: l_api_version CONSTANT number := 1.0;
1162:

Line 1163: l_batch_rec AR_BATCHES%ROWTYPE;

1159:
1160: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1161: l_api_version CONSTANT number := 1.0;
1162:
1163: l_batch_rec AR_BATCHES%ROWTYPE;
1164:
1165:
1166: BEGIN
1167: