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_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 602: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;

598:
599: BEGIN
600:
601: p_x_route_rec.last_update_date := SYSDATE;
602: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;
603: p_x_route_rec.last_update_login := FND_GLOBAL.login_id;
604:
605: IF ( p_x_route_rec.dml_operation = 'C' ) THEN
606: p_x_route_rec.revision_status_code := 'DRAFT';

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

599: BEGIN
600:
601: p_x_route_rec.last_update_date := SYSDATE;
602: p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;
603: p_x_route_rec.last_update_login := FND_GLOBAL.login_id;
604:
605: IF ( p_x_route_rec.dml_operation = 'C' ) THEN
606: p_x_route_rec.revision_status_code := 'DRAFT';
607: p_x_route_rec.object_version_number := 1;

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

606: p_x_route_rec.revision_status_code := 'DRAFT';
607: p_x_route_rec.object_version_number := 1;
608: p_x_route_rec.revision_number := 1;
609: p_x_route_rec.creation_date := SYSDATE;
610: p_x_route_rec.created_by := FND_GLOBAL.user_id;
611: END IF;
612:
613: END default_attributes;
614: */

Line 3183: X_CREATED_BY => FND_GLOBAL.user_id ,

3179: X_TITLE => l_old_route_rec.title ,
3180: X_REMARKS => l_old_route_rec.remarks ,
3181: X_REVISION_NOTES => NULL ,
3182: X_CREATION_DATE => SYSDATE ,
3183: X_CREATED_BY => FND_GLOBAL.user_id ,
3184: X_LAST_UPDATE_DATE => SYSDATE ,
3185: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3186: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3187: X_ENABLED_FLAG => 'Y',

Line 3185: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,

3181: X_REVISION_NOTES => NULL ,
3182: X_CREATION_DATE => SYSDATE ,
3183: X_CREATED_BY => FND_GLOBAL.user_id ,
3184: X_LAST_UPDATE_DATE => SYSDATE ,
3185: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3186: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3187: X_ENABLED_FLAG => 'Y',
3188: X_SUMMARY_FLAG => 'N'
3189: );

Line 3186: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,

3182: X_CREATION_DATE => SYSDATE ,
3183: X_CREATED_BY => FND_GLOBAL.user_id ,
3184: X_LAST_UPDATE_DATE => SYSDATE ,
3185: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
3186: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id,
3187: X_ENABLED_FLAG => 'Y',
3188: X_SUMMARY_FLAG => 'N'
3189: );
3190:

Line 3258: FND_GLOBAL.user_id,

3254: l_get_route_efcts.mc_id,
3255: l_get_route_efcts.mc_header_id,
3256: 1,
3257: SYSDATE,
3258: FND_GLOBAL.user_id,
3259: SYSDATE,
3260: FND_GLOBAL.user_id,
3261: FND_GLOBAL.user_id,
3262: l_get_route_efcts.security_group_id,

Line 3260: FND_GLOBAL.user_id,

3256: 1,
3257: SYSDATE,
3258: FND_GLOBAL.user_id,
3259: SYSDATE,
3260: FND_GLOBAL.user_id,
3261: FND_GLOBAL.user_id,
3262: l_get_route_efcts.security_group_id,
3263: l_get_route_efcts.ATTRIBUTE_CATEGORY,
3264: l_get_route_efcts.ATTRIBUTE1,

Line 3261: FND_GLOBAL.user_id,

3257: SYSDATE,
3258: FND_GLOBAL.user_id,
3259: SYSDATE,
3260: FND_GLOBAL.user_id,
3261: FND_GLOBAL.user_id,
3262: l_get_route_efcts.security_group_id,
3263: l_get_route_efcts.ATTRIBUTE_CATEGORY,
3264: l_get_route_efcts.ATTRIBUTE1,
3265: l_get_route_efcts.ATTRIBUTE2,

Line 3426: FND_GLOBAL.user_id,

3422: ATTRIBUTE14,
3423: ATTRIBUTE15,
3424: EXCLUDE_FLAG,
3425: SYSDATE,
3426: FND_GLOBAL.user_id,
3427: SYSDATE,
3428: FND_GLOBAL.user_id,
3429: FND_GLOBAL.login_id,
3430: IN_SERVICE --pdoki added for OGMA 105 issue

Line 3428: FND_GLOBAL.user_id,

3424: EXCLUDE_FLAG,
3425: SYSDATE,
3426: FND_GLOBAL.user_id,
3427: SYSDATE,
3428: FND_GLOBAL.user_id,
3429: FND_GLOBAL.login_id,
3430: IN_SERVICE --pdoki added for OGMA 105 issue
3431: FROM AHL_RT_OPER_MATERIALS
3432: WHERE object_id = p_route_id

Line 3429: FND_GLOBAL.login_id,

3425: SYSDATE,
3426: FND_GLOBAL.user_id,
3427: SYSDATE,
3428: FND_GLOBAL.user_id,
3429: FND_GLOBAL.login_id,
3430: IN_SERVICE --pdoki added for OGMA 105 issue
3431: FROM AHL_RT_OPER_MATERIALS
3432: WHERE object_id = p_route_id
3433: AND association_type_code = 'ROUTE';

Line 3509: FND_GLOBAL.user_id,

3505: l_get_rt_oper_resources.ATTRIBUTE13,
3506: l_get_rt_oper_resources.ATTRIBUTE14,
3507: l_get_rt_oper_resources.ATTRIBUTE15,
3508: SYSDATE,
3509: FND_GLOBAL.user_id,
3510: SYSDATE,
3511: FND_GLOBAL.user_id,
3512: FND_GLOBAL.login_id,
3513: -- Bug # 7644260 (FP for ER # 6998882) -- start

Line 3511: FND_GLOBAL.user_id,

3507: l_get_rt_oper_resources.ATTRIBUTE15,
3508: SYSDATE,
3509: FND_GLOBAL.user_id,
3510: SYSDATE,
3511: FND_GLOBAL.user_id,
3512: FND_GLOBAL.login_id,
3513: -- Bug # 7644260 (FP for ER # 6998882) -- start
3514: l_get_rt_oper_resources.SCHEDULE_SEQ
3515: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 3512: FND_GLOBAL.login_id,

3508: SYSDATE,
3509: FND_GLOBAL.user_id,
3510: SYSDATE,
3511: FND_GLOBAL.user_id,
3512: FND_GLOBAL.login_id,
3513: -- Bug # 7644260 (FP for ER # 6998882) -- start
3514: l_get_rt_oper_resources.SCHEDULE_SEQ
3515: -- Bug # 7644260 (FP for ER # 6998882) -- end
3516: );

Line 3551: FND_GLOBAL.user_id,

3547: SELECT
3548: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
3549: 1,
3550: SYSDATE,
3551: FND_GLOBAL.user_id,
3552: SYSDATE,
3553: FND_GLOBAL.user_id,
3554: FND_GLOBAL.login_id,
3555: l_rt_oper_resource_id,

Line 3553: FND_GLOBAL.user_id,

3549: 1,
3550: SYSDATE,
3551: FND_GLOBAL.user_id,
3552: SYSDATE,
3553: FND_GLOBAL.user_id,
3554: FND_GLOBAL.login_id,
3555: l_rt_oper_resource_id,
3556: aso_resource_id,
3557: priority,

Line 3554: FND_GLOBAL.login_id,

3550: SYSDATE,
3551: FND_GLOBAL.user_id,
3552: SYSDATE,
3553: FND_GLOBAL.user_id,
3554: FND_GLOBAL.login_id,
3555: l_rt_oper_resource_id,
3556: aso_resource_id,
3557: priority,
3558: ATTRIBUTE_CATEGORY,

Line 3619: X_CREATED_BY => fnd_global.user_id ,

3615: X_FIGURE => I.figure,
3616: X_PAGE => I.page,
3617: X_NOTE => I.note,
3618: X_CREATION_DATE => SYSDATE,
3619: X_CREATED_BY => fnd_global.user_id ,
3620: X_LAST_UPDATE_DATE => SYSDATE,
3621: X_LAST_UPDATED_BY => fnd_global.user_id ,
3622: X_LAST_UPDATE_LOGIN => fnd_global.login_id
3623: );

Line 3621: X_LAST_UPDATED_BY => fnd_global.user_id ,

3617: X_NOTE => I.note,
3618: X_CREATION_DATE => SYSDATE,
3619: X_CREATED_BY => fnd_global.user_id ,
3620: X_LAST_UPDATE_DATE => SYSDATE,
3621: X_LAST_UPDATED_BY => fnd_global.user_id ,
3622: X_LAST_UPDATE_LOGIN => fnd_global.login_id
3623: );
3624: END LOOP;
3625: -- 4.Copy Associated Operations

Line 3622: X_LAST_UPDATE_LOGIN => fnd_global.login_id

3618: X_CREATION_DATE => SYSDATE,
3619: X_CREATED_BY => fnd_global.user_id ,
3620: X_LAST_UPDATE_DATE => SYSDATE,
3621: X_LAST_UPDATED_BY => fnd_global.user_id ,
3622: X_LAST_UPDATE_LOGIN => fnd_global.login_id
3623: );
3624: END LOOP;
3625: -- 4.Copy Associated Operations
3626: INSERT INTO AHL_ROUTE_OPERATIONS

Line 3680: FND_GLOBAL.user_id,

3676: ATTRIBUTE13,
3677: ATTRIBUTE14,
3678: ATTRIBUTE15,
3679: SYSDATE,
3680: FND_GLOBAL.user_id,
3681: SYSDATE,
3682: FND_GLOBAL.user_id,
3683: FND_GLOBAL.login_id
3684: FROM AHL_ROUTE_OPERATIONS

Line 3682: FND_GLOBAL.user_id,

3678: ATTRIBUTE15,
3679: SYSDATE,
3680: FND_GLOBAL.user_id,
3681: SYSDATE,
3682: FND_GLOBAL.user_id,
3683: FND_GLOBAL.login_id
3684: FROM AHL_ROUTE_OPERATIONS
3685: WHERE route_id = p_route_id;
3686:

Line 3683: FND_GLOBAL.login_id

3679: SYSDATE,
3680: FND_GLOBAL.user_id,
3681: SYSDATE,
3682: FND_GLOBAL.user_id,
3683: FND_GLOBAL.login_id
3684: FROM AHL_ROUTE_OPERATIONS
3685: WHERE route_id = p_route_id;
3686:
3687: -- Adithya added to fix bug# 6525763

Line 3741: FND_GLOBAL.user_id,

3737: ATTRIBUTE13,
3738: ATTRIBUTE14,
3739: ATTRIBUTE15,
3740: SYSDATE,
3741: FND_GLOBAL.user_id,
3742: SYSDATE,
3743: FND_GLOBAL.user_id,
3744: FND_GLOBAL.login_id
3745: FROM AHL_RT_OPER_ACCESS_PANELS

Line 3743: FND_GLOBAL.user_id,

3739: ATTRIBUTE15,
3740: SYSDATE,
3741: FND_GLOBAL.user_id,
3742: SYSDATE,
3743: FND_GLOBAL.user_id,
3744: FND_GLOBAL.login_id
3745: FROM AHL_RT_OPER_ACCESS_PANELS
3746: WHERE object_id = p_route_id
3747: AND association_type_code = 'ROUTE';

Line 3744: FND_GLOBAL.login_id

3740: SYSDATE,
3741: FND_GLOBAL.user_id,
3742: SYSDATE,
3743: FND_GLOBAL.user_id,
3744: FND_GLOBAL.login_id
3745: FROM AHL_RT_OPER_ACCESS_PANELS
3746: WHERE object_id = p_route_id
3747: AND association_type_code = 'ROUTE';
3748: