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.

[Home] [Help]

APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on FND_GLOBAL

Line 361: X_CREATED_BY => FND_GLOBAL.User_id,

357: X_from_entity_name => G_ENTITY_NAME,
358: X_from_pk1_value => delRecord.deliverable_id,
359: X_to_entity_name => G_ENTITY_NAME,
360: X_to_pk1_value => to_char(delInstanceRecTab(j).deliverable_id),
361: X_CREATED_BY => FND_GLOBAL.User_id,
362: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'6012: Done Copy Attachments ');
365: END IF;

Line 362: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);

358: X_from_pk1_value => delRecord.deliverable_id,
359: X_to_entity_name => G_ENTITY_NAME,
360: X_to_pk1_value => to_char(delInstanceRecTab(j).deliverable_id),
361: X_CREATED_BY => FND_GLOBAL.User_id,
362: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'6012: Done Copy Attachments ');
365: END IF;
366:

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

372: delStsTab(st_hist_count).deliverable_status:= 'INACTIVE';
373: delStsTab(st_hist_count).status_change_date:= sysdate;
374: delStsTab(st_hist_count).status_change_notes:= null;
375: delStsTab(st_hist_count).object_version_number:= 1;
376: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
377: delStsTab(st_hist_count).creation_date := sysdate;
378: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
379: delStsTab(st_hist_count).last_update_date := sysdate;
380: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;

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

374: delStsTab(st_hist_count).status_change_notes:= null;
375: delStsTab(st_hist_count).object_version_number:= 1;
376: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
377: delStsTab(st_hist_count).creation_date := sysdate;
378: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
379: delStsTab(st_hist_count).last_update_date := sysdate;
380: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;
381:
382: --- set the status, if required from updateDeliverables

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

376: delStsTab(st_hist_count).created_by:= Fnd_Global.User_Id;
377: delStsTab(st_hist_count).creation_date := sysdate;
378: delStsTab(st_hist_count).last_updated_by:= Fnd_Global.User_Id;
379: delStsTab(st_hist_count).last_update_date := sysdate;
380: delStsTab(st_hist_count).last_update_login := Fnd_Global.Login_Id;
381:
382: --- set the status, if required from updateDeliverables
383: IF (p_change_status_to is not null) AND (p_change_status_to = 'OPEN') THEN
384:

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

401: delStsTab1(st_hist_count1).deliverable_status:= p_change_status_to;
402: delStsTab1(st_hist_count1).status_change_date:= sysdate;
403: delStsTab1(st_hist_count1).status_change_notes:= null;
404: delStsTab1(st_hist_count1).object_version_number:= 1;
405: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
406: delStsTab1(st_hist_count1).creation_date := sysdate;
407: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
408: delStsTab1(st_hist_count1).last_update_date := sysdate;
409: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;

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

403: delStsTab1(st_hist_count1).status_change_notes:= null;
404: delStsTab1(st_hist_count1).object_version_number:= 1;
405: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
406: delStsTab1(st_hist_count1).creation_date := sysdate;
407: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
408: delStsTab1(st_hist_count1).last_update_date := sysdate;
409: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;
410:
411: END IF;

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

405: delStsTab1(st_hist_count1).created_by:= Fnd_Global.User_Id;
406: delStsTab1(st_hist_count1).creation_date := sysdate;
407: delStsTab1(st_hist_count1).last_updated_by:= Fnd_Global.User_Id;
408: delStsTab1(st_hist_count1).last_update_date := sysdate;
409: delStsTab1(st_hist_count1).last_update_login := Fnd_Global.Login_Id;
410:
411: END IF;
412: --- set object version number
413: delInstanceRecTab(j).object_version_number:= 1;

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

412: --- set object version number
413: delInstanceRecTab(j).object_version_number:= 1;
414:
415: --- set who columns
416: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
417: delInstanceRecTab(j).creation_date := sysdate;
418: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
419: delInstanceRecTab(j).last_update_date := sysdate;
420: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;

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

414:
415: --- set who columns
416: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
417: delInstanceRecTab(j).creation_date := sysdate;
418: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
419: delInstanceRecTab(j).last_update_date := sysdate;
420: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;
421: END LOOP;
422: END IF;

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

416: delInstanceRecTab(j).created_by:= Fnd_Global.User_Id;
417: delInstanceRecTab(j).creation_date := sysdate;
418: delInstanceRecTab(j).last_updated_by:= Fnd_Global.User_Id;
419: delInstanceRecTab(j).last_update_date := sysdate;
420: delInstanceRecTab(j).last_update_login := Fnd_Global.Login_Id;
421: END LOOP;
422: END IF;
423:
424: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1840: last_updated_by= Fnd_Global.User_Id,

1836: SET
1837: actual_due_date = deliverableDueDates(i),
1838: start_event_date = deliverableStartEventDates(i),
1839: end_event_date = deliverableEndEventDates(i),
1840: last_updated_by= Fnd_Global.User_Id,
1841: last_update_date = sysdate,
1842: last_update_login = Fnd_Global.Login_Id
1843: WHERE deliverable_id = deliverableIds(i);
1844: END IF;

Line 1842: last_update_login = Fnd_Global.Login_Id

1838: start_event_date = deliverableStartEventDates(i),
1839: end_event_date = deliverableEndEventDates(i),
1840: last_updated_by= Fnd_Global.User_Id,
1841: last_update_date = sysdate,
1842: last_update_login = Fnd_Global.Login_Id
1843: WHERE deliverable_id = deliverableIds(i);
1844: END IF;
1845: IF del_cur %ISOPEN THEN
1846: CLOSE del_cur ;

Line 2603: last_updated_by= Fnd_Global.User_Id,

2599: SET
2600: actual_due_date = deliverableDueDates(i),
2601: start_event_date = deliverableStartEventDates(i),
2602: end_event_date = deliverableEndEventDates(i),
2603: last_updated_by= Fnd_Global.User_Id,
2604: last_update_date = sysdate,
2605: last_update_login = Fnd_Global.Login_Id
2606: WHERE deliverable_id = deliverableIds(i);
2607: END IF;

Line 2605: last_update_login = Fnd_Global.Login_Id

2601: start_event_date = deliverableStartEventDates(i),
2602: end_event_date = deliverableEndEventDates(i),
2603: last_updated_by= Fnd_Global.User_Id,
2604: last_update_date = sysdate,
2605: last_update_login = Fnd_Global.Login_Id
2606: WHERE deliverable_id = deliverableIds(i);
2607: END IF;
2608:
2609: IF del_cur %ISOPEN THEN

Line 3114: last_updated_by= Fnd_Global.User_Id,

3110: x_return_status := FND_API.G_RET_STS_SUCCESS;
3111:
3112: UPDATE OKC_DELIVERABLES
3113: set internal_party_contact_id = p_new_buyer_id,
3114: last_updated_by= Fnd_Global.User_Id,
3115: last_update_date = sysdate,
3116: last_update_login=Fnd_Global.Login_Id
3117: WHERE business_document_id = p_bus_doc_id
3118: AND business_document_type = p_bus_doc_type

Line 3116: last_update_login=Fnd_Global.Login_Id

3112: UPDATE OKC_DELIVERABLES
3113: set internal_party_contact_id = p_new_buyer_id,
3114: last_updated_by= Fnd_Global.User_Id,
3115: last_update_date = sysdate,
3116: last_update_login=Fnd_Global.Login_Id
3117: WHERE business_document_id = p_bus_doc_id
3118: AND business_document_type = p_bus_doc_type
3119: AND business_document_version = p_bus_doc_version
3120: AND internal_party_contact_id = p_original_buyer_id;

Line 3226: last_updated_by= Fnd_Global.User_Id,

3222: --- bulk update for deliverables actual due date
3223: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3224: UPDATE OKC_DELIVERABLES
3225: set internal_party_contact_id = p_new_buyer_id,
3226: last_updated_by= Fnd_Global.User_Id,
3227: last_update_date = sysdate,
3228: last_update_login=Fnd_Global.Login_Id
3229: WHERE internal_party_contact_id = p_original_buyer_id
3230: AND business_document_id = l_bus_doc_ids(j)

Line 3228: last_update_login=Fnd_Global.Login_Id

3224: UPDATE OKC_DELIVERABLES
3225: set internal_party_contact_id = p_new_buyer_id,
3226: last_updated_by= Fnd_Global.User_Id,
3227: last_update_date = sysdate,
3228: last_update_login=Fnd_Global.Login_Id
3229: WHERE internal_party_contact_id = p_original_buyer_id
3230: AND business_document_id = l_bus_doc_ids(j)
3231: AND business_document_type = l_bus_doc_types(j)
3232: AND business_document_version = l_bus_doc_versions(j);

Line 3435: last_updated_by= Fnd_Global.User_Id,

3431:
3432: --bug#4154567 update -99 version aswell
3433: UPDATE OKC_DELIVERABLES
3434: set internal_party_contact_id = p_new_internal_contact_id,
3435: last_updated_by= Fnd_Global.User_Id,
3436: last_update_date = sysdate,
3437: last_update_login=Fnd_Global.Login_Id
3438: WHERE business_document_id = p_bus_doc_id
3439: AND business_document_type = p_bus_doc_type

Line 3437: last_update_login=Fnd_Global.Login_Id

3433: UPDATE OKC_DELIVERABLES
3434: set internal_party_contact_id = p_new_internal_contact_id,
3435: last_updated_by= Fnd_Global.User_Id,
3436: last_update_date = sysdate,
3437: last_update_login=Fnd_Global.Login_Id
3438: WHERE business_document_id = p_bus_doc_id
3439: AND business_document_type = p_bus_doc_type
3440: AND business_document_version IN (-99, p_bus_doc_version)
3441: AND internal_party_contact_id = p_original_internal_contact_id;

Line 3549: last_updated_by= Fnd_Global.User_Id,

3545: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3546: --bug#4154567 update -99 version aswell
3547: UPDATE OKC_DELIVERABLES
3548: set internal_party_contact_id = p_new_internal_contact_id,
3549: last_updated_by= Fnd_Global.User_Id,
3550: last_update_date = sysdate,
3551: last_update_login=Fnd_Global.Login_Id
3552: WHERE internal_party_contact_id = p_original_internal_contact_id
3553: AND business_document_id = l_bus_doc_ids(j)

Line 3551: last_update_login=Fnd_Global.Login_Id

3547: UPDATE OKC_DELIVERABLES
3548: set internal_party_contact_id = p_new_internal_contact_id,
3549: last_updated_by= Fnd_Global.User_Id,
3550: last_update_date = sysdate,
3551: last_update_login=Fnd_Global.Login_Id
3552: WHERE internal_party_contact_id = p_original_internal_contact_id
3553: AND business_document_id = l_bus_doc_ids(j)
3554: AND business_document_type = l_bus_doc_types(j)
3555: AND business_document_version IN (l_bus_doc_versions(j),-99);

Line 3646: last_updated_by= Fnd_Global.User_Id,

3642:
3643: UPDATE OKC_DELIVERABLES
3644: SET external_party_id = p_external_party_id,
3645: external_party_site_id = p_external_party_site_id,
3646: last_updated_by= Fnd_Global.User_Id,
3647: last_update_date = sysdate,
3648: last_update_login=Fnd_Global.Login_Id
3649: WHERE business_document_id = p_bus_doc_id
3650: AND business_document_type = p_bus_doc_type

Line 3648: last_update_login=Fnd_Global.Login_Id

3644: SET external_party_id = p_external_party_id,
3645: external_party_site_id = p_external_party_site_id,
3646: last_updated_by= Fnd_Global.User_Id,
3647: last_update_date = sysdate,
3648: last_update_login=Fnd_Global.Login_Id
3649: WHERE business_document_id = p_bus_doc_id
3650: AND business_document_type = p_bus_doc_type
3651: AND business_document_version = -99;
3652:

Line 3787: last_updated_by= Fnd_Global.User_Id,

3783: FORALL i IN delIdTab.FIRST..delIdTab.LAST
3784: UPDATE okc_deliverables
3785: SET external_party_id = p_to_external_party_id,
3786: external_party_site_id = delExtSiteIdTab(i),
3787: last_updated_by= Fnd_Global.User_Id,
3788: last_update_date = sysdate,
3789: last_update_login=Fnd_Global.Login_Id
3790: WHERE deliverable_id = delIdTab(i);
3791: END IF;

Line 3789: last_update_login=Fnd_Global.Login_Id

3785: SET external_party_id = p_to_external_party_id,
3786: external_party_site_id = delExtSiteIdTab(i),
3787: last_updated_by= Fnd_Global.User_Id,
3788: last_update_date = sysdate,
3789: last_update_login=Fnd_Global.Login_Id
3790: WHERE deliverable_id = delIdTab(i);
3791: END IF;
3792: IF del_cur %ISOPEN THEN
3793: CLOSE del_cur ;

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

3954:
3955: --add to status history table
3956: delStsTab(k).deliverable_id := del_rec.deliverable_id;
3957: delStsTab(k).deliverable_status := del_rec.deliverable_status;
3958: delStsTab(k).status_changed_by := fnd_global.user_id;
3959: delStsTab(k).status_change_date := sysdate;
3960: delStsTab(k).status_change_notes := del_rec.status_change_notes;
3961: delStsTab(k).object_version_number := 1;
3962: delStsTab(k).created_by := fnd_global.user_id;

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

3958: delStsTab(k).status_changed_by := fnd_global.user_id;
3959: delStsTab(k).status_change_date := sysdate;
3960: delStsTab(k).status_change_notes := del_rec.status_change_notes;
3961: delStsTab(k).object_version_number := 1;
3962: delStsTab(k).created_by := fnd_global.user_id;
3963: delStsTab(k).creation_date := sysdate;
3964: delStsTab(k).last_update_date := sysdate;
3965: delStsTab(k).last_updated_by := fnd_global.user_id;
3966: delStsTab(k).last_update_login := fnd_global.login_Id;

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

3961: delStsTab(k).object_version_number := 1;
3962: delStsTab(k).created_by := fnd_global.user_id;
3963: delStsTab(k).creation_date := sysdate;
3964: delStsTab(k).last_update_date := sysdate;
3965: delStsTab(k).last_updated_by := fnd_global.user_id;
3966: delStsTab(k).last_update_login := fnd_global.login_Id;
3967:
3968: --if necessary, send notification
3969: if ('Y' = del_rec.notify_completed_yn) then

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

3962: delStsTab(k).created_by := fnd_global.user_id;
3963: delStsTab(k).creation_date := sysdate;
3964: delStsTab(k).last_update_date := sysdate;
3965: delStsTab(k).last_updated_by := fnd_global.user_id;
3966: delStsTab(k).last_update_login := fnd_global.login_Id;
3967:
3968: --if necessary, send notification
3969: if ('Y' = del_rec.notify_completed_yn) then
3970: select OKC_WF_NOTIFY_S1.nextval into l_key from dual;

Line 4316: last_updated_by= Fnd_Global.User_Id,

4312: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4313: UPDATE okc_deliverables
4314: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4315: external_party_site_id = p_to_external_party_site_id,
4316: last_updated_by= Fnd_Global.User_Id,
4317: last_update_date = sysdate,
4318: last_update_login=Fnd_Global.Login_Id
4319: WHERE deliverable_id = delIdTab(i);
4320: END IF;

Line 4318: last_update_login=Fnd_Global.Login_Id

4314: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4315: external_party_site_id = p_to_external_party_site_id,
4316: last_updated_by= Fnd_Global.User_Id,
4317: last_update_date = sysdate,
4318: last_update_login=Fnd_Global.Login_Id
4319: WHERE deliverable_id = delIdTab(i);
4320: END IF;
4321: IF del_cur %ISOPEN THEN
4322: CLOSE del_cur ;