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

Line 43: | This function inserts a row into AR_BATCHES table |

39: | PROCEDURE |
40: | insert_p |
41: | |
42: | DESCRIPTION |
43: | This function inserts a row into AR_BATCHES table |
44: | |
45: | SCOPE - PUBLIC |
46: | |
47: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 52: | p_bat_id - Batch Id of inserted AR_BATCHES row |

48: | |
49: | ARGUMENTS : IN: |
50: | p_bat_rec - Batches Record structure |
51: | OUT: |
52: | p_bat_id - Batch Id of inserted AR_BATCHES row |
53: | |
54: | RETURNS : NONE |
55: | |
56: | NOTES - Overloaded procedure |

Line 63: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,

59: | |
60: +===========================================================================*/
61: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
62:
63: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
64: p_row_id OUT NOCOPY VARCHAR2,
65: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
66: l_bat_id ar_batches.batch_id%TYPE;
67: l_row_id VARCHAR2( 20 );

Line 65: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS

61: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
62:
63: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
64: p_row_id OUT NOCOPY VARCHAR2,
65: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
66: l_bat_id ar_batches.batch_id%TYPE;
67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN

Line 66: l_bat_id ar_batches.batch_id%TYPE;

62:
63: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
64: p_row_id OUT NOCOPY VARCHAR2,
65: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
66: l_bat_id ar_batches.batch_id%TYPE;
67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );

Line 77: FROM ar_batches

73: ARP_CR_BATCHES_PKG.insert_p( p_bat_rec, l_bat_id );
74: --
75: SELECT rowid
76: INTO l_row_id
77: FROM ar_batches
78: WHERE batch_id = l_bat_id;
79: --
80: p_bat_id := l_bat_id;
81: p_row_id := l_row_id;

Line 99: | This function inserts a row into AR_BATCHES table |

95: | PROCEDURE |
96: | insert_p |
97: | |
98: | DESCRIPTION |
99: | This function inserts a row into AR_BATCHES table |
100: | |
101: | SCOPE - PUBLIC |
102: | |
103: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 108: | p_bat_id - Batch Id of inserted AR_BATCHES row |

104: | |
105: | ARGUMENTS : IN: |
106: | p_bat_rec - Batches Record structure |
107: | OUT: |
108: | p_bat_id - Batch Id of inserted AR_BATCHES row |
109: | |
110: | RETURNS : NONE |
111: | |
112: | NOTES - Overloaded procedure |

Line 125: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,

121: | purged_children_flag |
122: | into the table handlers. |
123: | |
124: +===========================================================================*/
125: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
127: l_bat_id ar_batches.batch_id%TYPE;
128:
129: BEGIN

Line 126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS

122: | into the table handlers. |
123: | |
124: +===========================================================================*/
125: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
127: l_bat_id ar_batches.batch_id%TYPE;
128:
129: BEGIN
130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );

Line 127: l_bat_id ar_batches.batch_id%TYPE;

123: | |
124: +===========================================================================*/
125: PROCEDURE insert_p( p_bat_rec IN ar_batches%ROWTYPE,
126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
127: l_bat_id ar_batches.batch_id%TYPE;
128:
129: BEGIN
130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );
131: --

Line 132: SELECT ar_batches_s.nextval

128:
129: BEGIN
130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );
131: --
132: SELECT ar_batches_s.nextval
133: INTO l_bat_id
134: FROM dual;
135: --
136: INSERT INTO ar_batches (

Line 136: INSERT INTO ar_batches (

132: SELECT ar_batches_s.nextval
133: INTO l_bat_id
134: FROM dual;
135: --
136: INSERT INTO ar_batches (
137: batch_id,
138: batch_applied_status,
139: batch_date,
140: batch_source_id,

Line 268: -- p_table_name => 'AR_BATCHES',

264: +----------------------------------*/
265: --{BUG4301323
266: -- ar_mrc_engine.maintain_mrc_data(
267: -- p_event_mode => 'INSERT',
268: -- p_table_name => 'AR_BATCHES',
269: -- p_mode => 'SINGLE',
270: -- p_key_value => l_bat_id);
271: --}
272: --

Line 287: 'update ar_batches

283: BEGIN
284: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()+');
285: --
286: update_text :=
287: 'update ar_batches
288: SET batch_applied_status =
289: decode(:batch_applied_status,
290: :ar_text_dummy, batch_applied_status,
291: :batch_applied_status),

Line 511: p_bat_rec IN ar_batches%rowtype)

507: --
508: --
509: --
510: PROCEDURE bind_bat_variables(p_update_cursor IN integer,
511: p_bat_rec IN ar_batches%rowtype)
512: IS
513: --
514: BEGIN
515: --

Line 732: p_bat_rec IN ar_batches%ROWTYPE)

728: --
729: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
730: p_where_clause IN varchar2,
731: p_where1 IN number,
732: p_bat_rec IN ar_batches%ROWTYPE)
733: IS
734: --
735: l_count number;
736: l_update_statement varchar2(20000);

Line 835: -- p_table_name => 'AR_BATCHES',

831: -- arp_standard.debug('batch array('||to_char(I) || ') = ' || to_char(ar_batch_array(I)));
832:
833: -- ar_mrc_engine.maintain_mrc_data(
834: -- p_event_mode => 'UPDATE',
835: -- p_table_name => 'AR_BATCHES',
836: -- p_mode => 'SINGLE',
837: -- p_key_value => ar_batch_array(I));
838: -- END LOOP;
839: --}

Line 857: PROCEDURE set_to_dummy( p_bat_rec OUT NOCOPY ar_batches%rowtype)

853: END;
854: --
855: --
856: --
857: PROCEDURE set_to_dummy( p_bat_rec OUT NOCOPY ar_batches%rowtype)
858: IS
859: --
860: BEGIN
861: --

Line 927: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE,

923: --
924: --
925: --
926: --
927: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE,
928: p_batch_id IN
929: ar_batches.batch_id%TYPE) IS
930: --
931: BEGIN

Line 929: ar_batches.batch_id%TYPE) IS

925: --
926: --
927: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE,
928: p_batch_id IN
929: ar_batches.batch_id%TYPE) IS
930: --
931: BEGIN
932: --
933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');

Line 956: | This function updates a row into AR_BATCHES table |

952: | PROCEDURE |
953: | update_p |
954: | |
955: | DESCRIPTION |
956: | This function updates a row into AR_BATCHES table |
957: | |
958: | SCOPE - PUBLIC |
959: | |
960: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 972: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE ) IS

968: | |
969: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
970: | |
971: +===========================================================================*/
972: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE ) IS
973: BEGIN
974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );
975: --
976: update_p( p_bat_rec, p_bat_rec.batch_id );

Line 990: | This function deletes a row into AR_BATCHES table |

986: | PROCEDURE |
987: | delete_p |
988: | |
989: | DESCRIPTION |
990: | This function deletes a row into AR_BATCHES table |
991: | |
992: | SCOPE - PUBLIC |
993: | |
994: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 997: | p_bat_id - Batch id to delete a row from AR_BATCHES |

993: | |
994: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
995: | |
996: | ARGUMENTS : IN: |
997: | p_bat_id - Batch id to delete a row from AR_BATCHES |
998: | |
999: | RETURNS : NONE |
1000: | |
1001: | NOTES |

Line 1007: p_bat_id IN ar_batches.batch_id%TYPE ) IS

1003: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1004: | |
1005: +===========================================================================*/
1006: PROCEDURE delete_p(
1007: p_bat_id IN ar_batches.batch_id%TYPE ) IS
1008: BEGIN
1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );
1010: --
1011: DELETE FROM ar_batches

Line 1011: DELETE FROM ar_batches

1007: p_bat_id IN ar_batches.batch_id%TYPE ) IS
1008: BEGIN
1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );
1010: --
1011: DELETE FROM ar_batches
1012: WHERE batch_id = p_bat_id;
1013:
1014: /*---------------------------------+
1015: | Calling central MRC library |

Line 1021: -- p_table_name => 'AR_BATCHES',

1017: +---------------------------------*/
1018: --{BUG4301323
1019: -- ar_mrc_engine.maintain_mrc_data(
1020: -- p_event_mode => 'DELETE',
1021: -- p_table_name => 'AR_BATCHES',
1022: -- p_mode => 'SINGLE',
1023: -- p_key_value => p_bat_id);
1024: --}
1025: --

Line 1038: | This function locks a row in AR_BATCHES table |

1034: | PROCEDURE |
1035: | lock_p |
1036: | |
1037: | DESCRIPTION |
1038: | This function locks a row in AR_BATCHES table |
1039: | |
1040: | SCOPE - PUBLIC |
1041: | |
1042: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,

1051: | |
1052: +===========================================================================*/
1053: PROCEDURE lock_p(
1054: p_row_id VARCHAR2,
1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,
1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,

Line 1056: p_batch_id ar_batches.batch_id%TYPE,

1052: +===========================================================================*/
1053: PROCEDURE lock_p(
1054: p_row_id VARCHAR2,
1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,
1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,

Line 1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,

1053: PROCEDURE lock_p(
1054: p_row_id VARCHAR2,
1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,
1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,

Line 1058: p_batch_date ar_batches.batch_date%TYPE,

1054: p_row_id VARCHAR2,
1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,
1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,

Line 1059: p_batch_source_id ar_batches.batch_source_id%TYPE,

1055: p_set_of_books_id ar_batches.set_of_books_id%TYPE,
1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,

Line 1060: p_comments ar_batches.comments%TYPE,

1056: p_batch_id ar_batches.batch_id%TYPE,
1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,

Line 1061: p_control_amount ar_batches.control_amount%TYPE,

1057: p_batch_applied_status ar_batches.batch_applied_status%TYPE,
1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,

Line 1062: p_control_count ar_batches.control_count%TYPE,

1058: p_batch_date ar_batches.batch_date%TYPE,
1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,

Line 1063: p_exchange_date ar_batches.exchange_date%TYPE,

1059: p_batch_source_id ar_batches.batch_source_id%TYPE,
1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,

Line 1064: p_exchange_rate ar_batches.exchange_rate%TYPE,

1060: p_comments ar_batches.comments%TYPE,
1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,

Line 1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,

1061: p_control_amount ar_batches.control_amount%TYPE,
1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,

Line 1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,

1062: p_control_count ar_batches.control_count%TYPE,
1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,

Line 1067: p_media_reference ar_batches.media_reference%TYPE,

1063: p_exchange_date ar_batches.exchange_date%TYPE,
1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,

Line 1068: p_operation_request_id ar_batches.operation_request_id%TYPE,

1064: p_exchange_rate ar_batches.exchange_rate%TYPE,
1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,

Line 1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,

1065: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE,
1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,

Line 1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,

1066: p_lockbox_batch_name ar_batches.lockbox_batch_name%TYPE,
1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,

Line 1071: p_remit_method_code ar_batches.remit_method_code%TYPE,

1067: p_media_reference ar_batches.media_reference%TYPE,
1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,

Line 1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,

1068: p_operation_request_id ar_batches.operation_request_id%TYPE,
1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,

Line 1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,

1069: p_receipt_class_id ar_batches.receipt_class_id%TYPE,
1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,

Line 1074: p_attribute_category ar_batches.attribute_category%TYPE,

1070: p_receipt_method_id ar_batches.receipt_method_id%TYPE,
1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,

Line 1075: p_attribute1 ar_batches.attribute1%TYPE,

1071: p_remit_method_code ar_batches.remit_method_code%TYPE,
1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,

Line 1076: p_attribute2 ar_batches.attribute2%TYPE,

1072: p_remittance_bank_account_id ar_batches.remit_bank_acct_use_id%type,
1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,

Line 1077: p_attribute3 ar_batches.attribute3%TYPE,

1073: p_remittance_bank_branch_id ar_batches.remittance_bank_branch_id%TYPE,
1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,

Line 1078: p_attribute4 ar_batches.attribute4%TYPE,

1074: p_attribute_category ar_batches.attribute_category%TYPE,
1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,

Line 1079: p_attribute5 ar_batches.attribute5%TYPE,

1075: p_attribute1 ar_batches.attribute1%TYPE,
1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,

Line 1080: p_attribute6 ar_batches.attribute6%TYPE,

1076: p_attribute2 ar_batches.attribute2%TYPE,
1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,

Line 1081: p_attribute7 ar_batches.attribute7%TYPE,

1077: p_attribute3 ar_batches.attribute3%TYPE,
1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,

Line 1082: p_attribute8 ar_batches.attribute8%TYPE,

1078: p_attribute4 ar_batches.attribute4%TYPE,
1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,

Line 1083: p_attribute9 ar_batches.attribute9%TYPE,

1079: p_attribute5 ar_batches.attribute5%TYPE,
1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,

Line 1084: p_attribute10 ar_batches.attribute10%TYPE,

1080: p_attribute6 ar_batches.attribute6%TYPE,
1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,

Line 1085: p_attribute11 ar_batches.attribute11%TYPE,

1081: p_attribute7 ar_batches.attribute7%TYPE,
1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,

Line 1086: p_attribute12 ar_batches.attribute12%TYPE,

1082: p_attribute8 ar_batches.attribute8%TYPE,
1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,

Line 1087: p_attribute13 ar_batches.attribute13%TYPE,

1083: p_attribute9 ar_batches.attribute9%TYPE,
1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,

Line 1088: p_attribute14 ar_batches.attribute14%TYPE,

1084: p_attribute10 ar_batches.attribute10%TYPE,
1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS

Line 1089: p_attribute15 ar_batches.attribute15%TYPE,

1085: p_attribute11 ar_batches.attribute11%TYPE,
1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS
1093: CURSOR C IS

Line 1090: p_request_id ar_batches.request_id%TYPE,

1086: p_attribute12 ar_batches.attribute12%TYPE,
1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS
1093: CURSOR C IS
1094: SELECT *

Line 1091: p_transmission_id ar_batches.transmission_id%TYPE,

1087: p_attribute13 ar_batches.attribute13%TYPE,
1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS
1093: CURSOR C IS
1094: SELECT *
1095: FROM ar_batches

Line 1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS

1088: p_attribute14 ar_batches.attribute14%TYPE,
1089: p_attribute15 ar_batches.attribute15%TYPE,
1090: p_request_id ar_batches.request_id%TYPE,
1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS
1093: CURSOR C IS
1094: SELECT *
1095: FROM ar_batches
1096: WHERE rowid = p_row_id

Line 1095: FROM ar_batches

1091: p_transmission_id ar_batches.transmission_id%TYPE,
1092: p_bank_deposit_number ar_batches.bank_deposit_number%TYPE ) IS
1093: CURSOR C IS
1094: SELECT *
1095: FROM ar_batches
1096: WHERE rowid = p_row_id
1097: FOR UPDATE of BATCH_ID NOWAIT;
1098: Recinfo C%ROWTYPE;
1099: --

Line 1265: PROCEDURE nowaitlock_p( p_bat_id IN ar_batches.batch_id%TYPE ) IS

1261: APP_EXCEPTION.Raise_Exception;
1262: end if;
1263: END lock_p;
1264: --
1265: PROCEDURE nowaitlock_p( p_bat_id IN ar_batches.batch_id%TYPE ) IS
1266: l_bat_id ar_batches.batch_id%TYPE;
1267: BEGIN
1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );
1269: --

Line 1266: l_bat_id ar_batches.batch_id%TYPE;

1262: end if;
1263: END lock_p;
1264: --
1265: PROCEDURE nowaitlock_p( p_bat_id IN ar_batches.batch_id%TYPE ) IS
1266: l_bat_id ar_batches.batch_id%TYPE;
1267: BEGIN
1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );
1269: --
1270: SELECT batch_id

Line 1272: FROM ar_batches

1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );
1269: --
1270: SELECT batch_id
1271: INTO l_bat_id
1272: FROM ar_batches
1273: WHERE batch_id = p_bat_id
1274: FOR UPDATE OF STATUS NOWAIT;
1275: --
1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );

Line 1288: | This function fetches a row from AR_BATCHES table |

1284: | PROCEDURE |
1285: | fetch_p |
1286: | |
1287: | DESCRIPTION |
1288: | This function fetches a row from AR_BATCHES table |
1289: | |
1290: | SCOPE - PUBLIC |
1291: | |
1292: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1295: | p_bat_id - Batch Id of row to be fetched from AR_BATCHES |

1291: | |
1292: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1293: | |
1294: | ARGUMENTS : IN: |
1295: | p_bat_id - Batch Id of row to be fetched from AR_BATCHES |
1296: | OUT: |
1297: | p_adj_rec - Batches Record structure |
1298: | |
1299: | RETURNS : NONE |

Line 1306: PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,

1302: | |
1303: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1304: | |
1305: +===========================================================================*/
1306: PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,
1307: p_batch_rec OUT NOCOPY ar_batches%ROWTYPE ) IS
1308: BEGIN
1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );
1310: --

Line 1307: p_batch_rec OUT NOCOPY ar_batches%ROWTYPE ) IS

1303: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1304: | |
1305: +===========================================================================*/
1306: PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,
1307: p_batch_rec OUT NOCOPY ar_batches%ROWTYPE ) IS
1308: BEGIN
1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );
1310: --
1311: SELECT *

Line 1313: FROM ar_batches

1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );
1310: --
1311: SELECT *
1312: INTO p_batch_rec
1313: FROM ar_batches
1314: WHERE batch_id = p_batch_id;
1315: --
1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );
1317: EXCEPTION

Line 1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS

1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );
1321: RAISE;
1322: END;
1323: --
1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1325: BEGIN
1326: IF PG_DEBUG in ('Y', 'C') THEN
1327: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()+' );
1328: END IF;

Line 1332: FROM ar_batches

1328: END IF;
1329: --
1330: SELECT *
1331: INTO p_batch_rec
1332: FROM ar_batches
1333: WHERE batch_id = p_batch_rec.batch_id
1334: FOR UPDATE OF STATUS;
1335: --
1336: IF PG_DEBUG in ('Y', 'C') THEN

Line 1348: PROCEDURE nowaitlock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS

1344: RAISE;
1345: END lock_fetch_p;
1346: --
1347: --
1348: PROCEDURE nowaitlock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1349: BEGIN
1350: IF PG_DEBUG in ('Y', 'C') THEN
1351: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()+' );
1352: END IF;

Line 1356: FROM ar_batches

1352: END IF;
1353: --
1354: SELECT *
1355: INTO p_batch_rec
1356: FROM ar_batches
1357: WHERE batch_id = p_batch_rec.batch_id
1358: FOR UPDATE OF STATUS NOWAIT;
1359: --
1360: IF PG_DEBUG in ('Y', 'C') THEN