DBA Data[Home] [Help]

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 2518: SET scn.last_updated_by = fnd_global.user_id,

2514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2515: END IF;
2516:
2517: UPDATE okc_sections_b scn
2518: SET scn.last_updated_by = fnd_global.user_id,
2519: scn.last_update_date = sysdate,
2520: scn.amendment_operation_code = 'DELETED',
2521: scn.summary_amend_operation_code =
2522: okc_terms_util_pvt.get_summary_amend_code(

Line 2526: scn.last_amended_by = fnd_global.user_id,

2522: okc_terms_util_pvt.get_summary_amend_code(
2523: scn.summary_amend_operation_code,
2524: scn.amendment_operation_code,
2525: 'DELETED'),
2526: scn.last_amended_by = fnd_global.user_id,
2527: scn.last_amendment_date = sysdate
2528: WHERE scn.id = obj_ids(i);
2529: ELSE
2530:

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

2562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2563: END IF;
2564:
2565: UPDATE okc_k_articles_b kart
2566: SET kart.last_updated_by = fnd_global.user_id,
2567: kart.last_update_date = sysdate,
2568: kart.amendment_operation_code = 'DELETED',
2569: kart.summary_amend_operation_code =
2570: okc_terms_util_pvt.get_summary_amend_code(

Line 2574: kart.last_amended_by = fnd_global.user_id,

2570: okc_terms_util_pvt.get_summary_amend_code(
2571: kart.summary_amend_operation_code,
2572: kart.amendment_operation_code,
2573: 'DELETED'),
2574: kart.last_amended_by = fnd_global.user_id,
2575: kart.last_amendment_date = sysdate
2576: WHERE kart.id = obj_ids(i);
2577: ELSE
2578:

Line 3370: FND_GLOBAL.LOGIN_ID,

3366: null,
3367: null,
3368: null,
3369: null,
3370: FND_GLOBAL.LOGIN_ID,
3371: FND_GLOBAL.USER_ID,
3372: SYSDATE,
3373: FND_GLOBAL.USER_ID,
3374: SYSDATE from dual);

Line 3371: FND_GLOBAL.USER_ID,

3367: null,
3368: null,
3369: null,
3370: FND_GLOBAL.LOGIN_ID,
3371: FND_GLOBAL.USER_ID,
3372: SYSDATE,
3373: FND_GLOBAL.USER_ID,
3374: SYSDATE from dual);
3375:

Line 3373: FND_GLOBAL.USER_ID,

3369: null,
3370: FND_GLOBAL.LOGIN_ID,
3371: FND_GLOBAL.USER_ID,
3372: SYSDATE,
3373: FND_GLOBAL.USER_ID,
3374: SYSDATE from dual);
3375:
3376: END IF;
3377: CLOSE check_document_row_exists;

Line 3536: FND_GLOBAL.LOGIN_ID,

3532: WHERE PARENT.OBJECT_ID = KART.SCN_ID
3533: AND PARENT.DOCUMENT_TYPE = p_document_type
3534: AND PARENT.DOCUMENT_ID = p_document_id),
3535: -- KART.SCN_ID,
3536: FND_GLOBAL.LOGIN_ID,
3537: FND_GLOBAL.USER_ID,
3538: SYSDATE,
3539: FND_GLOBAL.USER_ID,
3540: SYSDATE

Line 3537: FND_GLOBAL.USER_ID,

3533: AND PARENT.DOCUMENT_TYPE = p_document_type
3534: AND PARENT.DOCUMENT_ID = p_document_id),
3535: -- KART.SCN_ID,
3536: FND_GLOBAL.LOGIN_ID,
3537: FND_GLOBAL.USER_ID,
3538: SYSDATE,
3539: FND_GLOBAL.USER_ID,
3540: SYSDATE
3541: FROM OKC_K_ARTICLES_B KART,

Line 3539: FND_GLOBAL.USER_ID,

3535: -- KART.SCN_ID,
3536: FND_GLOBAL.LOGIN_ID,
3537: FND_GLOBAL.USER_ID,
3538: SYSDATE,
3539: FND_GLOBAL.USER_ID,
3540: SYSDATE
3541: FROM OKC_K_ARTICLES_B KART,
3542: OKC_ARTICLES_ALL ART,
3543: OKC_ARTICLE_VERSIONS VER

Line 3607: FND_GLOBAL.LOGIN_ID,

3603: WHERE PARENT.OBJECT_ID = SCN.SCN_ID
3604: AND PARENT.DOCUMENT_TYPE = p_document_type
3605: AND PARENT.DOCUMENT_ID = p_document_id)
3606: ),
3607: FND_GLOBAL.LOGIN_ID,
3608: FND_GLOBAL.USER_ID,
3609: SYSDATE,
3610: FND_GLOBAL.USER_ID,
3611: SYSDATE

Line 3608: FND_GLOBAL.USER_ID,

3604: AND PARENT.DOCUMENT_TYPE = p_document_type
3605: AND PARENT.DOCUMENT_ID = p_document_id)
3606: ),
3607: FND_GLOBAL.LOGIN_ID,
3608: FND_GLOBAL.USER_ID,
3609: SYSDATE,
3610: FND_GLOBAL.USER_ID,
3611: SYSDATE
3612: FROM OKC_SECTIONS_B SCN

Line 3610: FND_GLOBAL.USER_ID,

3606: ),
3607: FND_GLOBAL.LOGIN_ID,
3608: FND_GLOBAL.USER_ID,
3609: SYSDATE,
3610: FND_GLOBAL.USER_ID,
3611: SYSDATE
3612: FROM OKC_SECTIONS_B SCN
3613: WHERE SCN.DOCUMENT_ID = P_DOCUMENT_ID
3614: AND SCN.DOCUMENT_TYPE = P_DOCUMENT_TYPE

Line 4151: p_locked_by_user_id => FND_GLOBAL.user_id);

4147: x_msg_data => x_msg_data,
4148: p_document_type => p_document_type,
4149: p_document_id => p_document_id,
4150: p_lock_terms_flag => 'Y',
4151: p_locked_by_user_id => FND_GLOBAL.user_id);
4152:
4153: open current_num_scheme;
4154: fetch current_num_scheme into l_doc_num_scheme;
4155: close current_num_scheme;

Line 4379: FND_GLOBAL.LOGIN_ID,

4375: 'ADDED',
4376: NULL,
4377: NULL,
4378: p_new_parent_id,
4379: FND_GLOBAL.LOGIN_ID,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: SYSDATE

Line 4380: FND_GLOBAL.USER_ID,

4376: NULL,
4377: NULL,
4378: p_new_parent_id,
4379: FND_GLOBAL.LOGIN_ID,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: SYSDATE
4384: FROM dual);

Line 4382: FND_GLOBAL.USER_ID,

4378: p_new_parent_id,
4379: FND_GLOBAL.LOGIN_ID,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: SYSDATE
4384: FROM dual);
4385:
4386: --------------------------------------------