DBA Data[Home] [Help]

APPS.BIS_MEASURE_PVT dependencies on FND_GLOBAL

Line 327: l_login_id := fnd_global.LOGIN_ID;

323: end if;
324:
325: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
326:
327: l_login_id := fnd_global.LOGIN_ID;
328:
329: insert into bis_indicator_dimensions
330: (
331: INDICATOR_ID

Line 1025: l_Measure_Rec.Last_Update_Login := fnd_global.LOGIN_ID;

1021: IF (l_Measure_Rec.Last_Updated_By IS NULL) THEN
1022: l_Measure_Rec.Last_Updated_By := l_Measure_Rec.Created_By;
1023: END IF;
1024: IF (l_Measure_Rec.Last_Update_Login IS NULL) THEN
1025: l_Measure_Rec.Last_Update_Login := fnd_global.LOGIN_ID;
1026: END IF;
1027: IF (l_Measure_Rec.Creation_Date IS NULL) THEN
1028: l_Measure_Rec.Creation_Date := sysdate;
1029: END IF;

Line 1302: l_Measure_Rec.Last_Update_Login := fnd_global.LOGIN_ID;

1298: IF (l_Measure_Rec.Last_Updated_By IS NULL) THEN
1299: l_Measure_Rec.Last_Updated_By := l_Measure_Rec.Created_By;
1300: END IF;
1301: IF (l_Measure_Rec.Last_Update_Login IS NULL) THEN
1302: l_Measure_Rec.Last_Update_Login := fnd_global.LOGIN_ID;
1303: END IF;
1304: IF (l_Measure_Rec.Creation_Date IS NULL) THEN
1305: l_Measure_Rec.Creation_Date := sysdate;
1306: END IF;

Line 1887: l_login_id := fnd_global.LOGIN_ID;

1883: return;
1884: end if;
1885:
1886: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1887: l_login_id := fnd_global.LOGIN_ID;
1888:
1889: UPDATE bis_indicator_dimensions
1890: set
1891: Dimension_ID = p_dimension_id

Line 2686: l_login_id := fnd_global.LOGIN_ID;

2682: , x_Measure_Rec => l_measure_rec
2683: ) ;
2684:
2685: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
2686: l_login_id := fnd_global.LOGIN_ID;
2687:
2688: l_Measure_Rec.Last_Updated_By := l_user_id;
2689: l_Measure_Rec.Last_Update_Login := l_login_id;
2690:

Line 2939: l_login_id := fnd_global.LOGIN_ID;

2935: );
2936:
2937:
2938: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
2939: l_login_id := fnd_global.LOGIN_ID;
2940:
2941: l_Measure_Rec.Last_Update_Date := p_Measure_Rec.Last_Update_Date;
2942: IF (l_Measure_Rec.Last_Update_Date IS NULL) THEN
2943: l_Measure_Rec.Last_Update_Date := SYSDATE;

Line 3254: l_login_id := fnd_global.LOGIN_ID;

3250: --
3251:
3252: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3253:
3254: l_login_id := fnd_global.LOGIN_ID;
3255: --
3256:
3257: Update bis_INDICATORS_TL
3258: set

Line 5243: l_login_id := fnd_global.LOGIN_ID;

5239: SAVEPOINT TransMeasByLangPvt;
5240:
5241: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
5242:
5243: l_login_id := fnd_global.LOGIN_ID;
5244:
5245: Update bis_INDICATORS_TL
5246: set
5247: NAME = p_Measure_Rec.Measure_Name

Line 5296: AND (user_id = fnd_global.user_id

5292: ORG_ID,
5293: SITE_ID
5294: FROM BIS_IND_CUSTOMIZATIONS
5295: WHERE INDICATOR_ID = p_indicator_id
5296: AND (user_id = fnd_global.user_id
5297: OR responsibility_id = fnd_global.RESP_ID
5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;

Line 5297: OR responsibility_id = fnd_global.RESP_ID

5293: SITE_ID
5294: FROM BIS_IND_CUSTOMIZATIONS
5295: WHERE INDICATOR_ID = p_indicator_id
5296: AND (user_id = fnd_global.user_id
5297: OR responsibility_id = fnd_global.RESP_ID
5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;

Line 5298: OR application_id = fnd_global.RESP_APPL_ID

5294: FROM BIS_IND_CUSTOMIZATIONS
5295: WHERE INDICATOR_ID = p_indicator_id
5296: AND (user_id = fnd_global.user_id
5297: OR responsibility_id = fnd_global.RESP_ID
5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;

Line 5299: OR org_id = fnd_global.ORG_ID

5295: WHERE INDICATOR_ID = p_indicator_id
5296: AND (user_id = fnd_global.user_id
5297: OR responsibility_id = fnd_global.RESP_ID
5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;

Line 5474: last_updated_by = FND_GLOBAL.USER_ID ,

5470: UPDATE bis_indicators
5471: SET
5472: obsolete = p_obsolete ,
5473: last_update_date = SYSDATE,
5474: last_updated_by = FND_GLOBAL.USER_ID ,
5475: last_update_login = FND_GLOBAL.USER_ID
5476: WHERE short_name = p_measure_short_name;
5477:
5478: IF(p_Commit = FND_API.G_TRUE) THEN

Line 5475: last_update_login = FND_GLOBAL.USER_ID

5471: SET
5472: obsolete = p_obsolete ,
5473: last_update_date = SYSDATE,
5474: last_updated_by = FND_GLOBAL.USER_ID ,
5475: last_update_login = FND_GLOBAL.USER_ID
5476: WHERE short_name = p_measure_short_name;
5477:
5478: IF(p_Commit = FND_API.G_TRUE) THEN
5479: commit;