APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on FND_GLOBAL

Line 17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

13: G_PROC_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROC_NAME';
14: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';
15:
16:
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
19:
20:
21: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;

Line 18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

14: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';
15:
16:
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
19:
20:
21: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
22: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;

Line 264: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID

260: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261: ,p_incident_id IN NUMBER
262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
264: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
265: ,p_modified_on IN DATE := SYSDATE
266: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
267: ,x_return_status OUT NOCOPY VARCHAR2
268: ,x_errorcode OUT NOCOPY NUMBER

Line 2135: g_newline varchar2(8) := fnd_global.newline;

2131: l_unique_value_date DATE;
2132: l_unique_value_uom VARCHAR2(3);
2133:
2134: l_sql VARCHAR2(4000);
2135: g_newline varchar2(8) := fnd_global.newline;
2136: l_cs_sr_contacts_ext_rec cs_sr_contacts_ext%ROWTYPE;
2137:
2138:
2139: v_get_ext_attr_db_rec c_get_ext_attr_db_rec%ROWTYPE;

Line 4815: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID

4811: PROCEDURE Create_Ext_Attr_Audit(
4812: p_sr_ea_new_audit_rec_table IN Ext_Attr_Audit_Tbl_Type
4813: ,p_sr_ea_old_audit_rec_table IN Ext_Attr_Audit_Tbl_Type
4814: ,p_object_name IN VARCHAR2
4815: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
4816: ,p_modified_on IN DATE := SYSDATE
4817: ,x_return_status OUT NOCOPY VARCHAR2
4818: ,x_msg_count OUT NOCOPY NUMBER
4819: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5185: l_last_updated_by := FND_GLOBAL.USER_ID;

5181: l_api_name CONSTANT VARCHAR2(30) := 'insert_sr_row';
5182: l_api_name_full CONSTANT VARCHAR2(61) := 'CS_SR_EXTATTRIBUTES_PVT'||'.'||l_api_name;
5183: BEGIN
5184: x_return_status := FND_API.G_RET_STS_SUCCESS;
5185: l_last_updated_by := FND_GLOBAL.USER_ID;
5186: l_last_update_date := SYSDATE;
5187: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5188:
5189: IF P_MODIFIED_BY IS NULL THEN

Line 5187: l_last_update_login := FND_GLOBAL.LOGIN_ID;

5183: BEGIN
5184: x_return_status := FND_API.G_RET_STS_SUCCESS;
5185: l_last_updated_by := FND_GLOBAL.USER_ID;
5186: l_last_update_date := SYSDATE;
5187: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5188:
5189: IF P_MODIFIED_BY IS NULL THEN
5190: l_modified_by := FND_GLOBAL.USER_ID;
5191: ELSE

Line 5190: l_modified_by := FND_GLOBAL.USER_ID;

5186: l_last_update_date := SYSDATE;
5187: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5188:
5189: IF P_MODIFIED_BY IS NULL THEN
5190: l_modified_by := FND_GLOBAL.USER_ID;
5191: ELSE
5192: l_modified_by := P_MODIFIED_BY;
5193: END IF;
5194:

Line 5810: l_last_updated_by := FND_GLOBAL.USER_ID;

5806: BEGIN
5807: x_return_status := FND_API.G_RET_STS_SUCCESS;
5808:
5809:
5810: l_last_updated_by := FND_GLOBAL.USER_ID;
5811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5812: l_last_update_date := SYSDATE;
5813:
5814: IF P_MODIFIED_BY IS NULL THEN

Line 5811: l_last_update_login := FND_GLOBAL.LOGIN_ID;

5807: x_return_status := FND_API.G_RET_STS_SUCCESS;
5808:
5809:
5810: l_last_updated_by := FND_GLOBAL.USER_ID;
5811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5812: l_last_update_date := SYSDATE;
5813:
5814: IF P_MODIFIED_BY IS NULL THEN
5815: l_modified_by := FND_GLOBAL.USER_ID;

Line 5815: l_modified_by := FND_GLOBAL.USER_ID;

5811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5812: l_last_update_date := SYSDATE;
5813:
5814: IF P_MODIFIED_BY IS NULL THEN
5815: l_modified_by := FND_GLOBAL.USER_ID;
5816: ELSE
5817: l_modified_by := P_MODIFIED_BY;
5818: END IF;
5819: