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.AHL_PRD_WORKORDER_PVT dependencies on FND_GLOBAL

Line 3414: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;

3410: END IF;
3411: --Balaji added for BAE ER # 4462462 - End.
3412: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER :=1;
3413: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
3414: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
3415: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
3416: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
3417: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
3418: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;

Line 3416: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;

3412: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER :=1;
3413: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
3414: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
3415: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
3416: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
3417: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
3418: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;
3419: --p_x_prd_workorder_rec.STATUS_CODE :=G_JOB_STATUS_UNRELEASED; -- Unreleased
3420:

Line 3417: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;

3413: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
3414: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
3415: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
3416: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
3417: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
3418: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;
3419: --p_x_prd_workorder_rec.STATUS_CODE :=G_JOB_STATUS_UNRELEASED; -- Unreleased
3420:
3421: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG IS NULL OR

Line 5146: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),

5142:
5143: UPDATE AHL_WORKORDERS SET
5144: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
5145: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5146: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
5147: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),
5148: STATUS_CODE =p_x_prd_workorder_rec.STATUS_CODE,
5149: ACTUAL_START_DATE =p_x_prd_workorder_rec.ACTUAL_START_DATE,
5150: ACTUAL_END_DATE =p_x_prd_workorder_rec.ACTUAL_END_DATE,

Line 5147: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),

5143: UPDATE AHL_WORKORDERS SET
5144: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
5145: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5146: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
5147: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),
5148: STATUS_CODE =p_x_prd_workorder_rec.STATUS_CODE,
5149: ACTUAL_START_DATE =p_x_prd_workorder_rec.ACTUAL_START_DATE,
5150: ACTUAL_END_DATE =p_x_prd_workorder_rec.ACTUAL_END_DATE,
5151: CONFIRM_FAILURE_FLAG =p_x_prd_workorder_rec.CONFIRM_FAILURE_FLAG,

Line 5223: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

5219: (
5220: AHL_WORKORDER_TXNS_S.NEXTVAL,
5221: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
5222: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5223: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
5224: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
5225: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
5226: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
5227: p_x_prd_workorder_rec.WORKORDER_ID,

Line 5225: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),

5221: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
5222: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5223: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
5224: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
5225: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
5226: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
5227: p_x_prd_workorder_rec.WORKORDER_ID,
5228: 0,
5229: p_x_prd_workorder_rec.STATUS_CODE,

Line 5226: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),

5222: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5223: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
5224: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
5225: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
5226: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
5227: p_x_prd_workorder_rec.WORKORDER_ID,
5228: 0,
5229: p_x_prd_workorder_rec.STATUS_CODE,
5230: p_x_prd_workorder_rec.SCHEDULED_START_DATE,

Line 6648: last_updated_by = Fnd_Global.USER_ID,

6644: UPDATE AHL_WORKORDERS
6645: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,
6646: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
6647: last_update_date = SYSDATE,
6648: last_updated_by = Fnd_Global.USER_ID,
6649: last_update_login = Fnd_Global.LOGIN_ID
6650:
6651: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
6652:

Line 6649: last_update_login = Fnd_Global.LOGIN_ID

6645: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,
6646: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
6647: last_update_date = SYSDATE,
6648: last_updated_by = Fnd_Global.USER_ID,
6649: last_update_login = Fnd_Global.LOGIN_ID
6650:
6651: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
6652:
6653: /* MANESING::Execution Enhancements, 09-Mar-2011, process workorder operations relationships

Line 6715: last_updated_by = Fnd_Global.USER_ID,

6711: UPDATE AHL_WORKORDERS
6712: SET status_code = l_eam_wo_tbl(i).status_type,
6713: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
6714: last_update_date = SYSDATE,
6715: last_updated_by = Fnd_Global.USER_ID,
6716: last_update_login = Fnd_Global.LOGIN_ID
6717:
6718: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
6719:

Line 6716: last_update_login = Fnd_Global.LOGIN_ID

6712: SET status_code = l_eam_wo_tbl(i).status_type,
6713: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
6714: last_update_date = SYSDATE,
6715: last_updated_by = Fnd_Global.USER_ID,
6716: last_update_login = Fnd_Global.LOGIN_ID
6717:
6718: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
6719:
6720: END IF;

Line 10625: --l_user_id := FND_GLOBAL.user_id;

10621:
10622: IF p_trunover_notes_tbl(i).employee_name IS NULL THEN
10623: FND_MESSAGE.set_name('AHL','AHL_PRD_EMP_NULL_TRNTS');
10624: FND_MSG_PUB.ADD;
10625: --l_user_id := FND_GLOBAL.user_id;
10626: ELSE
10627: matchFound := FALSE;
10628: FOR emp_rec IN get_user_id_csr(p_trunover_notes_tbl(i).employee_name,
10629: p_trunover_notes_tbl(i).org_id) LOOP

Line 11048: NVL(l_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

11044: (
11045: AHL_WORKORDER_TXNS_S.NEXTVAL,
11046: NVL(l_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
11047: NVL(l_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
11048: NVL(l_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
11049: NVL(l_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
11050: NVL(l_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
11051: NVL(l_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
11052: l_x_prd_workorder_rec.WORKORDER_ID,

Line 11050: NVL(l_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),

11046: NVL(l_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
11047: NVL(l_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
11048: NVL(l_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
11049: NVL(l_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
11050: NVL(l_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
11051: NVL(l_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
11052: l_x_prd_workorder_rec.WORKORDER_ID,
11053: 0,
11054: l_x_prd_workorder_rec.STATUS_CODE,

Line 11051: NVL(l_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),

11047: NVL(l_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
11048: NVL(l_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
11049: NVL(l_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
11050: NVL(l_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
11051: NVL(l_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
11052: l_x_prd_workorder_rec.WORKORDER_ID,
11053: 0,
11054: l_x_prd_workorder_rec.STATUS_CODE,
11055: l_x_prd_workorder_rec.SCHEDULED_START_DATE,

Line 11814: --fnd_global.APPS_INITIALIZE(fnd_global.USER_ID, 62211, 867);

11810: l_err_msg VARCHAR2(2000);
11811:
11812: BEGIN
11813:
11814: --fnd_global.APPS_INITIALIZE(fnd_global.USER_ID, 62211, 867);
11815: --mo_global.init('AHL');
11816:
11817: -- 1. Initialize error message stack by default
11818: FND_MSG_PUB.Initialize;

Line 11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:

Line 11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:
11839: l_wo_count := 0;

Line 11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:
11839: l_wo_count := 0;
11840:

Line 12145: and fu.user_id = fnd_global.user_id;

12141: and pf.organization_id = bre.organization_id
12142: and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE
12143: and FU.employee_id = pf.employee_id
12144: and pf.organization_id= c_organization_id
12145: and fu.user_id = fnd_global.user_id;
12146: --Cursor to get lookup meaning against code and type
12147: CURSOR Get_Lkp_Meaning(c_lookup_code VARCHAR2, c_lookup_type VARCHAR2) IS
12148: select meaning
12149: from FND_LOOKUP_VALUES_VL

Line 12321: p_entered_by => fnd_global.user_id,

12317: x_msg_data => l_msg_data,
12318: p_source_object_id => l_workorder_id,
12319: p_source_object_code => 'AHL_WO_TURNOVER_NOTES',
12320: p_notes => l_notes,
12321: p_entered_by => fnd_global.user_id,
12322: p_entered_date => SYSDATE,
12323: x_jtf_note_id => l_jtf_note_id
12324: );
12325: END IF;

Line 12519: p_entered_by => fnd_global.user_id,

12515: x_msg_data => l_msg_data,
12516: p_source_object_id => p_workorder_id,
12517: p_source_object_code => 'AHL_WO_TURNOVER_NOTES',
12518: p_notes => l_notes,
12519: p_entered_by => fnd_global.user_id,
12520: p_entered_date => SYSDATE,
12521: x_jtf_note_id => l_jtf_note_id
12522: );
12523: l_msg_count := FND_MSG_PUB.count_msg;

Line 12736: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

12732: UPDATE AHL_WORKORDERS
12733: SET AOG_FLAG = 'Y',
12734: OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM + 1,
12735: LAST_UPDATE_DATE = SYSDATE,
12736: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
12737: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
12738: WHERE WORKORDER_ID = P_WORKORDER_ID_TBL(I).WORKORDER_ID
12739: and OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM;
12740:

Line 12737: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

12733: SET AOG_FLAG = 'Y',
12734: OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM + 1,
12735: LAST_UPDATE_DATE = SYSDATE,
12736: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
12737: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
12738: WHERE WORKORDER_ID = P_WORKORDER_ID_TBL(I).WORKORDER_ID
12739: and OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM;
12740:
12741:

Line 12779: FND_GLOBAL.USER_ID,

12775: (
12776: AHL_WORKORDER_TXNS_S.NEXTVAL,
12777: NVL(L_PRD_WORKORDER_REC.OBJECT_VERSION_NUMBER,1),
12778: SYSDATE,
12779: FND_GLOBAL.USER_ID,
12780: SYSDATE,
12781: FND_GLOBAL.USER_ID,
12782: FND_GLOBAL.USER_ID,
12783: L_PRD_WORKORDER_REC.WORKORDER_ID,

Line 12781: FND_GLOBAL.USER_ID,

12777: NVL(L_PRD_WORKORDER_REC.OBJECT_VERSION_NUMBER,1),
12778: SYSDATE,
12779: FND_GLOBAL.USER_ID,
12780: SYSDATE,
12781: FND_GLOBAL.USER_ID,
12782: FND_GLOBAL.USER_ID,
12783: L_PRD_WORKORDER_REC.WORKORDER_ID,
12784: 0,
12785: L_PRD_WORKORDER_REC.JOB_STATUS_CODE,

Line 12782: FND_GLOBAL.USER_ID,

12778: SYSDATE,
12779: FND_GLOBAL.USER_ID,
12780: SYSDATE,
12781: FND_GLOBAL.USER_ID,
12782: FND_GLOBAL.USER_ID,
12783: L_PRD_WORKORDER_REC.WORKORDER_ID,
12784: 0,
12785: L_PRD_WORKORDER_REC.JOB_STATUS_CODE,
12786: L_PRD_WORKORDER_REC.SCHEDULED_START_DATE,