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

Line 128: WHERE s.person_id = fnd_global.employee_id()),

124: WHERE h.quote_header_id = p_contract_id
125: AND get_quote_access(
126: (SELECT s.resource_id
127: FROM jtf_rs_salesreps s
128: WHERE s.person_id = fnd_global.employee_id()),
129: h.quote_number) <> 'NONE';
130:
131: CURSOR mo_check_csr(p_org_id in number) IS
132: SELECT organization_id

Line 507: AND e.user_id = FND_GLOBAL.user_id()

503: and g.object_id = o.object_id
504: AND o.obj_name = G_OBJECT_NAME
505: AND g.grantee_type = G_FND_GRANTEE_TYPE_GROUP
506: AND g.instance_pk1_value = p_contract_id1
507: AND e.user_id = FND_GLOBAL.user_id()
508: AND (
509: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
510: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
511: )

Line 524: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility

520: AND g.grantee_type = G_FND_GRANTEE_TYPE_USER
521: AND g.instance_pk1_value = p_contract_id2
522: AND (
523: (g.grantee_key = p_grantee_key AND (g.grantee_orig_system = p_grantee_orig_system OR g.grantee_orig_system = 'JRES_IND')) -- for R12 functionality
524: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
525: )
526: AND (
527: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
528: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)

Line 535: WHERE user_id = FND_GLOBAL.user_id();

531: -- Cursor to get current user's JTF resource id
532: CURSOR cur_user_jtf_resource_csr IS
533: SELECT resource_id
534: FROM jtf_rs_resource_extns
535: WHERE user_id = FND_GLOBAL.user_id();
536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;
539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;

Line 569: 'Values : FND_GLOBAL.user_id() = ' || FND_GLOBAL.user_id() || ', FND_GLOBAL.user_name() = ' || FND_GLOBAL.user_name());

565: 'Values from contract_csr: l_org_id = ' || l_org_id || ', l_owner_id = ' || l_owner_id || ',l_use_acl_flag = ' || l_use_acl_flag);
566: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
567: 'Values from contract_csr: l_contract_type = ' || l_contract_type || ', l_status_code = ' || l_status_code || ',l_sign_type = ' || l_sign_type);
568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
569: 'Values : FND_GLOBAL.user_id() = ' || FND_GLOBAL.user_id() || ', FND_GLOBAL.user_name() = ' || FND_GLOBAL.user_name());
570: END IF;
571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: x_has_access := FND_API.G_FALSE;

Line 574: l_user_name := FND_GLOBAL.user_name();

570: END IF;
571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: x_has_access := FND_API.G_FALSE;
574: l_user_name := FND_GLOBAL.user_name();
575: l_user_id := FND_GLOBAL.user_id();
576:
577: -- Multi-Org Initialization
578: MO_GLOBAL.init(G_APP_NAME);

Line 575: l_user_id := FND_GLOBAL.user_id();

571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: x_has_access := FND_API.G_FALSE;
574: l_user_name := FND_GLOBAL.user_name();
575: l_user_id := FND_GLOBAL.user_id();
576:
577: -- Multi-Org Initialization
578: MO_GLOBAL.init(G_APP_NAME);
579:

Line 682: 'Value from FND_GLOBAL.user_id() call: l_user_id = ' || l_user_id);

678: IF (l_result = 'Y') THEN
679:
680: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
682: 'Value from FND_GLOBAL.user_id() call: l_user_id = ' || l_user_id);
683: END IF;
684:
685: -- Check if the current user is owner of the contract
686: IF (l_user_id = l_owner_id) THEN

Line 1081: contract_last_updated_by = FND_GLOBAL.user_id()

1077: -- Update the contract status
1078: UPDATE okc_rep_contracts_all
1079: SET contract_status_code = p_status_code,
1080: contract_last_update_date = sysdate,
1081: contract_last_updated_by = FND_GLOBAL.user_id()
1082: WHERE contract_id = p_contract_id
1083: AND contract_version_num = p_contract_version;
1084:
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1093: l_user_id := FND_GLOBAL.user_id();

1089: END IF;
1090:
1091: -- Log this status change into OKC_REP_CON_STATUS_HIST table
1092: IF (p_user_id IS NULL) THEN
1093: l_user_id := FND_GLOBAL.user_id();
1094:
1095: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1097: g_module || l_api_name || '.begin',

Line 5791: FND_GLOBAL.USER_ID, --created_by,

5787: keywords,
5788: physical_location,
5789: USERENV('LANG'),--source_language,
5790: 1, --object_version_number,
5791: FND_GLOBAL.USER_ID, --created_by,
5792: SYSDATE, --creation_date,
5793: FND_GLOBAL.USER_ID, --last_updated_by,
5794: SYSDATE, --last_update_date,
5795: FND_GLOBAL.USER_ID, --last_update_login,

Line 5793: FND_GLOBAL.USER_ID, --last_updated_by,

5789: USERENV('LANG'),--source_language,
5790: 1, --object_version_number,
5791: FND_GLOBAL.USER_ID, --created_by,
5792: SYSDATE, --creation_date,
5793: FND_GLOBAL.USER_ID, --last_updated_by,
5794: SYSDATE, --last_update_date,
5795: FND_GLOBAL.USER_ID, --last_update_login,
5796: program_id,
5797: program_login_id,

Line 5795: FND_GLOBAL.USER_ID, --last_update_login,

5791: FND_GLOBAL.USER_ID, --created_by,
5792: SYSDATE, --creation_date,
5793: FND_GLOBAL.USER_ID, --last_updated_by,
5794: SYSDATE, --last_update_date,
5795: FND_GLOBAL.USER_ID, --last_update_login,
5796: program_id,
5797: program_login_id,
5798: program_application_id,
5799: request_id,

Line 5867: FND_GLOBAL.USER_ID, --CREATED_BY,

5863: party_id,
5864: --signed_by_txt,
5865: --TO_DATE(signed_date, G_IMP_DATE_FORMAT),
5866: 1, --object_version_number,
5867: FND_GLOBAL.USER_ID, --CREATED_BY,
5868: SYSDATE, --CREATION_DATE,
5869: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5870: SYSDATE, --LAST_UPDATE_DATE,
5871: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

Line 5869: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

5865: --TO_DATE(signed_date, G_IMP_DATE_FORMAT),
5866: 1, --object_version_number,
5867: FND_GLOBAL.USER_ID, --CREATED_BY,
5868: SYSDATE, --CREATION_DATE,
5869: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5870: SYSDATE, --LAST_UPDATE_DATE,
5871: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5872: program_id,
5873: program_login_id,

Line 5871: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

5867: FND_GLOBAL.USER_ID, --CREATED_BY,
5868: SYSDATE, --CREATION_DATE,
5869: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5870: SYSDATE, --LAST_UPDATE_DATE,
5871: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5872: program_id,
5873: program_login_id,
5874: program_application_id,
5875: request_id

Line 5913: FND_GLOBAL.USER_ID, --created_by,

5909: sig.party_id,
5910: sig.signed_by_txt,
5911: TO_DATE(sig.signed_date, g_imp_date_format),
5912: 1, --object_version_number,
5913: FND_GLOBAL.USER_ID, --created_by,
5914: SYSDATE, --creation_date,
5915: FND_GLOBAL.USER_ID, --last_updated_by,
5916: SYSDATE, --last_update_date,
5917: FND_GLOBAL.USER_ID, --last_update_login,

Line 5915: FND_GLOBAL.USER_ID, --last_updated_by,

5911: TO_DATE(sig.signed_date, g_imp_date_format),
5912: 1, --object_version_number,
5913: FND_GLOBAL.USER_ID, --created_by,
5914: SYSDATE, --creation_date,
5915: FND_GLOBAL.USER_ID, --last_updated_by,
5916: SYSDATE, --last_update_date,
5917: FND_GLOBAL.USER_ID, --last_update_login,
5918: sig.program_id,
5919: sig.program_login_id,

Line 5917: FND_GLOBAL.USER_ID, --last_update_login,

5913: FND_GLOBAL.USER_ID, --created_by,
5914: SYSDATE, --creation_date,
5915: FND_GLOBAL.USER_ID, --last_updated_by,
5916: SYSDATE, --last_update_date,
5917: FND_GLOBAL.USER_ID, --last_update_login,
5918: sig.program_id,
5919: sig.program_login_id,
5920: sig.program_application_id,
5921: sig.request_id

Line 5953: FND_GLOBAL.USER_ID,

5949: contract_id,
5950: contract_version_num,
5951: contract_status_code,
5952: SYSDATE,
5953: FND_GLOBAL.USER_ID,
5954: object_version_number,
5955: created_by,
5956: creation_date,
5957: last_updated_by,

Line 5962: AND created_by = FND_GLOBAL.USER_ID

5958: last_update_date,
5959: last_update_login
5960: FROM okc_rep_contracts_all
5961: WHERE run_id = p_run_id
5962: AND created_by = FND_GLOBAL.USER_ID
5963: AND contract_id >= l_start_contract_id
5964: AND contract_id < l_start_contract_id + l_insert_batch_size;
5965:
5966: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');

Line 5994: FND_GLOBAL.USER_ID, --CREATED_BY,

5990: party_role_code,
5991: contact_id,
5992: contact_role_id,
5993: 1, --object_version_number,
5994: FND_GLOBAL.USER_ID, --CREATED_BY,
5995: SYSDATE, --CREATION_DATE,
5996: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5997: SYSDATE, --LAST_UPDATE_DATE,
5998: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

Line 5996: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

5992: contact_role_id,
5993: 1, --object_version_number,
5994: FND_GLOBAL.USER_ID, --CREATED_BY,
5995: SYSDATE, --CREATION_DATE,
5996: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5997: SYSDATE, --LAST_UPDATE_DATE,
5998: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5999: program_id,
6000: program_login_id,

Line 5998: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

5994: FND_GLOBAL.USER_ID, --CREATED_BY,
5995: SYSDATE, --CREATION_DATE,
5996: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5997: SYSDATE, --LAST_UPDATE_DATE,
5998: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5999: program_id,
6000: program_login_id,
6001: program_application_id,
6002: request_id

Line 6006: --AND created_by = FND_GLOBAL.USER_ID

6002: request_id
6003: FROM okc_rep_imp_contacts_t
6004: WHERE run_id = p_run_id
6005: AND valid_flag = 'Y'
6006: --AND created_by = FND_GLOBAL.USER_ID
6007: AND contract_id >= l_start_contract_id
6008: AND contract_id < l_start_contract_id + l_insert_batch_size;
6009:
6010:

Line 6048: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

6044: risk_occurence_date,
6045: 1,
6046: --created_by,
6047: SYSDATE, --CREATION_DATE,
6048: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
6049: SYSDATE, --LAST_UPDATE_DATE,
6050: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
6051: program_id,
6052: program_login_id,

Line 6050: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

6046: --created_by,
6047: SYSDATE, --CREATION_DATE,
6048: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
6049: SYSDATE, --LAST_UPDATE_DATE,
6050: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
6051: program_id,
6052: program_login_id,
6053: program_application_id,
6054: request_id

Line 6058: --AND created_by = FND_GLOBAL.USER_ID

6054: request_id
6055: FROM okc_rep_imp_risks_t
6056: WHERE run_id = p_run_id
6057: AND valid_flag = 'Y'
6058: --AND created_by = FND_GLOBAL.USER_ID
6059: AND business_document_id >= l_start_contract_id
6060: AND business_document_id < l_start_contract_id + l_insert_batch_size;
6061:
6062: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_contract_risks *****');

Line 6863: l_error_msg := l_error_msg || FND_GLOBAL.Newline || l_imp_errors_rec.error_message || ' ';

6859: OPEN IMP_ERRORS_CSR;
6860: LOOP
6861: FETCH IMP_ERRORS_CSR INTO l_imp_errors_rec;
6862: EXIT WHEN IMP_ERRORS_CSR%NOTFOUND;
6863: l_error_msg := l_error_msg || FND_GLOBAL.Newline || l_imp_errors_rec.error_message || ' ';
6864: END LOOP;
6865: CLOSE IMP_ERRORS_CSR;
6866:
6867: IF(LENGTH(l_error_msg) > 0) THEN

Line 6871: l_csv_error_string := l_csv_error_string || FND_GLOBAL.Newline;

6867: IF(LENGTH(l_error_msg) > 0) THEN
6868: l_csv_error_string := l_csv_error_string || ',' || add_quotes(l_error_msg);
6869: END IF;
6870:
6871: l_csv_error_string := l_csv_error_string || FND_GLOBAL.Newline;
6872:
6873:
6874: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6875: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 6935: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('OKC_REP_IMP_TEMPL_ATTRIBUTES', VIEW_APPLICATION_ID)

6931: select meaning from fnd_lookup_values
6932: where lookup_type = 'OKC_REP_IMP_TEMPL_ATTRIBUTES'
6933: and LANGUAGE = userenv('LANG')
6934: and VIEW_APPLICATION_ID = 0
6935: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('OKC_REP_IMP_TEMPL_ATTRIBUTES', VIEW_APPLICATION_ID)
6936: and enabled_flag = 'Y'
6937: order by to_number(tag);
6938:
6939: l_csv_header_rec CSV_HEADER_CSR%ROWTYPE;

Line 7564: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()

7560: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
7561: -- No need to updated these columns. These are updated upon View Contract.
7562: -- UPDATE okc_rep_contracts_all
7563: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
7564: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
7565: -- WHERE contract_id = p_doc_id;
7566: l_ok_to_commit := FND_API.G_TRUE;
7567: CLOSE l_contract_exist_csr;
7568: END IF; -- (l_contract_exist_csr%NOTFOUND)

Line 7584: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()

7580: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
7581: -- No need to updated these columns. These are updated upon View Contract.
7582: -- UPDATE okc_rep_contracts_all
7583: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
7584: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
7585: -- WHERE contract_id = p_doc_id;
7586: l_ok_to_commit := FND_API.G_TRUE;
7587: CLOSE l_contract_updatable_csr;
7588: END IF; -- (l_contract_updatable_csr%NOTFOUND)