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

Line 1259: X_CREATED_BY => FND_GLOBAL.User_id,

1255: X_from_entity_name => G_ENTITY_NAME,
1256: X_from_pk1_value => delIdTab(i).orig_del_id,
1257: X_to_entity_name => G_ENTITY_NAME,
1258: X_to_pk1_value => to_char(delIdTab(i).del_id),
1259: X_CREATED_BY => FND_GLOBAL.User_id,
1260: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
1261: );
1262: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'121: Attachments copied for delId: '||to_char(delIdTab(i).del_id));

Line 1260: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

1256: X_from_pk1_value => delIdTab(i).orig_del_id,
1257: X_to_entity_name => G_ENTITY_NAME,
1258: X_to_pk1_value => to_char(delIdTab(i).del_id),
1259: X_CREATED_BY => FND_GLOBAL.User_id,
1260: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
1261: );
1262: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'121: Attachments copied for delId: '||to_char(delIdTab(i).del_id));
1264: END IF;

Line 1951: WHERE fu.user_id = fnd_global.user_id

1947: --ER Structured Terms Authoring in Repository strivedi
1948: CURSOR getRepDefaultInternalContactId IS
1949: SELECT pf.person_id contact_id
1950: FROM per_all_workforce_v pf,fnd_user fu
1951: WHERE fu.user_id = fnd_global.user_id
1952: AND pf.person_id = fu.employee_id;
1953: l_rep_dflt_int_contact_id okc_deliverables.INTERNAL_PARTY_CONTACT_ID%TYPE;
1954: --End of ER Code Modifications
1955:

Line 2728: delNewTab(i).created_by:= Fnd_Global.User_Id;

2724: delNewTab(i).business_document_id := p_target_doc_id;
2725: delNewTab(i).business_document_type := p_target_doc_type;
2726: delNewTab(i).business_document_number := p_target_doc_number;
2727: delNewTab(i).business_document_version := -99;
2728: delNewTab(i).created_by:= Fnd_Global.User_Id;
2729: delNewTab(i).creation_date := sysdate;
2730: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2731: delNewTab(i).last_update_date := sysdate;
2732: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;

Line 2730: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;

2726: delNewTab(i).business_document_number := p_target_doc_number;
2727: delNewTab(i).business_document_version := -99;
2728: delNewTab(i).created_by:= Fnd_Global.User_Id;
2729: delNewTab(i).creation_date := sysdate;
2730: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2731: delNewTab(i).last_update_date := sysdate;
2732: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;
2733: /*bug#3631944 flush amendment attributes at the time of copy.
2734: Since the target document will be a new document.*/

Line 2732: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;

2728: delNewTab(i).created_by:= Fnd_Global.User_Id;
2729: delNewTab(i).creation_date := sysdate;
2730: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2731: delNewTab(i).last_update_date := sysdate;
2732: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;
2733: /*bug#3631944 flush amendment attributes at the time of copy.
2734: Since the target document will be a new document.*/
2735: delNewTab(i).amendment_operation := null;
2736: delNewTab(i).summary_amend_operation_code := null;

Line 2968: X_CREATED_BY => FND_GLOBAL.User_id,

2964: X_from_entity_name => G_ENTITY_NAME,
2965: X_from_pk1_value => delIdTab(i).orig_del_id,
2966: X_to_entity_name => G_ENTITY_NAME,
2967: X_to_pk1_value => to_char(delIdTab(i).del_id),
2968: X_CREATED_BY => FND_GLOBAL.User_id,
2969: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
2970: );
2971: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

Line 2969: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

2965: X_from_pk1_value => delIdTab(i).orig_del_id,
2966: X_to_entity_name => G_ENTITY_NAME,
2967: X_to_pk1_value => to_char(delIdTab(i).del_id),
2968: X_CREATED_BY => FND_GLOBAL.User_id,
2969: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
2970: );
2971: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
2973: '100: Done Copy Deliverable Attachments ');

Line 3416: delNewTab(j).created_by := FND_GLOBAL.User_id;

3412: -- End 3711754 reset the contact ids and notification attributes from the definition
3413:
3414: -- 3667445 Reset the creation_date and created_by for instances. 03-Jun-2004
3415: delNewTab(j).creation_date := sysdate;
3416: delNewTab(j).created_by := FND_GLOBAL.User_id;
3417:
3418: --bug 6055520
3419: delNewTab(j).ATTRIBUTE_CATEGORY := delRecTab(i).ATTRIBUTE_CATEGORY;
3420: delNewTab(j).ATTRIBUTE1 := delRecTab(i).ATTRIBUTE1;

Line 3693: -- delNewTab(j).created_by := FND_GLOBAL.User_id;

3689: FOR j IN delNewTab.FIRST..delNewTab.LAST LOOP
3690: --3667445 do not reset creation date for definitions, reset only for instances
3691: -- of recurring deliverables
3692: -- delNewTab(j).creation_date := sysdate;
3693: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3694: delNewTab(j).last_update_date := sysdate;
3695: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3696: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3697: --copy status history not done as status is not being changed here

Line 3695: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;

3691: -- of recurring deliverables
3692: -- delNewTab(j).creation_date := sysdate;
3693: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3694: delNewTab(j).last_update_date := sysdate;
3695: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3696: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3697: --copy status history not done as status is not being changed here
3698: --OPEN delStsHist(delNewTab(j).deliverable_id);
3699: /*FOR delStsHist_rec in delStsHist(delNewTab(j).deliverable_id) LOOP

Line 3696: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;

3692: -- delNewTab(j).creation_date := sysdate;
3693: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3694: delNewTab(j).last_update_date := sysdate;
3695: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3696: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3697: --copy status history not done as status is not being changed here
3698: --OPEN delStsHist(delNewTab(j).deliverable_id);
3699: /*FOR delStsHist_rec in delStsHist(delNewTab(j).deliverable_id) LOOP
3700: p := p+1;

Line 3724: delHistTab(j).created_by := FND_GLOBAL.User_id;

3720: /*IF delHistTab.COUNT <> 0 THEN
3721: FOR j IN delHistTab.FIRST..delHistTab.LAST LOOP
3722: delHistTab(j).deliverable_id := delNewTab(j).deliverable_id;
3723: delHistTab(j).creation_date := sysdate;
3724: delHistTab(j).created_by := FND_GLOBAL.User_id;
3725: delHistTab(j).last_update_date := sysdate;
3726: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3727: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3728: END LOOP;

Line 3726: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;

3722: delHistTab(j).deliverable_id := delNewTab(j).deliverable_id;
3723: delHistTab(j).creation_date := sysdate;
3724: delHistTab(j).created_by := FND_GLOBAL.User_id;
3725: delHistTab(j).last_update_date := sysdate;
3726: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3727: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3728: END LOOP;
3729: END IF;
3730: IF delStsHist%ISOPEN THEN

Line 3727: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;

3723: delHistTab(j).creation_date := sysdate;
3724: delHistTab(j).created_by := FND_GLOBAL.User_id;
3725: delHistTab(j).last_update_date := sysdate;
3726: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3727: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3728: END LOOP;
3729: END IF;
3730: IF delStsHist%ISOPEN THEN
3731: CLOSE delStsHist;

Line 3944: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;

3940: delHistTab(p).STATUS_CHANGED_BY := delStsHist_rec.STATUS_CHANGED_BY;
3941: delHistTab(p).STATUS_CHANGE_DATE := delStsHist_rec.STATUS_CHANGE_DATE;
3942: delHistTab(p).STATUS_CHANGE_NOTES := delStsHist_rec.STATUS_CHANGE_NOTES;
3943: delHistTab(p).OBJECT_VERSION_NUMBER := delStsHist_rec.OBJECT_VERSION_NUMBER;
3944: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
3945: delHistTab(p).CREATION_DATE := sysdate;
3946: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
3947: delHistTab(p).LAST_UPDATE_DATE := sysdate;
3948: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/

Line 3946: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;

3942: delHistTab(p).STATUS_CHANGE_NOTES := delStsHist_rec.STATUS_CHANGE_NOTES;
3943: delHistTab(p).OBJECT_VERSION_NUMBER := delStsHist_rec.OBJECT_VERSION_NUMBER;
3944: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
3945: delHistTab(p).CREATION_DATE := sysdate;
3946: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
3947: delHistTab(p).LAST_UPDATE_DATE := sysdate;
3948: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
3949:
3950: --insert into status history

Line 3948: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/

3944: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
3945: delHistTab(p).CREATION_DATE := sysdate;
3946: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
3947: delHistTab(p).LAST_UPDATE_DATE := sysdate;
3948: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
3949:
3950: --insert into status history
3951: INSERT INTO okc_del_status_history (
3952: deliverable_id,

Line 3970: FND_GLOBAL.User_id,

3966: delStsHist_rec.STATUS_CHANGED_BY,
3967: delStsHist_rec.STATUS_CHANGE_DATE,
3968: delStsHist_rec.STATUS_CHANGE_NOTES,
3969: delStsHist_rec.OBJECT_VERSION_NUMBER,
3970: FND_GLOBAL.User_id,
3971: sysdate,
3972: FND_GLOBAL.User_id,
3973: sysdate,
3974: Fnd_Global.Login_Id);

Line 3972: FND_GLOBAL.User_id,

3968: delStsHist_rec.STATUS_CHANGE_NOTES,
3969: delStsHist_rec.OBJECT_VERSION_NUMBER,
3970: FND_GLOBAL.User_id,
3971: sysdate,
3972: FND_GLOBAL.User_id,
3973: sysdate,
3974: Fnd_Global.Login_Id);
3975: END LOOP;
3976: IF delStsHist%ISOPEN THEN

Line 3974: Fnd_Global.Login_Id);

3970: FND_GLOBAL.User_id,
3971: sysdate,
3972: FND_GLOBAL.User_id,
3973: sysdate,
3974: Fnd_Global.Login_Id);
3975: END LOOP;
3976: IF delStsHist%ISOPEN THEN
3977: CLOSE delStsHist;
3978: END IF;

Line 3994: X_CREATED_BY => FND_GLOBAL.User_id,

3990: X_from_entity_name => G_ENTITY_NAME,
3991: X_from_pk1_value => delIdTab(j).orig_del_id,
3992: X_to_entity_name => G_ENTITY_NAME,
3993: X_to_pk1_value => to_char(delIdTab(j).del_id),
3994: X_CREATED_BY => FND_GLOBAL.User_id,
3995: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
3996: );
3997: END IF;
3998: END LOOP;

Line 3995: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

3991: X_from_pk1_value => delIdTab(j).orig_del_id,
3992: X_to_entity_name => G_ENTITY_NAME,
3993: X_to_pk1_value => to_char(delIdTab(j).del_id),
3994: X_CREATED_BY => FND_GLOBAL.User_id,
3995: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
3996: );
3997: END IF;
3998: END LOOP;
3999: END IF; -- delNewTab.COUNT

Line 4305: -- delNewTab(j).created_by := FND_GLOBAL.User_id;

4301: -- update the who columns
4302: FOR j IN delNewTab.FIRST..delNewTab.LAST LOOP
4303: -- do not reset the creation date bug#3641366
4304: -- delNewTab(j).creation_date := sysdate;
4305: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4306: delNewTab(j).last_update_date := sysdate;
4307: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4308: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4309: END LOOP;

Line 4307: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;

4303: -- do not reset the creation date bug#3641366
4304: -- delNewTab(j).creation_date := sysdate;
4305: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4306: delNewTab(j).last_update_date := sysdate;
4307: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4308: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4309: END LOOP;
4310: ------------------------------------------
4311:

Line 4308: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;

4304: -- delNewTab(j).creation_date := sysdate;
4305: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4306: delNewTab(j).last_update_date := sysdate;
4307: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4308: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4309: END LOOP;
4310: ------------------------------------------
4311:
4312:

Line 4515: X_CREATED_BY => FND_GLOBAL.User_id,

4511: X_from_entity_name => G_ENTITY_NAME,
4512: X_from_pk1_value => delIdTab(j).orig_del_id,
4513: X_to_entity_name => G_ENTITY_NAME,
4514: X_to_pk1_value => to_char(delIdTab(j).del_id),
4515: X_CREATED_BY => FND_GLOBAL.User_id,
4516: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4517: );
4518: END IF;
4519: END LOOP;

Line 4516: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

4512: X_from_pk1_value => delIdTab(j).orig_del_id,
4513: X_to_entity_name => G_ENTITY_NAME,
4514: X_to_pk1_value => to_char(delIdTab(j).del_id),
4515: X_CREATED_BY => FND_GLOBAL.User_id,
4516: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4517: );
4518: END IF;
4519: END LOOP;
4520:

Line 4538: last_updated_by= Fnd_Global.User_Id,

4534: END IF;
4535: UPDATE okc_deliverables SET amendment_operation = null,
4536: --amendment_notes = null,
4537: --last_amendment_date = null,
4538: last_updated_by= Fnd_Global.User_Id,
4539: last_update_date = sysdate,
4540: last_update_login=Fnd_Global.Login_Id
4541: WHERE deliverable_id = del_rec.deliverable_id;
4542:

Line 4540: last_update_login=Fnd_Global.Login_Id

4536: --amendment_notes = null,
4537: --last_amendment_date = null,
4538: last_updated_by= Fnd_Global.User_Id,
4539: last_update_date = sysdate,
4540: last_update_login=Fnd_Global.Login_Id
4541: WHERE deliverable_id = del_rec.deliverable_id;
4542:
4543: END LOOP;
4544: IF del_cur %ISOPEN THEN

Line 4673: last_updated_by= Fnd_Global.User_Id,

4669: -- to enable or disable deliverables link
4670: UPDATE okc_deliverables SET amendment_operation = null,
4671: summary_amend_operation_code = null,
4672: amendment_notes = null,
4673: last_updated_by= Fnd_Global.User_Id,
4674: last_update_date = sysdate,
4675: last_update_login=Fnd_Global.Login_Id
4676: WHERE deliverable_id = def_rec.deliverable_id;
4677: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4675: last_update_login=Fnd_Global.Login_Id

4671: summary_amend_operation_code = null,
4672: amendment_notes = null,
4673: last_updated_by= Fnd_Global.User_Id,
4674: last_update_date = sysdate,
4675: last_update_login=Fnd_Global.Login_Id
4676: WHERE deliverable_id = def_rec.deliverable_id;
4677: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4678: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4679: ,'100: updated deliverable: '||to_char(def_rec.deliverable_id));

Line 4698: last_updated_by= Fnd_Global.User_Id,

4694: where deliverable_id = def_rec.deliverable_id;
4695: ELSE
4696: -- clear only amendment_operation
4697: UPDATE okc_deliverables SET amendment_operation = null,
4698: last_updated_by= Fnd_Global.User_Id,
4699: last_update_date = sysdate,
4700: last_update_login=Fnd_Global.Login_Id
4701: WHERE deliverable_id = def_rec.deliverable_id;
4702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4700: last_update_login=Fnd_Global.Login_Id

4696: -- clear only amendment_operation
4697: UPDATE okc_deliverables SET amendment_operation = null,
4698: last_updated_by= Fnd_Global.User_Id,
4699: last_update_date = sysdate,
4700: last_update_login=Fnd_Global.Login_Id
4701: WHERE deliverable_id = def_rec.deliverable_id;
4702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4704: ,'100: updated deliverable: '||to_char(def_rec.deliverable_id));

Line 4774: last_updated_by= Fnd_Global.User_Id,

4770: FETCH del_cur BULK COLLECT INTO delIdTab;
4771: IF delIdTab.COUNT <> 0 THEN
4772: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4773: UPDATE okc_deliverables SET manage_yn = 'N',
4774: last_updated_by= Fnd_Global.User_Id,
4775: last_update_date = sysdate,
4776: last_update_login=Fnd_Global.Login_Id
4777: WHERE deliverable_id = delIdTab(i);
4778: END IF;

Line 4776: last_update_login=Fnd_Global.Login_Id

4772: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4773: UPDATE okc_deliverables SET manage_yn = 'N',
4774: last_updated_by= Fnd_Global.User_Id,
4775: last_update_date = sysdate,
4776: last_update_login=Fnd_Global.Login_Id
4777: WHERE deliverable_id = delIdTab(i);
4778: END IF;
4779: IF del_cur %ISOPEN THEN
4780: CLOSE del_cur ;

Line 4874: Fnd_Global.User_Id,

4870: null,
4871: sysdate,
4872: null,
4873: 1,
4874: Fnd_Global.User_Id,
4875: sysdate,
4876: Fnd_Global.User_Id,
4877: sysdate,
4878: Fnd_Global.Login_Id);

Line 4876: Fnd_Global.User_Id,

4872: null,
4873: 1,
4874: Fnd_Global.User_Id,
4875: sysdate,
4876: Fnd_Global.User_Id,
4877: sysdate,
4878: Fnd_Global.Login_Id);
4879:
4880: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4878: Fnd_Global.Login_Id);

4874: Fnd_Global.User_Id,
4875: sysdate,
4876: Fnd_Global.User_Id,
4877: sysdate,
4878: Fnd_Global.Login_Id);
4879:
4880: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4881: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving ');
4882: END IF;

Line 4991: delStsTab(j).created_by:= Fnd_Global.User_Id;

4987: delStsTab(j).deliverable_status:= p_new_status;
4988: delStsTab(j).status_change_date:= sysdate;
4989: delStsTab(j).status_change_notes:= null;
4990: delStsTab(j).object_version_number:= 1;
4991: delStsTab(j).created_by:= Fnd_Global.User_Id;
4992: delStsTab(j).creation_date := sysdate;
4993: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
4994: delStsTab(j).last_update_date := sysdate;
4995: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

Line 4993: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;

4989: delStsTab(j).status_change_notes:= null;
4990: delStsTab(j).object_version_number:= 1;
4991: delStsTab(j).created_by:= Fnd_Global.User_Id;
4992: delStsTab(j).creation_date := sysdate;
4993: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
4994: delStsTab(j).last_update_date := sysdate;
4995: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
4996: END LOOP;
4997:

Line 4995: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

4991: delStsTab(j).created_by:= Fnd_Global.User_Id;
4992: delStsTab(j).creation_date := sysdate;
4993: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
4994: delStsTab(j).last_update_date := sysdate;
4995: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
4996: END LOOP;
4997:
4998: --Bulk update of status in okc_deliverables
4999: FORALL i IN delIdTab.FIRST..delIdTab.LAST

Line 5004: last_updated_by= Fnd_Global.User_Id,

5000: UPDATE okc_deliverables
5001: SET
5002: deliverable_status = p_new_status,
5003: manage_yn = p_manage_yn,
5004: last_updated_by= Fnd_Global.User_Id,
5005: last_update_date = sysdate,
5006: last_update_login = Fnd_Global.Login_Id
5007: WHERE deliverable_id = delIdTab(i);
5008: --Bulk insert into status history

Line 5006: last_update_login = Fnd_Global.Login_Id

5002: deliverable_status = p_new_status,
5003: manage_yn = p_manage_yn,
5004: last_updated_by= Fnd_Global.User_Id,
5005: last_update_date = sysdate,
5006: last_update_login = Fnd_Global.Login_Id
5007: WHERE deliverable_id = delIdTab(i);
5008: --Bulk insert into status history
5009: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5010: /*code changed for 8i compatability bug#3307941

Line 5076: delStsTab(j).created_by:= Fnd_Global.User_Id;

5072: delStsTab(j).deliverable_status:= p_new_status;
5073: delStsTab(j).status_change_date:= sysdate;
5074: delStsTab(j).status_change_notes:= null;
5075: delStsTab(j).object_version_number:= 1;
5076: delStsTab(j).created_by:= Fnd_Global.User_Id;
5077: delStsTab(j).creation_date := sysdate;
5078: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5079: delStsTab(j).last_update_date := sysdate;
5080: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

Line 5078: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;

5074: delStsTab(j).status_change_notes:= null;
5075: delStsTab(j).object_version_number:= 1;
5076: delStsTab(j).created_by:= Fnd_Global.User_Id;
5077: delStsTab(j).creation_date := sysdate;
5078: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5079: delStsTab(j).last_update_date := sysdate;
5080: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5081: END LOOP;
5082:

Line 5080: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

5076: delStsTab(j).created_by:= Fnd_Global.User_Id;
5077: delStsTab(j).creation_date := sysdate;
5078: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5079: delStsTab(j).last_update_date := sysdate;
5080: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5081: END LOOP;
5082:
5083: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5084: -- BULK UPDATE of status

Line 5090: last_updated_by= Fnd_Global.User_Id,

5086: UPDATE okc_deliverables
5087: SET
5088: deliverable_status = p_new_status,
5089: manage_yn = 'N',
5090: last_updated_by= Fnd_Global.User_Id,
5091: last_update_date = sysdate,
5092: last_update_login = Fnd_Global.Login_Id
5093: WHERE deliverable_id = delIdTab(i);
5094:

Line 5092: last_update_login = Fnd_Global.Login_Id

5088: deliverable_status = p_new_status,
5089: manage_yn = 'N',
5090: last_updated_by= Fnd_Global.User_Id,
5091: last_update_date = sysdate,
5092: last_update_login = Fnd_Global.Login_Id
5093: WHERE deliverable_id = delIdTab(i);
5094:
5095: -- BULK INSERT into status history
5096: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP

Line 5397: last_updated_by = FND_GLOBAL.User_id,

5393:
5394: UPDATE okc_deliverables
5395: SET overdue_notification_id = overdue_ntf_ids(i),
5396: last_update_date = sysdate,
5397: last_updated_by = FND_GLOBAL.User_id,
5398: last_update_login =Fnd_Global.Login_Id
5399: WHERE deliverable_id = deliverable_ids(i);
5400:
5401: COMMIT;

Line 5398: last_update_login =Fnd_Global.Login_Id

5394: UPDATE okc_deliverables
5395: SET overdue_notification_id = overdue_ntf_ids(i),
5396: last_update_date = sysdate,
5397: last_updated_by = FND_GLOBAL.User_id,
5398: last_update_login =Fnd_Global.Login_Id
5399: WHERE deliverable_id = deliverable_ids(i);
5400:
5401: COMMIT;
5402:

Line 5741: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;

5737: j := j+1;
5738: delNtfTab(j) := delRecTab(i);
5739: delNtfTab(j).prior_notification_id := l_notification_id;
5740: delNtfTab(j).last_update_date := sysdate;
5741: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
5742: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
5743: ELSIF l_return_status <> 'S' THEN
5744: -- The return status is success because error notification has been
5745: -- sent to person who launched the concurrent request.

Line 5742: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;

5738: delNtfTab(j) := delRecTab(i);
5739: delNtfTab(j).prior_notification_id := l_notification_id;
5740: delNtfTab(j).last_update_date := sysdate;
5741: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
5742: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
5743: ELSIF l_return_status <> 'S' THEN
5744: -- The return status is success because error notification has been
5745: -- sent to person who launched the concurrent request.
5746: l_return_status := 'S';

Line 5763: last_updated_by = FND_GLOBAL.User_id,

5759: l_deliverable_id := delNtfTab(i).deliverable_id;*/
5760: UPDATE okc_deliverables
5761: SET prior_notification_id = delNtfTab(i).prior_notification_id,
5762: last_update_date = sysdate,
5763: last_updated_by = FND_GLOBAL.User_id,
5764: last_update_login =Fnd_Global.Login_Id
5765: where deliverable_id = delNtfTab(i).deliverable_id;
5766: END LOOP;
5767: COMMIT;

Line 5764: last_update_login =Fnd_Global.Login_Id

5760: UPDATE okc_deliverables
5761: SET prior_notification_id = delNtfTab(i).prior_notification_id,
5762: last_update_date = sysdate,
5763: last_updated_by = FND_GLOBAL.User_id,
5764: last_update_login =Fnd_Global.Login_Id
5765: where deliverable_id = delNtfTab(i).deliverable_id;
5766: END LOOP;
5767: COMMIT;
5768: END IF;

Line 6097: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;

6093: j := j+1;
6094: delNtfTab(j) := delRecTab(i);
6095: delNtfTab(j).escalation_notification_id := l_notification_id;
6096: delNtfTab(j).last_update_date := sysdate;
6097: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6098: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6099: ELSIF l_return_status <> 'S' THEN
6100: -- The return status is success because error notification has been
6101: -- sent to person who launched the concurrent request.

Line 6098: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;

6094: delNtfTab(j) := delRecTab(i);
6095: delNtfTab(j).escalation_notification_id := l_notification_id;
6096: delNtfTab(j).last_update_date := sysdate;
6097: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6098: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6099: ELSIF l_return_status <> 'S' THEN
6100: -- The return status is success because error notification has been
6101: -- sent to person who launched the concurrent request.
6102: l_return_status := 'S';

Line 6119: last_updated_by = FND_GLOBAL.User_id,

6115: l_deliverable_id := delNtfTab(i).deliverable_id;*/
6116: UPDATE okc_deliverables
6117: SET escalation_notification_id = delNtfTab(i).escalation_notification_id,
6118: last_update_date = sysdate,
6119: last_updated_by = FND_GLOBAL.User_id,
6120: last_update_login =Fnd_Global.Login_Id
6121: where deliverable_id = delNtfTab(i).deliverable_id;
6122: END LOOP;
6123: COMMIT;

Line 6120: last_update_login =Fnd_Global.Login_Id

6116: UPDATE okc_deliverables
6117: SET escalation_notification_id = delNtfTab(i).escalation_notification_id,
6118: last_update_date = sysdate,
6119: last_updated_by = FND_GLOBAL.User_id,
6120: last_update_login =Fnd_Global.Login_Id
6121: where deliverable_id = delNtfTab(i).deliverable_id;
6122: END LOOP;
6123: COMMIT;
6124: END IF;

Line 6494: last_updated_by= Fnd_Global.User_Id,

6490: IF delIdTab.COUNT <> 0 THEN
6491: FORALL j IN delIdTab.FIRST..delIdTab.LAST
6492: UPDATE okc_deliverables
6493: SET business_document_id = p_base_template_id,
6494: last_updated_by= Fnd_Global.User_Id,
6495: last_update_date = sysdate,
6496: last_update_login=Fnd_Global.Login_Id
6497: WHERE deliverable_id = delIdTab(j);
6498: END IF;

Line 6496: last_update_login=Fnd_Global.Login_Id

6492: UPDATE okc_deliverables
6493: SET business_document_id = p_base_template_id,
6494: last_updated_by= Fnd_Global.User_Id,
6495: last_update_date = sysdate,
6496: last_update_login=Fnd_Global.Login_Id
6497: WHERE deliverable_id = delIdTab(j);
6498: END IF;
6499: IF del_cur %ISOPEN THEN
6500: CLOSE del_cur ;

Line 10452: delNewTab(j).created_by:= Fnd_Global.User_Id;

10448: -- assign common attributes
10449: delNewTab(j).business_document_id := p_target_doc_id;
10450: delNewTab(j).business_document_type := p_target_doc_type;
10451: delNewTab(j).business_document_number := p_target_doc_number;
10452: delNewTab(j).created_by:= Fnd_Global.User_Id;
10453: delNewTab(j).creation_date := sysdate;
10454: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10455: delNewTab(j).last_update_date := sysdate;
10456: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

Line 10454: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;

10450: delNewTab(j).business_document_type := p_target_doc_type;
10451: delNewTab(j).business_document_number := p_target_doc_number;
10452: delNewTab(j).created_by:= Fnd_Global.User_Id;
10453: delNewTab(j).creation_date := sysdate;
10454: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10455: delNewTab(j).last_update_date := sysdate;
10456: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
10457: -- Check for instances on deliverable definition
10458: IF delRecTab(i).recurring_yn = 'Y' THEN

Line 10456: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

10452: delNewTab(j).created_by:= Fnd_Global.User_Id;
10453: delNewTab(j).creation_date := sysdate;
10454: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10455: delNewTab(j).last_update_date := sysdate;
10456: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
10457: -- Check for instances on deliverable definition
10458: IF delRecTab(i).recurring_yn = 'Y' THEN
10459:
10460: --Initialize the table with 0 rows

Line 10578: delNewTab(j).created_by:= Fnd_Global.User_Id;

10574: -- assign common attributes
10575: delNewTab(j).business_document_id := p_target_doc_id;
10576: delNewTab(j).business_document_type := p_target_doc_type;
10577: delNewTab(j).business_document_number := p_target_doc_number;
10578: delNewTab(j).created_by:= Fnd_Global.User_Id;
10579: delNewTab(j).creation_date := sysdate;
10580: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10581: delNewTab(j).last_update_date := sysdate;
10582: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

Line 10580: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;

10576: delNewTab(j).business_document_type := p_target_doc_type;
10577: delNewTab(j).business_document_number := p_target_doc_number;
10578: delNewTab(j).created_by:= Fnd_Global.User_Id;
10579: delNewTab(j).creation_date := sysdate;
10580: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10581: delNewTab(j).last_update_date := sysdate;
10582: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
10583:
10584: END LOOP; -- delInsTab.FIRST..delInsTab.LAST

Line 10582: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

10578: delNewTab(j).created_by:= Fnd_Global.User_Id;
10579: delNewTab(j).creation_date := sysdate;
10580: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
10581: delNewTab(j).last_update_date := sysdate;
10582: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
10583:
10584: END LOOP; -- delInsTab.FIRST..delInsTab.LAST
10585: END IF;--delInsTab.COUNT
10586:

Line 10817: FND_GLOBAL.User_id,

10813: delStsHist_rec.STATUS_CHANGED_BY,
10814: delStsHist_rec.STATUS_CHANGE_DATE,
10815: delStsHist_rec.STATUS_CHANGE_NOTES,
10816: delStsHist_rec.OBJECT_VERSION_NUMBER,
10817: FND_GLOBAL.User_id,
10818: sysdate,
10819: FND_GLOBAL.User_id,
10820: sysdate,
10821: Fnd_Global.Login_Id);

Line 10819: FND_GLOBAL.User_id,

10815: delStsHist_rec.STATUS_CHANGE_NOTES,
10816: delStsHist_rec.OBJECT_VERSION_NUMBER,
10817: FND_GLOBAL.User_id,
10818: sysdate,
10819: FND_GLOBAL.User_id,
10820: sysdate,
10821: Fnd_Global.Login_Id);
10822: END LOOP; -- delStsHist END LOOP;
10823: IF delStsHist%ISOPEN THEN

Line 10821: Fnd_Global.Login_Id);

10817: FND_GLOBAL.User_id,
10818: sysdate,
10819: FND_GLOBAL.User_id,
10820: sysdate,
10821: Fnd_Global.Login_Id);
10822: END LOOP; -- delStsHist END LOOP;
10823: IF delStsHist%ISOPEN THEN
10824: CLOSE delStsHist;
10825: END IF;

Line 10842: X_CREATED_BY => FND_GLOBAL.User_id,

10838: X_from_entity_name => G_ENTITY_NAME,
10839: X_from_pk1_value => delIdTab(i).orig_del_id,
10840: X_to_entity_name => G_ENTITY_NAME,
10841: X_to_pk1_value => to_char(delIdTab(i).del_id),
10842: X_CREATED_BY => FND_GLOBAL.User_id,
10843: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
10844: );
10845: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Done Copy Deliverable Attachments ');

Line 10843: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

10839: X_from_pk1_value => delIdTab(i).orig_del_id,
10840: X_to_entity_name => G_ENTITY_NAME,
10841: X_to_pk1_value => to_char(delIdTab(i).del_id),
10842: X_CREATED_BY => FND_GLOBAL.User_id,
10843: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
10844: );
10845: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Done Copy Deliverable Attachments ');
10847: END IF;

Line 11403: delNewTab(j).created_by:= Fnd_Global.User_Id;

11399: delNewTab(j).business_document_id := p_target_doc_id;
11400: delNewTab(j).business_document_type := p_target_doc_type;
11401: delNewTab(j).business_document_number := p_target_doc_number;
11402: delNewTab(j).business_document_version := -99;
11403: delNewTab(j).created_by:= Fnd_Global.User_Id;
11404: delNewTab(j).creation_date := sysdate;
11405: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11406: delNewTab(j).last_update_date := sysdate;
11407: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

Line 11405: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;

11401: delNewTab(j).business_document_number := p_target_doc_number;
11402: delNewTab(j).business_document_version := -99;
11403: delNewTab(j).created_by:= Fnd_Global.User_Id;
11404: delNewTab(j).creation_date := sysdate;
11405: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11406: delNewTab(j).last_update_date := sysdate;
11407: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11408:
11409: END LOOP;

Line 11407: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

11403: delNewTab(j).created_by:= Fnd_Global.User_Id;
11404: delNewTab(j).creation_date := sysdate;
11405: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11406: delNewTab(j).last_update_date := sysdate;
11407: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11408:
11409: END LOOP;
11410: -- bug#4083525 CopyDelForTemplateRevision
11411: IF delNewTab.COUNT <> 0 THEN

Line 11621: X_CREATED_BY => FND_GLOBAL.User_id,

11617: X_from_entity_name => G_ENTITY_NAME,
11618: X_from_pk1_value => delIdTab(i).orig_del_id,
11619: X_to_entity_name => G_ENTITY_NAME,
11620: X_to_pk1_value => to_char(delIdTab(i).del_id),
11621: X_CREATED_BY => FND_GLOBAL.User_id,
11622: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
11623: );
11624: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

Line 11622: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

11618: X_from_pk1_value => delIdTab(i).orig_del_id,
11619: X_to_entity_name => G_ENTITY_NAME,
11620: X_to_pk1_value => to_char(delIdTab(i).del_id),
11621: X_CREATED_BY => FND_GLOBAL.User_id,
11622: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
11623: );
11624: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
11626: '100: Done Copy Deliverable Attachments ');

Line 12200: X_CREATED_BY => FND_GLOBAL.User_id,

12196: X_from_entity_name => G_ENTITY_NAME,
12197: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
12198: X_to_entity_name => G_ENTITY_NAME,
12199: X_to_pk1_value => to_char(l_deliverable_id),
12200: X_CREATED_BY => FND_GLOBAL.User_id,
12201: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
12202:
12203: END LOOP;
12204:

Line 12201: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);

12197: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
12198: X_to_entity_name => G_ENTITY_NAME,
12199: X_to_pk1_value => to_char(l_deliverable_id),
12200: X_CREATED_BY => FND_GLOBAL.User_id,
12201: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
12202:
12203: END LOOP;
12204:
12205: END IF;