eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on FND_GLOBAL

Line 247: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||

243: l_xml XMLTYPE;
244: l_where_clause VARCHAR2(4000);
245: l_extract_query VARCHAR2(4000) :=
246: 'select XMLElement("FundsCapturePayerNotification", ' ||
247: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
248: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
249: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
250: ' where txn.trxnmid = xml_order.trxnmid ' ||
251: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';

Line 1009: ' last_updated_by = fnd_global.user_id, ' ||

1005: ' debit_advice_email = null, ' ||
1006: ' debit_advice_fax = null, ' ||
1007: ' payer_notification_created = ''Y'', ' ||
1008: ' object_version_number = object_version_number + 1, ' ||
1009: ' last_updated_by = fnd_global.user_id, ' ||
1010: ' last_update_date = SYSDATE, ' ||
1011: ' last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id) ' ||
1012: 'WHERE nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
1013:

Line 1011: ' last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id) ' ||

1007: ' payer_notification_created = ''Y'', ' ||
1008: ' object_version_number = object_version_number + 1, ' ||
1009: ' last_updated_by = fnd_global.user_id, ' ||
1010: ' last_update_date = SYSDATE, ' ||
1011: ' last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id) ' ||
1012: 'WHERE nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
1013:
1014: BEGIN
1015:

Line 1070: last_updated_by = fnd_global.user_id,

1066: debit_advice_email = p_recipient_email,
1067: debit_advice_fax = null,
1068: payer_notification_created = 'Y',
1069: object_version_number = object_version_number + 1,
1070: last_updated_by = fnd_global.user_id,
1071: last_update_date = SYSDATE,
1072: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1073: WHERE trxnmid = p_trxnmid;
1074: ELSIF p_delivery_method = 'FAX' THEN

Line 1072: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1068: payer_notification_created = 'Y',
1069: object_version_number = object_version_number + 1,
1070: last_updated_by = fnd_global.user_id,
1071: last_update_date = SYSDATE,
1072: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1073: WHERE trxnmid = p_trxnmid;
1074: ELSIF p_delivery_method = 'FAX' THEN
1075: UPDATE
1076: iby_trxn_summaries_all

Line 1083: last_updated_by = fnd_global.user_id,

1079: debit_advice_email = null,
1080: debit_advice_fax = p_recipient_fax,
1081: payer_notification_created = 'Y',
1082: object_version_number = object_version_number + 1,
1083: last_updated_by = fnd_global.user_id,
1084: last_update_date = SYSDATE,
1085: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1086: WHERE trxnmid = p_trxnmid;
1087: ELSIF p_delivery_method = 'PRINTED' THEN

Line 1085: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1081: payer_notification_created = 'Y',
1082: object_version_number = object_version_number + 1,
1083: last_updated_by = fnd_global.user_id,
1084: last_update_date = SYSDATE,
1085: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1086: WHERE trxnmid = p_trxnmid;
1087: ELSIF p_delivery_method = 'PRINTED' THEN
1088: UPDATE
1089: iby_trxn_summaries_all

Line 1096: last_updated_by = fnd_global.user_id,

1092: debit_advice_email = NULL,
1093: debit_advice_fax = NULL,
1094: payer_notification_created = 'Y',
1095: object_version_number = object_version_number + 1,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_date = SYSDATE,
1098: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1099: WHERE trxnmid = p_trxnmid;
1100: END IF;

Line 1098: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1094: payer_notification_created = 'Y',
1095: object_version_number = object_version_number + 1,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_date = SYSDATE,
1098: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1099: WHERE trxnmid = p_trxnmid;
1100: END IF;
1101:
1102: COMMIT;