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_EXT_FWK_PUB dependencies on EGO_FLEX_VALUESET_VERSION_B

Line 6492: FROM ego_flex_valueset_version_b

6488:
6489: BEGIN
6490: BEGIN
6491: SELECT version_seq_id INTO l_version_seq_id
6492: FROM ego_flex_valueset_version_b
6493: WHERE start_active_date < p_start_effective_date
6494: AND ( end_active_date > p_start_effective_date
6495: OR end_active_date IS NULL ) AND last_update_date < p_creation_date
6496: AND flex_value_set_id = p_value_set_id AND version_seq_id <> 0 ;

Line 6500: FROM ego_flex_valueset_version_b

6496: AND flex_value_set_id = p_value_set_id AND version_seq_id <> 0 ;
6497: EXCEPTION WHEN No_Data_Found THEN
6498: BEGIN
6499: SELECT version_seq_id INTO l_version_seq_id
6500: FROM ego_flex_valueset_version_b
6501: WHERE start_active_date < p_start_effective_date
6502: AND last_update_date =(SELECT Min(last_update_date) from ego_flex_valueset_version_b
6503: WHERE flex_value_set_id = p_value_set_id AND version_seq_id <> 0
6504: AND last_update_date > p_creation_date )

Line 6502: AND last_update_date =(SELECT Min(last_update_date) from ego_flex_valueset_version_b

6498: BEGIN
6499: SELECT version_seq_id INTO l_version_seq_id
6500: FROM ego_flex_valueset_version_b
6501: WHERE start_active_date < p_start_effective_date
6502: AND last_update_date =(SELECT Min(last_update_date) from ego_flex_valueset_version_b
6503: WHERE flex_value_set_id = p_value_set_id AND version_seq_id <> 0
6504: AND last_update_date > p_creation_date )
6505: AND flex_value_set_id = p_value_set_id AND version_seq_id <> 0 ;
6506: EXCEPTION

Line 6542: FROM ego_flex_valueset_version_b

6538:
6539: CURSOR compareReleaseDates
6540: IS
6541: SELECT start_active_date ,end_active_date,version_seq_id
6542: FROM ego_flex_valueset_version_b
6543: WHERE flex_value_set_id = p_value_set_id AND version_seq_id <> 0 ;
6544: rect_t compareReleaseDates%rowtype;
6545: CURSOR copyDuplicateRow
6546: IS

Line 6585: SELECT COUNT(*) INTO L_SAME_REL_DATE FROM EGO_FLEX_VALUESET_VERSION_B

6581: END IF ;
6582: /* Validation ends. */
6583: /* Validating whether value set is already released on the date */
6584:
6585: SELECT COUNT(*) INTO L_SAME_REL_DATE FROM EGO_FLEX_VALUESET_VERSION_B
6586: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND
6587: ( START_ACTIVE_DATE= P_START_DATE OR END_ACTIVE_DATE = P_START_DATE)
6588: AND VERSION_SEQ_ID <>0;
6589:

Line 6617: UPDATE EGO_FLEX_VALUESET_VERSION_B

6613: END LOOP;
6614: CLOSE compareReleaseDates;
6615:
6616: IF(l_future_effective) THEN
6617: UPDATE EGO_FLEX_VALUESET_VERSION_B
6618: SET END_ACTIVE_DATE =p_start_date -1/(24*60*60) ,
6619: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6620: LAST_UPDATE_DATE = SYSDATE,
6621: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 6627: INSERT INTO EGO_FLEX_VALUESET_VERSION_B

6623:
6624: /* Creating record for the newly releasing version.Here end date is the start date of
6625: the released version(releasing version start date lies in between
6626: the start date and end date of released version) */
6627: INSERT INTO EGO_FLEX_VALUESET_VERSION_B
6628: (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,
6629: DESCRIPTION, START_ACTIVE_DATE,END_ACTIVE_DATE, CREATED_BY,CREATION_DATE,
6630: LAST_UPDATED_BY,last_update_date,last_update_login)
6631: VALUES (p_value_set_id, p_version_seq_id,

Line 6636: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,

6632: p_description, p_start_date,l_relver_end_active_date,fnd_global.party_id,
6633: SYSDATE,fnd_global.party_id,SYSDATE,
6634: fnd_global.login_id) ;
6635: /* Creating record for the draft row .*/
6636: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,
6637: CREATED_BY,CREATION_DATE,
6638: LAST_UPDATED_BY,last_update_date,last_update_login) VALUES (p_value_set_id, 0,
6639: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,
6640: fnd_global.login_id) ;

Line 6643: FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = p_value_set_id ;

6639: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,
6640: fnd_global.login_id) ;
6641: ELSE
6642: SELECT Min(start_active_date ) INTO l_min_start_active_date
6643: FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = p_value_set_id ;
6644:
6645: /* Updating end date of already released version with the start date(less one second)
6646: of newly releasing version*/
6647:

Line 6649: UPDATE EGO_FLEX_VALUESET_VERSION_B SET END_ACTIVE_DATE =(p_start_date- 1/(246060)),

6645: /* Updating end date of already released version with the start date(less one second)
6646: of newly releasing version*/
6647:
6648: IF (p_version_seq_id > 1 AND (l_min_start_active_date < p_start_date)) THEN
6649: UPDATE EGO_FLEX_VALUESET_VERSION_B SET END_ACTIVE_DATE =(p_start_date- 1/(24*60*60)),
6650: version_seq_id = l_max_version_seq_id ,
6651: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6652: LAST_UPDATE_DATE = SYSDATE,
6653: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 6655: FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = p_value_set_id) ) ;

6651: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6652: LAST_UPDATE_DATE = SYSDATE,
6653: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6654: WHERE FLEX_VALUE_SET_ID = p_value_set_id AND (start_active_date =( SELECT Max(start_active_date )
6655: FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = p_value_set_id) ) ;
6656: END IF ;
6657:
6658: /* Creating record for the draft row .*/
6659: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,

Line 6659: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,

6655: FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = p_value_set_id) ) ;
6656: END IF ;
6657:
6658: /* Creating record for the draft row .*/
6659: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,
6660: CREATED_BY,CREATION_DATE,
6661: LAST_UPDATED_BY,last_update_date,last_update_login) VALUES (p_value_set_id, 0,
6662: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,
6663: fnd_global.login_id) ;

Line 6666: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,

6662: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,
6663: fnd_global.login_id) ;
6664:
6665: /* Creating record for the newly releasing version*/
6666: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,
6667: DESCRIPTION, START_ACTIVE_DATE,CREATED_BY,CREATION_DATE,
6668: LAST_UPDATED_BY,last_update_date,last_update_login) VALUES (p_value_set_id,p_version_seq_id,
6669: p_description, p_start_date,fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,
6670: fnd_global.login_id) ;

Line 6674: UPDATE EGO_FLEX_VALUESET_VERSION_B SET END_ACTIVE_DATE =(l_min_start_active_date -

6670: fnd_global.login_id) ;
6671: /* below condition is only true if the start date of version getting release is less than the min(start date)
6672: of released version*/
6673: IF(p_start_date< l_min_start_active_date) THEN
6674: UPDATE EGO_FLEX_VALUESET_VERSION_B SET END_ACTIVE_DATE =(l_min_start_active_date -
6675: 1/(24*60*60) ),LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6676: LAST_UPDATE_DATE = SYSDATE,
6677: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6678: WHERE FLEX_VALUE_SET_ID = p_value_set_id AND start_active_date = p_start_date;

Line 6802: --Inserting the new record in EGO_FLEX_VALUESET_VERSION_B for making versioned value set.

6798: --Inserting party id instead of user id .
6799: SELECT PERSON_PARTY_ID INTO L_CREATED_BY FROM FND_USER WHERE USER_ID
6800: =( SELECT CREATED_BY FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID) ;
6801:
6802: --Inserting the new record in EGO_FLEX_VALUESET_VERSION_B for making versioned value set.
6803: INSERT INTO EGO_FLEX_VALUESET_VERSION_B(FLEX_VALUE_SET_ID,VERSION_SEQ_ID,DESCRIPTION
6804: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6805: VALUES (P_VALUE_SET_ID, 0, P_DESCRIPTION,L_CREATED_BY,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,
6806: FND_GLOBAL.LOGIN_ID);

Line 6803: INSERT INTO EGO_FLEX_VALUESET_VERSION_B(FLEX_VALUE_SET_ID,VERSION_SEQ_ID,DESCRIPTION

6799: SELECT PERSON_PARTY_ID INTO L_CREATED_BY FROM FND_USER WHERE USER_ID
6800: =( SELECT CREATED_BY FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID) ;
6801:
6802: --Inserting the new record in EGO_FLEX_VALUESET_VERSION_B for making versioned value set.
6803: INSERT INTO EGO_FLEX_VALUESET_VERSION_B(FLEX_VALUE_SET_ID,VERSION_SEQ_ID,DESCRIPTION
6804: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6805: VALUES (P_VALUE_SET_ID, 0, P_DESCRIPTION,L_CREATED_BY,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,
6806: FND_GLOBAL.LOGIN_ID);
6807: --Inserting the new record in EGO_OBJECT_LOCK for Locking versioned value set agains username.

Line 6904: Insert into EGO_FLEX_VALUESET_VERSION_B

6900: -- P4T Specific logic
6901: -- If Value Set was created successfully , create the version records in EGO tables
6902:
6903: IF ( x_return_status = 'S' AND p_versioning_enabled ='true' ) THEN
6904: Insert into EGO_FLEX_VALUESET_VERSION_B
6905: (flex_value_set_id,version_seq_id,description
6906: ,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
6907: VALUES (x_value_set_id, 0, p_description,FND_GLOBAL.party_id,SYSDATE,FND_GLOBAL.party_id,SYSDATE,
6908: FND_GLOBAL.login_id);

Line 7706: SELECT Count(*) INTO isVersionedVS FROM ego_flex_valueset_version_b

7702: END IF;
7703:
7704: x_return_status := FND_API.G_RET_STS_SUCCESS;
7705: --changes for P4t begin
7706: SELECT Count(*) INTO isVersionedVS FROM ego_flex_valueset_version_b
7707: WHERE flex_value_set_id = p_value_set_id ;
7708: IF(isVersionedVS > 0) THEN
7709: x_versioned_vs := 'true';
7710: END IF ;

Line 8363: SELECT count (*) INTO VersionedValueSet FROM EGO_FLEX_VALUESET_VERSION_B WHERE

8359:
8360:
8361: END IF;
8362:
8363: SELECT count (*) INTO VersionedValueSet FROM EGO_FLEX_VALUESET_VERSION_B WHERE
8364: FLEX_VALUE_SET_ID = x_flex_Value_Set_Id ;
8365:
8366: x_valueSetId := x_flex_Value_Set_Id;
8367:

Line 8704: SELECT COUNT(*) INTO L_VALUES_COUNT FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = L_VALUE_SET_ID;

8700: /*P4T changes begin. */
8701:
8702: ELSE
8703:
8704: SELECT COUNT(*) INTO L_VALUES_COUNT FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = L_VALUE_SET_ID;
8705: IF(l_values_count > 0 ) THEN
8706: UPDATE ego_flex_value_version_b SET SEQUENCE = p_sequence
8707: WHERE version_seq_id = 0 AND flex_value_set_id = l_value_set_id AND flex_value_id = l_flex_value_id ;
8708: