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 155: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||

151: l_xml XMLTYPE;
152: l_where_clause VARCHAR2(4000);
153: l_extract_query VARCHAR2(4000) :=
154: 'select XMLElement("FundsCapturePayerNotification", ' ||
155: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
156: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
157: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
158: ' where txn.trxnmid = xml_order.trxnmid ' ||
159: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';

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

864: ' debit_advice_email = null, ' ||
865: ' debit_advice_fax = null, ' ||
866: ' payer_notification_created = ''Y'', ' ||
867: ' object_version_number = object_version_number + 1, ' ||
868: ' last_updated_by = fnd_global.user_id, ' ||
869: ' last_update_date = SYSDATE, ' ||
870: ' last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id) ' ||
871: 'WHERE nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
872:

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

866: ' payer_notification_created = ''Y'', ' ||
867: ' object_version_number = object_version_number + 1, ' ||
868: ' last_updated_by = fnd_global.user_id, ' ||
869: ' last_update_date = SYSDATE, ' ||
870: ' last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id) ' ||
871: 'WHERE nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
872:
873: BEGIN
874:

Line 929: last_updated_by = fnd_global.user_id,

925: debit_advice_email = p_recipient_email,
926: debit_advice_fax = null,
927: payer_notification_created = 'Y',
928: object_version_number = object_version_number + 1,
929: last_updated_by = fnd_global.user_id,
930: last_update_date = SYSDATE,
931: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
932: WHERE trxnmid = p_trxnmid;
933: ELSIF p_delivery_method = 'FAX' THEN

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

927: payer_notification_created = 'Y',
928: object_version_number = object_version_number + 1,
929: last_updated_by = fnd_global.user_id,
930: last_update_date = SYSDATE,
931: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
932: WHERE trxnmid = p_trxnmid;
933: ELSIF p_delivery_method = 'FAX' THEN
934: UPDATE
935: iby_trxn_summaries_all

Line 942: last_updated_by = fnd_global.user_id,

938: debit_advice_email = null,
939: debit_advice_fax = p_recipient_fax,
940: payer_notification_created = 'Y',
941: object_version_number = object_version_number + 1,
942: last_updated_by = fnd_global.user_id,
943: last_update_date = SYSDATE,
944: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
945: WHERE trxnmid = p_trxnmid;
946: ELSIF p_delivery_method = 'PRINTED' THEN

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

940: payer_notification_created = 'Y',
941: object_version_number = object_version_number + 1,
942: last_updated_by = fnd_global.user_id,
943: last_update_date = SYSDATE,
944: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
945: WHERE trxnmid = p_trxnmid;
946: ELSIF p_delivery_method = 'PRINTED' THEN
947: UPDATE
948: iby_trxn_summaries_all

Line 955: last_updated_by = fnd_global.user_id,

951: debit_advice_email = NULL,
952: debit_advice_fax = NULL,
953: payer_notification_created = 'Y',
954: object_version_number = object_version_number + 1,
955: last_updated_by = fnd_global.user_id,
956: last_update_date = SYSDATE,
957: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
958: WHERE trxnmid = p_trxnmid;
959: END IF;

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

953: payer_notification_created = 'Y',
954: object_version_number = object_version_number + 1,
955: last_updated_by = fnd_global.user_id,
956: last_update_date = SYSDATE,
957: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
958: WHERE trxnmid = p_trxnmid;
959: END IF;
960:
961: COMMIT;