APPS.ARP_LOCKBOX_PKG dependencies on AR_PAYMENTS_INTERFACE

Line 138: FROM ar_payments_interface

134: p_ussgl_transaction_code8 IN VARCHAR2
135: ) IS
136: CURSOR C IS
137: SELECT *
138: FROM ar_payments_interface
139: WHERE rowid = p_row_id
140: FOR UPDATE of transmission_record_id NOWAIT;
141:
142: Recinfo C%ROWTYPE;

Line 693: FROM ar_payments_interface

689: locked the record
690: l_break_point := 'lock record';
691: SELECT transmission_record_id
692: INTO l_dummy
693: FROM ar_payments_interface
694: WHERE transmission_record_id = p_transmission_record_id
695: FOR UPDATE NOWAIT; */
696: --
697: l_break_point := 'update record';

Line 698: UPDATE ar_payments_interface

694: WHERE transmission_record_id = p_transmission_record_id
695: FOR UPDATE NOWAIT; */
696: --
697: l_break_point := 'update record';
698: UPDATE ar_payments_interface
699: SET lockbox_number = p_lockbox_number,
700: batch_name = p_batch_name,
701: item_number = p_item_number,
702: check_number = p_check_number,

Line 855: FROM ar_payments_interface

851: locked the record
852: l_break_point := 'lock record';
853: SELECT transmission_record_id
854: INTO l_dummy
855: FROM ar_payments_interface
856: WHERE transmission_record_id = p_transmission_record_id
857: FOR UPDATE NOWAIT; */
858: --
859: l_break_point := 'delete record';

Line 860: DELETE ar_payments_interface

856: WHERE transmission_record_id = p_transmission_record_id
857: FOR UPDATE NOWAIT; */
858: --
859: l_break_point := 'delete record';
860: DELETE ar_payments_interface
861: WHERE transmission_record_id = p_transmission_record_id;
862: --
863: IF PG_DEBUG in ('Y', 'C') THEN
864: arp_util.debug('arp_lockbox_pkg.delete_trans_data()-');

Line 882: l_batch_name ar_payments_interface.batch_name%type;

878: FUNCTION get_batch_name(p_transmission_id number,
879: p_lockbox_number varchar2,
880: p_item_num number)
881: RETURN varchar2 IS
882: l_batch_name ar_payments_interface.batch_name%type;
883: BEGIN
884: if (p_transmission_id is NULL) THEN
885: return NULL;
886: end if;

Line 892: FROM ar_payments_interface

888: if (p_lockbox_number is NOT NULL) THEN
889: begin
890: SELECT distinct(batch_name)
891: INTO l_batch_name
892: FROM ar_payments_interface
893: WHERE lockbox_number = p_lockbox_number
894: AND transmission_id = p_transmission_id
895: AND batch_name is NOT NULL;
896: if (l_batch_name is NOT NULL) THEN

Line 910: FROM ar_payments_interface

906: if (p_item_num is NOT NULL) THEN
907: begin
908: SELECT distinct(batch_name)
909: INTO l_batch_name
910: FROM ar_payments_interface
911: WHERE item_number = p_item_num
912: AND transmission_id = p_transmission_id
913: AND batch_name is NOT NULL;
914: if (l_batch_name is NOT NULL) THEN

Line 936: l_lockbox_number ar_payments_interface.lockbox_number%type;

932: FUNCTION get_lb_num(p_transmission_id number,
933: p_batch_name varchar2,
934: p_item_num number)
935: RETURN VARCHAR2 IS
936: l_lockbox_number ar_payments_interface.lockbox_number%type;
937: BEGIN
938: if (p_transmission_id is NULL) THEN
939: return NULL;
940: end if;

Line 946: FROM ar_payments_interface

942: if (p_batch_name is NOT NULL) THEN
943: begin
944: SELECT distinct(lockbox_number)
945: INTO l_lockbox_number
946: FROM ar_payments_interface
947: WHERE batch_name = p_batch_name
948: AND transmission_id = p_transmission_id
949: AND lockbox_number is NOT NULL;
950: if (l_lockbox_number is NOT NULL) THEN

Line 964: FROM ar_payments_interface

960: if (p_item_num is NOT NULL) THEN
961: begin
962: SELECT distinct(lockbox_number)
963: INTO l_lockbox_number
964: FROM ar_payments_interface
965: WHERE item_number = p_item_num
966: AND transmission_id = p_transmission_id
967: AND lockbox_number is NOT NULL;
968: if (l_lockbox_number is NOT NULL) THEN