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_K_ENTITY_LOCKS_GRP dependencies on FND_GLOBAL

Line 381: 1, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

377: last_updated_by, last_update_date, last_update_login)
378: SELECT okc_k_entity_locks_s.NEXTVAL, p_entity_name, p_entity_pk1,
379: p_entity_pk2, p_entity_pk3, p_entity_pk4, p_entity_pk5,
380: p_lock_by_entity_id, p_lock_by_document_type, p_lock_by_document_id,
381: 1, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
382: fnd_global.login_id
383: FROM DUAL
384: WHERE NOT EXISTS (
385: SELECT 'Y'

Line 382: fnd_global.login_id

378: SELECT okc_k_entity_locks_s.NEXTVAL, p_entity_name, p_entity_pk1,
379: p_entity_pk2, p_entity_pk3, p_entity_pk4, p_entity_pk5,
380: p_lock_by_entity_id, p_lock_by_document_type, p_lock_by_document_id,
381: 1, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
382: fnd_global.login_id
383: FROM DUAL
384: WHERE NOT EXISTS (
385: SELECT 'Y'
386: FROM okc_k_entity_locks

Line 464: p_created_by => fnd_global.user_id,

460: p_lock_by_entity_id => p_lock_by_entity_id,
461: p_lock_by_document_type => p_lock_by_document_type,
462: p_lock_by_document_id => p_lock_by_document_id,
463: p_object_version_number => 1,
464: p_created_by => fnd_global.user_id,
465: p_creation_date => SYSDATE,
466: p_last_updated_by => fnd_global.user_id,
467: p_last_update_date => SYSDATE,
468: p_last_update_login => fnd_global.login_id,

Line 466: p_last_updated_by => fnd_global.user_id,

462: p_lock_by_document_id => p_lock_by_document_id,
463: p_object_version_number => 1,
464: p_created_by => fnd_global.user_id,
465: p_creation_date => SYSDATE,
466: p_last_updated_by => fnd_global.user_id,
467: p_last_update_date => SYSDATE,
468: p_last_update_login => fnd_global.login_id,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,

Line 468: p_last_update_login => fnd_global.login_id,

464: p_created_by => fnd_global.user_id,
465: p_creation_date => SYSDATE,
466: p_last_updated_by => fnd_global.user_id,
467: p_last_update_date => SYSDATE,
468: p_last_update_login => fnd_global.login_id,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: x_k_entity_lock_id => x_k_entity_lock_id

Line 694: last_updated_by = fnd_global.user_id,

690:
691: FORALL i IN l_old_clause_id_tbl.FIRST .. l_old_clause_id_tbl.LAST
692: UPDATE okc_k_entity_locks
693: SET entity_pk1 = TO_CHAR (l_new_clause_id_tbl (i)),
694: last_updated_by = fnd_global.user_id,
695: last_update_date = SYSDATE,
696: last_update_login = fnd_global.login_id
697: WHERE entity_pk1 = TO_CHAR (l_old_clause_id_tbl (i))
698: AND entity_name = G_CLAUSE_ENTITY;

Line 696: last_update_login = fnd_global.login_id

692: UPDATE okc_k_entity_locks
693: SET entity_pk1 = TO_CHAR (l_new_clause_id_tbl (i)),
694: last_updated_by = fnd_global.user_id,
695: last_update_date = SYSDATE,
696: last_update_login = fnd_global.login_id
697: WHERE entity_pk1 = TO_CHAR (l_old_clause_id_tbl (i))
698: AND entity_name = G_CLAUSE_ENTITY;
699:
700: -- Update the Lock By articles with the correct orig_sys_ref.

Line 750: last_updated_by = fnd_global.user_id,

746:
747: FORALL i IN l_old_dlvbl_id_tbl.FIRST .. l_old_dlvbl_id_tbl.LAST
748: UPDATE okc_k_entity_locks
749: SET entity_pk1 = TO_CHAR (l_new_dlvbl_id_tbl (i)),
750: last_updated_by = fnd_global.user_id,
751: last_update_date = SYSDATE,
752: last_update_login = fnd_global.login_id
753: WHERE entity_pk1 = TO_CHAR (l_old_dlvbl_id_tbl (i))
754: AND entity_name = G_DLVBL_ENTITY;

Line 752: last_update_login = fnd_global.login_id

748: UPDATE okc_k_entity_locks
749: SET entity_pk1 = TO_CHAR (l_new_dlvbl_id_tbl (i)),
750: last_updated_by = fnd_global.user_id,
751: last_update_date = SYSDATE,
752: last_update_login = fnd_global.login_id
753: WHERE entity_pk1 = TO_CHAR (l_old_dlvbl_id_tbl (i))
754: AND entity_name = G_DLVBL_ENTITY;
755:
756: -- Update the Lock By dleiverables with the correct orig_sys_ref.

Line 1288: fnd_global.user_id, SYSDATE, fnd_global.user_id,

1284: l_doc_clause_rec.attribute14,
1285: l_doc_clause_rec.attribute15, NULL,
1286: l_doc_clause_rec.ref_article_id,
1287: l_doc_clause_rec.ref_article_version_id, 1,
1288: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1289: fnd_global.login_id, SYSDATE,
1290: l_doc_clause_rec.orig_article_id
1291: )
1292: RETURNING ID

Line 1289: fnd_global.login_id, SYSDATE,

1285: l_doc_clause_rec.attribute15, NULL,
1286: l_doc_clause_rec.ref_article_id,
1287: l_doc_clause_rec.ref_article_version_id, 1,
1288: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1289: fnd_global.login_id, SYSDATE,
1290: l_doc_clause_rec.orig_article_id
1291: )
1292: RETURNING ID
1293: INTO x_new_doc_clause_id;

Line 1837: SYSDATE, fnd_global.user_id, SYSDATE,

1833: external_yn_tbl (i), value_set_id_tbl (i),
1834: var_value_tbl (i), var_value_id_tbl (i),
1835: override_global_yn_tbl (i), mrvariablehtml_tbl (i),
1836: mrvariablexml_tbl (i), 1,
1837: SYSDATE, fnd_global.user_id, SYSDATE,
1838: fnd_global.user_id, fnd_global.login_id
1839: );
1840: END IF;
1841:

Line 1838: fnd_global.user_id, fnd_global.login_id

1834: var_value_tbl (i), var_value_id_tbl (i),
1835: override_global_yn_tbl (i), mrvariablehtml_tbl (i),
1836: mrvariablexml_tbl (i), 1,
1837: SYSDATE, fnd_global.user_id, SYSDATE,
1838: fnd_global.user_id, fnd_global.login_id
1839: );
1840: END IF;
1841:
1842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2022: last_amended_by = fnd_global.user_id,

2018: SET amendment_description = l_par_scn_details_rec.amendment_description,
2019: amendment_operation_code = l_par_scn_details_rec.amendment_operation_code,
2020: summary_amend_operation_code = l_par_scn_details_rec.summary_amend_operation_code,
2021: scn_id = p_scn_id,
2022: last_amended_by = fnd_global.user_id,
2023: last_amendment_date = SYSDATE
2024: WHERE ID = p_target_doc_section_id;
2025: END IF;
2026: ELSE

Line 2063: 1,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id

2059: attribute1, attribute2, attribute3, attribute4, attribute5,
2060: attribute6, attribute7, attribute8, attribute9,
2061: attribute10, attribute11, attribute12, attribute13,
2062: attribute14, attribute15,
2063: 1,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
2064: ,Decode(p_keep_orig_ref,'Y',amendment_description,null)
2065: ,Decode(p_keep_orig_ref,'Y',amendment_operation_code,null)
2066: ,Decode(p_keep_orig_ref,'Y',summary_amend_operation_code,null)
2067: ,Decode(p_keep_orig_ref,'Y',fnd_global.user_id,null)

Line 2067: ,Decode(p_keep_orig_ref,'Y',fnd_global.user_id,null)

2063: 1,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
2064: ,Decode(p_keep_orig_ref,'Y',amendment_description,null)
2065: ,Decode(p_keep_orig_ref,'Y',amendment_operation_code,null)
2066: ,Decode(p_keep_orig_ref,'Y',summary_amend_operation_code,null)
2067: ,Decode(p_keep_orig_ref,'Y',fnd_global.user_id,null)
2068: ,Decode(p_keep_orig_ref,'Y',sysdate,To_Date(NULL))
2069: FROM okc_sections_b
2070: WHERE ID = p_source_section_id;
2071:

Line 3216: l_reqestor_name := NVL (l_reqestor_name, fnd_global.user_name);

3212: INTO l_reqestor_name;
3213:
3214: CLOSE cur_user;
3215:
3216: l_reqestor_name := NVL (l_reqestor_name, fnd_global.user_name);
3217:
3218: -- Get the Actioner user details;
3219: OPEN cur_user (p_actioner_id);
3220: