eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_FLEX_VALUESET_VERSION_B

Line 801: FROM ego_flex_valueset_version_b

797:
798: CURSOR Cur_Version_date
799: IS
800: SELECT start_active_date, end_active_date
801: FROM ego_flex_valueset_version_b
802: WHERE flex_value_set_id = l_value_set_id
803: AND version_seq_id = l_version_seq_id;
804:
805:

Line 1941: FROM ego_flex_valueset_version_b

1937:
1938: CURSOR Getversiondates
1939: IS
1940: SELECT start_active_date ,end_active_date,version_seq_id
1941: FROM ego_flex_valueset_version_b
1942: WHERE flex_value_set_id = p_value_set_id AND version_seq_id <> 0 ;
1943:
1944:
1945: -- Cursor to get maximum available version on target instance.

Line 1949: FROM ego_flex_valueset_version_b

1945: -- Cursor to get maximum available version on target instance.
1946: CURSOR Cur_Max_Ver(cp_value_set_id NUMBER)
1947: IS
1948: SELECT Max(version_seq_id) max_ver --,start_active_date, end_active_date
1949: FROM ego_flex_valueset_version_b
1950: WHERE flex_value_set_id = cp_value_set_id
1951: AND version_seq_id <> 0;
1952:
1953:

Line 1959: FROM ego_flex_valueset_version_b

1955: -- Cursor to check if draft version is there.
1956: CURSOR Cur_Draft_Ver(cp_value_set_id NUMBER)
1957: IS
1958: SELECT (version_seq_id) draft_ver
1959: FROM ego_flex_valueset_version_b
1960: WHERE flex_value_set_id = cp_value_set_id
1961: AND version_seq_id = 0;
1962:
1963:

Line 2066: FROM EGO_FLEX_VALUESET_VERSION_B

2062:
2063:
2064: --Validate if Value Set has been released on same Start Date or End date should not be same.
2065: SELECT COUNT(*) INTO l_same_rel_date
2066: FROM EGO_FLEX_VALUESET_VERSION_B
2067: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID
2068: AND ( START_ACTIVE_DATE= l_start_date
2069: OR END_ACTIVE_DATE = l_start_date
2070: )

Line 2171: INSERT INTO EGO_FLEX_VALUESET_VERSION_B

2167: write_debug(G_PKG_Name,l_api_name,' Creating draft Version ');
2168: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Creating draft Version G_Party_id = '||G_Party_id);
2169:
2170: -- Create record for draft version with sysdate as start date
2171: INSERT INTO EGO_FLEX_VALUESET_VERSION_B
2172: (flex_value_set_id,version_seq_id,description, start_active_date, end_active_date ,
2173: created_by,creation_date,last_updated_by,last_update_date,last_update_login)
2174: VALUES ( l_value_set_id, 0, l_description, SYSDATE, NULL,
2175: G_Party_Id,SYSDATE,G_Party_Id,SYSDATE,G_Login_Id);

Line 2309: Update ego_flex_valueset_version_b

2305:
2306:
2307: IF(l_future_effective) THEN
2308:
2309: Update ego_flex_valueset_version_b
2310: SET end_active_date= l_start_date-1/(24*60*60),
2311: LAST_UPDATED_BY= G_Party_Id,
2312: LAST_UPDATE_DATE = SYSDATE,
2313: LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 2319: INSERT INTO EGO_FLEX_VALUESET_VERSION_B

2315: AND version_seq_id= l_prev_future_version;
2316:
2317:
2318: -- need to decide which version we need to insert, same as user passed of l_target_max_ver+1
2319: INSERT INTO EGO_FLEX_VALUESET_VERSION_B
2320: (flex_value_set_id, version_seq_id,description, start_active_date,end_active_date,
2321: created_by,creation_date,last_updated_by,last_update_date,last_update_login)
2322: VALUES (l_value_set_id, Nvl(l_target_max_ver,0)+1,l_description, l_start_date,l_relver_end_date,
2323: G_Party_Id,sysdate,G_Party_Id,sysdate,G_Login_id) ;

Line 2331: FROM EGO_FLEX_VALUESET_VERSION_B

2327: ELSE
2328:
2329: -- Get least future effective start active date which is higher then passed in date
2330: SELECT Min(start_active_date ) INTO l_min_future_start_date
2331: FROM EGO_FLEX_VALUESET_VERSION_B
2332: WHERE FLEX_VALUE_SET_ID = p_value_set_id
2333: AND version_seq_id >0;
2334:
2335: -- This is the case where passed in start date will always be greater than all available version

Line 2339: Update ego_flex_valueset_version_b

2335: -- This is the case where passed in start date will always be greater than all available version
2336: IF ( l_min_future_start_date < l_start_date) THEN
2337:
2338:
2339: Update ego_flex_valueset_version_b
2340: SET end_active_date= l_start_date-1/(24*60*60),
2341: LAST_UPDATED_BY= G_Party_Id,
2342: LAST_UPDATE_DATE = SYSDATE,
2343: LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 2346: FROM ego_flex_valueset_version_b

2342: LAST_UPDATE_DATE = SYSDATE,
2343: LAST_UPDATE_LOGIN = G_LOGIN_ID
2344: WHERE flex_value_set_id = p_value_set_id
2345: AND (start_active_date =( SELECT Max(start_active_date )
2346: FROM ego_flex_valueset_version_b
2347: WHERE flex_value_set_id = p_value_set_id
2348: AND version_seq_id >0
2349: )
2350: );

Line 2356: INSERT INTO EGO_FLEX_VALUESET_VERSION_B

2352: END IF;
2353:
2354:
2355: -- Create a new version
2356: INSERT INTO EGO_FLEX_VALUESET_VERSION_B
2357: (flex_value_set_id, version_seq_id,description, start_active_date,end_active_date,
2358: created_by,creation_date,last_updated_by,last_update_date,last_update_login)
2359: VALUES (l_value_set_id, Nvl(l_target_max_ver,0)+1,l_description, l_start_date,NULL ,
2360: G_Party_Id,sysdate,G_Party_Id,sysdate,G_Login_id) ;

Line 2366: Update ego_flex_valueset_version_b

2362:
2363: -- This is the case where passed in start date will always be lesser than all available version
2364: IF ( l_start_date< l_min_future_start_date) THEN
2365:
2366: Update ego_flex_valueset_version_b
2367: SET end_active_date= l_min_future_start_date-1/(24*60*60),
2368: LAST_UPDATED_BY= G_Party_Id,
2369: LAST_UPDATE_DATE = SYSDATE,
2370: LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 3957: FROM Ego_Flex_valueSet_Version_b efvsv

3953: OR ffvs.flex_value_set_id= evsvi.value_set_id
3954: )
3955: AND NOT EXISTS
3956: ( SELECT 1
3957: FROM Ego_Flex_valueSet_Version_b efvsv
3958: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
3959: )
3960: AND NOT EXISTS
3961: ( SELECT 1

Line 4057: FROM Ego_Flex_valueSet_Version_b efvsv

4053: AND evsvi.process_status = G_PROCESS_RECORD
4054: AND ffvs.parent_flex_value_set_id IS NULL
4055: AND NOT EXISTS
4056: ( SELECT 1
4057: FROM Ego_Flex_valueSet_Version_b efvsv
4058: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4059: )
4060: AND NOT EXISTS
4061: ( SELECT 1

Line 4324: FROM Ego_Flex_valueSet_Version_b efvsv

4320: OR ffvs.flex_value_set_id= evsvi.value_set_id
4321: )
4322: AND NOT EXISTS
4323: ( SELECT 1
4324: FROM Ego_Flex_valueSet_Version_b efvsv
4325: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4326: )
4327:
4328: AND EXISTS

Line 4514: FROM Ego_Flex_valueSet_Version_b efvsv

4510: OR ffvs.flex_value_set_id= evsvi.value_set_id
4511: )
4512: AND NOT EXISTS
4513: ( SELECT 1
4514: FROM Ego_Flex_valueSet_Version_b efvsv
4515: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4516: )
4517: AND NOT EXISTS
4518: ( SELECT 1

Line 4571: FROM Ego_Flex_valueSet_Version_b efvsv

4567: OR ffvs.flex_value_set_id= evsvi.value_set_id
4568: )
4569: AND NOT EXISTS
4570: ( SELECT 1
4571: FROM Ego_Flex_valueSet_Version_b efvsv
4572: WHERE ffvs.flex_value_set_id= efvsv.flex_value_set_id
4573: )
4574: AND NOT EXISTS
4575: ( SELECT 1

Line 5705: FROM ego_flex_valueset_version_b

5701:
5702: -- Cursor to check current effective version in target system
5703: CURSOR cur_current_version(cp_value_set_id NUMBER ) IS
5704: SELECT version_seq_id,start_active_date, end_active_date
5705: FROM ego_flex_valueset_version_b
5706: WHERE flex_value_set_id = cp_value_set_id
5707: AND start_active_date <= G_SYSDATE
5708: AND Nvl(end_active_date,G_SYSDATE)>= G_SYSDATE ;
5709:

Line 5714: FROM ego_flex_valueset_version_b

5710:
5711: -- Cursor to get max version seq id for a value set in target system.
5712: CURSOR cur_max_ver(cp_value_set_id NUMBER) IS
5713: SELECT Max(Nvl(version_seq_id,0)) max_version
5714: FROM ego_flex_valueset_version_b
5715: WHERE flex_value_set_id = cp_value_set_id;
5716:
5717:
5718: -- Cursor to get future version which has max end active date but lesser then passed in start active date

Line 5722: FROM ego_flex_valueset_version_b

5718: -- Cursor to get future version which has max end active date but lesser then passed in start active date
5719: CURSOR cur_max_future_ver(cp_value_set_id NUMBER,
5720: cp_start_active_date DATE ) IS
5721: SELECT version_seq_id, start_active_date, end_active_date
5722: FROM ego_flex_valueset_version_b
5723: WHERE flex_value_set_id = cp_value_set_id
5724: AND ( start_active_date = (
5725: SELECT Max(start_active_date )
5726: FROM EGO_FLEX_VALUESET_VERSION_B

Line 5726: FROM EGO_FLEX_VALUESET_VERSION_B

5722: FROM ego_flex_valueset_version_b
5723: WHERE flex_value_set_id = cp_value_set_id
5724: AND ( start_active_date = (
5725: SELECT Max(start_active_date )
5726: FROM EGO_FLEX_VALUESET_VERSION_B
5727: WHERE FLEX_VALUE_SET_ID = cp_value_set_id
5728: AND Nvl(end_active_date,G_SYSDATE) <= cp_start_active_date
5729: )
5730: );