APPS.IBY_TRANSACTIONSET_PKG dependencies on IBY_PAYEE

Line 40: l_mpayeeid iby_payee.mpayeeid%type;

36: err_msg VARCHAR2(100);
37: trxn_mid NUMBER;
38: transaction_id NUMBER;
39: l_tmid iby_trxn_summaries_all.mtangibleid%type;
40: l_mpayeeid iby_payee.mpayeeid%type;
41:
42: BEGIN
43: -- Check trxn_type
44: IF ((trxn_type_in = '') OR

Line 226: l_mpayeeid iby_payee.mpayeeid%type;

222: transaction_id NUMBER;
223: l_tmid iby_trxn_summaries_all.mtangibleid%type;
224: l_order_id iby_trxn_summaries_all.tangibleid%type;
225:
226: l_mpayeeid iby_payee.mpayeeid%type;
227: l_mbatchid iby_batches_all.mbatchid%type;
228: BEGIN
229: -- Initialize variables
230: num_trxns := 0;

Line 516: l_mpayeeid iby_payee.mpayeeid%type;

512: err_msg VARCHAR2(100);
513: trxn_mid NUMBER;
514: transaction_id NUMBER;
515: l_tmid iby_trxn_summaries_all.mtangibleid%type;
516: l_mpayeeid iby_payee.mpayeeid%type;
517: l_mbatchid iby_batches_all.mbatchid%type;
518: BEGIN
519: -- NULL optional parameters if they are empty string
520: IF (batch_id_in = '')

Line 771: l_mpayeeid iby_payee.mpayeeid%type;

767: trxn_mid NUMBER;
768: transaction_id NUMBER;
769: l_tmid iby_trxn_summaries_all.mtangibleid%type;
770: l_order_id iby_trxn_summaries_all.tangibleid%type;
771: l_mpayeeid iby_payee.mpayeeid%type;
772: l_mbatchid iby_batches_all.mbatchid%type;
773: BEGIN
774: -- NULL optional parameters if they are empty string
775: IF (batch_id_in = '')

Line 1020: l_mpayeeid iby_payee.mpayeeid%type;

1016: trxn_mid NUMBER;
1017: transaction_id NUMBER;
1018: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1019: l_order_id iby_trxn_summaries_all.tangibleid%type;
1020: l_mpayeeid iby_payee.mpayeeid%type;
1021: BEGIN
1022: -- Count number of previous transactions
1023: SELECT count(*)
1024: INTO num_trxns

Line 1185: l_mpayeeid iby_payee.mpayeeid%type;

1181: num_trxns NUMBER;
1182: err_msg VARCHAR2(100);
1183:
1184: l_mbatchid iby_batches_all.mbatchid%type;
1185: l_mpayeeid iby_payee.mpayeeid%type;
1186: BEGIN
1187:
1188: num_trxns := 0;
1189: -- Get number of existing batches that match

Line 1297: l_mpayeeid iby_payee.mpayeeid%type;

1293: num_trxns NUMBER := 0;
1294: err_msg VARCHAR2(100);
1295: trxn_mid NUMBER;
1296:
1297: l_mpayeeid iby_payee.mpayeeid%type;
1298: l_mbatchid iby_batches_all.mbatchid%type;
1299: BEGIN
1300: -- Check for idempotency: see if transaction already
1301: -- exists

Line 1533: l_mpayeeid iby_payee.mpayeeid%type;

1529: mid iby_trxn_extended.SplitID%TYPE;
1530: err_msg VARCHAR2(100);
1531: trxn_mid NUMBER;
1532:
1533: l_mpayeeid iby_payee.mpayeeid%type;
1534: BEGIN
1535: -- NULL optional parameters
1536: IF (card_BIN_in = '')
1537: THEN