7: -- constants for WHO Columns
8: -- Added by Prithwi as a part of Public API cleanup
9:
10: G_LAST_UPDATE_DATE DATE := SYSDATE;
11: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
12: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
13: G_CREATION_DATE DATE := SYSDATE;
14: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
15:
8: -- Added by Prithwi as a part of Public API cleanup
9:
10: G_LAST_UPDATE_DATE DATE := SYSDATE;
11: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
12: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
13: G_CREATION_DATE DATE := SYSDATE;
14: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
15:
16: -- Procedure to validate the Inputs of the API
10: G_LAST_UPDATE_DATE DATE := SYSDATE;
11: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
12: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
13: G_CREATION_DATE DATE := SYSDATE;
14: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
15:
16: -- Procedure to validate the Inputs of the API
17: PROCEDURE validate_api_inputs
18: (
2864: ATTRIBUTE13,
2865: ATTRIBUTE14,
2866: ATTRIBUTE15,
2867: SYSDATE,
2868: FND_GLOBAL.user_id,
2869: SYSDATE,
2870: FND_GLOBAL.user_id,
2871: FND_GLOBAL.login_id
2872: FROM AHL_RT_OPER_ACCESS_PANELS
2866: ATTRIBUTE15,
2867: SYSDATE,
2868: FND_GLOBAL.user_id,
2869: SYSDATE,
2870: FND_GLOBAL.user_id,
2871: FND_GLOBAL.login_id
2872: FROM AHL_RT_OPER_ACCESS_PANELS
2873: WHERE object_id = p_operation_id
2874: AND association_type_code = 'OPERATION';
2867: SYSDATE,
2868: FND_GLOBAL.user_id,
2869: SYSDATE,
2870: FND_GLOBAL.user_id,
2871: FND_GLOBAL.login_id
2872: FROM AHL_RT_OPER_ACCESS_PANELS
2873: WHERE object_id = p_operation_id
2874: AND association_type_code = 'OPERATION';
2875: