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

Line 648: p_x_df_header_rec.created_by := fnd_global.user_id;

644: ELSIF(p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
645: --setting object version number for create
646: p_x_df_header_rec.object_version_number := 1;
647: --setting up user/create/update information
648: p_x_df_header_rec.created_by := fnd_global.user_id;
649: p_x_df_header_rec.creation_date := SYSDATE;
650: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
651: p_x_df_header_rec.last_update_date := SYSDATE;
652: p_x_df_header_rec.last_update_login := fnd_global.user_id;

Line 650: p_x_df_header_rec.last_updated_by := fnd_global.user_id;

646: p_x_df_header_rec.object_version_number := 1;
647: --setting up user/create/update information
648: p_x_df_header_rec.created_by := fnd_global.user_id;
649: p_x_df_header_rec.creation_date := SYSDATE;
650: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
651: p_x_df_header_rec.last_update_date := SYSDATE;
652: p_x_df_header_rec.last_update_login := fnd_global.user_id;
653:
654: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG OR p_x_df_header_rec.cancel_flag = G_YES_FLAG)THEN

Line 652: p_x_df_header_rec.last_update_login := fnd_global.user_id;

648: p_x_df_header_rec.created_by := fnd_global.user_id;
649: p_x_df_header_rec.creation_date := SYSDATE;
650: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
651: p_x_df_header_rec.last_update_date := SYSDATE;
652: p_x_df_header_rec.last_update_login := fnd_global.user_id;
653:
654: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG OR p_x_df_header_rec.cancel_flag = G_YES_FLAG)THEN
655: p_x_df_header_rec.set_due_date := null;
656: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;

Line 703: p_x_df_header_rec.last_updated_by := fnd_global.user_id;

699:
700: -- setting up object version number
701: p_x_df_header_rec.object_version_number := p_x_df_header_rec.object_version_number + 1;
702: --setting up user/create/update information
703: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
704: p_x_df_header_rec.last_update_date := SYSDATE;
705: p_x_df_header_rec.last_update_login := fnd_global.user_id;
706:
707: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG OR p_x_df_header_rec.cancel_flag = G_YES_FLAG)THEN

Line 705: p_x_df_header_rec.last_update_login := fnd_global.user_id;

701: p_x_df_header_rec.object_version_number := p_x_df_header_rec.object_version_number + 1;
702: --setting up user/create/update information
703: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
704: p_x_df_header_rec.last_update_date := SYSDATE;
705: p_x_df_header_rec.last_update_login := fnd_global.user_id;
706:
707: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG OR p_x_df_header_rec.cancel_flag = G_YES_FLAG)THEN
708: p_x_df_header_rec.set_due_date := null;
709: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;

Line 868: 'user id : ' || FND_GLOBAL.USER_ID()

864: fnd_log.string
865: (
866: fnd_log.level_statement,
867: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
868: 'user id : ' || FND_GLOBAL.USER_ID()
869: );
870: fnd_log.string
871: (
872: fnd_log.level_statement,

Line 874: 'resp id : ' || FND_GLOBAL.RESP_ID()

870: fnd_log.string
871: (
872: fnd_log.level_statement,
873: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
874: 'resp id : ' || FND_GLOBAL.RESP_ID()
875: );
876: fnd_log.string
877: (
878: fnd_log.level_statement,

Line 880: 'resp appl id : ' || FND_GLOBAL.resp_appl_id()

876: fnd_log.string
877: (
878: fnd_log.level_statement,
879: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
880: 'resp appl id : ' || FND_GLOBAL.resp_appl_id()
881: );
882: END IF;
883: END log_df_header;
884:

Line 2044: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;

2040: IF (p_x_df_schedules_tbl(i).operation_flag = G_OP_UPDATE) THEN
2041:
2042: p_x_df_schedules_tbl(i).object_version_number := p_x_df_schedules_tbl(i).object_version_number + 1;
2043:
2044: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2045: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2046: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2047:
2048: AHL_UNIT_THRESHOLDS_PKG.update_row(

Line 2046: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;

2042: p_x_df_schedules_tbl(i).object_version_number := p_x_df_schedules_tbl(i).object_version_number + 1;
2043:
2044: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2045: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2046: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2047:
2048: AHL_UNIT_THRESHOLDS_PKG.update_row(
2049: p_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2050: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,

Line 2082: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;

2078: IF(p_x_df_schedules_tbl(i).operation_flag = G_OP_CREATE) THEN
2079:
2080: p_x_df_schedules_tbl(i).object_version_number := 1;
2081:
2082: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2083: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2084: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2085: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2086: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;

Line 2084: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;

2080: p_x_df_schedules_tbl(i).object_version_number := 1;
2081:
2082: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2083: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2084: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2085: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2086: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2087:
2088: AHL_UNIT_THRESHOLDS_PKG.insert_row(

Line 2086: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;

2082: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2083: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2084: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2085: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2086: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2087:
2088: AHL_UNIT_THRESHOLDS_PKG.insert_row(
2089: p_x_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2090: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,

Line 3180: P_REQUESTER_USERID => fnd_global.user_id,--1003259,--

3176: P_OBJECT_VERSION_NUMBER => p_df_header_rec.object_version_number,
3177: P_ORIG_STATUS_CODE => p_df_header_rec.approval_status_code,
3178: P_NEW_STATUS_CODE => l_new_status_code ,
3179: P_REJECT_STATUS_CODE => 'DEFERRAL_REJECTED',
3180: P_REQUESTER_USERID => fnd_global.user_id,--1003259,--
3181: P_NOTES_FROM_REQUESTER => '',
3182: P_WORKFLOWPROCESS => 'AHL_GEN_APPROVAL',
3183: P_ITEM_TYPE => 'AHLGAPP');
3184: ELSE

Line 4917: X_CREATED_BY => fnd_global.user_id,

4913: X_POSITION_PATH_ID => ue_rec.position_path_id,
4914: X_ATA_CODE => ue_rec.ATA_CODE,
4915: X_UNIT_CONFIG_HEADER_ID => ue_rec.unit_config_header_id,
4916: X_CREATION_DATE => sysdate,
4917: X_CREATED_BY => fnd_global.user_id,
4918: X_LAST_UPDATE_DATE => sysdate,
4919: X_LAST_UPDATED_BY => fnd_global.user_id,
4920: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4921:

Line 4919: X_LAST_UPDATED_BY => fnd_global.user_id,

4915: X_UNIT_CONFIG_HEADER_ID => ue_rec.unit_config_header_id,
4916: X_CREATION_DATE => sysdate,
4917: X_CREATED_BY => fnd_global.user_id,
4918: X_LAST_UPDATE_DATE => sysdate,
4919: X_LAST_UPDATED_BY => fnd_global.user_id,
4920: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4921:
4922: -- copy originating WO id seperately as table handler does not support it.
4923: UPDATE ahl_unit_effectivities_b

Line 4920: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

4916: X_CREATION_DATE => sysdate,
4917: X_CREATED_BY => fnd_global.user_id,
4918: X_LAST_UPDATE_DATE => sysdate,
4919: X_LAST_UPDATED_BY => fnd_global.user_id,
4920: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4921:
4922: -- copy originating WO id seperately as table handler does not support it.
4923: UPDATE ahl_unit_effectivities_b
4924: SET originating_wo_id = ue_rec.originating_wo_id,

Line 4961: LAST_UPDATED_BY = fnd_global.user_id,

4957: IF is_initdue_def%FOUND THEN
4958: UPDATE AHL_UNIT_DEFERRALS_B
4959: SET unit_effectivity_id = l_new_unit_effectivity_id,
4960: LAST_UPDATE_DATE = sysdate,
4961: LAST_UPDATED_BY = fnd_global.user_id,
4962: LAST_UPDATE_LOGIN = fnd_global.login_id
4963: WHERE unit_deferral_id = l_init_due_deferral_id;
4964: END IF;
4965: CLOSE is_initdue_def;

Line 4962: LAST_UPDATE_LOGIN = fnd_global.login_id

4958: UPDATE AHL_UNIT_DEFERRALS_B
4959: SET unit_effectivity_id = l_new_unit_effectivity_id,
4960: LAST_UPDATE_DATE = sysdate,
4961: LAST_UPDATED_BY = fnd_global.user_id,
4962: LAST_UPDATE_LOGIN = fnd_global.login_id
4963: WHERE unit_deferral_id = l_init_due_deferral_id;
4964: END IF;
4965: CLOSE is_initdue_def;
4966: END IF;

Line 5032: x_last_updated_by => fnd_global.user_id,

5028: x_attribute14 => ue_rec.ATTRIBUTE14,
5029: x_attribute15 => ue_rec.ATTRIBUTE15,
5030: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5031: x_last_update_date => sysdate,
5032: x_last_updated_by => fnd_global.user_id,
5033: x_last_update_login => fnd_global.login_id
5034: );
5035: END LOOP;
5036: -- create tree here

Line 5033: x_last_update_login => fnd_global.login_id

5029: x_attribute15 => ue_rec.ATTRIBUTE15,
5030: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5031: x_last_update_date => sysdate,
5032: x_last_updated_by => fnd_global.user_id,
5033: x_last_update_login => fnd_global.login_id
5034: );
5035: END LOOP;
5036: -- create tree here
5037: IF (l_ue_relns_tbl.count > 0 AND (p_new_status = 'DEFERRED' OR (l_deferral_type = 'MR' AND l_manually_planned_flag = G_NO_FLAG AND p_new_status = 'CANCELLED')

Line 5073: X_LAST_UPDATED_BY => fnd_global.user_id,

5069: X_ATTRIBUTE14 => null,
5070: X_ATTRIBUTE15 => null,
5071: X_OBJECT_VERSION_NUMBER => 1,
5072: X_LAST_UPDATE_DATE => sysdate,
5073: X_LAST_UPDATED_BY => fnd_global.user_id,
5074: X_CREATION_DATE => sysdate,
5075: X_CREATED_BY => fnd_global.user_id,
5076: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
5077: END LOOP;

Line 5075: X_CREATED_BY => fnd_global.user_id,

5071: X_OBJECT_VERSION_NUMBER => 1,
5072: X_LAST_UPDATE_DATE => sysdate,
5073: X_LAST_UPDATED_BY => fnd_global.user_id,
5074: X_CREATION_DATE => sysdate,
5075: X_CREATED_BY => fnd_global.user_id,
5076: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
5077: END LOOP;
5078: END IF;
5079: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id

Line 5076: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

5072: X_LAST_UPDATE_DATE => sysdate,
5073: X_LAST_UPDATED_BY => fnd_global.user_id,
5074: X_CREATION_DATE => sysdate,
5075: X_CREATED_BY => fnd_global.user_id,
5076: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
5077: END LOOP;
5078: END IF;
5079: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id
5080: * This call should be made only when p_new_status = 'DEFERRED' as SR can not be terminated

Line 5152: x_last_updated_by => fnd_global.user_id,

5148: x_attribute14 => ue_rec.ATTRIBUTE14,
5149: x_attribute15 => ue_rec.ATTRIBUTE15,
5150: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5151: x_last_update_date => sysdate,
5152: x_last_updated_by => fnd_global.user_id,
5153: x_last_update_login => fnd_global.login_id);
5154: END IF;
5155: END LOOP;
5156: END IF;

Line 5153: x_last_update_login => fnd_global.login_id);

5149: x_attribute15 => ue_rec.ATTRIBUTE15,
5150: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5151: x_last_update_date => sysdate,
5152: x_last_updated_by => fnd_global.user_id,
5153: x_last_update_login => fnd_global.login_id);
5154: END IF;
5155: END LOOP;
5156: END IF;
5157:

Line 5327: x_last_updated_by => fnd_global.user_id,

5323: x_attribute14 => ue_rec.ATTRIBUTE14,
5324: x_attribute15 => ue_rec.ATTRIBUTE15,
5325: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5326: x_last_update_date => sysdate,
5327: x_last_updated_by => fnd_global.user_id,
5328: x_last_update_login => fnd_global.login_id);
5329: END LOOP;
5330: END IF;
5331: CLOSE assigned_to_visit_csr;

Line 5328: x_last_update_login => fnd_global.login_id);

5324: x_attribute15 => ue_rec.ATTRIBUTE15,
5325: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
5326: x_last_update_date => sysdate,
5327: x_last_updated_by => fnd_global.user_id,
5328: x_last_update_login => fnd_global.login_id);
5329: END LOOP;
5330: END IF;
5331: CLOSE assigned_to_visit_csr;
5332: END LOOP;