DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on FND_GLOBAL

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

626: ELSIF(p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
627: --setting object version number for create
628: p_x_df_header_rec.object_version_number := 1;
629: --setting up user/create/update information
630: p_x_df_header_rec.created_by := fnd_global.user_id;
631: p_x_df_header_rec.creation_date := SYSDATE;
632: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
633: p_x_df_header_rec.last_update_date := SYSDATE;
634: p_x_df_header_rec.last_update_login := fnd_global.user_id;

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

628: p_x_df_header_rec.object_version_number := 1;
629: --setting up user/create/update information
630: p_x_df_header_rec.created_by := fnd_global.user_id;
631: p_x_df_header_rec.creation_date := SYSDATE;
632: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
633: p_x_df_header_rec.last_update_date := SYSDATE;
634: p_x_df_header_rec.last_update_login := fnd_global.user_id;
635:
636: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG)THEN

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

630: p_x_df_header_rec.created_by := fnd_global.user_id;
631: p_x_df_header_rec.creation_date := SYSDATE;
632: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
633: p_x_df_header_rec.last_update_date := SYSDATE;
634: p_x_df_header_rec.last_update_login := fnd_global.user_id;
635:
636: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG)THEN
637: p_x_df_header_rec.set_due_date := null;
638: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;

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

680:
681: -- setting up object version number
682: p_x_df_header_rec.object_version_number := p_x_df_header_rec.object_version_number + 1;
683: --setting up user/create/update information
684: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
685: p_x_df_header_rec.last_update_date := SYSDATE;
686: p_x_df_header_rec.last_update_login := fnd_global.user_id;
687:
688: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG)THEN

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

682: p_x_df_header_rec.object_version_number := p_x_df_header_rec.object_version_number + 1;
683: --setting up user/create/update information
684: p_x_df_header_rec.last_updated_by := fnd_global.user_id;
685: p_x_df_header_rec.last_update_date := SYSDATE;
686: p_x_df_header_rec.last_update_login := fnd_global.user_id;
687:
688: IF(p_x_df_header_rec.skip_mr_flag = G_YES_FLAG)THEN
689: p_x_df_header_rec.set_due_date := null;
690: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;

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

838: fnd_log.string
839: (
840: fnd_log.level_statement,
841: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
842: 'user id : ' || FND_GLOBAL.USER_ID()
843: );
844: fnd_log.string
845: (
846: fnd_log.level_statement,

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

844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
848: 'resp id : ' || FND_GLOBAL.RESP_ID()
849: );
850: fnd_log.string
851: (
852: fnd_log.level_statement,

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

850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
854: 'resp appl id : ' || FND_GLOBAL.resp_appl_id()
855: );
856: END IF;
857: END log_df_header;
858:

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

1977: IF (p_x_df_schedules_tbl(i).operation_flag = G_OP_UPDATE) THEN
1978:
1979: p_x_df_schedules_tbl(i).object_version_number := p_x_df_schedules_tbl(i).object_version_number + 1;
1980:
1981: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
1982: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
1983: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
1984:
1985: AHL_UNIT_THRESHOLDS_PKG.update_row(

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

1979: p_x_df_schedules_tbl(i).object_version_number := p_x_df_schedules_tbl(i).object_version_number + 1;
1980:
1981: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
1982: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
1983: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
1984:
1985: AHL_UNIT_THRESHOLDS_PKG.update_row(
1986: p_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
1987: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,

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

2015: IF(p_x_df_schedules_tbl(i).operation_flag = G_OP_CREATE) THEN
2016:
2017: p_x_df_schedules_tbl(i).object_version_number := 1;
2018:
2019: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2020: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2021: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2022: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2023: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;

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

2017: p_x_df_schedules_tbl(i).object_version_number := 1;
2018:
2019: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2020: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2021: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2022: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2023: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2024:
2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(

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

2019: p_x_df_schedules_tbl(i).created_by := fnd_global.user_id;
2020: p_x_df_schedules_tbl(i).creation_date := SYSDATE;
2021: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2022: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2023: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2024:
2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(
2026: p_x_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2027: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,

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

3039: P_OBJECT_VERSION_NUMBER => p_df_header_rec.object_version_number,
3040: P_ORIG_STATUS_CODE => p_df_header_rec.approval_status_code,
3041: P_NEW_STATUS_CODE => l_new_status_code ,
3042: P_REJECT_STATUS_CODE => 'DEFERRAL_REJECTED',
3043: P_REQUESTER_USERID => fnd_global.user_id,--1003259,--
3044: P_NOTES_FROM_REQUESTER => '',
3045: P_WORKFLOWPROCESS => 'AHL_GEN_APPROVAL',
3046: P_ITEM_TYPE => 'AHLGAPP');
3047: ELSE

Line 4491: X_CREATED_BY => fnd_global.user_id,

4487: X_POSITION_PATH_ID => ue_rec.position_path_id,
4488: X_ATA_CODE => ue_rec.ATA_CODE,
4489: X_UNIT_CONFIG_HEADER_ID => ue_rec.unit_config_header_id,
4490: X_CREATION_DATE => sysdate,
4491: X_CREATED_BY => fnd_global.user_id,
4492: X_LAST_UPDATE_DATE => sysdate,
4493: X_LAST_UPDATED_BY => fnd_global.user_id,
4494: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4495:

Line 4493: X_LAST_UPDATED_BY => fnd_global.user_id,

4489: X_UNIT_CONFIG_HEADER_ID => ue_rec.unit_config_header_id,
4490: X_CREATION_DATE => sysdate,
4491: X_CREATED_BY => fnd_global.user_id,
4492: X_LAST_UPDATE_DATE => sysdate,
4493: X_LAST_UPDATED_BY => fnd_global.user_id,
4494: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4495:
4496: IF(ue_rec.unit_effectivity_id = l_unit_effectivity_id)THEN
4497: l_new_parent_ue_id := l_new_unit_effectivity_id;

Line 4494: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

4490: X_CREATION_DATE => sysdate,
4491: X_CREATED_BY => fnd_global.user_id,
4492: X_LAST_UPDATE_DATE => sysdate,
4493: X_LAST_UPDATED_BY => fnd_global.user_id,
4494: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4495:
4496: IF(ue_rec.unit_effectivity_id = l_unit_effectivity_id)THEN
4497: l_new_parent_ue_id := l_new_unit_effectivity_id;
4498: END IF;

Line 4575: x_last_updated_by => fnd_global.user_id,

4571: x_attribute14 => ue_rec.ATTRIBUTE14,
4572: x_attribute15 => ue_rec.ATTRIBUTE15,
4573: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4574: x_last_update_date => sysdate,
4575: x_last_updated_by => fnd_global.user_id,
4576: x_last_update_login => fnd_global.login_id
4577: );
4578:
4579: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id

Line 4576: x_last_update_login => fnd_global.login_id

4572: x_attribute15 => ue_rec.ATTRIBUTE15,
4573: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4574: x_last_update_date => sysdate,
4575: x_last_updated_by => fnd_global.user_id,
4576: x_last_update_login => fnd_global.login_id
4577: );
4578:
4579: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id
4580: * This call should be made only when p_new_status = 'DEFERRED' as SR can not be terminated

Line 4695: X_LAST_UPDATED_BY => fnd_global.user_id,

4691: X_ATTRIBUTE14 => null,
4692: X_ATTRIBUTE15 => null,
4693: X_OBJECT_VERSION_NUMBER => 1,
4694: X_LAST_UPDATE_DATE => sysdate,
4695: X_LAST_UPDATED_BY => fnd_global.user_id,
4696: X_CREATION_DATE => sysdate,
4697: X_CREATED_BY => fnd_global.user_id,
4698: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4699: END LOOP;

Line 4697: X_CREATED_BY => fnd_global.user_id,

4693: X_OBJECT_VERSION_NUMBER => 1,
4694: X_LAST_UPDATE_DATE => sysdate,
4695: X_LAST_UPDATED_BY => fnd_global.user_id,
4696: X_CREATION_DATE => sysdate,
4697: X_CREATED_BY => fnd_global.user_id,
4698: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4699: END LOOP;
4700: END IF;
4701: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id

Line 4698: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

4694: X_LAST_UPDATE_DATE => sysdate,
4695: X_LAST_UPDATED_BY => fnd_global.user_id,
4696: X_CREATION_DATE => sysdate,
4697: X_CREATED_BY => fnd_global.user_id,
4698: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4699: END LOOP;
4700: END IF;
4701: /* Insert SR update status call here after making sure that object type is 'SR' for p_unit_effectivity_id
4702: * This call should be made only when p_new_status = 'DEFERRED' as SR can not be terminated

Line 4774: x_last_updated_by => fnd_global.user_id,

4770: x_attribute14 => ue_rec.ATTRIBUTE14,
4771: x_attribute15 => ue_rec.ATTRIBUTE15,
4772: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4773: x_last_update_date => sysdate,
4774: x_last_updated_by => fnd_global.user_id,
4775: x_last_update_login => fnd_global.login_id);
4776: END IF;
4777: END LOOP;
4778: END IF;

Line 4775: x_last_update_login => fnd_global.login_id);

4771: x_attribute15 => ue_rec.ATTRIBUTE15,
4772: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4773: x_last_update_date => sysdate,
4774: x_last_updated_by => fnd_global.user_id,
4775: x_last_update_login => fnd_global.login_id);
4776: END IF;
4777: END LOOP;
4778: END IF;
4779:

Line 4949: x_last_updated_by => fnd_global.user_id,

4945: x_attribute14 => ue_rec.ATTRIBUTE14,
4946: x_attribute15 => ue_rec.ATTRIBUTE15,
4947: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4948: x_last_update_date => sysdate,
4949: x_last_updated_by => fnd_global.user_id,
4950: x_last_update_login => fnd_global.login_id);
4951: END LOOP;
4952: END IF;
4953: CLOSE assigned_to_visit_csr;

Line 4950: x_last_update_login => fnd_global.login_id);

4946: x_attribute15 => ue_rec.ATTRIBUTE15,
4947: x_object_version_number => ue_rec.OBJECT_VERSION_NUMBER + 1,
4948: x_last_update_date => sysdate,
4949: x_last_updated_by => fnd_global.user_id,
4950: x_last_update_login => fnd_global.login_id);
4951: END LOOP;
4952: END IF;
4953: CLOSE assigned_to_visit_csr;
4954: END LOOP;