DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PVT dependencies on FND_GLOBAL

Line 10: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;

6:
7: -- constants for WHO Columns
8: -- Added by balaji as a part of Public API cleanup
9: G_LAST_UPDATE_DATE DATE := SYSDATE;
10: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
12: G_CREATION_DATE DATE := SYSDATE;
13: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
14:

Line 11: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;

7: -- constants for WHO Columns
8: -- Added by balaji as a part of Public API cleanup
9: G_LAST_UPDATE_DATE DATE := SYSDATE;
10: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
12: G_CREATION_DATE DATE := SYSDATE;
13: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
14:
15: -- Procedure to validate the Inputs of the API

Line 13: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;

9: G_LAST_UPDATE_DATE DATE := SYSDATE;
10: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
12: G_CREATION_DATE DATE := SYSDATE;
13: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
14:
15: -- Procedure to validate the Inputs of the API
16: PROCEDURE validate_api_inputs
17: (

Line 698: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;

694:
695: BEGIN
696:
697: p_x_route_rec.last_update_date := SYSDATE;
698: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;
699: p_x_route_rec.last_update_login := FND_GLOBAL.login_id;
700:
701: IF ( p_x_route_rec.dml_operation = 'C' ) THEN
702: p_x_route_rec.revision_status_code := 'DRAFT';

Line 699: p_x_route_rec.last_update_login := FND_GLOBAL.login_id;

695: BEGIN
696:
697: p_x_route_rec.last_update_date := SYSDATE;
698: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;
699: p_x_route_rec.last_update_login := FND_GLOBAL.login_id;
700:
701: IF ( p_x_route_rec.dml_operation = 'C' ) THEN
702: p_x_route_rec.revision_status_code := 'DRAFT';
703: p_x_route_rec.object_version_number := 1;

Line 706: p_x_route_rec.created_by := FND_GLOBAL.user_id;

702: p_x_route_rec.revision_status_code := 'DRAFT';
703: p_x_route_rec.object_version_number := 1;
704: p_x_route_rec.revision_number := 1;
705: p_x_route_rec.creation_date := SYSDATE;
706: p_x_route_rec.created_by := FND_GLOBAL.user_id;
707: END IF;
708:
709: END default_attributes;
710: */

Line 3353: FND_GLOBAL.user_id last_updated_by,

3349: ATTRIBUTE13,
3350: ATTRIBUTE14,
3351: ATTRIBUTE15,
3352: SYSDATE last_update_date,
3353: FND_GLOBAL.user_id last_updated_by,
3354: SYSDATE creation_date,
3355: FND_GLOBAL.user_id created_by,
3356: FND_GLOBAL.login_id last_update_login
3357: FROM AHL_ROUTE_OPERATIONS_V

Line 3355: FND_GLOBAL.user_id created_by,

3351: ATTRIBUTE15,
3352: SYSDATE last_update_date,
3353: FND_GLOBAL.user_id last_updated_by,
3354: SYSDATE creation_date,
3355: FND_GLOBAL.user_id created_by,
3356: FND_GLOBAL.login_id last_update_login
3357: FROM AHL_ROUTE_OPERATIONS_V
3358: WHERE route_id = c_route_id
3359: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;

Line 3356: FND_GLOBAL.login_id last_update_login

3352: SYSDATE last_update_date,
3353: FND_GLOBAL.user_id last_updated_by,
3354: SYSDATE creation_date,
3355: FND_GLOBAL.user_id created_by,
3356: FND_GLOBAL.login_id last_update_login
3357: FROM AHL_ROUTE_OPERATIONS_V
3358: WHERE route_id = c_route_id
3359: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;
3360:

Line 3368: FND_GLOBAL.user_id last_updated_by,

3364: SELECT
3365: AHL_RT_OPER_DEP_S.NEXTVAL rt_op_dependency_id,
3366: 1 OBJECT_VERSION_NUMBER,
3367: SYSDATE last_update_date,
3368: FND_GLOBAL.user_id last_updated_by,
3369: SYSDATE creation_date,
3370: FND_GLOBAL.user_id created_by,
3371: FND_GLOBAL.login_id last_update_login,
3372: FROM_RT_OP_ID,

Line 3370: FND_GLOBAL.user_id created_by,

3366: 1 OBJECT_VERSION_NUMBER,
3367: SYSDATE last_update_date,
3368: FND_GLOBAL.user_id last_updated_by,
3369: SYSDATE creation_date,
3370: FND_GLOBAL.user_id created_by,
3371: FND_GLOBAL.login_id last_update_login,
3372: FROM_RT_OP_ID,
3373: FROM_OP_STEP,
3374: DEPENDENCY_CODE,

Line 3371: FND_GLOBAL.login_id last_update_login,

3367: SYSDATE last_update_date,
3368: FND_GLOBAL.user_id last_updated_by,
3369: SYSDATE creation_date,
3370: FND_GLOBAL.user_id created_by,
3371: FND_GLOBAL.login_id last_update_login,
3372: FROM_RT_OP_ID,
3373: FROM_OP_STEP,
3374: DEPENDENCY_CODE,
3375: TO_RT_OP_ID,

Line 3600: X_CREATED_BY => FND_GLOBAL.user_id ,

3596: X_TITLE => l_old_route_rec.title ,
3597: X_REMARKS => l_old_route_rec.remarks ,
3598: X_REVISION_NOTES => l_old_route_rec.REVISION_NOTES ,
3599: X_CREATION_DATE => SYSDATE ,
3600: X_CREATED_BY => FND_GLOBAL.user_id ,
3601: X_LAST_UPDATE_DATE => SYSDATE ,
3602: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3603: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3604: X_ENABLED_FLAG => 'Y',

Line 3602: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,

3598: X_REVISION_NOTES => l_old_route_rec.REVISION_NOTES ,
3599: X_CREATION_DATE => SYSDATE ,
3600: X_CREATED_BY => FND_GLOBAL.user_id ,
3601: X_LAST_UPDATE_DATE => SYSDATE ,
3602: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3603: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3604: X_ENABLED_FLAG => 'Y',
3605: X_SUMMARY_FLAG => 'N'
3606: );

Line 3603: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,

3599: X_CREATION_DATE => SYSDATE ,
3600: X_CREATED_BY => FND_GLOBAL.user_id ,
3601: X_LAST_UPDATE_DATE => SYSDATE ,
3602: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3603: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3604: X_ENABLED_FLAG => 'Y',
3605: X_SUMMARY_FLAG => 'N'
3606: );
3607:

Line 3675: FND_GLOBAL.user_id,

3671: l_get_route_efcts.mc_id,
3672: l_get_route_efcts.mc_header_id,
3673: 1,
3674: SYSDATE,
3675: FND_GLOBAL.user_id,
3676: SYSDATE,
3677: FND_GLOBAL.user_id,
3678: FND_GLOBAL.user_id,
3679: l_get_route_efcts.security_group_id,

Line 3677: FND_GLOBAL.user_id,

3673: 1,
3674: SYSDATE,
3675: FND_GLOBAL.user_id,
3676: SYSDATE,
3677: FND_GLOBAL.user_id,
3678: FND_GLOBAL.user_id,
3679: l_get_route_efcts.security_group_id,
3680: l_get_route_efcts.ATTRIBUTE_CATEGORY,
3681: l_get_route_efcts.ATTRIBUTE1,

Line 3678: FND_GLOBAL.user_id,

3674: SYSDATE,
3675: FND_GLOBAL.user_id,
3676: SYSDATE,
3677: FND_GLOBAL.user_id,
3678: FND_GLOBAL.user_id,
3679: l_get_route_efcts.security_group_id,
3680: l_get_route_efcts.ATTRIBUTE_CATEGORY,
3681: l_get_route_efcts.ATTRIBUTE1,
3682: l_get_route_efcts.ATTRIBUTE2,

Line 3847: FND_GLOBAL.user_id,

3843: ATTRIBUTE14,
3844: ATTRIBUTE15,
3845: EXCLUDE_FLAG,
3846: SYSDATE,
3847: FND_GLOBAL.user_id,
3848: SYSDATE,
3849: FND_GLOBAL.user_id,
3850: FND_GLOBAL.login_id,
3851: IN_SERVICE, --pdoki added for OGMA 105 issue

Line 3849: FND_GLOBAL.user_id,

3845: EXCLUDE_FLAG,
3846: SYSDATE,
3847: FND_GLOBAL.user_id,
3848: SYSDATE,
3849: FND_GLOBAL.user_id,
3850: FND_GLOBAL.login_id,
3851: IN_SERVICE, --pdoki added for OGMA 105 issue
3852: --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
3853: MC_ID,

Line 3850: FND_GLOBAL.login_id,

3846: SYSDATE,
3847: FND_GLOBAL.user_id,
3848: SYSDATE,
3849: FND_GLOBAL.user_id,
3850: FND_GLOBAL.login_id,
3851: IN_SERVICE, --pdoki added for OGMA 105 issue
3852: --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
3853: MC_ID,
3854: POSITION_KEY

Line 3933: FND_GLOBAL.user_id,

3929: l_get_rt_oper_resources.ATTRIBUTE13,
3930: l_get_rt_oper_resources.ATTRIBUTE14,
3931: l_get_rt_oper_resources.ATTRIBUTE15,
3932: SYSDATE,
3933: FND_GLOBAL.user_id,
3934: SYSDATE,
3935: FND_GLOBAL.user_id,
3936: FND_GLOBAL.login_id,
3937: -- Bug # 7644260 (FP for ER # 6998882) -- start

Line 3935: FND_GLOBAL.user_id,

3931: l_get_rt_oper_resources.ATTRIBUTE15,
3932: SYSDATE,
3933: FND_GLOBAL.user_id,
3934: SYSDATE,
3935: FND_GLOBAL.user_id,
3936: FND_GLOBAL.login_id,
3937: -- Bug # 7644260 (FP for ER # 6998882) -- start
3938: l_get_rt_oper_resources.SCHEDULE_SEQ
3939: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 3936: FND_GLOBAL.login_id,

3932: SYSDATE,
3933: FND_GLOBAL.user_id,
3934: SYSDATE,
3935: FND_GLOBAL.user_id,
3936: FND_GLOBAL.login_id,
3937: -- Bug # 7644260 (FP for ER # 6998882) -- start
3938: l_get_rt_oper_resources.SCHEDULE_SEQ
3939: -- Bug # 7644260 (FP for ER # 6998882) -- end
3940: );

Line 3975: FND_GLOBAL.user_id,

3971: SELECT
3972: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
3973: 1,
3974: SYSDATE,
3975: FND_GLOBAL.user_id,
3976: SYSDATE,
3977: FND_GLOBAL.user_id,
3978: FND_GLOBAL.login_id,
3979: l_rt_oper_resource_id,

Line 3977: FND_GLOBAL.user_id,

3973: 1,
3974: SYSDATE,
3975: FND_GLOBAL.user_id,
3976: SYSDATE,
3977: FND_GLOBAL.user_id,
3978: FND_GLOBAL.login_id,
3979: l_rt_oper_resource_id,
3980: aso_resource_id,
3981: priority,

Line 3978: FND_GLOBAL.login_id,

3974: SYSDATE,
3975: FND_GLOBAL.user_id,
3976: SYSDATE,
3977: FND_GLOBAL.user_id,
3978: FND_GLOBAL.login_id,
3979: l_rt_oper_resource_id,
3980: aso_resource_id,
3981: priority,
3982: ATTRIBUTE_CATEGORY,

Line 4044: X_CREATED_BY => fnd_global.user_id ,

4040: X_FIGURE => I.figure,
4041: X_PAGE => I.page,
4042: X_NOTE => I.note,
4043: X_CREATION_DATE => SYSDATE,
4044: X_CREATED_BY => fnd_global.user_id ,
4045: X_LAST_UPDATE_DATE => SYSDATE,
4046: X_LAST_UPDATED_BY => fnd_global.user_id ,
4047: X_LAST_UPDATE_LOGIN => fnd_global.login_id
4048: );

Line 4046: X_LAST_UPDATED_BY => fnd_global.user_id ,

4042: X_NOTE => I.note,
4043: X_CREATION_DATE => SYSDATE,
4044: X_CREATED_BY => fnd_global.user_id ,
4045: X_LAST_UPDATE_DATE => SYSDATE,
4046: X_LAST_UPDATED_BY => fnd_global.user_id ,
4047: X_LAST_UPDATE_LOGIN => fnd_global.login_id
4048: );
4049: -- pekambar changes for bug # 9342005 -- End
4050: END LOOP;

Line 4047: X_LAST_UPDATE_LOGIN => fnd_global.login_id

4043: X_CREATION_DATE => SYSDATE,
4044: X_CREATED_BY => fnd_global.user_id ,
4045: X_LAST_UPDATE_DATE => SYSDATE,
4046: X_LAST_UPDATED_BY => fnd_global.user_id ,
4047: X_LAST_UPDATE_LOGIN => fnd_global.login_id
4048: );
4049: -- pekambar changes for bug # 9342005 -- End
4050: END LOOP;
4051: -- Pekambar(Praveen) Modifed for USAF - VEE - Start

Line 4107: FND_GLOBAL.user_id,

4103: ATTRIBUTE13,
4104: ATTRIBUTE14,
4105: ATTRIBUTE15,
4106: SYSDATE,
4107: FND_GLOBAL.user_id,
4108: SYSDATE,
4109: FND_GLOBAL.user_id,
4110: FND_GLOBAL.login_id
4111: FROM AHL_ROUTE_OPERATIONS_V

Line 4109: FND_GLOBAL.user_id,

4105: ATTRIBUTE15,
4106: SYSDATE,
4107: FND_GLOBAL.user_id,
4108: SYSDATE,
4109: FND_GLOBAL.user_id,
4110: FND_GLOBAL.login_id
4111: FROM AHL_ROUTE_OPERATIONS_V
4112: WHERE route_id = p_route_id
4113: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;

Line 4110: FND_GLOBAL.login_id

4106: SYSDATE,
4107: FND_GLOBAL.user_id,
4108: SYSDATE,
4109: FND_GLOBAL.user_id,
4110: FND_GLOBAL.login_id
4111: FROM AHL_ROUTE_OPERATIONS_V
4112: WHERE route_id = p_route_id
4113: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;
4114: */

Line 4237: FND_GLOBAL.user_id,

4233: ATTRIBUTE13,
4234: ATTRIBUTE14,
4235: ATTRIBUTE15,
4236: SYSDATE,
4237: FND_GLOBAL.user_id,
4238: SYSDATE,
4239: FND_GLOBAL.user_id,
4240: FND_GLOBAL.login_id
4241: FROM AHL_RT_OPER_ACCESS_PANELS

Line 4239: FND_GLOBAL.user_id,

4235: ATTRIBUTE15,
4236: SYSDATE,
4237: FND_GLOBAL.user_id,
4238: SYSDATE,
4239: FND_GLOBAL.user_id,
4240: FND_GLOBAL.login_id
4241: FROM AHL_RT_OPER_ACCESS_PANELS
4242: WHERE object_id = p_route_id
4243: AND association_type_code = 'ROUTE';

Line 4240: FND_GLOBAL.login_id

4236: SYSDATE,
4237: FND_GLOBAL.user_id,
4238: SYSDATE,
4239: FND_GLOBAL.user_id,
4240: FND_GLOBAL.login_id
4241: FROM AHL_RT_OPER_ACCESS_PANELS
4242: WHERE object_id = p_route_id
4243: AND association_type_code = 'ROUTE';
4244: