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.EDR_PSIG dependencies on FND_GLOBAL

Line 290: l_user_id := fnd_global.user_id;

286: wf_log_pkg.string(6, 'Copy Attachments...','pk3....'||l_pk3_value);
287: wf_log_pkg.string(6, 'Copy Attachments...','pk4....'||l_pk4_value);
288: wf_log_pkg.string(6, 'Copy Attachments...','pk5....'||l_pk5_value);
289:
290: l_user_id := fnd_global.user_id;
291: l_login_id := fnd_global.login_id;
292: l_erecord_id := p_target_value;
293:
294: /* obtain the category id of the document category 'ERES' */

Line 291: l_login_id := fnd_global.login_id;

287: wf_log_pkg.string(6, 'Copy Attachments...','pk4....'||l_pk4_value);
288: wf_log_pkg.string(6, 'Copy Attachments...','pk5....'||l_pk5_value);
289:
290: l_user_id := fnd_global.user_id;
291: l_login_id := fnd_global.login_id;
292: l_erecord_id := p_target_value;
293:
294: /* obtain the category id of the document category 'ERES' */
295: select category_id into l_eres_category_id

Line 776: last_updated_by = fnd_global.user_id(),

772: UPDATE EDR_PSIG_DOCUMENTS
773: set PSIG_STATUS=UPPER(p_STATUS),
774: --Bug 4672801: start
775: last_update_date = sysdate,
776: last_updated_by = fnd_global.user_id(),
777: last_update_login = fnd_global.login_id()
778: --Bug 4672801: end
779: where DOCUMENT_ID=P_DOCUMENT_ID;
780:

Line 777: last_update_login = fnd_global.login_id()

773: set PSIG_STATUS=UPPER(p_STATUS),
774: --Bug 4672801: start
775: last_update_date = sysdate,
776: last_updated_by = fnd_global.user_id(),
777: last_update_login = fnd_global.login_id()
778: --Bug 4672801: end
779: where DOCUMENT_ID=P_DOCUMENT_ID;
780:
781: --Bug 3101047: Start

Line 935: last_updated_by = fnd_global.user_id(),

931: EVENT_NAME=P_EVENT_NAME,
932: EVENT_KEY=P_EVENT_KEY,
933: --Bug 4672801: start
934: last_update_date = sysdate,
935: last_updated_by = fnd_global.user_id(),
936: last_update_login = fnd_global.login_id()
937: --Bug 4672801: end
938: where DOCUMENT_ID=P_DOCUMENT_ID;
939: -- Bug 3604783 : End

Line 936: last_update_login = fnd_global.login_id()

932: EVENT_KEY=P_EVENT_KEY,
933: --Bug 4672801: start
934: last_update_date = sysdate,
935: last_updated_by = fnd_global.user_id(),
936: last_update_login = fnd_global.login_id()
937: --Bug 4672801: end
938: where DOCUMENT_ID=P_DOCUMENT_ID;
939: -- Bug 3604783 : End
940:

Line 1016: last_updated_by = fnd_global.user_id(),

1012: UPDATE EDR_PSIG_DOCUMENTS
1013: set PSIG_STATUS='COMPLETE',
1014: --Bug 4672801: start
1015: last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id(),
1017: last_update_login = fnd_global.login_id()
1018: --Bug 4672801: end
1019: where DOCUMENT_ID=P_DOCUMENT_ID;
1020:

Line 1017: last_update_login = fnd_global.login_id()

1013: set PSIG_STATUS='COMPLETE',
1014: --Bug 4672801: start
1015: last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id(),
1017: last_update_login = fnd_global.login_id()
1018: --Bug 4672801: end
1019: where DOCUMENT_ID=P_DOCUMENT_ID;
1020:
1021: EXCEPTION

Line 1075: last_updated_by = fnd_global.user_id(),

1071: UPDATE EDR_PSIG_DOCUMENTS
1072: set PSIG_STATUS='CANCEL',
1073: --Bug 4672801: start
1074: last_update_date = sysdate,
1075: last_updated_by = fnd_global.user_id(),
1076: last_update_login = fnd_global.login_id()
1077: --Bug 4672801: end
1078: where DOCUMENT_ID=P_DOCUMENT_ID;
1079:

Line 1076: last_update_login = fnd_global.login_id()

1072: set PSIG_STATUS='CANCEL',
1073: --Bug 4672801: start
1074: last_update_date = sysdate,
1075: last_updated_by = fnd_global.user_id(),
1076: last_update_login = fnd_global.login_id()
1077: --Bug 4672801: end
1078: where DOCUMENT_ID=P_DOCUMENT_ID;
1079:
1080: EXCEPTION

Line 1285: FND_GLOBAL.USER_ID,

1281: P_ORIGINAL_RECIPIENT,
1282: P_OVERRIDING_COMMENTS,
1283: 'PENDING',
1284: SYSDATE,
1285: FND_GLOBAL.USER_ID,
1286: SYSDATE,
1287: FND_GLOBAL.USER_ID,
1288: FND_GLOBAL.LOGIN_ID,
1289: P_ADHOC_STATUS,

Line 1287: FND_GLOBAL.USER_ID,

1283: 'PENDING',
1284: SYSDATE,
1285: FND_GLOBAL.USER_ID,
1286: SYSDATE,
1287: FND_GLOBAL.USER_ID,
1288: FND_GLOBAL.LOGIN_ID,
1289: P_ADHOC_STATUS,
1290: l_signer_seq
1291: );

Line 1288: FND_GLOBAL.LOGIN_ID,

1284: SYSDATE,
1285: FND_GLOBAL.USER_ID,
1286: SYSDATE,
1287: FND_GLOBAL.USER_ID,
1288: FND_GLOBAL.LOGIN_ID,
1289: P_ADHOC_STATUS,
1290: l_signer_seq
1291: );
1292: --Bug 3330240 : end

Line 1477: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

1473: SIGNATURE_TIMESTAMP=SYSDATE,
1474: SIGNATURE_TIMEZONE=l_server_timezone,
1475: SIGNATURE_STATUS='COMPLETE',
1476: LAST_UPDATE_DATE = SYSDATE,
1477: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
1478: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1479: USER_DISPLAY_NAME = L_USER_DISPLAY_NAME,
1480: ORIG_SYSTEM = L_ORIG_SYSTEM,
1481: ORIG_SYSTEM_ID = L_ORIG_SYSTEM_ID

Line 1478: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1474: SIGNATURE_TIMEZONE=l_server_timezone,
1475: SIGNATURE_STATUS='COMPLETE',
1476: LAST_UPDATE_DATE = SYSDATE,
1477: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
1478: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1479: USER_DISPLAY_NAME = L_USER_DISPLAY_NAME,
1480: ORIG_SYSTEM = L_ORIG_SYSTEM,
1481: ORIG_SYSTEM_ID = L_ORIG_SYSTEM_ID
1482: WHERE SIGNATURE_ID = l_SIGNATURE_ID;

Line 1577: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

1573: */
1574: UPDATE EDR_PSIG_DETAILS
1575: set SIGNATURE_STATUS='CANCEL',
1576: LAST_UPDATE_DATE=SYSDATE,
1577: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
1578: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
1579: where SIGNATURE_ID=P_SIGNATURE_ID;
1580: --Bug 3330240 : end
1581: EXCEPTION

Line 1578: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

1574: UPDATE EDR_PSIG_DETAILS
1575: set SIGNATURE_STATUS='CANCEL',
1576: LAST_UPDATE_DATE=SYSDATE,
1577: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
1578: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
1579: where SIGNATURE_ID=P_SIGNATURE_ID;
1580: --Bug 3330240 : end
1581: EXCEPTION
1582: WHEN EDR_GENERIC_ERROR then

Line 1634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1630: X_NAME => P_PARAMETERS(i).PARAM_NAME,
1631: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1632: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1633: X_LAST_UPDATE_DATE => SYSDATE,
1634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1636:
1637:
1638: EXCEPTION

Line 1635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1631: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1632: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1633: X_LAST_UPDATE_DATE => SYSDATE,
1634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1636:
1637:
1638: EXCEPTION
1639: WHEN NO_DATA_FOUND then

Line 1650: X_CREATED_BY => FND_GLOBAL.USER_ID,

1646: X_NAME => P_PARAMETERS(i).PARAM_NAME,
1647: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1648: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1649: X_CREATION_DATE => SYSDATE,
1650: X_CREATED_BY => FND_GLOBAL.USER_ID,
1651: X_LAST_UPDATE_DATE => SYSDATE,
1652: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1653: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1654: END;

Line 1652: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1648: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1649: X_CREATION_DATE => SYSDATE,
1650: X_CREATED_BY => FND_GLOBAL.USER_ID,
1651: X_LAST_UPDATE_DATE => SYSDATE,
1652: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1653: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1654: END;
1655: END IF;
1656: END LOOP;

Line 1653: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1649: X_CREATION_DATE => SYSDATE,
1650: X_CREATED_BY => FND_GLOBAL.USER_ID,
1651: X_LAST_UPDATE_DATE => SYSDATE,
1652: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1653: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1654: END;
1655: END IF;
1656: END LOOP;
1657: else

Line 1764: X_CREATED_BY => FND_GLOBAL.USER_ID,

1760: X_NAME => P_PARAMETERS(i).PARAM_NAME,
1761: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1762: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1763: X_CREATION_DATE => SYSDATE,
1764: X_CREATED_BY => FND_GLOBAL.USER_ID,
1765: X_LAST_UPDATE_DATE => SYSDATE,
1766: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1767: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1768: ELSE

Line 1766: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1762: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1763: X_CREATION_DATE => SYSDATE,
1764: X_CREATED_BY => FND_GLOBAL.USER_ID,
1765: X_LAST_UPDATE_DATE => SYSDATE,
1766: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1767: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1768: ELSE
1769: EDR_PSIG_SIGN_PARAMS_PKG.UPDATE_ROW(
1770: X_PARAMETER_ID => L_PARAMETER_ID,

Line 1767: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1763: X_CREATION_DATE => SYSDATE,
1764: X_CREATED_BY => FND_GLOBAL.USER_ID,
1765: X_LAST_UPDATE_DATE => SYSDATE,
1766: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1767: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1768: ELSE
1769: EDR_PSIG_SIGN_PARAMS_PKG.UPDATE_ROW(
1770: X_PARAMETER_ID => L_PARAMETER_ID,
1771: X_SIGNATURE_ID => P_SIGNATURE_ID,

Line 1776: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1772: X_NAME => P_PARAMETERS(i).PARAM_NAME,
1773: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1774: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1775: X_LAST_UPDATE_DATE => SYSDATE,
1776: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1777: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1778: END IF;
1779: CLOSE C1;
1780: END IF;

Line 1777: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1773: X_VALUE => P_PARAMETERS(i).PARAM_VALUE,
1774: X_DISPLAY_NAME => NVL(P_PARAMETERS(i).PARAM_DISPLAYNAME,P_PARAMETERS(i).PARAM_NAME),
1775: X_LAST_UPDATE_DATE => SYSDATE,
1776: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1777: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1778: END IF;
1779: CLOSE C1;
1780: END IF;
1781: END LOOP;

Line 2078: last_updated_by = fnd_global.user_id(),

2074: SET
2075: print_count = P_NEW_COUNT,
2076: --Bug 4672801: start
2077: last_update_date = sysdate,
2078: last_updated_by = fnd_global.user_id(),
2079: last_update_login = fnd_global.login_id()
2080: --Bug 4672801: end
2081: WHERE document_id = P_DOC_ID;
2082:

Line 2079: last_update_login = fnd_global.login_id()

2075: print_count = P_NEW_COUNT,
2076: --Bug 4672801: start
2077: last_update_date = sysdate,
2078: last_updated_by = fnd_global.user_id(),
2079: last_update_login = fnd_global.login_id()
2080: --Bug 4672801: end
2081: WHERE document_id = P_DOC_ID;
2082:
2083: commit;

Line 2297: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

2293: /* Document Exist */
2294: UPDATE EDR_PSIG_DETAILS
2295: set SIGNATURE_SEQUENCE=P_SIGNATURE_SEQUENCE,
2296: LAST_UPDATE_DATE=SYSDATE,
2297: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2298: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
2299: where SIGNATURE_ID=P_SIGNATURE_ID;
2300:
2301: X_ERROR := 0;

Line 2298: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

2294: UPDATE EDR_PSIG_DETAILS
2295: set SIGNATURE_SEQUENCE=P_SIGNATURE_SEQUENCE,
2296: LAST_UPDATE_DATE=SYSDATE,
2297: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2298: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
2299: where SIGNATURE_ID=P_SIGNATURE_ID;
2300:
2301: X_ERROR := 0;
2302: EXCEPTION

Line 2377: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

2373: /* Document Exist */
2374: UPDATE EDR_PSIG_DETAILS
2375: set ADHOC_STATUS=P_ADHOC_STATUS,
2376: LAST_UPDATE_DATE=SYSDATE,
2377: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2378: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
2379: where SIGNATURE_ID=P_SIGNATURE_ID;
2380:
2381: X_ERROR := 0;

Line 2378: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

2374: UPDATE EDR_PSIG_DETAILS
2375: set ADHOC_STATUS=P_ADHOC_STATUS,
2376: LAST_UPDATE_DATE=SYSDATE,
2377: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2378: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
2379: where SIGNATURE_ID=P_SIGNATURE_ID;
2380:
2381: X_ERROR := 0;
2382: EXCEPTION

Line 3277: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

3273: begin
3274: update edr_psig_details
3275: set signature_status = null,
3276: LAST_UPDATE_DATE=SYSDATE,
3277: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
3278: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
3279: where document_id = p_document_id
3280: and signature_status = 'PENDING';
3281: end clear_pending_signatures;

Line 3278: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

3274: update edr_psig_details
3275: set signature_status = null,
3276: LAST_UPDATE_DATE=SYSDATE,
3277: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
3278: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID
3279: where document_id = p_document_id
3280: and signature_status = 'PENDING';
3281: end clear_pending_signatures;
3282: --Bug 4577122: End