DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on FND_GLOBAL

Line 101: fnd_global.user_id,

97: settlement_date_in,
98: req_type_in,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: sysdate,
103: fnd_global.user_id,
104: fnd_global.login_id,
105: 0,

Line 103: fnd_global.user_id,

99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: sysdate,
103: fnd_global.user_id,
104: fnd_global.login_id,
105: 0,
106: 0,
107: 0

Line 104: fnd_global.login_id,

100: sysdate,
101: fnd_global.user_id,
102: sysdate,
103: fnd_global.user_id,
104: fnd_global.login_id,
105: 0,
106: 0,
107: 0
108: );

Line 118: last_updated_by = fnd_global.user_id,

114: batchid = merch_batchid_in,
115: mbatchid = l_mbatchid,
116: last_update_date = sysdate,
117: updatedate = sysdate,
118: last_updated_by = fnd_global.user_id,
119: object_version_number = object_version_number + 1
120: WHERE
121: status = oldstatus_in AND
122: payeeid = merchant_id_in AND

Line 387: fnd_global.user_id,

383: settlement_date_in,
384: req_type_in,
385: sysdate,
386: sysdate,
387: fnd_global.user_id,
388: sysdate,
389: fnd_global.user_id,
390: fnd_global.login_id,
391: 0,

Line 389: fnd_global.user_id,

385: sysdate,
386: sysdate,
387: fnd_global.user_id,
388: sysdate,
389: fnd_global.user_id,
390: fnd_global.login_id,
391: 0,
392: 0,
393: 0,

Line 390: fnd_global.login_id,

386: sysdate,
387: fnd_global.user_id,
388: sysdate,
389: fnd_global.user_id,
390: fnd_global.login_id,
391: 0,
392: 0,
393: 0,
394: l_batches_tab(i).profile_code,

Line 449: last_updated_by = fnd_global.user_id,

445: batchid = l_trxns_in_batch_tab(i).batch_id,
446: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
447: last_update_date = sysdate,
448: updatedate = sysdate,
449: last_updated_by = fnd_global.user_id,
450: object_version_number = object_version_number + 1
451: WHERE
452: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
453: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

Line 767: fnd_global.user_id,

763: settlement_date_in,
764: req_type_in,
765: sysdate,
766: sysdate,
767: fnd_global.user_id,
768: sysdate,
769: fnd_global.user_id,
770: fnd_global.login_id,
771: 0,

Line 769: fnd_global.user_id,

765: sysdate,
766: sysdate,
767: fnd_global.user_id,
768: sysdate,
769: fnd_global.user_id,
770: fnd_global.login_id,
771: 0,
772: 0,
773: 0,

Line 770: fnd_global.login_id,

766: sysdate,
767: fnd_global.user_id,
768: sysdate,
769: fnd_global.user_id,
770: fnd_global.login_id,
771: 0,
772: 0,
773: 0,
774: --l_batches_tab(i).profile_code

Line 830: last_updated_by = fnd_global.user_id,

826: batchid = l_trxns_in_batch_tab(i).batch_id,
827: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
828: last_update_date = sysdate,
829: updatedate = sysdate,
830: last_updated_by = fnd_global.user_id,
831: object_version_number = object_version_number + 1
832: WHERE
833: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
834: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

Line 905: LAST_UPDATED_BY = fnd_global.user_id,

901: BATCHCLOSEDATE = time_in,
902: BEPCODE = vendor_code_in,
903: BEPMESSAGE = vendor_message_in,
904: LAST_UPDATE_DATE = sysdate,
905: LAST_UPDATED_BY = fnd_global.user_id,
906: OBJECT_VERSION_NUMBER = Object_Version_Number + 1,
907: SENTCOUNTER = SENTCOUNTER + 1,
908: SENTCOUNTERDAILY = SENTCOUNTERDAILY + 1
909: WHERE batchid = merch_batchid_in

Line 919: LAST_UPDATED_BY = fnd_global.user_id,

915: BEPCODE = vendor_code_in,
916: BEPMESSAGE = vendor_message_in,
917: LAST_UPDATE_DATE = sysdate,
918: UPDATEDATE = sysdate,
919: LAST_UPDATED_BY = fnd_global.user_id,
920: OBJECT_VERSION_NUMBER = object_version_number + 1
921: WHERE
922: -- 109 means STATUS_BATCH_TRANSITIONAL, 101 means STATUS_BATCH_COMM_ERROR, 120 means STATUS_BATCH_MAX_EXCEEDED
923: status in (109, 101, 120)

Line 975: LAST_UPDATED_BY = fnd_global.user_id

971: BEPCODE = i_errCode_arr( l_index ),
972: BEPMESSAGE = i_errMsg_arr( l_index ),
973: LAST_UPDATE_DATE = sysdate,
974: UPDATEDATE = sysdate,
975: LAST_UPDATED_BY = fnd_global.user_id
976: WHERE TANGIBLEID = i_tangibleId_arr( l_index )
977: AND batchid = i_merch_batchid
978: AND payeeid = i_merchant_id;
979:

Line 1137: sysdate, fnd_global.user_id,

1133: (
1134: l_mtangibleid(j), i_tangibleid(j), i_amount(j),
1135: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1136: i_ordermedium(j), i_eftauthmethod(j),
1137: sysdate, fnd_global.user_id,
1138: sysdate, fnd_global.user_id,
1139: fnd_global.login_id, 1
1140: );
1141:

Line 1138: sysdate, fnd_global.user_id,

1134: l_mtangibleid(j), i_tangibleid(j), i_amount(j),
1135: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1136: i_ordermedium(j), i_eftauthmethod(j),
1137: sysdate, fnd_global.user_id,
1138: sysdate, fnd_global.user_id,
1139: fnd_global.login_id, 1
1140: );
1141:
1142: /**

Line 1139: fnd_global.login_id, 1

1135: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1136: i_ordermedium(j), i_eftauthmethod(j),
1137: sysdate, fnd_global.user_id,
1138: sysdate, fnd_global.user_id,
1139: fnd_global.login_id, 1
1140: );
1141:
1142: /**
1143: * Create transaction records in iby_trxn_summaries_all.

Line 1168: sysdate, sysdate, fnd_global.user_id,

1164: i_payerinstrid(j), i_amount(j), i_currency(j),
1165: i_reqdate, i_reqtype, 100, i_settledate(j),
1166: 'BANKACCOUNT', i_instrsubtype(j),
1167: i_customerref(j),
1168: sysdate, sysdate, fnd_global.user_id,
1169: sysdate, fnd_global.user_id,
1170: fnd_global.login_id, 1,'Y'
1171: );
1172:

Line 1169: sysdate, fnd_global.user_id,

1165: i_reqdate, i_reqtype, 100, i_settledate(j),
1166: 'BANKACCOUNT', i_instrsubtype(j),
1167: i_customerref(j),
1168: sysdate, sysdate, fnd_global.user_id,
1169: sysdate, fnd_global.user_id,
1170: fnd_global.login_id, 1,'Y'
1171: );
1172:
1173: ELSIF (l_count=1) THEN

Line 1170: fnd_global.login_id, 1,'Y'

1166: 'BANKACCOUNT', i_instrsubtype(j),
1167: i_customerref(j),
1168: sysdate, sysdate, fnd_global.user_id,
1169: sysdate, fnd_global.user_id,
1170: fnd_global.login_id, 1,'Y'
1171: );
1172:
1173: ELSIF (l_count=1) THEN
1174:

Line 1190: last_updated_by = fnd_global.user_id,

1186: order_medium = i_ordermedium(j),
1187: eft_auth_method = i_eftauthmethod(j),
1188: issuedate = i_issuedate(j),
1189: last_update_date = sysdate,
1190: last_updated_by = fnd_global.user_id,
1191: creation_date = sysdate,
1192: created_by = fnd_global.user_id,
1193: last_update_login= fnd_global.login_id,
1194: object_version_number = 1

Line 1192: created_by = fnd_global.user_id,

1188: issuedate = i_issuedate(j),
1189: last_update_date = sysdate,
1190: last_updated_by = fnd_global.user_id,
1191: creation_date = sysdate,
1192: created_by = fnd_global.user_id,
1193: last_update_login= fnd_global.login_id,
1194: object_version_number = 1
1195: where tangibleid = i_tangibleid(j);
1196:

Line 1193: last_update_login= fnd_global.login_id,

1189: last_update_date = sysdate,
1190: last_updated_by = fnd_global.user_id,
1191: creation_date = sysdate,
1192: created_by = fnd_global.user_id,
1193: last_update_login= fnd_global.login_id,
1194: object_version_number = 1
1195: where tangibleid = i_tangibleid(j);
1196:
1197: UPDATE iby_trxn_summaries_all

Line 1229: last_updated_by = fnd_global.user_id,

1225: mbatchid = null,
1226: errorlocation = null,
1227: last_update_date = sysdate,
1228: updatedate = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: creation_date = sysdate,
1231: created_by = fnd_global.user_id,
1232: last_update_login = fnd_global.user_id,
1233: object_version_number = 1

Line 1231: created_by = fnd_global.user_id,

1227: last_update_date = sysdate,
1228: updatedate = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: creation_date = sysdate,
1231: created_by = fnd_global.user_id,
1232: last_update_login = fnd_global.user_id,
1233: object_version_number = 1
1234:
1235: where tangibleid = i_tangibleid(j);

Line 1232: last_update_login = fnd_global.user_id,

1228: updatedate = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: creation_date = sysdate,
1231: created_by = fnd_global.user_id,
1232: last_update_login = fnd_global.user_id,
1233: object_version_number = 1
1234:
1235: where tangibleid = i_tangibleid(j);
1236: ELSE

Line 1481: fnd_global.user_id, -- last_updated_by

1477: i_instrsubtype, -- instrsubtype
1478: sysdate, -- last_update_date
1479: i_trxndate, -- reqdate
1480: i_trxndate, -- updatedate
1481: fnd_global.user_id, -- last_updated_by
1482: sysdate, -- creation_date
1483: fnd_global.user_id, -- created_by
1484: fnd_global.login_id, -- last_update_login
1485: 1, -- object_version_number

Line 1483: fnd_global.user_id, -- created_by

1479: i_trxndate, -- reqdate
1480: i_trxndate, -- updatedate
1481: fnd_global.user_id, -- last_updated_by
1482: sysdate, -- creation_date
1483: fnd_global.user_id, -- created_by
1484: fnd_global.login_id, -- last_update_login
1485: 1, -- object_version_number
1486: i_bepcode, -- bepcode
1487: i_bepmessage, -- bepmessage

Line 1484: fnd_global.login_id, -- last_update_login

1480: i_trxndate, -- updatedate
1481: fnd_global.user_id, -- last_updated_by
1482: sysdate, -- creation_date
1483: fnd_global.user_id, -- created_by
1484: fnd_global.login_id, -- last_update_login
1485: 1, -- object_version_number
1486: i_bepcode, -- bepcode
1487: i_bepmessage, -- bepmessage
1488: i_errorlocation, -- errorlocation

Line 1546: last_updated_by = fnd_global.user_id,

1542: errorlocation = i_errorlocation,
1543: last_update_date = sysdate,
1544: reqdate = i_trxndate,
1545: updatedate = i_trxndate,
1546: last_updated_by = fnd_global.user_id,
1547: creation_date = sysdate,
1548: created_by = fnd_global.user_id,
1549: last_update_login = fnd_global.user_id,
1550: object_version_number = 1,

Line 1548: created_by = fnd_global.user_id,

1544: reqdate = i_trxndate,
1545: updatedate = i_trxndate,
1546: last_updated_by = fnd_global.user_id,
1547: creation_date = sysdate,
1548: created_by = fnd_global.user_id,
1549: last_update_login = fnd_global.user_id,
1550: object_version_number = 1,
1551: -- trxntypeid = i_trxntypeid,
1552: proc_reference_code = i_referencecode,

Line 1549: last_update_login = fnd_global.user_id,

1545: updatedate = i_trxndate,
1546: last_updated_by = fnd_global.user_id,
1547: creation_date = sysdate,
1548: created_by = fnd_global.user_id,
1549: last_update_login = fnd_global.user_id,
1550: object_version_number = 1,
1551: -- trxntypeid = i_trxntypeid,
1552: proc_reference_code = i_referencecode,
1553: org_type = i_orgtype,

Line 1611: * If FND_GLOBAL.conc_request_id is -1, it implies that

1607:
1608: BEGIN
1609:
1610: /*
1611: * If FND_GLOBAL.conc_request_id is -1, it implies that
1612: * this method has not been invoked via the concurrent
1613: * manager. In that case, write to apps log else write
1614: * to concurrent manager log file.
1615: */

Line 1616: IF (FND_GLOBAL.conc_request_id = -1) THEN

1612: * this method has not been invoked via the concurrent
1613: * manager. In that case, write to apps log else write
1614: * to concurrent manager log file.
1615: */
1616: IF (FND_GLOBAL.conc_request_id = -1) THEN
1617:
1618: /*
1619: * OPTION I:
1620: * Write debug text to the common application log file.