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 1341: X_CREATED_BY => FND_GLOBAL.User_id,

1337: X_from_entity_name => G_ENTITY_NAME,
1338: X_from_pk1_value => delIdTab(i).orig_del_id,
1339: X_to_entity_name => G_ENTITY_NAME,
1340: X_to_pk1_value => to_char(delIdTab(i).del_id),
1341: X_CREATED_BY => FND_GLOBAL.User_id,
1342: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
1343: );
1344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'121: Attachments copied for delId: '||to_char(delIdTab(i).del_id));

Line 1342: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

1338: X_from_pk1_value => delIdTab(i).orig_del_id,
1339: X_to_entity_name => G_ENTITY_NAME,
1340: X_to_pk1_value => to_char(delIdTab(i).del_id),
1341: X_CREATED_BY => FND_GLOBAL.User_id,
1342: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
1343: );
1344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'121: Attachments copied for delId: '||to_char(delIdTab(i).del_id));
1346: END IF;

Line 2067: WHERE fu.user_id = fnd_global.user_id

2063: --ER Structured Terms Authoring in Repository strivedi
2064: CURSOR getRepDefaultInternalContactId IS
2065: SELECT pf.person_id contact_id
2066: FROM per_all_workforce_v pf,fnd_user fu
2067: WHERE fu.user_id = fnd_global.user_id
2068: AND pf.person_id = fu.employee_id;
2069: l_rep_dflt_int_contact_id okc_deliverables.INTERNAL_PARTY_CONTACT_ID%TYPE;
2070: --End of ER Code Modifications
2071: x_errorcode NUMBER;

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

2873: delNewTab(i).business_document_id := p_target_doc_id;
2874: delNewTab(i).business_document_type := p_target_doc_type;
2875: delNewTab(i).business_document_number := p_target_doc_number;
2876: delNewTab(i).business_document_version := -99;
2877: delNewTab(i).created_by:= Fnd_Global.User_Id;
2878: delNewTab(i).creation_date := sysdate;
2879: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2880: delNewTab(i).last_update_date := sysdate;
2881: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;

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

2875: delNewTab(i).business_document_number := p_target_doc_number;
2876: delNewTab(i).business_document_version := -99;
2877: delNewTab(i).created_by:= Fnd_Global.User_Id;
2878: delNewTab(i).creation_date := sysdate;
2879: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2880: delNewTab(i).last_update_date := sysdate;
2881: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;
2882: /*bug#3631944 flush amendment attributes at the time of copy.
2883: Since the target document will be a new document.*/

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

2877: delNewTab(i).created_by:= Fnd_Global.User_Id;
2878: delNewTab(i).creation_date := sysdate;
2879: delNewTab(i).last_updated_by:= Fnd_Global.User_Id;
2880: delNewTab(i).last_update_date := sysdate;
2881: delNewTab(i).last_update_login:=Fnd_Global.Login_Id;
2882: /*bug#3631944 flush amendment attributes at the time of copy.
2883: Since the target document will be a new document.*/
2884: delNewTab(i).amendment_operation := null;
2885: delNewTab(i).summary_amend_operation_code := null;

Line 3144: X_CREATED_BY => FND_GLOBAL.User_id,

3140: X_from_entity_name => G_ENTITY_NAME,
3141: X_from_pk1_value => delIdTab(i).orig_del_id,
3142: X_to_entity_name => G_ENTITY_NAME,
3143: X_to_pk1_value => to_char(delIdTab(i).del_id),
3144: X_CREATED_BY => FND_GLOBAL.User_id,
3145: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
3146: );
3147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

Line 3145: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

3141: X_from_pk1_value => delIdTab(i).orig_del_id,
3142: X_to_entity_name => G_ENTITY_NAME,
3143: X_to_pk1_value => to_char(delIdTab(i).del_id),
3144: X_CREATED_BY => FND_GLOBAL.User_id,
3145: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
3146: );
3147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
3149: '100: Done Copy Deliverable Attachments ');

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

3611: -- End 3711754 reset the contact ids and notification attributes from the definition
3612:
3613: -- 3667445 Reset the creation_date and created_by for instances. 03-Jun-2004
3614: delNewTab(j).creation_date := sysdate;
3615: delNewTab(j).created_by := FND_GLOBAL.User_id;
3616:
3617: --bug 6055520
3618: delNewTab(j).ATTRIBUTE_CATEGORY := delRecTab(i).ATTRIBUTE_CATEGORY;
3619: delNewTab(j).ATTRIBUTE1 := delRecTab(i).ATTRIBUTE1;

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

3902: FOR j IN delNewTab.FIRST..delNewTab.LAST LOOP
3903: --3667445 do not reset creation date for definitions, reset only for instances
3904: -- of recurring deliverables
3905: -- delNewTab(j).creation_date := sysdate;
3906: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3907: delNewTab(j).last_update_date := sysdate;
3908: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3909: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3910: --copy status history not done as status is not being changed here

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

3904: -- of recurring deliverables
3905: -- delNewTab(j).creation_date := sysdate;
3906: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3907: delNewTab(j).last_update_date := sysdate;
3908: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3909: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3910: --copy status history not done as status is not being changed here
3911: --OPEN delStsHist(delNewTab(j).deliverable_id);
3912: /*FOR delStsHist_rec in delStsHist(delNewTab(j).deliverable_id) LOOP

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

3905: -- delNewTab(j).creation_date := sysdate;
3906: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
3907: delNewTab(j).last_update_date := sysdate;
3908: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
3909: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
3910: --copy status history not done as status is not being changed here
3911: --OPEN delStsHist(delNewTab(j).deliverable_id);
3912: /*FOR delStsHist_rec in delStsHist(delNewTab(j).deliverable_id) LOOP
3913: p := p+1;

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

3933: /*IF delHistTab.COUNT <> 0 THEN
3934: FOR j IN delHistTab.FIRST..delHistTab.LAST LOOP
3935: delHistTab(j).deliverable_id := delNewTab(j).deliverable_id;
3936: delHistTab(j).creation_date := sysdate;
3937: delHistTab(j).created_by := FND_GLOBAL.User_id;
3938: delHistTab(j).last_update_date := sysdate;
3939: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3940: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3941: END LOOP;

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

3935: delHistTab(j).deliverable_id := delNewTab(j).deliverable_id;
3936: delHistTab(j).creation_date := sysdate;
3937: delHistTab(j).created_by := FND_GLOBAL.User_id;
3938: delHistTab(j).last_update_date := sysdate;
3939: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3940: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3941: END LOOP;
3942: END IF;
3943: IF delStsHist%ISOPEN THEN

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

3936: delHistTab(j).creation_date := sysdate;
3937: delHistTab(j).created_by := FND_GLOBAL.User_id;
3938: delHistTab(j).last_update_date := sysdate;
3939: delHistTab(j).last_updated_by := FND_GLOBAL.User_id;
3940: delHistTab(j).last_update_login:= Fnd_Global.Login_Id;
3941: END LOOP;
3942: END IF;
3943: IF delStsHist%ISOPEN THEN
3944: CLOSE delStsHist;

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

4178: delHistTab(p).STATUS_CHANGED_BY := delStsHist_rec.STATUS_CHANGED_BY;
4179: delHistTab(p).STATUS_CHANGE_DATE := delStsHist_rec.STATUS_CHANGE_DATE;
4180: delHistTab(p).STATUS_CHANGE_NOTES := delStsHist_rec.STATUS_CHANGE_NOTES;
4181: delHistTab(p).OBJECT_VERSION_NUMBER := delStsHist_rec.OBJECT_VERSION_NUMBER;
4182: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
4183: delHistTab(p).CREATION_DATE := sysdate;
4184: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
4185: delHistTab(p).LAST_UPDATE_DATE := sysdate;
4186: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/

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

4180: delHistTab(p).STATUS_CHANGE_NOTES := delStsHist_rec.STATUS_CHANGE_NOTES;
4181: delHistTab(p).OBJECT_VERSION_NUMBER := delStsHist_rec.OBJECT_VERSION_NUMBER;
4182: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
4183: delHistTab(p).CREATION_DATE := sysdate;
4184: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
4185: delHistTab(p).LAST_UPDATE_DATE := sysdate;
4186: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
4187:
4188: --insert into status history

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

4182: delHistTab(p).CREATED_BY := FND_GLOBAL.User_id;
4183: delHistTab(p).CREATION_DATE := sysdate;
4184: delHistTab(p).LAST_UPDATED_BY := FND_GLOBAL.User_id;
4185: delHistTab(p).LAST_UPDATE_DATE := sysdate;
4186: delHistTab(p).LAST_UPDATE_LOGIN := Fnd_Global.Login_Id;*/
4187:
4188: --insert into status history
4189: INSERT INTO okc_del_status_history (
4190: deliverable_id,

Line 4208: FND_GLOBAL.User_id,

4204: delStsHist_rec.STATUS_CHANGED_BY,
4205: delStsHist_rec.STATUS_CHANGE_DATE,
4206: delStsHist_rec.STATUS_CHANGE_NOTES,
4207: delStsHist_rec.OBJECT_VERSION_NUMBER,
4208: FND_GLOBAL.User_id,
4209: sysdate,
4210: FND_GLOBAL.User_id,
4211: sysdate,
4212: Fnd_Global.Login_Id);

Line 4210: FND_GLOBAL.User_id,

4206: delStsHist_rec.STATUS_CHANGE_NOTES,
4207: delStsHist_rec.OBJECT_VERSION_NUMBER,
4208: FND_GLOBAL.User_id,
4209: sysdate,
4210: FND_GLOBAL.User_id,
4211: sysdate,
4212: Fnd_Global.Login_Id);
4213: END LOOP;
4214: IF delStsHist%ISOPEN THEN

Line 4212: Fnd_Global.Login_Id);

4208: FND_GLOBAL.User_id,
4209: sysdate,
4210: FND_GLOBAL.User_id,
4211: sysdate,
4212: Fnd_Global.Login_Id);
4213: END LOOP;
4214: IF delStsHist%ISOPEN THEN
4215: CLOSE delStsHist;
4216: END IF;

Line 4232: X_CREATED_BY => FND_GLOBAL.User_id,

4228: X_from_entity_name => G_ENTITY_NAME,
4229: X_from_pk1_value => delIdTab(j).orig_del_id,
4230: X_to_entity_name => G_ENTITY_NAME,
4231: X_to_pk1_value => to_char(delIdTab(j).del_id),
4232: X_CREATED_BY => FND_GLOBAL.User_id,
4233: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4234: );
4235: END IF;
4236: END LOOP;

Line 4233: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

4229: X_from_pk1_value => delIdTab(j).orig_del_id,
4230: X_to_entity_name => G_ENTITY_NAME,
4231: X_to_pk1_value => to_char(delIdTab(j).del_id),
4232: X_CREATED_BY => FND_GLOBAL.User_id,
4233: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4234: );
4235: END IF;
4236: END LOOP;
4237: END IF; -- delNewTab.COUNT

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

4560: -- update the who columns
4561: FOR j IN delNewTab.FIRST..delNewTab.LAST LOOP
4562: -- do not reset the creation date bug#3641366
4563: -- delNewTab(j).creation_date := sysdate;
4564: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4565: delNewTab(j).last_update_date := sysdate;
4566: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4567: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4568: END LOOP;

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

4562: -- do not reset the creation date bug#3641366
4563: -- delNewTab(j).creation_date := sysdate;
4564: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4565: delNewTab(j).last_update_date := sysdate;
4566: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4567: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4568: END LOOP;
4569: ------------------------------------------
4570:

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

4563: -- delNewTab(j).creation_date := sysdate;
4564: -- delNewTab(j).created_by := FND_GLOBAL.User_id;
4565: delNewTab(j).last_update_date := sysdate;
4566: delNewTab(j).last_updated_by := FND_GLOBAL.User_id;
4567: delNewTab(j).last_update_login:= Fnd_Global.Login_Id;
4568: END LOOP;
4569: ------------------------------------------
4570:
4571:

Line 4802: X_CREATED_BY => FND_GLOBAL.User_id,

4798: X_from_entity_name => G_ENTITY_NAME,
4799: X_from_pk1_value => delIdTab(j).orig_del_id,
4800: X_to_entity_name => G_ENTITY_NAME,
4801: X_to_pk1_value => to_char(delIdTab(j).del_id),
4802: X_CREATED_BY => FND_GLOBAL.User_id,
4803: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4804: );
4805: END IF;
4806: END LOOP;

Line 4803: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

4799: X_from_pk1_value => delIdTab(j).orig_del_id,
4800: X_to_entity_name => G_ENTITY_NAME,
4801: X_to_pk1_value => to_char(delIdTab(j).del_id),
4802: X_CREATED_BY => FND_GLOBAL.User_id,
4803: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
4804: );
4805: END IF;
4806: END LOOP;
4807:

Line 4825: last_updated_by= Fnd_Global.User_Id,

4821: END IF;
4822: UPDATE okc_deliverables SET amendment_operation = null,
4823: --amendment_notes = null,
4824: --last_amendment_date = null,
4825: last_updated_by= Fnd_Global.User_Id,
4826: last_update_date = sysdate,
4827: last_update_login=Fnd_Global.Login_Id
4828: WHERE deliverable_id = del_rec.deliverable_id;
4829:

Line 4827: last_update_login=Fnd_Global.Login_Id

4823: --amendment_notes = null,
4824: --last_amendment_date = null,
4825: last_updated_by= Fnd_Global.User_Id,
4826: last_update_date = sysdate,
4827: last_update_login=Fnd_Global.Login_Id
4828: WHERE deliverable_id = del_rec.deliverable_id;
4829:
4830: END LOOP;
4831: IF del_cur %ISOPEN THEN

Line 4966: last_updated_by= Fnd_Global.User_Id,

4962: -- to enable or disable deliverables link
4963: UPDATE okc_deliverables SET amendment_operation = null,
4964: summary_amend_operation_code = null,
4965: amendment_notes = null,
4966: last_updated_by= Fnd_Global.User_Id,
4967: last_update_date = sysdate,
4968: last_update_login=Fnd_Global.Login_Id
4969: WHERE deliverable_id = def_rec.deliverable_id;
4970: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4968: last_update_login=Fnd_Global.Login_Id

4964: summary_amend_operation_code = null,
4965: amendment_notes = null,
4966: last_updated_by= Fnd_Global.User_Id,
4967: last_update_date = sysdate,
4968: last_update_login=Fnd_Global.Login_Id
4969: WHERE deliverable_id = def_rec.deliverable_id;
4970: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4971: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4972: ,'100: updated deliverable: '||to_char(def_rec.deliverable_id));

Line 4995: last_updated_by= Fnd_Global.User_Id,

4991: WHERE deliverable_id = def_rec.deliverable_id;
4992: ELSE
4993: -- clear only amendment_operation
4994: UPDATE okc_deliverables SET amendment_operation = null,
4995: last_updated_by= Fnd_Global.User_Id,
4996: last_update_date = sysdate,
4997: last_update_login=Fnd_Global.Login_Id
4998: WHERE deliverable_id = def_rec.deliverable_id;
4999: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4997: last_update_login=Fnd_Global.Login_Id

4993: -- clear only amendment_operation
4994: UPDATE okc_deliverables SET amendment_operation = null,
4995: last_updated_by= Fnd_Global.User_Id,
4996: last_update_date = sysdate,
4997: last_update_login=Fnd_Global.Login_Id
4998: WHERE deliverable_id = def_rec.deliverable_id;
4999: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5000: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
5001: ,'100: updated deliverable: '||to_char(def_rec.deliverable_id));

Line 5071: last_updated_by= Fnd_Global.User_Id,

5067: FETCH del_cur BULK COLLECT INTO delIdTab;
5068: IF delIdTab.COUNT <> 0 THEN
5069: FORALL i IN delIdTab.FIRST..delIdTab.LAST
5070: UPDATE okc_deliverables SET manage_yn = 'N',
5071: last_updated_by= Fnd_Global.User_Id,
5072: last_update_date = sysdate,
5073: last_update_login=Fnd_Global.Login_Id
5074: WHERE deliverable_id = delIdTab(i);
5075: END IF;

Line 5073: last_update_login=Fnd_Global.Login_Id

5069: FORALL i IN delIdTab.FIRST..delIdTab.LAST
5070: UPDATE okc_deliverables SET manage_yn = 'N',
5071: last_updated_by= Fnd_Global.User_Id,
5072: last_update_date = sysdate,
5073: last_update_login=Fnd_Global.Login_Id
5074: WHERE deliverable_id = delIdTab(i);
5075: END IF;
5076: IF del_cur %ISOPEN THEN
5077: CLOSE del_cur ;

Line 5171: Fnd_Global.User_Id,

5167: null,
5168: sysdate,
5169: null,
5170: 1,
5171: Fnd_Global.User_Id,
5172: sysdate,
5173: Fnd_Global.User_Id,
5174: sysdate,
5175: Fnd_Global.Login_Id);

Line 5173: Fnd_Global.User_Id,

5169: null,
5170: 1,
5171: Fnd_Global.User_Id,
5172: sysdate,
5173: Fnd_Global.User_Id,
5174: sysdate,
5175: Fnd_Global.Login_Id);
5176:
5177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5175: Fnd_Global.Login_Id);

5171: Fnd_Global.User_Id,
5172: sysdate,
5173: Fnd_Global.User_Id,
5174: sysdate,
5175: Fnd_Global.Login_Id);
5176:
5177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5178: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving ');
5179: END IF;

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

5284: delStsTab(j).deliverable_status:= p_new_status;
5285: delStsTab(j).status_change_date:= sysdate;
5286: delStsTab(j).status_change_notes:= null;
5287: delStsTab(j).object_version_number:= 1;
5288: delStsTab(j).created_by:= Fnd_Global.User_Id;
5289: delStsTab(j).creation_date := sysdate;
5290: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5291: delStsTab(j).last_update_date := sysdate;
5292: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

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

5286: delStsTab(j).status_change_notes:= null;
5287: delStsTab(j).object_version_number:= 1;
5288: delStsTab(j).created_by:= Fnd_Global.User_Id;
5289: delStsTab(j).creation_date := sysdate;
5290: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5291: delStsTab(j).last_update_date := sysdate;
5292: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5293: END LOOP;
5294:

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

5288: delStsTab(j).created_by:= Fnd_Global.User_Id;
5289: delStsTab(j).creation_date := sysdate;
5290: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5291: delStsTab(j).last_update_date := sysdate;
5292: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5293: END LOOP;
5294:
5295: --Bulk update of status in okc_deliverables
5296: FORALL i IN delIdTab.FIRST..delIdTab.LAST

Line 5301: last_updated_by= Fnd_Global.User_Id,

5297: UPDATE okc_deliverables
5298: SET
5299: deliverable_status = p_new_status,
5300: manage_yn = p_manage_yn,
5301: last_updated_by= Fnd_Global.User_Id,
5302: last_update_date = sysdate,
5303: last_update_login = Fnd_Global.Login_Id
5304: WHERE deliverable_id = delIdTab(i);
5305: --Bulk insert into status history

Line 5303: last_update_login = Fnd_Global.Login_Id

5299: deliverable_status = p_new_status,
5300: manage_yn = p_manage_yn,
5301: last_updated_by= Fnd_Global.User_Id,
5302: last_update_date = sysdate,
5303: last_update_login = Fnd_Global.Login_Id
5304: WHERE deliverable_id = delIdTab(i);
5305: --Bulk insert into status history
5306: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP
5307: /*code changed for 8i compatability bug#3307941

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

5369: delStsTab(j).deliverable_status:= p_new_status;
5370: delStsTab(j).status_change_date:= sysdate;
5371: delStsTab(j).status_change_notes:= null;
5372: delStsTab(j).object_version_number:= 1;
5373: delStsTab(j).created_by:= Fnd_Global.User_Id;
5374: delStsTab(j).creation_date := sysdate;
5375: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5376: delStsTab(j).last_update_date := sysdate;
5377: delStsTab(j).last_update_login := Fnd_Global.Login_Id;

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

5371: delStsTab(j).status_change_notes:= null;
5372: delStsTab(j).object_version_number:= 1;
5373: delStsTab(j).created_by:= Fnd_Global.User_Id;
5374: delStsTab(j).creation_date := sysdate;
5375: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5376: delStsTab(j).last_update_date := sysdate;
5377: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5378: END LOOP;
5379:

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

5373: delStsTab(j).created_by:= Fnd_Global.User_Id;
5374: delStsTab(j).creation_date := sysdate;
5375: delStsTab(j).last_updated_by:= Fnd_Global.User_Id;
5376: delStsTab(j).last_update_date := sysdate;
5377: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5378: END LOOP;
5379:
5380: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5381: -- BULK UPDATE of status

Line 5387: last_updated_by= Fnd_Global.User_Id,

5383: UPDATE okc_deliverables
5384: SET
5385: deliverable_status = p_new_status,
5386: manage_yn = 'N',
5387: last_updated_by= Fnd_Global.User_Id,
5388: last_update_date = sysdate,
5389: last_update_login = Fnd_Global.Login_Id
5390: WHERE deliverable_id = delIdTab(i);
5391:

Line 5389: last_update_login = Fnd_Global.Login_Id

5385: deliverable_status = p_new_status,
5386: manage_yn = 'N',
5387: last_updated_by= Fnd_Global.User_Id,
5388: last_update_date = sysdate,
5389: last_update_login = Fnd_Global.Login_Id
5390: WHERE deliverable_id = delIdTab(i);
5391:
5392: -- BULK INSERT into status history
5393: FOR i IN delStsTab.FIRST..delStsTab.LAST LOOP

Line 5701: last_updated_by = FND_GLOBAL.User_id,

5697:
5698: UPDATE okc_deliverables
5699: SET overdue_notification_id = overdue_ntf_ids(i),
5700: last_update_date = sysdate,
5701: last_updated_by = FND_GLOBAL.User_id,
5702: last_update_login =Fnd_Global.Login_Id
5703: WHERE deliverable_id = deliverable_ids(i);
5704:
5705: COMMIT;

Line 5702: last_update_login =Fnd_Global.Login_Id

5698: UPDATE okc_deliverables
5699: SET overdue_notification_id = overdue_ntf_ids(i),
5700: last_update_date = sysdate,
5701: last_updated_by = FND_GLOBAL.User_id,
5702: last_update_login =Fnd_Global.Login_Id
5703: WHERE deliverable_id = deliverable_ids(i);
5704:
5705: COMMIT;
5706:

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

6050: j := j+1;
6051: delNtfTab(j) := delRecTab(i);
6052: delNtfTab(j).prior_notification_id := l_notification_id;
6053: delNtfTab(j).last_update_date := sysdate;
6054: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6055: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6056: ELSIF l_return_status <> 'S' THEN
6057: -- The return status is success because error notification has been
6058: -- sent to person who launched the concurrent request.

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

6051: delNtfTab(j) := delRecTab(i);
6052: delNtfTab(j).prior_notification_id := l_notification_id;
6053: delNtfTab(j).last_update_date := sysdate;
6054: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6055: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6056: ELSIF l_return_status <> 'S' THEN
6057: -- The return status is success because error notification has been
6058: -- sent to person who launched the concurrent request.
6059: l_return_status := 'S';

Line 6076: last_updated_by = FND_GLOBAL.User_id,

6072: l_deliverable_id := delNtfTab(i).deliverable_id;*/
6073: UPDATE okc_deliverables
6074: SET prior_notification_id = delNtfTab(i).prior_notification_id,
6075: last_update_date = sysdate,
6076: last_updated_by = FND_GLOBAL.User_id,
6077: last_update_login =Fnd_Global.Login_Id
6078: where deliverable_id = delNtfTab(i).deliverable_id;
6079: END LOOP;
6080: COMMIT;

Line 6077: last_update_login =Fnd_Global.Login_Id

6073: UPDATE okc_deliverables
6074: SET prior_notification_id = delNtfTab(i).prior_notification_id,
6075: last_update_date = sysdate,
6076: last_updated_by = FND_GLOBAL.User_id,
6077: last_update_login =Fnd_Global.Login_Id
6078: where deliverable_id = delNtfTab(i).deliverable_id;
6079: END LOOP;
6080: COMMIT;
6081: END IF;

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

6414: j := j+1;
6415: delNtfTab(j) := delRecTab(i);
6416: delNtfTab(j).escalation_notification_id := l_notification_id;
6417: delNtfTab(j).last_update_date := sysdate;
6418: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6419: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6420: ELSIF l_return_status <> 'S' THEN
6421: -- The return status is success because error notification has been
6422: -- sent to person who launched the concurrent request.

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

6415: delNtfTab(j) := delRecTab(i);
6416: delNtfTab(j).escalation_notification_id := l_notification_id;
6417: delNtfTab(j).last_update_date := sysdate;
6418: delNtfTab(j).last_updated_by := FND_GLOBAL.User_id;
6419: delNtfTab(j).last_update_login:=Fnd_Global.Login_Id;
6420: ELSIF l_return_status <> 'S' THEN
6421: -- The return status is success because error notification has been
6422: -- sent to person who launched the concurrent request.
6423: l_return_status := 'S';

Line 6440: last_updated_by = FND_GLOBAL.User_id,

6436: l_deliverable_id := delNtfTab(i).deliverable_id;*/
6437: UPDATE okc_deliverables
6438: SET escalation_notification_id = delNtfTab(i).escalation_notification_id,
6439: last_update_date = sysdate,
6440: last_updated_by = FND_GLOBAL.User_id,
6441: last_update_login =Fnd_Global.Login_Id
6442: where deliverable_id = delNtfTab(i).deliverable_id;
6443: END LOOP;
6444: COMMIT;

Line 6441: last_update_login =Fnd_Global.Login_Id

6437: UPDATE okc_deliverables
6438: SET escalation_notification_id = delNtfTab(i).escalation_notification_id,
6439: last_update_date = sysdate,
6440: last_updated_by = FND_GLOBAL.User_id,
6441: last_update_login =Fnd_Global.Login_Id
6442: where deliverable_id = delNtfTab(i).deliverable_id;
6443: END LOOP;
6444: COMMIT;
6445: END IF;

Line 6869: last_updated_by= Fnd_Global.User_Id,

6865: IF delIdTab.COUNT <> 0 THEN
6866: FORALL j IN delIdTab.FIRST..delIdTab.LAST
6867: UPDATE okc_deliverables
6868: SET business_document_id = p_base_template_id,
6869: last_updated_by= Fnd_Global.User_Id,
6870: last_update_date = sysdate,
6871: last_update_login=Fnd_Global.Login_Id
6872: WHERE deliverable_id = delIdTab(j);
6873: END IF;

Line 6871: last_update_login=Fnd_Global.Login_Id

6867: UPDATE okc_deliverables
6868: SET business_document_id = p_base_template_id,
6869: last_updated_by= Fnd_Global.User_Id,
6870: last_update_date = sysdate,
6871: last_update_login=Fnd_Global.Login_Id
6872: WHERE deliverable_id = delIdTab(j);
6873: END IF;
6874: IF del_cur %ISOPEN THEN
6875: CLOSE del_cur ;

Line 7932: EXECUTE IMMEDIATE 'SELECT enable_cdrl FROM po_system_parameters_all WHERE org_id=fnd_global.org_id ' INTO l_cdrl_enabled;

7928: NVL(FND_PROFILE.VALUE('PO_CLM_ENABLED'),'N') = 'Y' THEN
7929:
7930: -- Check po system parameters
7931: BEGIN
7932: EXECUTE IMMEDIATE 'SELECT enable_cdrl FROM po_system_parameters_all WHERE org_id=fnd_global.org_id ' INTO l_cdrl_enabled;
7933: EXCEPTION
7934: WHEN OTHERS THEN
7935: l_cdrl_enabled := 'N';
7936: END;

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

11420: -- assign common attributes
11421: delNewTab(j).business_document_id := p_target_doc_id;
11422: delNewTab(j).business_document_type := p_target_doc_type;
11423: delNewTab(j).business_document_number := p_target_doc_number;
11424: delNewTab(j).created_by:= Fnd_Global.User_Id;
11425: delNewTab(j).creation_date := sysdate;
11426: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11427: delNewTab(j).last_update_date := sysdate;
11428: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

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

11422: delNewTab(j).business_document_type := p_target_doc_type;
11423: delNewTab(j).business_document_number := p_target_doc_number;
11424: delNewTab(j).created_by:= Fnd_Global.User_Id;
11425: delNewTab(j).creation_date := sysdate;
11426: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11427: delNewTab(j).last_update_date := sysdate;
11428: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11429: -- Check for instances on deliverable definition
11430: IF delRecTab(i).recurring_yn = 'Y' THEN

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

11424: delNewTab(j).created_by:= Fnd_Global.User_Id;
11425: delNewTab(j).creation_date := sysdate;
11426: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11427: delNewTab(j).last_update_date := sysdate;
11428: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11429: -- Check for instances on deliverable definition
11430: IF delRecTab(i).recurring_yn = 'Y' THEN
11431:
11432: --Initialize the table with 0 rows

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

11560: -- assign common attributes
11561: delNewTab(j).business_document_id := p_target_doc_id;
11562: delNewTab(j).business_document_type := p_target_doc_type;
11563: delNewTab(j).business_document_number := p_target_doc_number;
11564: delNewTab(j).created_by:= Fnd_Global.User_Id;
11565: delNewTab(j).creation_date := sysdate;
11566: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11567: delNewTab(j).last_update_date := sysdate;
11568: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

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

11562: delNewTab(j).business_document_type := p_target_doc_type;
11563: delNewTab(j).business_document_number := p_target_doc_number;
11564: delNewTab(j).created_by:= Fnd_Global.User_Id;
11565: delNewTab(j).creation_date := sysdate;
11566: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11567: delNewTab(j).last_update_date := sysdate;
11568: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11569:
11570: END LOOP; -- delInsTab.FIRST..delInsTab.LAST

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

11564: delNewTab(j).created_by:= Fnd_Global.User_Id;
11565: delNewTab(j).creation_date := sysdate;
11566: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
11567: delNewTab(j).last_update_date := sysdate;
11568: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
11569:
11570: END LOOP; -- delInsTab.FIRST..delInsTab.LAST
11571: END IF;--delInsTab.COUNT
11572:

Line 11836: FND_GLOBAL.User_id,

11832: delStsHist_rec.STATUS_CHANGED_BY,
11833: delStsHist_rec.STATUS_CHANGE_DATE,
11834: delStsHist_rec.STATUS_CHANGE_NOTES,
11835: delStsHist_rec.OBJECT_VERSION_NUMBER,
11836: FND_GLOBAL.User_id,
11837: sysdate,
11838: FND_GLOBAL.User_id,
11839: sysdate,
11840: Fnd_Global.Login_Id);

Line 11838: FND_GLOBAL.User_id,

11834: delStsHist_rec.STATUS_CHANGE_NOTES,
11835: delStsHist_rec.OBJECT_VERSION_NUMBER,
11836: FND_GLOBAL.User_id,
11837: sysdate,
11838: FND_GLOBAL.User_id,
11839: sysdate,
11840: Fnd_Global.Login_Id);
11841: END LOOP; -- delStsHist END LOOP;
11842: IF delStsHist%ISOPEN THEN

Line 11840: Fnd_Global.Login_Id);

11836: FND_GLOBAL.User_id,
11837: sysdate,
11838: FND_GLOBAL.User_id,
11839: sysdate,
11840: Fnd_Global.Login_Id);
11841: END LOOP; -- delStsHist END LOOP;
11842: IF delStsHist%ISOPEN THEN
11843: CLOSE delStsHist;
11844: END IF;

Line 11861: X_CREATED_BY => FND_GLOBAL.User_id,

11857: X_from_entity_name => G_ENTITY_NAME,
11858: X_from_pk1_value => delIdTab(i).orig_del_id,
11859: X_to_entity_name => G_ENTITY_NAME,
11860: X_to_pk1_value => to_char(delIdTab(i).del_id),
11861: X_CREATED_BY => FND_GLOBAL.User_id,
11862: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
11863: );
11864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11865: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Done Copy Deliverable Attachments ');

Line 11862: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

11858: X_from_pk1_value => delIdTab(i).orig_del_id,
11859: X_to_entity_name => G_ENTITY_NAME,
11860: X_to_pk1_value => to_char(delIdTab(i).del_id),
11861: X_CREATED_BY => FND_GLOBAL.User_id,
11862: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
11863: );
11864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11865: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Done Copy Deliverable Attachments ');
11866: END IF;

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

12426: delNewTab(j).business_document_id := p_target_doc_id;
12427: delNewTab(j).business_document_type := p_target_doc_type;
12428: delNewTab(j).business_document_number := p_target_doc_number;
12429: delNewTab(j).business_document_version := -99;
12430: delNewTab(j).created_by:= Fnd_Global.User_Id;
12431: delNewTab(j).creation_date := sysdate;
12432: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
12433: delNewTab(j).last_update_date := sysdate;
12434: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;

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

12428: delNewTab(j).business_document_number := p_target_doc_number;
12429: delNewTab(j).business_document_version := -99;
12430: delNewTab(j).created_by:= Fnd_Global.User_Id;
12431: delNewTab(j).creation_date := sysdate;
12432: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
12433: delNewTab(j).last_update_date := sysdate;
12434: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
12435:
12436: END LOOP;

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

12430: delNewTab(j).created_by:= Fnd_Global.User_Id;
12431: delNewTab(j).creation_date := sysdate;
12432: delNewTab(j).last_updated_by:= Fnd_Global.User_Id;
12433: delNewTab(j).last_update_date := sysdate;
12434: delNewTab(j).last_update_login:=Fnd_Global.Login_Id;
12435:
12436: END LOOP;
12437: -- bug#4083525 CopyDelForTemplateRevision
12438: IF delNewTab.COUNT <> 0 THEN

Line 12667: X_CREATED_BY => FND_GLOBAL.User_id,

12663: X_from_entity_name => G_ENTITY_NAME,
12664: X_from_pk1_value => delIdTab(i).orig_del_id,
12665: X_to_entity_name => G_ENTITY_NAME,
12666: X_to_pk1_value => to_char(delIdTab(i).del_id),
12667: X_CREATED_BY => FND_GLOBAL.User_id,
12668: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
12669: );
12670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,

Line 12668: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id

12664: X_from_pk1_value => delIdTab(i).orig_del_id,
12665: X_to_entity_name => G_ENTITY_NAME,
12666: X_to_pk1_value => to_char(delIdTab(i).del_id),
12667: X_CREATED_BY => FND_GLOBAL.User_id,
12668: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
12669: );
12670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
12672: '100: Done Copy Deliverable Attachments ');

Line 13300: X_CREATED_BY => FND_GLOBAL.User_id,

13296: X_from_entity_name => G_ENTITY_NAME,
13297: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
13298: X_to_entity_name => G_ENTITY_NAME,
13299: X_to_pk1_value => to_char(l_deliverable_id),
13300: X_CREATED_BY => FND_GLOBAL.User_id,
13301: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
13302:
13303: -- Fix for bug 13518546 start
13304: l_deliverable_id := NULL;

Line 13301: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);

13297: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
13298: X_to_entity_name => G_ENTITY_NAME,
13299: X_to_pk1_value => to_char(l_deliverable_id),
13300: X_CREATED_BY => FND_GLOBAL.User_id,
13301: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id);
13302:
13303: -- Fix for bug 13518546 start
13304: l_deliverable_id := NULL;
13305: -- Fix for bug 13518546 end