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

Line 1147: l_created_by := Fnd_Global.User_Id;

1143: END IF;
1144: -- Set Internal columns
1145: l_object_version_number := 1;
1146: l_creation_date := Sysdate;
1147: l_created_by := Fnd_Global.User_Id;
1148: l_last_update_date := l_creation_date;
1149: l_last_updated_by := l_created_by;
1150: l_last_update_login := Fnd_Global.Login_Id;
1151:

Line 1150: l_last_update_login := Fnd_Global.Login_Id;

1146: l_creation_date := Sysdate;
1147: l_created_by := Fnd_Global.User_Id;
1148: l_last_update_date := l_creation_date;
1149: l_last_updated_by := l_created_by;
1150: l_last_update_login := Fnd_Global.Login_Id;
1151:
1152:
1153: --- Validate all non-missing attributes
1154: x_return_status := Validate_Record(

Line 1663: l_last_updated_by := FND_GLOBAL.USER_ID;

1659: END IF;
1660:
1661: -- Filling who columns
1662: l_last_update_date := SYSDATE;
1663: l_last_updated_by := FND_GLOBAL.USER_ID;
1664: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1665:
1666: -- Object version increment
1667: -- IF Nvl(p_object_version_number, 0) >= 0 THEN

Line 1664: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1660:
1661: -- Filling who columns
1662: l_last_update_date := SYSDATE;
1663: l_last_updated_by := FND_GLOBAL.USER_ID;
1664: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1665:
1666: -- Object version increment
1667: -- IF Nvl(p_object_version_number, 0) >= 0 THEN
1668: -- l_object_version_number := Nvl( p_object_version_number, 0) + 1;

Line 2416: SET scn.last_updated_by = fnd_global.user_id,

2412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2413: END IF;
2414:
2415: UPDATE okc_sections_b scn
2416: SET scn.last_updated_by = fnd_global.user_id,
2417: scn.last_update_date = sysdate,
2418: scn.amendment_operation_code = 'DELETED',
2419: scn.summary_amend_operation_code =
2420: okc_terms_util_pvt.get_summary_amend_code(

Line 2424: scn.last_amended_by = fnd_global.user_id,

2420: okc_terms_util_pvt.get_summary_amend_code(
2421: scn.summary_amend_operation_code,
2422: scn.amendment_operation_code,
2423: 'DELETED'),
2424: scn.last_amended_by = fnd_global.user_id,
2425: scn.last_amendment_date = sysdate
2426: WHERE scn.id = obj_ids(i);
2427: ELSE
2428:

Line 2464: SET kart.last_updated_by = fnd_global.user_id,

2460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2461: END IF;
2462:
2463: UPDATE okc_k_articles_b kart
2464: SET kart.last_updated_by = fnd_global.user_id,
2465: kart.last_update_date = sysdate,
2466: kart.amendment_operation_code = 'DELETED',
2467: kart.summary_amend_operation_code =
2468: okc_terms_util_pvt.get_summary_amend_code(

Line 2472: kart.last_amended_by = fnd_global.user_id,

2468: okc_terms_util_pvt.get_summary_amend_code(
2469: kart.summary_amend_operation_code,
2470: kart.amendment_operation_code,
2471: 'DELETED'),
2472: kart.last_amended_by = fnd_global.user_id,
2473: kart.last_amendment_date = sysdate
2474: WHERE kart.id = obj_ids(i);
2475: ELSE
2476:

Line 3259: FND_GLOBAL.LOGIN_ID,

3255: null,
3256: null,
3257: null,
3258: null,
3259: FND_GLOBAL.LOGIN_ID,
3260: FND_GLOBAL.USER_ID,
3261: SYSDATE,
3262: FND_GLOBAL.USER_ID,
3263: SYSDATE from dual);

Line 3260: FND_GLOBAL.USER_ID,

3256: null,
3257: null,
3258: null,
3259: FND_GLOBAL.LOGIN_ID,
3260: FND_GLOBAL.USER_ID,
3261: SYSDATE,
3262: FND_GLOBAL.USER_ID,
3263: SYSDATE from dual);
3264:

Line 3262: FND_GLOBAL.USER_ID,

3258: null,
3259: FND_GLOBAL.LOGIN_ID,
3260: FND_GLOBAL.USER_ID,
3261: SYSDATE,
3262: FND_GLOBAL.USER_ID,
3263: SYSDATE from dual);
3264:
3265: END IF;
3266: CLOSE check_document_row_exists;

Line 3424: FND_GLOBAL.LOGIN_ID,

3420: WHERE PARENT.OBJECT_ID = KART.SCN_ID
3421: AND PARENT.DOCUMENT_TYPE = p_document_type
3422: AND PARENT.DOCUMENT_ID = p_document_id),
3423: -- KART.SCN_ID,
3424: FND_GLOBAL.LOGIN_ID,
3425: FND_GLOBAL.USER_ID,
3426: SYSDATE,
3427: FND_GLOBAL.USER_ID,
3428: SYSDATE

Line 3425: FND_GLOBAL.USER_ID,

3421: AND PARENT.DOCUMENT_TYPE = p_document_type
3422: AND PARENT.DOCUMENT_ID = p_document_id),
3423: -- KART.SCN_ID,
3424: FND_GLOBAL.LOGIN_ID,
3425: FND_GLOBAL.USER_ID,
3426: SYSDATE,
3427: FND_GLOBAL.USER_ID,
3428: SYSDATE
3429: FROM OKC_K_ARTICLES_B KART,

Line 3427: FND_GLOBAL.USER_ID,

3423: -- KART.SCN_ID,
3424: FND_GLOBAL.LOGIN_ID,
3425: FND_GLOBAL.USER_ID,
3426: SYSDATE,
3427: FND_GLOBAL.USER_ID,
3428: SYSDATE
3429: FROM OKC_K_ARTICLES_B KART,
3430: OKC_ARTICLES_ALL ART,
3431: OKC_ARTICLE_VERSIONS VER

Line 3495: FND_GLOBAL.LOGIN_ID,

3491: WHERE PARENT.OBJECT_ID = SCN.SCN_ID
3492: AND PARENT.DOCUMENT_TYPE = p_document_type
3493: AND PARENT.DOCUMENT_ID = p_document_id)
3494: ),
3495: FND_GLOBAL.LOGIN_ID,
3496: FND_GLOBAL.USER_ID,
3497: SYSDATE,
3498: FND_GLOBAL.USER_ID,
3499: SYSDATE

Line 3496: FND_GLOBAL.USER_ID,

3492: AND PARENT.DOCUMENT_TYPE = p_document_type
3493: AND PARENT.DOCUMENT_ID = p_document_id)
3494: ),
3495: FND_GLOBAL.LOGIN_ID,
3496: FND_GLOBAL.USER_ID,
3497: SYSDATE,
3498: FND_GLOBAL.USER_ID,
3499: SYSDATE
3500: FROM OKC_SECTIONS_B SCN

Line 3498: FND_GLOBAL.USER_ID,

3494: ),
3495: FND_GLOBAL.LOGIN_ID,
3496: FND_GLOBAL.USER_ID,
3497: SYSDATE,
3498: FND_GLOBAL.USER_ID,
3499: SYSDATE
3500: FROM OKC_SECTIONS_B SCN
3501: WHERE SCN.DOCUMENT_ID = P_DOCUMENT_ID
3502: AND SCN.DOCUMENT_TYPE = P_DOCUMENT_TYPE

Line 3990: p_locked_by_user_id => FND_GLOBAL.user_id);

3986: x_msg_data => x_msg_data,
3987: p_document_type => p_document_type,
3988: p_document_id => p_document_id,
3989: p_lock_terms_flag => 'Y',
3990: p_locked_by_user_id => FND_GLOBAL.user_id);
3991:
3992: open current_num_scheme;
3993: fetch current_num_scheme into l_doc_num_scheme;
3994: close current_num_scheme;

Line 4218: FND_GLOBAL.LOGIN_ID,

4214: 'ADDED',
4215: NULL,
4216: NULL,
4217: p_new_parent_id,
4218: FND_GLOBAL.LOGIN_ID,
4219: FND_GLOBAL.USER_ID,
4220: SYSDATE,
4221: FND_GLOBAL.USER_ID,
4222: SYSDATE

Line 4219: FND_GLOBAL.USER_ID,

4215: NULL,
4216: NULL,
4217: p_new_parent_id,
4218: FND_GLOBAL.LOGIN_ID,
4219: FND_GLOBAL.USER_ID,
4220: SYSDATE,
4221: FND_GLOBAL.USER_ID,
4222: SYSDATE
4223: FROM dual);

Line 4221: FND_GLOBAL.USER_ID,

4217: p_new_parent_id,
4218: FND_GLOBAL.LOGIN_ID,
4219: FND_GLOBAL.USER_ID,
4220: SYSDATE,
4221: FND_GLOBAL.USER_ID,
4222: SYSDATE
4223: FROM dual);
4224:
4225: --------------------------------------------