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_RW_BATCHES_CHECK_PKG dependencies on AR_BATCHES

Line 8: p_batch_name IN ar_batches.name%TYPE );

4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE validate_args_cu_batch_name(
7: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
8: p_batch_name IN ar_batches.name%TYPE );
9: --
10: PROCEDURE validate_args_cu_batch_name(
11: p_batch_source_name IN ar_batch_sources.name%TYPE,
12: p_batch_name IN ar_batches.name%TYPE );

Line 12: p_batch_name IN ar_batches.name%TYPE );

8: p_batch_name IN ar_batches.name%TYPE );
9: --
10: PROCEDURE validate_args_cu_batch_name(
11: p_batch_source_name IN ar_batch_sources.name%TYPE,
12: p_batch_name IN ar_batches.name%TYPE );
13: --
14: PROCEDURE validate_args_cu_media_ref(
15: p_media_ref IN ar_batches.media_reference%TYPE );
16: --

Line 15: p_media_ref IN ar_batches.media_reference%TYPE );

11: p_batch_source_name IN ar_batch_sources.name%TYPE,
12: p_batch_name IN ar_batches.name%TYPE );
13: --
14: PROCEDURE validate_args_cu_media_ref(
15: p_media_ref IN ar_batches.media_reference%TYPE );
16: --
17: PROCEDURE validate_args_update_manual(
18: p_row_id IN VARCHAR2,
19: p_batch_id IN ar_batches.batch_id%TYPE,

Line 19: p_batch_id IN ar_batches.batch_id%TYPE,

15: p_media_ref IN ar_batches.media_reference%TYPE );
16: --
17: PROCEDURE validate_args_update_manual(
18: p_row_id IN VARCHAR2,
19: p_batch_id IN ar_batches.batch_id%TYPE,
20: p_batch_date IN ar_batches.batch_date%TYPE );
21: --
22: PROCEDURE validate_args_update_remit(
23: p_row_id IN VARCHAR2,

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

16: --
17: PROCEDURE validate_args_update_manual(
18: p_row_id IN VARCHAR2,
19: p_batch_id IN ar_batches.batch_id%TYPE,
20: p_batch_date IN ar_batches.batch_date%TYPE );
21: --
22: PROCEDURE validate_args_update_remit(
23: p_row_id IN VARCHAR2,
24: p_batch_id IN ar_batches.batch_id%TYPE,

Line 24: p_batch_id IN ar_batches.batch_id%TYPE,

20: p_batch_date IN ar_batches.batch_date%TYPE );
21: --
22: PROCEDURE validate_args_update_remit(
23: p_row_id IN VARCHAR2,
24: p_batch_id IN ar_batches.batch_id%TYPE,
25: p_batch_date IN ar_batches.batch_date%TYPE );
26: --
27: PROCEDURE validate_args_update_auto(
28: p_row_id IN VARCHAR2,

Line 25: p_batch_date IN ar_batches.batch_date%TYPE );

21: --
22: PROCEDURE validate_args_update_remit(
23: p_row_id IN VARCHAR2,
24: p_batch_id IN ar_batches.batch_id%TYPE,
25: p_batch_date IN ar_batches.batch_date%TYPE );
26: --
27: PROCEDURE validate_args_update_auto(
28: p_row_id IN VARCHAR2,
29: p_batch_id IN ar_batches.batch_id%TYPE,

Line 29: p_batch_id IN ar_batches.batch_id%TYPE,

25: p_batch_date IN ar_batches.batch_date%TYPE );
26: --
27: PROCEDURE validate_args_update_auto(
28: p_row_id IN VARCHAR2,
29: p_batch_id IN ar_batches.batch_id%TYPE,
30: p_batch_date IN ar_batches.batch_date%TYPE );
31: --
32: /*===========================================================================+
33: | PROCEDURE |

Line 30: p_batch_date IN ar_batches.batch_date%TYPE );

26: --
27: PROCEDURE validate_args_update_auto(
28: p_row_id IN VARCHAR2,
29: p_batch_id IN ar_batches.batch_id%TYPE,
30: p_batch_date IN ar_batches.batch_date%TYPE );
31: --
32: /*===========================================================================+
33: | PROCEDURE |
34: | update_manual_batch - Updates a row in AR_BATCHES after checking for|

Line 34: | update_manual_batch - Updates a row in AR_BATCHES after checking for|

30: p_batch_date IN ar_batches.batch_date%TYPE );
31: --
32: /*===========================================================================+
33: | PROCEDURE |
34: | update_manual_batch - Updates a row in AR_BATCHES after checking for|
35: | uniqueness |
36: | |
37: | DESCRIPTION |
38: | This function updates a row in AR_BATCHES table after checking for |

Line 38: | This function updates a row in AR_BATCHES table after checking for |

34: | update_manual_batch - Updates a row in AR_BATCHES after checking for|
35: | uniqueness |
36: | |
37: | DESCRIPTION |
38: | This function updates a row in AR_BATCHES table after checking for |
39: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE |
40: | |
41: | SCOPE - PUBLIC |
42: | |

Line 67: p_batch_id IN ar_batches.batch_id%TYPE,

63: | Date and Batch Source to update list. |
64: +===========================================================================*/
65: PROCEDURE update_manual_batch(
66: p_row_id IN VARCHAR2,
67: p_batch_id IN ar_batches.batch_id%TYPE,
68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,

Line 68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,

64: +===========================================================================*/
65: PROCEDURE update_manual_batch(
66: p_row_id IN VARCHAR2,
67: p_batch_id IN ar_batches.batch_id%TYPE,
68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,

Line 69: p_batch_date IN ar_batches.batch_date%TYPE,

65: PROCEDURE update_manual_batch(
66: p_row_id IN VARCHAR2,
67: p_batch_id IN ar_batches.batch_id%TYPE,
68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,

Line 70: p_gl_date IN ar_batches.gl_date%TYPE,

66: p_row_id IN VARCHAR2,
67: p_batch_id IN ar_batches.batch_id%TYPE,
68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,

Line 71: p_deposit_date IN ar_batches.batch_date%TYPE,

67: p_batch_id IN ar_batches.batch_id%TYPE,
68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,

Line 72: p_currency_code IN ar_batches.currency_code%TYPE,

68: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 73: p_comments IN ar_batches.comments%TYPE,

69: p_batch_date IN ar_batches.batch_date%TYPE,
70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 74: p_control_amount IN ar_batches.control_amount%TYPE,

70: p_gl_date IN ar_batches.gl_date%TYPE,
71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

Line 75: p_control_count IN ar_batches.control_count%TYPE,

71: p_deposit_date IN ar_batches.batch_date%TYPE,
72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 76: p_exchange_date IN ar_batches.exchange_date%TYPE,

72: p_currency_code IN ar_batches.currency_code%TYPE,
73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

73: p_comments IN ar_batches.comments%TYPE,
74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id

Line 78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

74: p_control_amount IN ar_batches.control_amount%TYPE,
75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,

Line 79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

75: p_control_count IN ar_batches.control_count%TYPE,
76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id

Line 80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

76: p_exchange_date IN ar_batches.exchange_date%TYPE,
77: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 82: IN ar_batches.remit_bank_acct_use_id%type,

78: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
79: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,

Line 84: IN ar_batches.remittance_bank_branch_id%TYPE,

80: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 85: p_attribute_category IN ar_batches.attribute_category%TYPE,

81: p_remittance_bank_account_id
82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 86: p_attribute1 IN ar_batches.attribute1%TYPE,

82: IN ar_batches.remit_bank_acct_use_id%type,
83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 87: p_attribute2 IN ar_batches.attribute2%TYPE,

83: p_remittance_bank_branch_id
84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 88: p_attribute3 IN ar_batches.attribute3%TYPE,

84: IN ar_batches.remittance_bank_branch_id%TYPE,
85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 89: p_attribute4 IN ar_batches.attribute4%TYPE,

85: p_attribute_category IN ar_batches.attribute_category%TYPE,
86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 90: p_attribute5 IN ar_batches.attribute5%TYPE,

86: p_attribute1 IN ar_batches.attribute1%TYPE,
87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 91: p_attribute6 IN ar_batches.attribute6%TYPE,

87: p_attribute2 IN ar_batches.attribute2%TYPE,
88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 92: p_attribute7 IN ar_batches.attribute7%TYPE,

88: p_attribute3 IN ar_batches.attribute3%TYPE,
89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 93: p_attribute8 IN ar_batches.attribute8%TYPE,

89: p_attribute4 IN ar_batches.attribute4%TYPE,
90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 94: p_attribute9 IN ar_batches.attribute9%TYPE,

90: p_attribute5 IN ar_batches.attribute5%TYPE,
91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 95: p_attribute10 IN ar_batches.attribute10%TYPE,

91: p_attribute6 IN ar_batches.attribute6%TYPE,
92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 96: p_attribute11 IN ar_batches.attribute11%TYPE,

92: p_attribute7 IN ar_batches.attribute7%TYPE,
93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,
100: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 97: p_attribute12 IN ar_batches.attribute12%TYPE,

93: p_attribute8 IN ar_batches.attribute8%TYPE,
94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,
100: p_attribute15 IN ar_batches.attribute15%TYPE,
101: p_module_name IN VARCHAR2,

Line 98: p_attribute13 IN ar_batches.attribute13%TYPE,

94: p_attribute9 IN ar_batches.attribute9%TYPE,
95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,
100: p_attribute15 IN ar_batches.attribute15%TYPE,
101: p_module_name IN VARCHAR2,
102: p_module_version IN VARCHAR2 ) IS

Line 99: p_attribute14 IN ar_batches.attribute14%TYPE,

95: p_attribute10 IN ar_batches.attribute10%TYPE,
96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,
100: p_attribute15 IN ar_batches.attribute15%TYPE,
101: p_module_name IN VARCHAR2,
102: p_module_version IN VARCHAR2 ) IS
103: --

Line 100: p_attribute15 IN ar_batches.attribute15%TYPE,

96: p_attribute11 IN ar_batches.attribute11%TYPE,
97: p_attribute12 IN ar_batches.attribute12%TYPE,
98: p_attribute13 IN ar_batches.attribute13%TYPE,
99: p_attribute14 IN ar_batches.attribute14%TYPE,
100: p_attribute15 IN ar_batches.attribute15%TYPE,
101: p_module_name IN VARCHAR2,
102: p_module_version IN VARCHAR2 ) IS
103: --
104: l_batch_rec ar_batches%ROWTYPE;

Line 104: l_batch_rec ar_batches%ROWTYPE;

100: p_attribute15 IN ar_batches.attribute15%TYPE,
101: p_module_name IN VARCHAR2,
102: p_module_version IN VARCHAR2 ) IS
103: --
104: l_batch_rec ar_batches%ROWTYPE;
105: BEGIN
106: IF PG_DEBUG in ('Y', 'C') THEN
107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );
108: arp_util.debug( 'Row Id : '||p_row_id );

Line 182: | This function updates a row in AR_BATCHES table after checking for |

178: | PROCEDURE |
179: | update_remit_batch |
180: | |
181: | DESCRIPTION |
182: | This function updates a row in AR_BATCHES table after checking for |
183: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE. Used for |
184: | Remittance Batches only. |
185: | |
186: | SCOPE - PUBLIC |

Line 209: p_batch_id IN ar_batches.batch_id%TYPE,

205: | MODIFICATION HISTORY - Created by Caroline M Clyde (21 MAY 1997) |
206: +===========================================================================*/
207: PROCEDURE update_remit_batch(
208: p_row_id IN VARCHAR2,
209: p_batch_id IN ar_batches.batch_id%TYPE,
210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,

Line 210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,

206: +===========================================================================*/
207: PROCEDURE update_remit_batch(
208: p_row_id IN VARCHAR2,
209: p_batch_id IN ar_batches.batch_id%TYPE,
210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,

Line 211: p_batch_date IN ar_batches.batch_date%TYPE,

207: PROCEDURE update_remit_batch(
208: p_row_id IN VARCHAR2,
209: p_batch_id IN ar_batches.batch_id%TYPE,
210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,

Line 212: p_gl_date IN ar_batches.gl_date%TYPE,

208: p_row_id IN VARCHAR2,
209: p_batch_id IN ar_batches.batch_id%TYPE,
210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,

Line 213: p_deposit_date IN ar_batches.batch_date%TYPE,

209: p_batch_id IN ar_batches.batch_id%TYPE,
210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,

Line 214: p_currency_code IN ar_batches.currency_code%TYPE,

210: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 215: p_comments IN ar_batches.comments%TYPE,

211: p_batch_date IN ar_batches.batch_date%TYPE,
212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 216: p_control_amount IN ar_batches.control_amount%TYPE,

212: p_gl_date IN ar_batches.gl_date%TYPE,
213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

Line 217: p_control_count IN ar_batches.control_count%TYPE,

213: p_deposit_date IN ar_batches.batch_date%TYPE,
214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 218: p_exchange_date IN ar_batches.exchange_date%TYPE,

214: p_currency_code IN ar_batches.currency_code%TYPE,
215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

215: p_comments IN ar_batches.comments%TYPE,
216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id

Line 220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

216: p_control_amount IN ar_batches.control_amount%TYPE,
217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,

Line 221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

217: p_control_count IN ar_batches.control_count%TYPE,
218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id

Line 222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

218: p_exchange_date IN ar_batches.exchange_date%TYPE,
219: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 224: IN ar_batches.remit_bank_acct_use_id%type,

220: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
221: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,

Line 226: IN ar_batches.remittance_bank_branch_id%TYPE,

222: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

Line 227: p_media_reference IN ar_batches.media_reference%TYPE,

223: p_remittance_bank_account_id
224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,

Line 228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,

224: IN ar_batches.remit_bank_acct_use_id%type,
225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,

Line 229: p_request_id IN ar_batches.request_id%TYPE,

225: p_remittance_bank_branch_id
226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

226: IN ar_batches.remittance_bank_branch_id%TYPE,
227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 231: p_attribute_category IN ar_batches.attribute_category%TYPE,

227: p_media_reference IN ar_batches.media_reference%TYPE,
228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 232: p_attribute1 IN ar_batches.attribute1%TYPE,

228: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 233: p_attribute2 IN ar_batches.attribute2%TYPE,

229: p_request_id IN ar_batches.request_id%TYPE,
230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 234: p_attribute3 IN ar_batches.attribute3%TYPE,

230: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 235: p_attribute4 IN ar_batches.attribute4%TYPE,

231: p_attribute_category IN ar_batches.attribute_category%TYPE,
232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 236: p_attribute5 IN ar_batches.attribute5%TYPE,

232: p_attribute1 IN ar_batches.attribute1%TYPE,
233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 237: p_attribute6 IN ar_batches.attribute6%TYPE,

233: p_attribute2 IN ar_batches.attribute2%TYPE,
234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 238: p_attribute7 IN ar_batches.attribute7%TYPE,

234: p_attribute3 IN ar_batches.attribute3%TYPE,
235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 239: p_attribute8 IN ar_batches.attribute8%TYPE,

235: p_attribute4 IN ar_batches.attribute4%TYPE,
236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 240: p_attribute9 IN ar_batches.attribute9%TYPE,

236: p_attribute5 IN ar_batches.attribute5%TYPE,
237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 241: p_attribute10 IN ar_batches.attribute10%TYPE,

237: p_attribute6 IN ar_batches.attribute6%TYPE,
238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 242: p_attribute11 IN ar_batches.attribute11%TYPE,

238: p_attribute7 IN ar_batches.attribute7%TYPE,
239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,
246: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 243: p_attribute12 IN ar_batches.attribute12%TYPE,

239: p_attribute8 IN ar_batches.attribute8%TYPE,
240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,
246: p_attribute15 IN ar_batches.attribute15%TYPE,
247: p_module_name IN VARCHAR2,

Line 244: p_attribute13 IN ar_batches.attribute13%TYPE,

240: p_attribute9 IN ar_batches.attribute9%TYPE,
241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,
246: p_attribute15 IN ar_batches.attribute15%TYPE,
247: p_module_name IN VARCHAR2,
248: p_module_version IN VARCHAR2 ) IS

Line 245: p_attribute14 IN ar_batches.attribute14%TYPE,

241: p_attribute10 IN ar_batches.attribute10%TYPE,
242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,
246: p_attribute15 IN ar_batches.attribute15%TYPE,
247: p_module_name IN VARCHAR2,
248: p_module_version IN VARCHAR2 ) IS
249:

Line 246: p_attribute15 IN ar_batches.attribute15%TYPE,

242: p_attribute11 IN ar_batches.attribute11%TYPE,
243: p_attribute12 IN ar_batches.attribute12%TYPE,
244: p_attribute13 IN ar_batches.attribute13%TYPE,
245: p_attribute14 IN ar_batches.attribute14%TYPE,
246: p_attribute15 IN ar_batches.attribute15%TYPE,
247: p_module_name IN VARCHAR2,
248: p_module_version IN VARCHAR2 ) IS
249:
250: l_batch_rec ar_batches%ROWTYPE;

Line 250: l_batch_rec ar_batches%ROWTYPE;

246: p_attribute15 IN ar_batches.attribute15%TYPE,
247: p_module_name IN VARCHAR2,
248: p_module_version IN VARCHAR2 ) IS
249:
250: l_batch_rec ar_batches%ROWTYPE;
251: BEGIN
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );
254: arp_util.debug( 'Row Id : '||p_row_id );

Line 312: -- Call update table handler to update the record in AR_BATCHES.

308: l_batch_rec.batch_date );
309: END IF;
310:
311:
312: -- Call update table handler to update the record in AR_BATCHES.
313:
314: arp_cr_batches_pkg.update_p( l_batch_rec, l_batch_rec.batch_id );
315:
316:

Line 335: | This function updates a row in AR_BATCHES table after checking for |

331: | PROCEDURE |
332: | update_auto_batch |
333: | |
334: | DESCRIPTION |
335: | This function updates a row in AR_BATCHES table after checking for |
336: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE. Used for |
337: | Automatic Batches only. |
338: | |
339: | SCOPE - PUBLIC |

Line 362: p_batch_id IN ar_batches.batch_id%TYPE,

358: | MODIFICATION HISTORY - Created by Caroline M Clyde (21 MAY 1997) |
359: +===========================================================================*/
360: PROCEDURE update_auto_batch(
361: p_row_id IN VARCHAR2,
362: p_batch_id IN ar_batches.batch_id%TYPE,
363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,

Line 363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,

359: +===========================================================================*/
360: PROCEDURE update_auto_batch(
361: p_row_id IN VARCHAR2,
362: p_batch_id IN ar_batches.batch_id%TYPE,
363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,

Line 364: p_batch_date IN ar_batches.batch_date%TYPE,

360: PROCEDURE update_auto_batch(
361: p_row_id IN VARCHAR2,
362: p_batch_id IN ar_batches.batch_id%TYPE,
363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,

Line 365: p_gl_date IN ar_batches.gl_date%TYPE,

361: p_row_id IN VARCHAR2,
362: p_batch_id IN ar_batches.batch_id%TYPE,
363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,

Line 366: p_deposit_date IN ar_batches.batch_date%TYPE,

362: p_batch_id IN ar_batches.batch_id%TYPE,
363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,

Line 367: p_currency_code IN ar_batches.currency_code%TYPE,

363: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 368: p_comments IN ar_batches.comments%TYPE,

364: p_batch_date IN ar_batches.batch_date%TYPE,
365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 369: p_control_amount IN ar_batches.control_amount%TYPE,

365: p_gl_date IN ar_batches.gl_date%TYPE,
366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

Line 370: p_control_count IN ar_batches.control_count%TYPE,

366: p_deposit_date IN ar_batches.batch_date%TYPE,
367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 371: p_exchange_date IN ar_batches.exchange_date%TYPE,

367: p_currency_code IN ar_batches.currency_code%TYPE,
368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

368: p_comments IN ar_batches.comments%TYPE,
369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id

Line 373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

369: p_control_amount IN ar_batches.control_amount%TYPE,
370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,

Line 374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

370: p_control_count IN ar_batches.control_count%TYPE,
371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id

Line 375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

371: p_exchange_date IN ar_batches.exchange_date%TYPE,
372: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 377: IN ar_batches.remit_bank_acct_use_id%type,

373: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
374: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,

Line 379: IN ar_batches.remittance_bank_branch_id%TYPE,

375: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

Line 380: p_media_reference IN ar_batches.media_reference%TYPE,

376: p_remittance_bank_account_id
377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,

Line 381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,

377: IN ar_batches.remit_bank_acct_use_id%type,
378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,

Line 382: p_request_id IN ar_batches.request_id%TYPE,

378: p_remittance_bank_branch_id
379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

379: IN ar_batches.remittance_bank_branch_id%TYPE,
380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 384: p_attribute_category IN ar_batches.attribute_category%TYPE,

380: p_media_reference IN ar_batches.media_reference%TYPE,
381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 385: p_attribute1 IN ar_batches.attribute1%TYPE,

381: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 386: p_attribute2 IN ar_batches.attribute2%TYPE,

382: p_request_id IN ar_batches.request_id%TYPE,
383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 387: p_attribute3 IN ar_batches.attribute3%TYPE,

383: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 388: p_attribute4 IN ar_batches.attribute4%TYPE,

384: p_attribute_category IN ar_batches.attribute_category%TYPE,
385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 389: p_attribute5 IN ar_batches.attribute5%TYPE,

385: p_attribute1 IN ar_batches.attribute1%TYPE,
386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 390: p_attribute6 IN ar_batches.attribute6%TYPE,

386: p_attribute2 IN ar_batches.attribute2%TYPE,
387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 391: p_attribute7 IN ar_batches.attribute7%TYPE,

387: p_attribute3 IN ar_batches.attribute3%TYPE,
388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 392: p_attribute8 IN ar_batches.attribute8%TYPE,

388: p_attribute4 IN ar_batches.attribute4%TYPE,
389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 393: p_attribute9 IN ar_batches.attribute9%TYPE,

389: p_attribute5 IN ar_batches.attribute5%TYPE,
390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 394: p_attribute10 IN ar_batches.attribute10%TYPE,

390: p_attribute6 IN ar_batches.attribute6%TYPE,
391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 395: p_attribute11 IN ar_batches.attribute11%TYPE,

391: p_attribute7 IN ar_batches.attribute7%TYPE,
392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,
399: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 396: p_attribute12 IN ar_batches.attribute12%TYPE,

392: p_attribute8 IN ar_batches.attribute8%TYPE,
393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,
399: p_attribute15 IN ar_batches.attribute15%TYPE,
400: p_module_name IN VARCHAR2,

Line 397: p_attribute13 IN ar_batches.attribute13%TYPE,

393: p_attribute9 IN ar_batches.attribute9%TYPE,
394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,
399: p_attribute15 IN ar_batches.attribute15%TYPE,
400: p_module_name IN VARCHAR2,
401: p_module_version IN VARCHAR2 ) IS

Line 398: p_attribute14 IN ar_batches.attribute14%TYPE,

394: p_attribute10 IN ar_batches.attribute10%TYPE,
395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,
399: p_attribute15 IN ar_batches.attribute15%TYPE,
400: p_module_name IN VARCHAR2,
401: p_module_version IN VARCHAR2 ) IS
402:

Line 399: p_attribute15 IN ar_batches.attribute15%TYPE,

395: p_attribute11 IN ar_batches.attribute11%TYPE,
396: p_attribute12 IN ar_batches.attribute12%TYPE,
397: p_attribute13 IN ar_batches.attribute13%TYPE,
398: p_attribute14 IN ar_batches.attribute14%TYPE,
399: p_attribute15 IN ar_batches.attribute15%TYPE,
400: p_module_name IN VARCHAR2,
401: p_module_version IN VARCHAR2 ) IS
402:
403: l_batch_rec ar_batches%ROWTYPE;

Line 403: l_batch_rec ar_batches%ROWTYPE;

399: p_attribute15 IN ar_batches.attribute15%TYPE,
400: p_module_name IN VARCHAR2,
401: p_module_version IN VARCHAR2 ) IS
402:
403: l_batch_rec ar_batches%ROWTYPE;
404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );
407: arp_util.debug( 'Row Id : '||p_row_id );

Line 465: -- Call update table handler to update the record in AR_BATCHES.

461: l_batch_rec.batch_date );
462: END IF;
463:
464:
465: -- Call update table handler to update the record in AR_BATCHES.
466:
467: arp_cr_batches_pkg.update_p( l_batch_rec, l_batch_rec.batch_id );
468:
469:

Line 506: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE) IS

502: | |
503: | MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
504: | |
505: +===========================================================================*/
506: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE) IS
507: l_icr_count NUMBER := 0;
508: l_icr_amount NUMBER := 0;
509: --
510: l_batch_status VARCHAR2( 30 );

Line 511: l_batch_rec ar_batches%ROWTYPE;

507: l_icr_count NUMBER := 0;
508: l_icr_amount NUMBER := 0;
509: --
510: l_batch_status VARCHAR2( 30 );
511: l_batch_rec ar_batches%ROWTYPE;
512: BEGIN
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
515: arp_util.debug( 'Batch ID : '||p_batch_id );

Line 539: ar_batches b

535: )),0),
536: NVL(SUM( icr.amount ), 0 )
537: INTO l_icr_count, l_icr_amount
538: FROM ar_interim_cash_receipts icr,
539: ar_batches b
540: WHERE b.batch_id = p_batch_id
541: AND b.batch_id = icr.batch_id(+);
542: --
543: -- select if the batch has the required count and that all the

Line 616: ar_batches b

612: )
613: INTO l_batch_status
614: FROM ar_cash_receipt_history crh,
615: ar_cash_receipts cr,
616: ar_batches b
617: WHERE b.batch_id = p_batch_id
618: AND crh.batch_id(+) = b.batch_id
619: AND crh.first_posted_record_flag(+) = 'Y'
620: AND cr.cash_receipt_id(+) = crh.cash_receipt_id

Line 665: p_batch_id IN ar_batches.batch_id%TYPE,

661: | |
662: +===========================================================================*/
663: PROCEDURE validate_args_update_manual(
664: p_row_id IN VARCHAR2,
665: p_batch_id IN ar_batches.batch_id%TYPE,
666: p_batch_date IN ar_batches.batch_date%TYPE ) IS
667:
668: BEGIN
669: IF PG_DEBUG in ('Y', 'C') THEN

Line 666: p_batch_date IN ar_batches.batch_date%TYPE ) IS

662: +===========================================================================*/
663: PROCEDURE validate_args_update_manual(
664: p_row_id IN VARCHAR2,
665: p_batch_id IN ar_batches.batch_id%TYPE,
666: p_batch_date IN ar_batches.batch_date%TYPE ) IS
667:
668: BEGIN
669: IF PG_DEBUG in ('Y', 'C') THEN
670: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()+' );

Line 717: p_batch_id IN ar_batches.batch_id%TYPE,

713: | |
714: +===========================================================================*/
715: PROCEDURE validate_args_update_remit(
716: p_row_id IN VARCHAR2,
717: p_batch_id IN ar_batches.batch_id%TYPE,
718: p_batch_date IN ar_batches.batch_date%TYPE ) IS
719:
720: BEGIN
721: IF PG_DEBUG in ('Y', 'C') THEN

Line 718: p_batch_date IN ar_batches.batch_date%TYPE ) IS

714: +===========================================================================*/
715: PROCEDURE validate_args_update_remit(
716: p_row_id IN VARCHAR2,
717: p_batch_id IN ar_batches.batch_id%TYPE,
718: p_batch_date IN ar_batches.batch_date%TYPE ) IS
719:
720: BEGIN
721: IF PG_DEBUG in ('Y', 'C') THEN
722: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()+' );

Line 769: p_batch_id IN ar_batches.batch_id%TYPE,

765: | |
766: +===========================================================================*/
767: PROCEDURE validate_args_update_auto(
768: p_row_id IN VARCHAR2,
769: p_batch_id IN ar_batches.batch_id%TYPE,
770: p_batch_date IN ar_batches.batch_date%TYPE ) IS
771:
772: BEGIN
773: IF PG_DEBUG in ('Y', 'C') THEN

Line 770: p_batch_date IN ar_batches.batch_date%TYPE ) IS

766: +===========================================================================*/
767: PROCEDURE validate_args_update_auto(
768: p_row_id IN VARCHAR2,
769: p_batch_id IN ar_batches.batch_id%TYPE,
770: p_batch_date IN ar_batches.batch_date%TYPE ) IS
771:
772: BEGIN
773: IF PG_DEBUG in ('Y', 'C') THEN
774: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()+' );

Line 827: p_batch_name IN ar_batches.name%TYPE,

823: +===========================================================================*/
824: PROCEDURE check_unique_batch_name(
825: p_row_id IN VARCHAR2,
826: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
827: p_batch_name IN ar_batches.name%TYPE,
828: p_module_name IN VARCHAR2,
829: p_module_version IN VARCHAR2 ) IS
830: l_count NUMBER := 0;
831: BEGIN

Line 845: FROM AR_BATCHES bat

841: END IF;
842: --
843: SELECT COUNT(*)
844: INTO l_count
845: FROM AR_BATCHES bat
846: WHERE bat.batch_source_id = p_batch_source_id
847: AND bat.name = p_batch_name
848: AND ( p_row_id IS NULL
849: OR bat.rowid <> p_row_id );

Line 894: p_batch_name IN ar_batches.name%TYPE ) IS

890: | |
891: +===========================================================================*/
892: PROCEDURE validate_args_cu_batch_name(
893: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
894: p_batch_name IN ar_batches.name%TYPE ) IS
895: BEGIN
896: IF PG_DEBUG in ('Y', 'C') THEN
897: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
898: END IF;

Line 949: p_batch_name IN ar_batches.name%TYPE,

945: +===========================================================================*/
946: PROCEDURE check_unique_batch_name(
947: p_row_id IN VARCHAR2,
948: p_batch_source_name IN ar_batch_sources.name%TYPE,
949: p_batch_name IN ar_batches.name%TYPE,
950: p_module_name IN VARCHAR2,
951: p_module_version IN VARCHAR2 ) IS
952: l_count NUMBER := 0;
953: BEGIN

Line 968: AR_BATCHES bat

964: --
965: SELECT COUNT(*)
966: INTO l_count
967: FROM AR_BATCH_SOURCES bs,
968: AR_BATCHES bat
969: WHERE bat.batch_source_id = bs.batch_source_id
970: AND bs.name = p_batch_source_name
971: AND bat.name = p_batch_name
972: AND ( p_row_id IS NULL

Line 1018: p_batch_name IN ar_batches.name%TYPE ) IS

1014: | |
1015: +===========================================================================*/
1016: PROCEDURE validate_args_cu_batch_name(
1017: p_batch_source_name IN ar_batch_sources.name%TYPE,
1018: p_batch_name IN ar_batches.name%TYPE ) IS
1019: BEGIN
1020: IF PG_DEBUG in ('Y', 'C') THEN
1021: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
1022: END IF;

Line 1047: | This function Check uniqueness of Media reference in AR_BATCHES table |

1043: | PROCEDURE |
1044: | check_unique_media_ref - Check uniqueness of a Media reference |
1045: | |
1046: | DESCRIPTION |
1047: | This function Check uniqueness of Media reference in AR_BATCHES table |
1048: | |
1049: | SCOPE - PUBLIC |
1050: | |
1051: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1069: p_media_ref IN ar_batches.media_reference%TYPE,

1065: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
1066: +===========================================================================*/
1067: PROCEDURE check_unique_media_ref(
1068: p_row_id IN VARCHAR2,
1069: p_media_ref IN ar_batches.media_reference%TYPE,
1070: p_module_name IN VARCHAR2,
1071: p_module_version IN VARCHAR2 ) IS
1072: l_count NUMBER := 0;
1073: BEGIN

Line 1086: FROM AR_BATCHES bat

1082: END IF;
1083: --
1084: SELECT COUNT(*)
1085: INTO l_count
1086: FROM AR_BATCHES bat
1087: WHERE bat.media_reference = p_media_ref
1088: AND ( p_row_id IS NULL
1089: OR bat.rowid <> p_row_id );
1090: IF ( l_count <> 0 ) THEN

Line 1132: p_media_ref IN ar_batches.media_reference%TYPE ) IS

1128: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
1129: | |
1130: +===========================================================================*/
1131: PROCEDURE validate_args_cu_media_ref(
1132: p_media_ref IN ar_batches.media_reference%TYPE ) IS
1133: BEGIN
1134: IF PG_DEBUG in ('Y', 'C') THEN
1135: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()+' );
1136: END IF;

Line 1185: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,

1181: | |
1182: | MODIFICATION HISTORY - 11/22/95 - Created by Ganesh Vaidee |
1183: | 18-JAN-96 scleung Added the p_set_of_books_id argument. |
1184: +===========================================================================*/
1185: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1186: p_set_of_books_id IN
1187: ar_batches.set_of_books_id%TYPE,
1188: p_transmission_id IN
1189: ar_batches.transmission_id%TYPE,

Line 1187: ar_batches.set_of_books_id%TYPE,

1183: | 18-JAN-96 scleung Added the p_set_of_books_id argument. |
1184: +===========================================================================*/
1185: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1186: p_set_of_books_id IN
1187: ar_batches.set_of_books_id%TYPE,
1188: p_transmission_id IN
1189: ar_batches.transmission_id%TYPE,
1190: p_batch_applied_status OUT NOCOPY
1191: ar_batches.batch_applied_status%TYPE,

Line 1189: ar_batches.transmission_id%TYPE,

1185: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1186: p_set_of_books_id IN
1187: ar_batches.set_of_books_id%TYPE,
1188: p_transmission_id IN
1189: ar_batches.transmission_id%TYPE,
1190: p_batch_applied_status OUT NOCOPY
1191: ar_batches.batch_applied_status%TYPE,
1192: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1193: p_module_name IN VARCHAR2,

Line 1191: ar_batches.batch_applied_status%TYPE,

1187: ar_batches.set_of_books_id%TYPE,
1188: p_transmission_id IN
1189: ar_batches.transmission_id%TYPE,
1190: p_batch_applied_status OUT NOCOPY
1191: ar_batches.batch_applied_status%TYPE,
1192: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1193: p_module_name IN VARCHAR2,
1194: p_module_version IN VARCHAR2 ) IS
1195: --

Line 1192: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,

1188: p_transmission_id IN
1189: ar_batches.transmission_id%TYPE,
1190: p_batch_applied_status OUT NOCOPY
1191: ar_batches.batch_applied_status%TYPE,
1192: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1193: p_module_name IN VARCHAR2,
1194: p_module_version IN VARCHAR2 ) IS
1195: --
1196: l_request_id ar_batches.request_id%TYPE;

Line 1196: l_request_id ar_batches.request_id%TYPE;

1192: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1193: p_module_name IN VARCHAR2,
1194: p_module_version IN VARCHAR2 ) IS
1195: --
1196: l_request_id ar_batches.request_id%TYPE;
1197: l_org_id number;
1198: BEGIN
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()+');

Line 1291: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,

1287: | postquick cash in receipt batches window. |
1288: | 07-JAN-03 K Dhaliwal Bug 2707190 added Claim Amount and Count |
1289: | to get_quick_amount_totals |
1290: +===========================================================================*/
1291: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
1292: p_actual_amount_total OUT NOCOPY NUMBER,
1293: p_actual_count_total OUT NOCOPY NUMBER,
1294: p_unidentified_amount_total OUT NOCOPY NUMBER,
1295: p_unidentified_count_total OUT NOCOPY NUMBER,

Line 1520: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,

1516: --
1517: END get_quick_amount_totals;
1518: --
1519:
1520: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
1521: p_actual_amount_total OUT NOCOPY NUMBER,
1522: p_actual_count_total OUT NOCOPY NUMBER,
1523: p_unidentified_amount_total OUT NOCOPY NUMBER,
1524: p_unidentified_count_total OUT NOCOPY NUMBER,