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,

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,
507: p_called_from IN VARCHAR2 DEFAULT NULL) IS
508: l_icr_count NUMBER := 0;
509: l_icr_amount NUMBER := 0;
510: --

Line 512: l_batch_rec ar_batches%ROWTYPE;

508: l_icr_count NUMBER := 0;
509: l_icr_amount NUMBER := 0;
510: --
511: l_batch_status VARCHAR2( 30 );
512: l_batch_rec ar_batches%ROWTYPE;
513: --Bug7194951
514: l_exists VARCHAR2(1);
515: l_bat_id ar_batches.batch_id%TYPE;
516: l_type ar_batches.type%TYPE;

Line 515: l_bat_id ar_batches.batch_id%TYPE;

511: l_batch_status VARCHAR2( 30 );
512: l_batch_rec ar_batches%ROWTYPE;
513: --Bug7194951
514: l_exists VARCHAR2(1);
515: l_bat_id ar_batches.batch_id%TYPE;
516: l_type ar_batches.type%TYPE;
517: BEGIN
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );

Line 516: l_type ar_batches.type%TYPE;

512: l_batch_rec ar_batches%ROWTYPE;
513: --Bug7194951
514: l_exists VARCHAR2(1);
515: l_bat_id ar_batches.batch_id%TYPE;
516: l_type ar_batches.type%TYPE;
517: BEGIN
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
520: arp_util.debug( 'Batch ID : '||p_batch_id );

Line 544: ar_batches b

540: )),0),
541: NVL(SUM( icr.amount ), 0 )
542: INTO l_icr_count, l_icr_amount
543: FROM ar_interim_cash_receipts icr,
544: ar_batches b
545: WHERE b.batch_id = p_batch_id
546: AND b.batch_id = icr.batch_id(+);
547: --
548: -- select if the batch has the required count and that all the

Line 622: ar_batches b

618: )
619: INTO l_batch_status
620: FROM ar_cash_receipt_history crh,
621: ar_cash_receipts cr,
622: ar_batches b
623: WHERE b.batch_id = p_batch_id
624: AND crh.batch_id(+) = b.batch_id
625: AND crh.first_posted_record_flag(+) = 'Y'
626: AND cr.cash_receipt_id(+) = crh.cash_receipt_id

Line 651: FROM ar_batches

647: l_exists := NULL;
648: BEGIN
649: SELECT 'Y',TYPE
650: INTO l_exists,l_type
651: FROM ar_batches
652: WHERE batch_id = p_batch_id;
653: EXCEPTION
654: WHEN NO_DATA_FOUND THEN
655: NULL;

Line 669: FROM ar_batches

665: IF nvl(l_exists,'N') = 'Y' THEN
666: /*
667: SELECT batch_id
668: INTO l_bat_id
669: FROM ar_batches
670: WHERE batch_id = p_batch_id
671: FOR UPDATE OF STATUS;
672: */
673: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: Before calling update for batch');

Line 713: p_batch_id IN ar_batches.batch_id%TYPE,

709: | |
710: +===========================================================================*/
711: PROCEDURE validate_args_update_manual(
712: p_row_id IN VARCHAR2,
713: p_batch_id IN ar_batches.batch_id%TYPE,
714: p_batch_date IN ar_batches.batch_date%TYPE ) IS
715:
716: BEGIN
717: IF PG_DEBUG in ('Y', 'C') THEN

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

710: +===========================================================================*/
711: PROCEDURE validate_args_update_manual(
712: p_row_id IN VARCHAR2,
713: p_batch_id IN ar_batches.batch_id%TYPE,
714: p_batch_date IN ar_batches.batch_date%TYPE ) IS
715:
716: BEGIN
717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()+' );

Line 765: p_batch_id IN ar_batches.batch_id%TYPE,

761: | |
762: +===========================================================================*/
763: PROCEDURE validate_args_update_remit(
764: p_row_id IN VARCHAR2,
765: p_batch_id IN ar_batches.batch_id%TYPE,
766: p_batch_date IN ar_batches.batch_date%TYPE ) IS
767:
768: BEGIN
769: IF PG_DEBUG in ('Y', 'C') THEN

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

762: +===========================================================================*/
763: PROCEDURE validate_args_update_remit(
764: p_row_id IN VARCHAR2,
765: p_batch_id IN ar_batches.batch_id%TYPE,
766: p_batch_date IN ar_batches.batch_date%TYPE ) IS
767:
768: BEGIN
769: IF PG_DEBUG in ('Y', 'C') THEN
770: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()+' );

Line 817: p_batch_id IN ar_batches.batch_id%TYPE,

813: | |
814: +===========================================================================*/
815: PROCEDURE validate_args_update_auto(
816: p_row_id IN VARCHAR2,
817: p_batch_id IN ar_batches.batch_id%TYPE,
818: p_batch_date IN ar_batches.batch_date%TYPE ) IS
819:
820: BEGIN
821: IF PG_DEBUG in ('Y', 'C') THEN

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

814: +===========================================================================*/
815: PROCEDURE validate_args_update_auto(
816: p_row_id IN VARCHAR2,
817: p_batch_id IN ar_batches.batch_id%TYPE,
818: p_batch_date IN ar_batches.batch_date%TYPE ) IS
819:
820: BEGIN
821: IF PG_DEBUG in ('Y', 'C') THEN
822: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()+' );

Line 875: p_batch_name IN ar_batches.name%TYPE,

871: +===========================================================================*/
872: PROCEDURE check_unique_batch_name(
873: p_row_id IN VARCHAR2,
874: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
875: p_batch_name IN ar_batches.name%TYPE,
876: p_module_name IN VARCHAR2,
877: p_module_version IN VARCHAR2 ) IS
878: l_count NUMBER := 0;
879: BEGIN

Line 893: FROM AR_BATCHES bat

889: END IF;
890: --
891: SELECT COUNT(*)
892: INTO l_count
893: FROM AR_BATCHES bat
894: WHERE bat.batch_source_id = p_batch_source_id
895: AND bat.name = p_batch_name
896: AND ( p_row_id IS NULL
897: OR bat.rowid <> p_row_id );

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

938: | |
939: +===========================================================================*/
940: PROCEDURE validate_args_cu_batch_name(
941: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
942: p_batch_name IN ar_batches.name%TYPE ) IS
943: BEGIN
944: IF PG_DEBUG in ('Y', 'C') THEN
945: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
946: END IF;

Line 997: p_batch_name IN ar_batches.name%TYPE,

993: +===========================================================================*/
994: PROCEDURE check_unique_batch_name(
995: p_row_id IN VARCHAR2,
996: p_batch_source_name IN ar_batch_sources.name%TYPE,
997: p_batch_name IN ar_batches.name%TYPE,
998: p_module_name IN VARCHAR2,
999: p_module_version IN VARCHAR2 ) IS
1000: l_count NUMBER := 0;
1001: BEGIN

Line 1016: AR_BATCHES bat

1012: --
1013: SELECT COUNT(*)
1014: INTO l_count
1015: FROM AR_BATCH_SOURCES bs,
1016: AR_BATCHES bat
1017: WHERE bat.batch_source_id = bs.batch_source_id
1018: AND bs.name = p_batch_source_name
1019: AND bat.name = p_batch_name
1020: AND ( p_row_id IS NULL

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

1062: | |
1063: +===========================================================================*/
1064: PROCEDURE validate_args_cu_batch_name(
1065: p_batch_source_name IN ar_batch_sources.name%TYPE,
1066: p_batch_name IN ar_batches.name%TYPE ) IS
1067: BEGIN
1068: IF PG_DEBUG in ('Y', 'C') THEN
1069: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
1070: END IF;

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

1091: | PROCEDURE |
1092: | check_unique_media_ref - Check uniqueness of a Media reference |
1093: | |
1094: | DESCRIPTION |
1095: | This function Check uniqueness of Media reference in AR_BATCHES table |
1096: | |
1097: | SCOPE - PUBLIC |
1098: | |
1099: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1117: p_media_ref IN ar_batches.media_reference%TYPE,

1113: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
1114: +===========================================================================*/
1115: PROCEDURE check_unique_media_ref(
1116: p_row_id IN VARCHAR2,
1117: p_media_ref IN ar_batches.media_reference%TYPE,
1118: p_module_name IN VARCHAR2,
1119: p_module_version IN VARCHAR2 ) IS
1120: l_count NUMBER := 0;
1121: BEGIN

Line 1134: FROM AR_BATCHES bat

1130: END IF;
1131: --
1132: SELECT COUNT(*)
1133: INTO l_count
1134: FROM AR_BATCHES bat
1135: WHERE bat.media_reference = p_media_ref
1136: AND ( p_row_id IS NULL
1137: OR bat.rowid <> p_row_id );
1138: IF ( l_count <> 0 ) THEN

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

1176: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
1177: | |
1178: +===========================================================================*/
1179: PROCEDURE validate_args_cu_media_ref(
1180: p_media_ref IN ar_batches.media_reference%TYPE ) IS
1181: BEGIN
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()+' );
1184: END IF;

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

1230: | MODIFICATION HISTORY - 11/22/95 - Created by Ganesh Vaidee |
1231: | 18-JAN-96 scleung Added the p_set_of_books_id argument. |
1232: | 16-FEB-10 aghoraka Added the p_app_unearn_disc as argument. |
1233: +===========================================================================*/
1234: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1235: p_set_of_books_id IN
1236: ar_batches.set_of_books_id%TYPE,
1237: p_transmission_id IN
1238: ar_batches.transmission_id%TYPE,

Line 1236: ar_batches.set_of_books_id%TYPE,

1232: | 16-FEB-10 aghoraka Added the p_app_unearn_disc as argument. |
1233: +===========================================================================*/
1234: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1235: p_set_of_books_id IN
1236: ar_batches.set_of_books_id%TYPE,
1237: p_transmission_id IN
1238: ar_batches.transmission_id%TYPE,
1239: p_app_unearn_disc IN
1240: VARCHAR2 DEFAULT 'N',

Line 1238: ar_batches.transmission_id%TYPE,

1234: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
1235: p_set_of_books_id IN
1236: ar_batches.set_of_books_id%TYPE,
1237: p_transmission_id IN
1238: ar_batches.transmission_id%TYPE,
1239: p_app_unearn_disc IN
1240: VARCHAR2 DEFAULT 'N',
1241: p_batch_applied_status OUT NOCOPY
1242: ar_batches.batch_applied_status%TYPE,

Line 1242: ar_batches.batch_applied_status%TYPE,

1238: ar_batches.transmission_id%TYPE,
1239: p_app_unearn_disc IN
1240: VARCHAR2 DEFAULT 'N',
1241: p_batch_applied_status OUT NOCOPY
1242: ar_batches.batch_applied_status%TYPE,
1243: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1244: p_module_name IN VARCHAR2,
1245: p_module_version IN VARCHAR2 ) IS
1246: --

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

1239: p_app_unearn_disc IN
1240: VARCHAR2 DEFAULT 'N',
1241: p_batch_applied_status OUT NOCOPY
1242: ar_batches.batch_applied_status%TYPE,
1243: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1244: p_module_name IN VARCHAR2,
1245: p_module_version IN VARCHAR2 ) IS
1246: --
1247: l_request_id ar_batches.request_id%TYPE;

Line 1247: l_request_id ar_batches.request_id%TYPE;

1243: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
1244: p_module_name IN VARCHAR2,
1245: p_module_version IN VARCHAR2 ) IS
1246: --
1247: l_request_id ar_batches.request_id%TYPE;
1248: l_org_id number;
1249: BEGIN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()+');

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

1339: | postquick cash in receipt batches window. |
1340: | 07-JAN-03 K Dhaliwal Bug 2707190 added Claim Amount and Count |
1341: | to get_quick_amount_totals |
1342: +===========================================================================*/
1343: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
1344: p_actual_amount_total OUT NOCOPY NUMBER,
1345: p_actual_count_total OUT NOCOPY NUMBER,
1346: p_unidentified_amount_total OUT NOCOPY NUMBER,
1347: p_unidentified_count_total OUT NOCOPY NUMBER,

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

1568: --
1569: END get_quick_amount_totals;
1570: --
1571:
1572: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
1573: p_actual_amount_total OUT NOCOPY NUMBER,
1574: p_actual_count_total OUT NOCOPY NUMBER,
1575: p_unidentified_amount_total OUT NOCOPY NUMBER,
1576: p_unidentified_count_total OUT NOCOPY NUMBER,