DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on FND_GLOBAL

Line 1117: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1113: -- 14834217: added who columns
1114: UPDATE ce_payment_transactions
1115: SET payment_offset_ccid = G_bat_payment_offset_ccid,
1116: receipt_offset_ccid = G_bat_receipt_offset_ccid,
1117: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1118: LAST_UPDATE_DATE = sysdate,
1119: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1120: WHERE trxn_reference_number = p_trxn_reference_number;
1121: p_result := 'SUCCESS';

Line 1119: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id

1115: SET payment_offset_ccid = G_bat_payment_offset_ccid,
1116: receipt_offset_ccid = G_bat_receipt_offset_ccid,
1117: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1118: LAST_UPDATE_DATE = sysdate,
1119: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1120: WHERE trxn_reference_number = p_trxn_reference_number;
1121: p_result := 'SUCCESS';
1122:
1123: IF (p_called_by = 'MANUAL' OR p_called_by = 'CL' OR p_called_by = 'ZBA')

Line 1253: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1249: log_msg(l_debug_proc,'Payment process request_id='||l_request_id||', payment_request_number='||p_pay_proc_req_code);
1250: -- 14834217: Added who columns
1251: UPDATE ce_payment_transactions
1252: SET trxn_status_code = 'IN_PROCESS',
1253: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1254: LAST_UPDATE_DATE = sysdate,
1255: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1256: WHERE payment_request_number = p_pay_proc_req_code;
1257: p_result := 'SUCCESS';

Line 1255: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id

1251: UPDATE ce_payment_transactions
1252: SET trxn_status_code = 'IN_PROCESS',
1253: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1254: LAST_UPDATE_DATE = sysdate,
1255: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1256: WHERE payment_request_number = p_pay_proc_req_code;
1257: p_result := 'SUCCESS';
1258: END IF;
1259: ELSE

Line 1275: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1271: -- stamp the transfer with the payment process request code
1272: -- 14834217: Added who columns
1273: UPDATE ce_payment_transactions
1274: SET payment_request_number = l_pay_proc_req_code,
1275: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1278: WHERE trxn_reference_number = p_trxn_reference_number;
1279:

Line 1277: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id

1273: UPDATE ce_payment_transactions
1274: SET payment_request_number = l_pay_proc_req_code,
1275: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id
1278: WHERE trxn_reference_number = p_trxn_reference_number;
1279:
1280: -- call IBY Build program
1281: log_msg(l_debug_proc,'submitting the Payments build program');

Line 1496: X_CREATED_BY => FND_GLOBAL.user_id,

1492: X_DOC_CATEGORY_CODE => NULL,
1493: X_PAYMENT_OFFSET_CCID => G_bat_payment_offset_ccid,
1494: X_RECEIPT_OFFSET_CCID => G_bat_receipt_offset_ccid,
1495: X_CASHPOOL_ID => G_cp_cashpool_id,
1496: X_CREATED_BY => FND_GLOBAL.user_id,
1497: X_CREATION_DATE => sysdate,
1498: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
1499: X_LAST_UPDATE_DATE => sysdate,
1500: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

Line 1498: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

1494: X_RECEIPT_OFFSET_CCID => G_bat_receipt_offset_ccid,
1495: X_CASHPOOL_ID => G_cp_cashpool_id,
1496: X_CREATED_BY => FND_GLOBAL.user_id,
1497: X_CREATION_DATE => sysdate,
1498: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
1499: X_LAST_UPDATE_DATE => sysdate,
1500: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
1501: X_EXT_BANK_ACCOUNT_ID => NULL,
1502: X_ATTRIBUTE_CATEGORY => NULL,

Line 1500: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

1496: X_CREATED_BY => FND_GLOBAL.user_id,
1497: X_CREATION_DATE => sysdate,
1498: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
1499: X_LAST_UPDATE_DATE => sysdate,
1500: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
1501: X_EXT_BANK_ACCOUNT_ID => NULL,
1502: X_ATTRIBUTE_CATEGORY => NULL,
1503: X_ATTRIBUTE1 => NULL,
1504: X_ATTRIBUTE2 => NULL,

Line 1789: NVL(FND_GLOBAL.user_id,-1),

1785: l_docs_payable_rec.payment_reason_comments,
1786: l_docs_payable_rec.remittance_message1,
1787: l_docs_payable_rec.remittance_message2,
1788: l_docs_payable_rec.remittance_message3,
1789: NVL(FND_GLOBAL.user_id,-1),
1790: SYSDATE,
1791: NVL(FND_GLOBAL.user_id,-1),
1792: SYSDATE,
1793: NVL(FND_GLOBAL.user_id,-1),

Line 1791: NVL(FND_GLOBAL.user_id,-1),

1787: l_docs_payable_rec.remittance_message2,
1788: l_docs_payable_rec.remittance_message3,
1789: NVL(FND_GLOBAL.user_id,-1),
1790: SYSDATE,
1791: NVL(FND_GLOBAL.user_id,-1),
1792: SYSDATE,
1793: NVL(FND_GLOBAL.user_id,-1),
1794: 1);
1795:

Line 1793: NVL(FND_GLOBAL.user_id,-1),

1789: NVL(FND_GLOBAL.user_id,-1),
1790: SYSDATE,
1791: NVL(FND_GLOBAL.user_id,-1),
1792: SYSDATE,
1793: NVL(FND_GLOBAL.user_id,-1),
1794: 1);
1795:
1796: log_msg(l_debug_proc,'calling validate_documents...');
1797: -- Call iby validate api