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 126: WHERE s.person_id = fnd_global.employee_id()),

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

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

483: and g.object_id = o.object_id
484: AND o.obj_name = G_OBJECT_NAME
485: AND g.grantee_type = G_FND_GRANTEE_TYPE_GROUP
486: AND g.instance_pk1_value = p_contract_id1
487: AND e.user_id = FND_GLOBAL.user_id()
488: AND (
489: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
490: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
491: )

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

500: AND g.grantee_type = G_FND_GRANTEE_TYPE_USER
501: AND g.instance_pk1_value = p_contract_id2
502: AND (
503: (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
504: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
505: )
506: AND (
507: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
508: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)

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

511: -- Cursor to get current user's JTF resource id
512: CURSOR cur_user_jtf_resource_csr IS
513: SELECT resource_id
514: FROM jtf_rs_resource_extns
515: WHERE user_id = FND_GLOBAL.user_id();
516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;
519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;

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

543: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
545: 'Values from contract_csr: l_org_id = ' || l_org_id || ', l_owner_id = ' || l_owner_id || ',l_use_acl_flag = ' || l_use_acl_flag);
546: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
547: 'Values : FND_GLOBAL.user_id() = ' || FND_GLOBAL.user_id() || ', FND_GLOBAL.user_name() = ' || FND_GLOBAL.user_name());
548: END IF;
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: x_has_access := FND_API.G_FALSE;

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

593: END IF;
594:
595: IF (l_result = 'Y') THEN
596:
597: l_user_id := FND_GLOBAL.user_id();
598:
599: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
601: 'Value from FND_GLOBAL.user_id() call: l_user_id = ' || l_user_id);

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

597: l_user_id := FND_GLOBAL.user_id();
598:
599: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
601: 'Value from FND_GLOBAL.user_id() call: l_user_id = ' || l_user_id);
602: END IF;
603:
604: -- Check if the current user is owner of the contract
605: IF (l_user_id = l_owner_id) THEN

Line 1000: contract_last_updated_by = FND_GLOBAL.user_id()

996: -- Update the contract status
997: UPDATE okc_rep_contracts_all
998: SET contract_status_code = p_status_code,
999: contract_last_update_date = sysdate,
1000: contract_last_updated_by = FND_GLOBAL.user_id()
1001: WHERE contract_id = p_contract_id
1002: AND contract_version_num = p_contract_version;
1003:
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1008: END IF;
1009:
1010: -- Log this status change into OKC_REP_CON_STATUS_HIST table
1011: IF (p_user_id IS NULL) THEN
1012: l_user_id := FND_GLOBAL.user_id();
1013:
1014: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1015: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1016: g_module || l_api_name || '.begin',

Line 5066: FND_GLOBAL.USER_ID, --created_by,

5062: keywords,
5063: physical_location,
5064: USERENV('LANG'),--source_language,
5065: 1, --object_version_number,
5066: FND_GLOBAL.USER_ID, --created_by,
5067: SYSDATE, --creation_date,
5068: FND_GLOBAL.USER_ID, --last_updated_by,
5069: SYSDATE, --last_update_date,
5070: FND_GLOBAL.USER_ID, --last_update_login,

Line 5068: FND_GLOBAL.USER_ID, --last_updated_by,

5064: USERENV('LANG'),--source_language,
5065: 1, --object_version_number,
5066: FND_GLOBAL.USER_ID, --created_by,
5067: SYSDATE, --creation_date,
5068: FND_GLOBAL.USER_ID, --last_updated_by,
5069: SYSDATE, --last_update_date,
5070: FND_GLOBAL.USER_ID, --last_update_login,
5071: program_id,
5072: program_login_id,

Line 5070: FND_GLOBAL.USER_ID, --last_update_login,

5066: FND_GLOBAL.USER_ID, --created_by,
5067: SYSDATE, --creation_date,
5068: FND_GLOBAL.USER_ID, --last_updated_by,
5069: SYSDATE, --last_update_date,
5070: FND_GLOBAL.USER_ID, --last_update_login,
5071: program_id,
5072: program_login_id,
5073: program_application_id,
5074: request_id,

Line 5113: FND_GLOBAL.USER_ID, --CREATED_BY,

5109: party_id,
5110: --signed_by_txt,
5111: --TO_DATE(signed_date, G_IMP_DATE_FORMAT),
5112: 1, --object_version_number,
5113: FND_GLOBAL.USER_ID, --CREATED_BY,
5114: SYSDATE, --CREATION_DATE,
5115: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5116: SYSDATE, --LAST_UPDATE_DATE,
5117: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

Line 5115: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

5111: --TO_DATE(signed_date, G_IMP_DATE_FORMAT),
5112: 1, --object_version_number,
5113: FND_GLOBAL.USER_ID, --CREATED_BY,
5114: SYSDATE, --CREATION_DATE,
5115: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5116: SYSDATE, --LAST_UPDATE_DATE,
5117: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5118: program_id,
5119: program_login_id,

Line 5117: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,

5113: FND_GLOBAL.USER_ID, --CREATED_BY,
5114: SYSDATE, --CREATION_DATE,
5115: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
5116: SYSDATE, --LAST_UPDATE_DATE,
5117: FND_GLOBAL.USER_ID, --LAST_UPDATE_LOGIN,
5118: program_id,
5119: program_login_id,
5120: program_application_id,
5121: request_id

Line 5159: FND_GLOBAL.USER_ID, --created_by,

5155: party_id,
5156: signed_by_txt,
5157: TO_DATE(signed_date, g_imp_date_format),
5158: 1, --object_version_number,
5159: FND_GLOBAL.USER_ID, --created_by,
5160: SYSDATE, --creation_date,
5161: FND_GLOBAL.USER_ID, --last_updated_by,
5162: SYSDATE, --last_update_date,
5163: FND_GLOBAL.USER_ID, --last_update_login,

Line 5161: FND_GLOBAL.USER_ID, --last_updated_by,

5157: TO_DATE(signed_date, g_imp_date_format),
5158: 1, --object_version_number,
5159: FND_GLOBAL.USER_ID, --created_by,
5160: SYSDATE, --creation_date,
5161: FND_GLOBAL.USER_ID, --last_updated_by,
5162: SYSDATE, --last_update_date,
5163: FND_GLOBAL.USER_ID, --last_update_login,
5164: program_id,
5165: program_login_id,

Line 5163: FND_GLOBAL.USER_ID, --last_update_login,

5159: FND_GLOBAL.USER_ID, --created_by,
5160: SYSDATE, --creation_date,
5161: FND_GLOBAL.USER_ID, --last_updated_by,
5162: SYSDATE, --last_update_date,
5163: FND_GLOBAL.USER_ID, --last_update_login,
5164: program_id,
5165: program_login_id,
5166: program_application_id,
5167: request_id

Line 5197: FND_GLOBAL.USER_ID,

5193: contract_id,
5194: contract_version_num,
5195: contract_status_code,
5196: SYSDATE,
5197: FND_GLOBAL.USER_ID,
5198: object_version_number,
5199: created_by,
5200: creation_date,
5201: last_updated_by,

Line 5206: AND created_by = FND_GLOBAL.USER_ID

5202: last_update_date,
5203: last_update_login
5204: FROM okc_rep_contracts_all
5205: WHERE request_id = p_request_id
5206: AND created_by = FND_GLOBAL.USER_ID
5207: AND contract_id >= l_start_contract_id
5208: AND contract_id < l_start_contract_id + l_insert_batch_size;
5209:
5210: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');

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

5976: OPEN IMP_ERRORS_CSR;
5977: LOOP
5978: FETCH IMP_ERRORS_CSR INTO l_imp_errors_rec;
5979: EXIT WHEN IMP_ERRORS_CSR%NOTFOUND;
5980: l_error_msg := l_error_msg || FND_GLOBAL.Newline || l_imp_errors_rec.error_message || ' ';
5981: END LOOP;
5982: CLOSE IMP_ERRORS_CSR;
5983:
5984: IF(LENGTH(l_error_msg) > 0) THEN

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

5984: IF(LENGTH(l_error_msg) > 0) THEN
5985: l_csv_error_string := l_csv_error_string || ',' || add_quotes(l_error_msg);
5986: END IF;
5987:
5988: l_csv_error_string := l_csv_error_string || FND_GLOBAL.Newline;
5989:
5990:
5991: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5992: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

6048: select meaning from fnd_lookup_values
6049: where lookup_type = 'OKC_REP_IMP_TEMPL_ATTRIBUTES'
6050: and LANGUAGE = userenv('LANG')
6051: and VIEW_APPLICATION_ID = 0
6052: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('OKC_REP_IMP_TEMPL_ATTRIBUTES', VIEW_APPLICATION_ID)
6053: and enabled_flag = 'Y'
6054: order by to_number(tag);
6055:
6056: l_csv_header_rec CSV_HEADER_CSR%ROWTYPE;

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

6677: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
6678: -- No need to updated these columns. These are updated upon View Contract.
6679: -- UPDATE okc_rep_contracts_all
6680: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
6681: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
6682: -- WHERE contract_id = p_doc_id;
6683: l_ok_to_commit := FND_API.G_TRUE;
6684: CLOSE l_contract_exist_csr;
6685: END IF; -- (l_contract_exist_csr%NOTFOUND)

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

6697: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
6698: -- No need to updated these columns. These are updated upon View Contract.
6699: -- UPDATE okc_rep_contracts_all
6700: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
6701: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
6702: -- WHERE contract_id = p_doc_id;
6703: l_ok_to_commit := FND_API.G_TRUE;
6704: CLOSE l_contract_updatable_csr;
6705: END IF; -- (l_contract_updatable_csr%NOTFOUND)