DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on FND_GLOBAL

Line 388: fnd_global.user_id,

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

Line 390: fnd_global.user_id,

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

Line 391: fnd_global.login_id,

387: sysdate,
388: fnd_global.user_id,
389: sysdate,
390: fnd_global.user_id,
391: fnd_global.login_id,
392: 0,
393: 0,
394: 0
395: ,sysdate);

Line 405: last_updated_by = fnd_global.user_id,

401: batchid = merch_batchid_in,
402: mbatchid = l_mbatchid,
403: last_update_date = sysdate,
404: updatedate = sysdate,
405: last_updated_by = fnd_global.user_id,
406: object_version_number = object_version_number + 1
407: WHERE
408: status = oldstatus_in AND
409: payeeid = merchant_id_in AND

Line 709: fnd_global.user_id,

705: settlement_date_in,
706: req_type_in,
707: sysdate,
708: sysdate,
709: fnd_global.user_id,
710: sysdate,
711: fnd_global.user_id,
712: fnd_global.login_id,
713: 0,

Line 711: fnd_global.user_id,

707: sysdate,
708: sysdate,
709: fnd_global.user_id,
710: sysdate,
711: fnd_global.user_id,
712: fnd_global.login_id,
713: 0,
714: 0,
715: 0,

Line 712: fnd_global.login_id,

708: sysdate,
709: fnd_global.user_id,
710: sysdate,
711: fnd_global.user_id,
712: fnd_global.login_id,
713: 0,
714: 0,
715: 0,
716: l_batches_tab(i).profile_code,

Line 802: last_updated_by = fnd_global.user_id,

798: batchid = l_trxns_in_batch_tab(i).batch_id,
799: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
800: last_update_date = sysdate,
801: updatedate = sysdate,
802: last_updated_by = fnd_global.user_id,
803: object_version_number = object_version_number + 1
804: WHERE
805: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
806: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

Line 1175: fnd_global.user_id,

1171: settlement_date_in,
1172: req_type_in,
1173: sysdate,
1174: sysdate,
1175: fnd_global.user_id,
1176: sysdate,
1177: fnd_global.user_id,
1178: fnd_global.login_id,
1179: 0,

Line 1177: fnd_global.user_id,

1173: sysdate,
1174: sysdate,
1175: fnd_global.user_id,
1176: sysdate,
1177: fnd_global.user_id,
1178: fnd_global.login_id,
1179: 0,
1180: 0,
1181: 0,

Line 1178: fnd_global.login_id,

1174: sysdate,
1175: fnd_global.user_id,
1176: sysdate,
1177: fnd_global.user_id,
1178: fnd_global.login_id,
1179: 0,
1180: 0,
1181: 0,
1182: --l_batches_tab(i).profile_code

Line 1267: last_updated_by = fnd_global.user_id,

1263: batchid = l_trxns_in_batch_tab(i).batch_id,
1264: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
1265: last_update_date = sysdate,
1266: updatedate = sysdate,
1267: last_updated_by = fnd_global.user_id,
1268: object_version_number = object_version_number + 1
1269: WHERE
1270: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
1271: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

Line 1348: LAST_UPDATED_BY = fnd_global.user_id,

1344: BATCHCLOSEDATE = time_in,
1345: BEPCODE = vendor_code_in,
1346: BEPMESSAGE = vendor_message_in,
1347: LAST_UPDATE_DATE = sysdate,
1348: LAST_UPDATED_BY = fnd_global.user_id,
1349: OBJECT_VERSION_NUMBER = Object_Version_Number + 1,
1350: SENTCOUNTER = SENTCOUNTER + 1,
1351: SENTCOUNTERDAILY = SENTCOUNTERDAILY + 1
1352: WHERE batchid = merch_batchid_in

Line 1362: LAST_UPDATED_BY = fnd_global.user_id,

1358: BEPCODE = vendor_code_in,
1359: BEPMESSAGE = vendor_message_in,
1360: LAST_UPDATE_DATE = sysdate,
1361: UPDATEDATE = sysdate,
1362: LAST_UPDATED_BY = fnd_global.user_id,
1363: OBJECT_VERSION_NUMBER = object_version_number + 1
1364: WHERE
1365: -- 109 means STATUS_BATCH_TRANSITIONAL, 101 means STATUS_BATCH_COMM_ERROR, 120 means STATUS_BATCH_MAX_EXCEEDED
1366: status in (109, 101, 120)

Line 1418: LAST_UPDATED_BY = fnd_global.user_id

1414: BEPCODE = i_errCode_arr( l_index ),
1415: BEPMESSAGE = i_errMsg_arr( l_index ),
1416: LAST_UPDATE_DATE = sysdate,
1417: UPDATEDATE = sysdate,
1418: LAST_UPDATED_BY = fnd_global.user_id
1419: WHERE TANGIBLEID = i_tangibleId_arr( l_index )
1420: AND batchid = i_merch_batchid
1421: AND payeeid = i_merchant_id;
1422:

Line 1580: sysdate, fnd_global.user_id,

1576: (
1577: l_mtangibleid(j), i_tangibleid(j), i_amount(j),
1578: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1579: i_ordermedium(j), i_eftauthmethod(j),
1580: sysdate, fnd_global.user_id,
1581: sysdate, fnd_global.user_id,
1582: fnd_global.login_id, 1
1583: );
1584:

Line 1581: sysdate, fnd_global.user_id,

1577: l_mtangibleid(j), i_tangibleid(j), i_amount(j),
1578: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1579: i_ordermedium(j), i_eftauthmethod(j),
1580: sysdate, fnd_global.user_id,
1581: sysdate, fnd_global.user_id,
1582: fnd_global.login_id, 1
1583: );
1584:
1585: /**

Line 1582: fnd_global.login_id, 1

1578: i_currency(j), i_refinfo(j), i_memo(j), i_issuedate(j),
1579: i_ordermedium(j), i_eftauthmethod(j),
1580: sysdate, fnd_global.user_id,
1581: sysdate, fnd_global.user_id,
1582: fnd_global.login_id, 1
1583: );
1584:
1585: /**
1586: * Create transaction records in iby_trxn_summaries_all.

Line 1611: sysdate, sysdate, fnd_global.user_id,

1607: i_payerinstrid(j), i_amount(j), i_currency(j),
1608: i_reqdate, i_reqtype, 100, i_settledate(j),
1609: 'BANKACCOUNT', i_instrsubtype(j),
1610: i_customerref(j),
1611: sysdate, sysdate, fnd_global.user_id,
1612: sysdate, fnd_global.user_id,
1613: fnd_global.login_id, 1,'Y'
1614: );
1615:

Line 1612: sysdate, fnd_global.user_id,

1608: i_reqdate, i_reqtype, 100, i_settledate(j),
1609: 'BANKACCOUNT', i_instrsubtype(j),
1610: i_customerref(j),
1611: sysdate, sysdate, fnd_global.user_id,
1612: sysdate, fnd_global.user_id,
1613: fnd_global.login_id, 1,'Y'
1614: );
1615:
1616: ELSIF (l_count=1) THEN

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

1609: 'BANKACCOUNT', i_instrsubtype(j),
1610: i_customerref(j),
1611: sysdate, sysdate, fnd_global.user_id,
1612: sysdate, fnd_global.user_id,
1613: fnd_global.login_id, 1,'Y'
1614: );
1615:
1616: ELSIF (l_count=1) THEN
1617:

Line 1633: last_updated_by = fnd_global.user_id,

1629: order_medium = i_ordermedium(j),
1630: eft_auth_method = i_eftauthmethod(j),
1631: issuedate = i_issuedate(j),
1632: last_update_date = sysdate,
1633: last_updated_by = fnd_global.user_id,
1634: creation_date = sysdate,
1635: created_by = fnd_global.user_id,
1636: last_update_login= fnd_global.login_id,
1637: object_version_number = 1

Line 1635: created_by = fnd_global.user_id,

1631: issuedate = i_issuedate(j),
1632: last_update_date = sysdate,
1633: last_updated_by = fnd_global.user_id,
1634: creation_date = sysdate,
1635: created_by = fnd_global.user_id,
1636: last_update_login= fnd_global.login_id,
1637: object_version_number = 1
1638: where tangibleid = i_tangibleid(j);
1639:

Line 1636: last_update_login= fnd_global.login_id,

1632: last_update_date = sysdate,
1633: last_updated_by = fnd_global.user_id,
1634: creation_date = sysdate,
1635: created_by = fnd_global.user_id,
1636: last_update_login= fnd_global.login_id,
1637: object_version_number = 1
1638: where tangibleid = i_tangibleid(j);
1639:
1640: UPDATE iby_trxn_summaries_all

Line 1672: last_updated_by = fnd_global.user_id,

1668: mbatchid = null,
1669: errorlocation = null,
1670: last_update_date = sysdate,
1671: updatedate = sysdate,
1672: last_updated_by = fnd_global.user_id,
1673: creation_date = sysdate,
1674: created_by = fnd_global.user_id,
1675: last_update_login = fnd_global.user_id,
1676: object_version_number = 1

Line 1674: created_by = fnd_global.user_id,

1670: last_update_date = sysdate,
1671: updatedate = sysdate,
1672: last_updated_by = fnd_global.user_id,
1673: creation_date = sysdate,
1674: created_by = fnd_global.user_id,
1675: last_update_login = fnd_global.user_id,
1676: object_version_number = 1
1677:
1678: where tangibleid = i_tangibleid(j);

Line 1675: last_update_login = fnd_global.user_id,

1671: updatedate = sysdate,
1672: last_updated_by = fnd_global.user_id,
1673: creation_date = sysdate,
1674: created_by = fnd_global.user_id,
1675: last_update_login = fnd_global.user_id,
1676: object_version_number = 1
1677:
1678: where tangibleid = i_tangibleid(j);
1679: ELSE

Line 1924: fnd_global.user_id, -- last_updated_by

1920: i_instrsubtype, -- instrsubtype
1921: sysdate, -- last_update_date
1922: i_trxndate, -- reqdate
1923: i_trxndate, -- updatedate
1924: fnd_global.user_id, -- last_updated_by
1925: sysdate, -- creation_date
1926: fnd_global.user_id, -- created_by
1927: fnd_global.login_id, -- last_update_login
1928: 1, -- object_version_number

Line 1926: fnd_global.user_id, -- created_by

1922: i_trxndate, -- reqdate
1923: i_trxndate, -- updatedate
1924: fnd_global.user_id, -- last_updated_by
1925: sysdate, -- creation_date
1926: fnd_global.user_id, -- created_by
1927: fnd_global.login_id, -- last_update_login
1928: 1, -- object_version_number
1929: i_bepcode, -- bepcode
1930: i_bepmessage, -- bepmessage

Line 1927: fnd_global.login_id, -- last_update_login

1923: i_trxndate, -- updatedate
1924: fnd_global.user_id, -- last_updated_by
1925: sysdate, -- creation_date
1926: fnd_global.user_id, -- created_by
1927: fnd_global.login_id, -- last_update_login
1928: 1, -- object_version_number
1929: i_bepcode, -- bepcode
1930: i_bepmessage, -- bepmessage
1931: i_errorlocation, -- errorlocation

Line 1989: last_updated_by = fnd_global.user_id,

1985: errorlocation = i_errorlocation,
1986: last_update_date = sysdate,
1987: reqdate = i_trxndate,
1988: updatedate = i_trxndate,
1989: last_updated_by = fnd_global.user_id,
1990: creation_date = sysdate,
1991: created_by = fnd_global.user_id,
1992: last_update_login = fnd_global.user_id,
1993: object_version_number = 1,

Line 1991: created_by = fnd_global.user_id,

1987: reqdate = i_trxndate,
1988: updatedate = i_trxndate,
1989: last_updated_by = fnd_global.user_id,
1990: creation_date = sysdate,
1991: created_by = fnd_global.user_id,
1992: last_update_login = fnd_global.user_id,
1993: object_version_number = 1,
1994: -- trxntypeid = i_trxntypeid,
1995: proc_reference_code = i_referencecode,

Line 1992: last_update_login = fnd_global.user_id,

1988: updatedate = i_trxndate,
1989: last_updated_by = fnd_global.user_id,
1990: creation_date = sysdate,
1991: created_by = fnd_global.user_id,
1992: last_update_login = fnd_global.user_id,
1993: object_version_number = 1,
1994: -- trxntypeid = i_trxntypeid,
1995: proc_reference_code = i_referencecode,
1996: org_type = i_orgtype,

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

2050:
2051: BEGIN
2052:
2053: /*
2054: * If FND_GLOBAL.conc_request_id is -1, it implies that
2055: * this method has not been invoked via the concurrent
2056: * manager. In that case, write to apps log else write
2057: * to concurrent manager log file.
2058: */

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

2055: * this method has not been invoked via the concurrent
2056: * manager. In that case, write to apps log else write
2057: * to concurrent manager log file.
2058: */
2059: IF (FND_GLOBAL.conc_request_id = -1) THEN
2060:
2061: /*
2062: * OPTION I:
2063: * Write debug text to the common application log file.