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 739: | remittance to update the remittance batch row in the table AR_BATCHES |

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

Line 762: p_batch_id IN AR_BATCHES.batch_id%TYPE,

758: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
759: x_return_status OUT NOCOPY VARCHAR2 ,
760: x_msg_count OUT NOCOPY NUMBER ,
761: x_msg_data OUT NOCOPY VARCHAR2 ,
762: p_batch_id IN AR_BATCHES.batch_id%TYPE,
763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

Line 763: p_status IN AR_BATCHES.status%TYPE,

759: x_return_status OUT NOCOPY VARCHAR2 ,
760: x_msg_count OUT NOCOPY NUMBER ,
761: x_msg_data OUT NOCOPY VARCHAR2 ,
762: p_batch_id IN AR_BATCHES.batch_id%TYPE,
763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,

Line 764: p_control_count IN AR_BATCHES.control_count%TYPE,

760: x_msg_count OUT NOCOPY NUMBER ,
761: x_msg_data OUT NOCOPY VARCHAR2 ,
762: p_batch_id IN AR_BATCHES.batch_id%TYPE,
763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 765: p_control_amount IN AR_BATCHES.control_amount%TYPE,

761: x_msg_data OUT NOCOPY VARCHAR2 ,
762: p_batch_id IN AR_BATCHES.batch_id%TYPE,
763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

Line 766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

762: p_batch_id IN AR_BATCHES.batch_id%TYPE,
763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 767: p_comments IN AR_BATCHES.comments%TYPE,

763: p_status IN AR_BATCHES.status%TYPE,
764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 768: p_media_reference IN AR_BATCHES.media_reference%TYPE,

764: p_control_count IN AR_BATCHES.control_count%TYPE,
765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

765: p_control_amount IN AR_BATCHES.control_amount%TYPE,
766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

766: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
774: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS

Line 771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

767: p_comments IN AR_BATCHES.comments%TYPE,
768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
774: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
775:

Line 772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

768: p_media_reference IN AR_BATCHES.media_reference%TYPE,
769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
774: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
775:
776: l_api_name CONSTANT varchar2(30) := 'update_remit';

Line 773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

769: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
774: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
775:
776: l_api_name CONSTANT varchar2(30) := 'update_remit';
777: l_api_version CONSTANT number := 1.0;

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

770: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
771: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
772: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
773: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
774: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
775:
776: l_api_name CONSTANT varchar2(30) := 'update_remit';
777: l_api_version CONSTANT number := 1.0;
778:

Line 782: l_batch_rec AR_BATCHES%ROWTYPE;

778:
779: l_row_id varchar2(20) := NULL;
780: l_field varchar2(30);
781:
782: l_batch_rec AR_BATCHES%ROWTYPE;
783:
784: BEGIN
785:
786: IF PG_DEBUG in ('Y', 'C') THEN

Line 894: p_batch_rec IN AR_BATCHES%ROWTYPE) IS

890: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
891: | |
892: +===========================================================================*/
893: PROCEDURE validate_args_update_remit(
894: p_batch_rec IN AR_BATCHES%ROWTYPE) IS
895:
896: l_row_id varchar2(20) := NULL;
897: l_field varchar2(30) := NULL;
898:

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

968: | cancel_remit |
969: | |
970: | DESCRIPTION |
971: | Procedure called during the process create bills receivable |
972: | remittance to update the remittance batch row in the table AR_BATCHES |
973: | |
974: | SCOPE - PUBLIC |
975: | |
976: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 988: p_batch_id IN AR_BATCHES.batch_id%TYPE,

984: | MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
985: | |
986: +===========================================================================*/
987: PROCEDURE cancel_remit(
988: p_batch_id IN AR_BATCHES.batch_id%TYPE,
989: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
990:
991: l_batch_rec AR_BATCHES%ROWTYPE;
992: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

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

985: | |
986: +===========================================================================*/
987: PROCEDURE cancel_remit(
988: p_batch_id IN AR_BATCHES.batch_id%TYPE,
989: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
990:
991: l_batch_rec AR_BATCHES%ROWTYPE;
992: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
993:

Line 991: l_batch_rec AR_BATCHES%ROWTYPE;

987: PROCEDURE cancel_remit(
988: p_batch_id IN AR_BATCHES.batch_id%TYPE,
989: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
990:
991: l_batch_rec AR_BATCHES%ROWTYPE;
992: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
993:
994: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
995:

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

1060: | lock_remit |
1061: | |
1062: | DESCRIPTION |
1063: | Procedure called during the process create bills receivable |
1064: | remittance to lock the remittance batch row in the table AR_BATCHES |
1065: | |
1066: | SCOPE - PUBLIC |
1067: | |
1068: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1084: x_return_status OUT NOCOPY VARCHAR2 ,
1085: x_msg_count OUT NOCOPY NUMBER ,
1086: x_msg_data OUT NOCOPY VARCHAR2 ,
1087: p_rowid IN varchar2,
1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,

Line 1089: p_batch_name IN AR_BATCHES.name%TYPE,

1085: x_msg_count OUT NOCOPY NUMBER ,
1086: x_msg_data OUT NOCOPY VARCHAR2 ,
1087: p_rowid IN varchar2,
1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,

Line 1090: p_status IN AR_BATCHES.status%TYPE,

1086: x_msg_data OUT NOCOPY VARCHAR2 ,
1087: p_rowid IN varchar2,
1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,

Line 1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,

1087: p_rowid IN varchar2,
1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,

1088: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,

1089: p_batch_name IN AR_BATCHES.name%TYPE,
1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 1094: p_comments IN AR_BATCHES.comments%TYPE,

1090: p_status IN AR_BATCHES.status%TYPE,
1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

1091: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

1092: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

1093: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

1094: p_comments IN AR_BATCHES.comments%TYPE,
1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

1095: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

1096: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

1097: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

1098: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

1099: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

1100: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

1101: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,

1102: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

1103: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

1104: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

1105: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

1106: p_media_reference IN AR_BATCHES.media_reference%TYPE,
1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

1107: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

1108: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1116: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS

Line 1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

1109: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1116: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1117:

Line 1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

1110: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1116: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1117:
1118: l_api_name CONSTANT varchar2(30) := 'lock_remit';

Line 1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

1111: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1116: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1117:
1118: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1119: l_api_version CONSTANT number := 1.0;

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

1112: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
1113: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
1114: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
1115: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
1116: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE) IS
1117:
1118: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1119: l_api_version CONSTANT number := 1.0;
1120:

Line 1121: l_batch_rec AR_BATCHES%ROWTYPE;

1117:
1118: l_api_name CONSTANT varchar2(30) := 'lock_remit';
1119: l_api_version CONSTANT number := 1.0;
1120:
1121: l_batch_rec AR_BATCHES%ROWTYPE;
1122:
1123:
1124: BEGIN
1125: