APPS.BIS_APPLICATION_MEASURE_PVT dependencies on BIS_APPLICATION_MEASURES

Line 95: SELECT count(1) FROM BIS_APPLICATION_MEASURES

91: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
92: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
93:
94: CURSOR c_app_meas(cp_ind_id IN NUMBER) IS
95: SELECT count(1) FROM BIS_APPLICATION_MEASURES
96: WHERE indicator_id = cp_ind_id;
97: l_count NUMBER := 0;
98: BEGIN
99: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 157: insert into bis_application_measures

153: -- dbms_output.put_line( l_Rec.OWNING_APPLICATION);
154: -- dbms_output.put_line( l_user_id);
155: -- dbms_output.put_line(l_login_id );
156:
157: insert into bis_application_measures
158: (
159: INDICATOR_ID
160: , APPLICATION_ID
161: , OWNING_APPLICATION

Line 439: from bis_application_measures

435:
436: -- mdamle 07/08/2003 - There have been occurrences of bad data when
437: -- an application_id record is missing for an indicator.
438: select count(1) into l_count
439: from bis_application_measures
440: where INDICATOR_ID = l_rec.Measure_Id;
441:
442: if (l_count = 0) then
443: Create_Application_Measure

Line 459: Update bis_application_measures

455: ELSE
456: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;
457: END IF;
458:
459: Update bis_application_measures
460: set
461: OWNING_APPLICATION = l_Rec.OWNING_APPLICATION
462: , LAST_UPDATE_DATE = SYSDATE
463: , LAST_UPDATED_BY = l_user_id

Line 531: delete from bis_application_measures

527: , x_return_status
528: , x_error_Tbl
529: );
530:
531: delete from bis_application_measures
532: where APPLICATION_ID = l_Rec.Application_id
533: AND indicator_id = l_Rec.Measure_id;
534:
535:

Line 791: FROM bis_application_measures

787: = FND_API.G_FALSE
788: ) THEN
789: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
790: INTO x_last_update_date
791: FROM bis_application_measures
792: WHERE INDICATOR_ID = p_Application_Measure_Rec.Measure_id
793: AND Application_ID = p_Application_Measure_Rec.Application_id;
794:
795: END IF;

Line 895: , p_Application_Id IN BIS_APPLICATION_MEASURES.APPLICATION_ID%TYPE

891: PROCEDURE Update_Application_Measure
892: ( p_api_version IN NUMBER
893: , p_commit IN VARCHAR2 := FND_API.G_FALSE
894: , p_Measure_Short_Name IN BIS_INDICATORS.SHORT_NAME%TYPE
895: , p_Application_Id IN BIS_APPLICATION_MEASURES.APPLICATION_ID%TYPE
896: , x_return_status OUT NOCOPY VARCHAR2
897: , x_msg_count OUT NOCOPY NUMBER
898: , x_msg_data OUT NOCOPY VARCHAR2
899: )