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 4817: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID

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

Line 5188: l_last_updated_by := FND_GLOBAL.USER_ID;

5184: l_api_name_full CONSTANT VARCHAR2(61) := 'CS_SR_EXTATTRIBUTES_PVT'||'.'||l_api_name;
5185: l_incident_id number;
5186: BEGIN
5187: x_return_status := FND_API.G_RET_STS_SUCCESS;
5188: l_last_updated_by := FND_GLOBAL.USER_ID;
5189: l_last_update_date := SYSDATE;
5190: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5191:
5192: IF P_MODIFIED_BY IS NULL THEN

Line 5190: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 5193: l_modified_by := FND_GLOBAL.USER_ID;

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

Line 5825: l_last_updated_by := FND_GLOBAL.USER_ID;

5821: BEGIN
5822: x_return_status := FND_API.G_RET_STS_SUCCESS;
5823:
5824:
5825: l_last_updated_by := FND_GLOBAL.USER_ID;
5826: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5827: l_last_update_date := SYSDATE;
5828:
5829: IF P_MODIFIED_BY IS NULL THEN

Line 5826: l_last_update_login := FND_GLOBAL.LOGIN_ID;

5822: x_return_status := FND_API.G_RET_STS_SUCCESS;
5823:
5824:
5825: l_last_updated_by := FND_GLOBAL.USER_ID;
5826: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5827: l_last_update_date := SYSDATE;
5828:
5829: IF P_MODIFIED_BY IS NULL THEN
5830: l_modified_by := FND_GLOBAL.USER_ID;

Line 5830: l_modified_by := FND_GLOBAL.USER_ID;

5826: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5827: l_last_update_date := SYSDATE;
5828:
5829: IF P_MODIFIED_BY IS NULL THEN
5830: l_modified_by := FND_GLOBAL.USER_ID;
5831: ELSE
5832: l_modified_by := P_MODIFIED_BY;
5833: END IF;
5834: