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

Line 381: X_CREATED_BY => FND_GLOBAL.User_id,

377: X_from_entity_name => G_ENTITY_NAME,
378: X_from_pk1_value => delRecord.deliverable_id,
379: X_to_entity_name => G_ENTITY_NAME,
380: X_to_pk1_value => to_char(delInstanceRecTab(j).deliverable_id),
381: X_CREATED_BY => FND_GLOBAL.User_id,
382: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
383: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'6012: Done Copy Attachments ');
385: END IF;

Line 382: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);

378: X_from_pk1_value => delRecord.deliverable_id,
379: X_to_entity_name => G_ENTITY_NAME,
380: X_to_pk1_value => to_char(delInstanceRecTab(j).deliverable_id),
381: X_CREATED_BY => FND_GLOBAL.User_id,
382: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
383: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'6012: Done Copy Attachments ');
385: END IF;
386:

Line 396: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;

392: delStsTab(st_hist_count).deliverable_status:= 'INACTIVE';
393: delStsTab(st_hist_count).status_change_date:= sysdate;
394: delStsTab(st_hist_count).status_change_notes:= null;
395: delStsTab(st_hist_count).object_version_number:= 1;
396: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
397: delStsTab(st_hist_count).creation_date := sysdate;
398: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
399: delStsTab(st_hist_count).last_update_date := sysdate;
400: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;

Line 398: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;

394: delStsTab(st_hist_count).status_change_notes:= null;
395: delStsTab(st_hist_count).object_version_number:= 1;
396: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
397: delStsTab(st_hist_count).creation_date := sysdate;
398: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
399: delStsTab(st_hist_count).last_update_date := sysdate;
400: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;
401:
402: --- set the status, if required from updateDeliverables

Line 400: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;

396: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
397: delStsTab(st_hist_count).creation_date := sysdate;
398: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
399: delStsTab(st_hist_count).last_update_date := sysdate;
400: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;
401:
402: --- set the status, if required from updateDeliverables
403: IF (p_change_status_to is not null) AND (p_change_status_to = 'OPEN') THEN
404:

Line 425: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;

421: delStsTab1(st_hist_count1).deliverable_status:= p_change_status_to;
422: delStsTab1(st_hist_count1).status_change_date:= sysdate;
423: delStsTab1(st_hist_count1).status_change_notes:= null;
424: delStsTab1(st_hist_count1).object_version_number:= 1;
425: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
426: delStsTab1(st_hist_count1).creation_date := sysdate;
427: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
428: delStsTab1(st_hist_count1).last_update_date := sysdate;
429: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;

Line 427: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;

423: delStsTab1(st_hist_count1).status_change_notes:= null;
424: delStsTab1(st_hist_count1).object_version_number:= 1;
425: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
426: delStsTab1(st_hist_count1).creation_date := sysdate;
427: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
428: delStsTab1(st_hist_count1).last_update_date := sysdate;
429: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;
430:
431: END IF;

Line 429: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;

425: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
426: delStsTab1(st_hist_count1).creation_date := sysdate;
427: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
428: delStsTab1(st_hist_count1).last_update_date := sysdate;
429: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;
430:
431: END IF;
432: --- set object version number
433: delInstanceRecTab(j).object_version_number:= 1;

Line 436: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;

432: --- set object version number
433: delInstanceRecTab(j).object_version_number:= 1;
434:
435: --- set who columns
436: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
437: delInstanceRecTab(j).creation_date := sysdate;
438: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
439: delInstanceRecTab(j).last_update_date := sysdate;
440: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;

Line 438: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;

434:
435: --- set who columns
436: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
437: delInstanceRecTab(j).creation_date := sysdate;
438: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
439: delInstanceRecTab(j).last_update_date := sysdate;
440: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;
441: /* Bug 10048345*/
442: ELSE

Line 440: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;

436: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
437: delInstanceRecTab(j).creation_date := sysdate;
438: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
439: delInstanceRecTab(j).last_update_date := sysdate;
440: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;
441: /* Bug 10048345*/
442: ELSE
443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'####1'||del_find_rec.deliverable_id||'##2'||del_find_rec.ACTUAL_DUE_DATE||'#3'||del_find_rec.RECURRING_DEL_PARENT_ID);

Line 1943: last_updated_by= Fnd_Global.User_Id,

1939: SET
1940: actual_due_date = deliverableDueDates(i),
1941: start_event_date = deliverableStartEventDates(i),
1942: end_event_date = deliverableEndEventDates(i),
1943: last_updated_by= Fnd_Global.User_Id,
1944: last_update_date = sysdate,
1945: last_update_login = Fnd_Global.Login_Id
1946: WHERE deliverable_id = deliverableIds(i);
1947: END IF;

Line 1945: last_update_login = Fnd_Global.Login_Id

1941: start_event_date = deliverableStartEventDates(i),
1942: end_event_date = deliverableEndEventDates(i),
1943: last_updated_by= Fnd_Global.User_Id,
1944: last_update_date = sysdate,
1945: last_update_login = Fnd_Global.Login_Id
1946: WHERE deliverable_id = deliverableIds(i);
1947: END IF;
1948: IF del_cur %ISOPEN THEN
1949: CLOSE del_cur ;

Line 2723: last_updated_by= Fnd_Global.User_Id,

2719: SET
2720: actual_due_date = deliverableDueDates(i),
2721: start_event_date = deliverableStartEventDates(i),
2722: end_event_date = deliverableEndEventDates(i),
2723: last_updated_by= Fnd_Global.User_Id,
2724: last_update_date = sysdate,
2725: last_update_login = Fnd_Global.Login_Id
2726: WHERE deliverable_id = deliverableIds(i);
2727: END IF;

Line 2725: last_update_login = Fnd_Global.Login_Id

2721: start_event_date = deliverableStartEventDates(i),
2722: end_event_date = deliverableEndEventDates(i),
2723: last_updated_by= Fnd_Global.User_Id,
2724: last_update_date = sysdate,
2725: last_update_login = Fnd_Global.Login_Id
2726: WHERE deliverable_id = deliverableIds(i);
2727: END IF;
2728:
2729: IF del_cur %ISOPEN THEN

Line 3234: last_updated_by= Fnd_Global.User_Id,

3230: x_return_status := FND_API.G_RET_STS_SUCCESS;
3231:
3232: UPDATE OKC_DELIVERABLES
3233: set internal_party_contact_id = p_new_buyer_id,
3234: last_updated_by= Fnd_Global.User_Id,
3235: last_update_date = sysdate,
3236: last_update_login=Fnd_Global.Login_Id
3237: WHERE business_document_id = p_bus_doc_id
3238: AND business_document_type = p_bus_doc_type

Line 3236: last_update_login=Fnd_Global.Login_Id

3232: UPDATE OKC_DELIVERABLES
3233: set internal_party_contact_id = p_new_buyer_id,
3234: last_updated_by= Fnd_Global.User_Id,
3235: last_update_date = sysdate,
3236: last_update_login=Fnd_Global.Login_Id
3237: WHERE business_document_id = p_bus_doc_id
3238: AND business_document_type = p_bus_doc_type
3239: AND business_document_version = p_bus_doc_version
3240: AND internal_party_contact_id = p_original_buyer_id;

Line 3346: last_updated_by= Fnd_Global.User_Id,

3342: --- bulk update for deliverables actual due date
3343: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3344: UPDATE OKC_DELIVERABLES
3345: set internal_party_contact_id = p_new_buyer_id,
3346: last_updated_by= Fnd_Global.User_Id,
3347: last_update_date = sysdate,
3348: last_update_login=Fnd_Global.Login_Id
3349: WHERE internal_party_contact_id = p_original_buyer_id
3350: AND business_document_id = l_bus_doc_ids(j)

Line 3348: last_update_login=Fnd_Global.Login_Id

3344: UPDATE OKC_DELIVERABLES
3345: set internal_party_contact_id = p_new_buyer_id,
3346: last_updated_by= Fnd_Global.User_Id,
3347: last_update_date = sysdate,
3348: last_update_login=Fnd_Global.Login_Id
3349: WHERE internal_party_contact_id = p_original_buyer_id
3350: AND business_document_id = l_bus_doc_ids(j)
3351: AND business_document_type = l_bus_doc_types(j)
3352: AND business_document_version = l_bus_doc_versions(j);

Line 3555: last_updated_by= Fnd_Global.User_Id,

3551:
3552: --bug#4154567 update -99 version aswell
3553: UPDATE OKC_DELIVERABLES
3554: set internal_party_contact_id = p_new_internal_contact_id,
3555: last_updated_by= Fnd_Global.User_Id,
3556: last_update_date = sysdate,
3557: last_update_login=Fnd_Global.Login_Id
3558: WHERE business_document_id = p_bus_doc_id
3559: AND business_document_type = p_bus_doc_type

Line 3557: last_update_login=Fnd_Global.Login_Id

3553: UPDATE OKC_DELIVERABLES
3554: set internal_party_contact_id = p_new_internal_contact_id,
3555: last_updated_by= Fnd_Global.User_Id,
3556: last_update_date = sysdate,
3557: last_update_login=Fnd_Global.Login_Id
3558: WHERE business_document_id = p_bus_doc_id
3559: AND business_document_type = p_bus_doc_type
3560: AND business_document_version IN (-99, p_bus_doc_version)
3561: AND internal_party_contact_id = p_original_internal_contact_id;

Line 3669: last_updated_by= Fnd_Global.User_Id,

3665: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3666: --bug#4154567 update -99 version aswell
3667: UPDATE OKC_DELIVERABLES
3668: set internal_party_contact_id = p_new_internal_contact_id,
3669: last_updated_by= Fnd_Global.User_Id,
3670: last_update_date = sysdate,
3671: last_update_login=Fnd_Global.Login_Id
3672: WHERE internal_party_contact_id = p_original_internal_contact_id
3673: AND business_document_id = l_bus_doc_ids(j)

Line 3671: last_update_login=Fnd_Global.Login_Id

3667: UPDATE OKC_DELIVERABLES
3668: set internal_party_contact_id = p_new_internal_contact_id,
3669: last_updated_by= Fnd_Global.User_Id,
3670: last_update_date = sysdate,
3671: last_update_login=Fnd_Global.Login_Id
3672: WHERE internal_party_contact_id = p_original_internal_contact_id
3673: AND business_document_id = l_bus_doc_ids(j)
3674: AND business_document_type = l_bus_doc_types(j)
3675: AND business_document_version IN (l_bus_doc_versions(j),-99);

Line 3766: last_updated_by= Fnd_Global.User_Id,

3762:
3763: UPDATE OKC_DELIVERABLES
3764: SET external_party_id = p_external_party_id,
3765: external_party_site_id = p_external_party_site_id,
3766: last_updated_by= Fnd_Global.User_Id,
3767: last_update_date = sysdate,
3768: last_update_login=Fnd_Global.Login_Id
3769: WHERE business_document_id = p_bus_doc_id
3770: AND business_document_type = p_bus_doc_type

Line 3768: last_update_login=Fnd_Global.Login_Id

3764: SET external_party_id = p_external_party_id,
3765: external_party_site_id = p_external_party_site_id,
3766: last_updated_by= Fnd_Global.User_Id,
3767: last_update_date = sysdate,
3768: last_update_login=Fnd_Global.Login_Id
3769: WHERE business_document_id = p_bus_doc_id
3770: AND business_document_type = p_bus_doc_type
3771: AND business_document_version = -99;
3772:

Line 3907: last_updated_by= Fnd_Global.User_Id,

3903: FORALL i IN delIdTab.FIRST..delIdTab.LAST
3904: UPDATE okc_deliverables
3905: SET external_party_id = p_to_external_party_id,
3906: external_party_site_id = delExtSiteIdTab(i),
3907: last_updated_by= Fnd_Global.User_Id,
3908: last_update_date = sysdate,
3909: last_update_login=Fnd_Global.Login_Id
3910: WHERE deliverable_id = delIdTab(i);
3911: END IF;

Line 3909: last_update_login=Fnd_Global.Login_Id

3905: SET external_party_id = p_to_external_party_id,
3906: external_party_site_id = delExtSiteIdTab(i),
3907: last_updated_by= Fnd_Global.User_Id,
3908: last_update_date = sysdate,
3909: last_update_login=Fnd_Global.Login_Id
3910: WHERE deliverable_id = delIdTab(i);
3911: END IF;
3912: IF del_cur %ISOPEN THEN
3913: CLOSE del_cur ;

Line 4082: delStsTab(k).status_changed_by := fnd_global.user_id;

4078:
4079: --add to status history table
4080: delStsTab(k).deliverable_id := del_rec.deliverable_id;
4081: delStsTab(k).deliverable_status := del_rec.deliverable_status;
4082: delStsTab(k).status_changed_by := fnd_global.user_id;
4083: delStsTab(k).status_change_date := sysdate;
4084: delStsTab(k).status_change_notes := del_rec.status_change_notes;
4085: delStsTab(k).object_version_number := 1;
4086: delStsTab(k).created_by := fnd_global.user_id;

Line 4086: delStsTab(k).created_by := fnd_global.user_id;

4082: delStsTab(k).status_changed_by := fnd_global.user_id;
4083: delStsTab(k).status_change_date := sysdate;
4084: delStsTab(k).status_change_notes := del_rec.status_change_notes;
4085: delStsTab(k).object_version_number := 1;
4086: delStsTab(k).created_by := fnd_global.user_id;
4087: delStsTab(k).creation_date := sysdate;
4088: delStsTab(k).last_update_date := sysdate;
4089: delStsTab(k).last_updated_by := fnd_global.user_id;
4090: delStsTab(k).last_update_login := fnd_global.login_Id;

Line 4089: delStsTab(k).last_updated_by := fnd_global.user_id;

4085: delStsTab(k).object_version_number := 1;
4086: delStsTab(k).created_by := fnd_global.user_id;
4087: delStsTab(k).creation_date := sysdate;
4088: delStsTab(k).last_update_date := sysdate;
4089: delStsTab(k).last_updated_by := fnd_global.user_id;
4090: delStsTab(k).last_update_login := fnd_global.login_Id;
4091:
4092: --if necessary, send notification
4093: if ('Y' = del_rec.notify_completed_yn) then

Line 4090: delStsTab(k).last_update_login := fnd_global.login_Id;

4086: delStsTab(k).created_by := fnd_global.user_id;
4087: delStsTab(k).creation_date := sysdate;
4088: delStsTab(k).last_update_date := sysdate;
4089: delStsTab(k).last_updated_by := fnd_global.user_id;
4090: delStsTab(k).last_update_login := fnd_global.login_Id;
4091:
4092: --if necessary, send notification
4093: if ('Y' = del_rec.notify_completed_yn) then
4094: select OKC_WF_NOTIFY_S1.nextval into l_key from dual;

Line 4461: last_updated_by= Fnd_Global.User_Id,

4457: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4458: UPDATE okc_deliverables
4459: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4460: external_party_site_id = p_to_external_party_site_id,
4461: last_updated_by= Fnd_Global.User_Id,
4462: last_update_date = sysdate,
4463: last_update_login=Fnd_Global.Login_Id
4464: WHERE deliverable_id = delIdTab(i);
4465: END IF;

Line 4463: last_update_login=Fnd_Global.Login_Id

4459: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4460: external_party_site_id = p_to_external_party_site_id,
4461: last_updated_by= Fnd_Global.User_Id,
4462: last_update_date = sysdate,
4463: last_update_login=Fnd_Global.Login_Id
4464: WHERE deliverable_id = delIdTab(i);
4465: END IF;
4466: IF del_cur %ISOPEN THEN
4467: CLOSE del_cur ;