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 FND_GLOBAL

Line 15: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;

11: G_API_NAME_TOKEN CONSTANT VARCHAR2(8) := 'API_NAME';
12: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';
13: G_PLSQL_ERR CONSTANT VARCHAR2(17) := 'EGO_PLSQL_ERR';
14:
15: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
16: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
17:
18: -- For use with error-reporting --
19: G_ADD_ERRORS_TO_FND_STACK CONSTANT VARCHAR2(1) := 'Y';

Line 16: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;

12: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';
13: G_PLSQL_ERR CONSTANT VARCHAR2(17) := 'EGO_PLSQL_ERR';
14:
15: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
16: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
17:
18: -- For use with error-reporting --
19: G_ADD_ERRORS_TO_FND_STACK CONSTANT VARCHAR2(1) := 'Y';
20: G_DUMMY_ENTITY_INDEX NUMBER;

Line 6619: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,

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
6622: WHERE FLEX_VALUE_SET_ID = p_value_set_id AND VERSION_SEQ_ID = l_version_seq_id;
6623:

Line 6621: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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
6622: WHERE FLEX_VALUE_SET_ID = p_value_set_id AND VERSION_SEQ_ID = l_version_seq_id;
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

Line 6632: p_description, p_start_date,l_relver_end_active_date,fnd_global.party_id,

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,
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,

Line 6633: SYSDATE,fnd_global.party_id,SYSDATE,

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,
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,

Line 6634: fnd_global.login_id) ;

6630: LAST_UPDATED_BY,last_update_date,last_update_login)
6631: VALUES (p_value_set_id, p_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,

Line 6639: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,

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) ;
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 ;

Line 6640: fnd_global.login_id) ;

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) ;
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:

Line 6651: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,

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
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) ) ;

Line 6653: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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
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:

Line 6662: fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,

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) ;
6664:
6665: /* Creating record for the newly releasing version*/
6666: INSERT INTO EGO_FLEX_VALUESET_VERSION_B (FLEX_VALUE_SET_ID, VERSION_SEQ_ID,

Line 6663: fnd_global.login_id) ;

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) ;
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,

Line 6669: p_description, p_start_date,fnd_global.party_id,SYSDATE,fnd_global.party_id,SYSDATE,

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) ;
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

Line 6670: fnd_global.login_id) ;

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) ;
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 -

Line 6675: 1/(246060) ),LAST_UPDATED_BY= FND_GLOBAL.PARTY_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;
6679: END IF ;

Line 6677: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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;
6679: END IF ;
6680: END IF ;
6681:

Line 6689: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,

6685: FETCH copyDuplicateRow INTO rec_duplicateRow ;
6686: EXIT WHEN copyDuplicateRow%NOTFOUND ;
6687:
6688: UPDATE EGO_FLEX_VALUE_VERSION_B SET VERSION_SEQ_ID =P_VERSION_SEQ_ID ,
6689: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6690: LAST_UPDATE_DATE = SYSDATE,
6691: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6692: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = 0 AND FLEX_VALUE_ID
6693: = REC_DUPLICATEROW.FLEX_VALUE_ID;

Line 6691: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

6687:
6688: UPDATE EGO_FLEX_VALUE_VERSION_B SET VERSION_SEQ_ID =P_VERSION_SEQ_ID ,
6689: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6690: LAST_UPDATE_DATE = SYSDATE,
6691: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6692: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = 0 AND FLEX_VALUE_ID
6693: = REC_DUPLICATEROW.FLEX_VALUE_ID;
6694:
6695: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID

Line 6698: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID);

6694:
6695: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID
6696: ,SEQUENCE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6697: VALUES(P_VALUE_SET_ID,REC_DUPLICATEROW.FLEX_VALUE_ID,0,REC_DUPLICATEROW.SEQUENCE,
6698: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID);
6699:
6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6701: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,

Line 6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,

6698: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID);
6699:
6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6701: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6703: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM
6704: EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = REC_DUPLICATEROW.FLEX_VALUE_ID AND VERSION_SEQ_ID=0 ;
6705:
6706: END LOOP ;

Line 6703: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM

6699:
6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6701: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6703: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM
6704: EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = REC_DUPLICATEROW.FLEX_VALUE_ID AND VERSION_SEQ_ID=0 ;
6705:
6706: END LOOP ;
6707: CLOSE copyDuplicateRow;

Line 6760: VALUES (P_VALUE_SET_ID,RECT_T.FLEX_VALUE_ID,0,RECT_T.SEQUENCE,FND_GLOBAL.PARTY_ID,

6756: EXIT WHEN revert_draft%notfound ;
6757: INSERT INTO EGO_FLEX_VALUE_VERSION_B(FLEX_VALUE_SET_ID,FLEX_VALUE_ID
6758: ,VERSION_SEQ_ID,SEQUENCE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
6759: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6760: VALUES (P_VALUE_SET_ID,RECT_T.FLEX_VALUE_ID,0,RECT_T.SEQUENCE,FND_GLOBAL.PARTY_ID,
6761: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );
6762:
6763:
6764: END LOOP;

Line 6761: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );

6757: INSERT INTO EGO_FLEX_VALUE_VERSION_B(FLEX_VALUE_SET_ID,FLEX_VALUE_ID
6758: ,VERSION_SEQ_ID,SEQUENCE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
6759: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6760: VALUES (P_VALUE_SET_ID,RECT_T.FLEX_VALUE_ID,0,RECT_T.SEQUENCE,FND_GLOBAL.PARTY_ID,
6761: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );
6762:
6763:
6764: END LOOP;
6765: CLOSE revert_draft;

Line 6770: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,

6766:
6767:
6768: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6769: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6770: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6771: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
6772: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID IN
6773: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B
6774: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = P_VERSION_NUMBER);

Line 6771: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL

6767:
6768: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6769: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6770: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6771: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
6772: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID IN
6773: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B
6774: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = P_VERSION_NUMBER);
6775: x_return_status :='S';

Line 6805: VALUES (P_VALUE_SET_ID, 0, P_DESCRIPTION,L_CREATED_BY,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,

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.
6808: INSERT INTO EGO_OBJECT_LOCK (LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)

Line 6806: FND_GLOBAL.LOGIN_ID);

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.
6808: INSERT INTO EGO_OBJECT_LOCK (LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6810: VALUES

Line 6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',

6807: --Inserting the new record in EGO_OBJECT_LOCK for Locking versioned value set agains username.
6808: INSERT INTO EGO_OBJECT_LOCK (LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6810: VALUES
6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',
6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;
6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the
6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL

Line 6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;

6808: INSERT INTO EGO_OBJECT_LOCK (LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6810: VALUES
6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',
6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;
6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the
6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL
6816: WHERE FLEX_VALUE_SET_ID= P_VALUE_SET_ID AND ENABLED_FLAG='Y';

Line 6821: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID

6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table
6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,
6819: VERSION_SEQ_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6820: SELECT P_VALUE_SET_ID, A.FLEX_VALUE_ID, B.DISP_SEQUENCE,0,A.CREATED_BY,SYSDATE,
6821: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID
6822: FROM FND_FLEX_VALUES A, EGO_VS_VALUES_DISP_ORDER B
6823: WHERE
6824: A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID
6825: AND A.ENABLED_FLAG='Y'

Line 6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,

6827:
6828: --Creating the record for values in EGO_FLEX_VALUE_VERSION_tl table
6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6830: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG
6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,
6833: FND_FLEX_VALUES_TL B
6834: WHERE A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND
6835: A.VERSION_SEQ_ID = 0 AND A.FLEX_VALUE_ID = B.FLEX_VALUE_ID;

Line 6907: VALUES (x_value_set_id, 0, p_description,FND_GLOBAL.party_id,SYSDATE,FND_GLOBAL.party_id,SYSDATE,

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);
6909:
6910:
6911: INSERT INTO ego_object_lock (LOCK_ID,OBJECT_NAME,PK1_VALUE,locking_party_id,lock_flag,

Line 6908: FND_GLOBAL.login_id);

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);
6909:
6910:
6911: INSERT INTO ego_object_lock (LOCK_ID,OBJECT_NAME,PK1_VALUE,locking_party_id,lock_flag,
6912: created_by,creation_date,last_updated_by,last_update_date,last_update_login) VALUES

Line 6913: (EGO_OBJECT_LOCK_S.nextval,'EGO_VALUE_SET',x_value_set_id,FND_GLOBAL.party_id,'L',FND_GLOBAL.login_id,SYSDATE,

6909:
6910:
6911: INSERT INTO ego_object_lock (LOCK_ID,OBJECT_NAME,PK1_VALUE,locking_party_id,lock_flag,
6912: created_by,creation_date,last_updated_by,last_update_date,last_update_login) VALUES
6913: (EGO_OBJECT_LOCK_S.nextval,'EGO_VALUE_SET',x_value_set_id,FND_GLOBAL.party_id,'L',FND_GLOBAL.login_id,SYSDATE,
6914: FND_GLOBAL.login_id,SYSDATE,FND_GLOBAL.login_id) ;
6915: END IF;
6916: ------------------------------------------------------------------------------------------------------
6917: END Create_Value_Set;

Line 6914: FND_GLOBAL.login_id,SYSDATE,FND_GLOBAL.login_id) ;

6910:
6911: INSERT INTO ego_object_lock (LOCK_ID,OBJECT_NAME,PK1_VALUE,locking_party_id,lock_flag,
6912: created_by,creation_date,last_updated_by,last_update_date,last_update_login) VALUES
6913: (EGO_OBJECT_LOCK_S.nextval,'EGO_VALUE_SET',x_value_set_id,FND_GLOBAL.party_id,'L',FND_GLOBAL.login_id,SYSDATE,
6914: FND_GLOBAL.login_id,SYSDATE,FND_GLOBAL.login_id) ;
6915: END IF;
6916: ------------------------------------------------------------------------------------------------------
6917: END Create_Value_Set;
6918:

Line 8378: VALUES (x_flex_Value_Set_Id, l_flex_value_id,0,p_sequence,fnd_global.party_id,SYSDATE,

8374:
8375:
8376: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID, VERSION_SEQ_ID,
8377: sequence,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
8378: VALUES (x_flex_Value_Set_Id, l_flex_value_id,0,p_sequence,fnd_global.party_id,SYSDATE,
8379: fnd_global.party_id,SYSDATE,fnd_global.login_id);
8380:
8381:
8382: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,

Line 8379: fnd_global.party_id,SYSDATE,fnd_global.login_id);

8375:
8376: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID, VERSION_SEQ_ID,
8377: sequence,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
8378: VALUES (x_flex_Value_Set_Id, l_flex_value_id,0,p_sequence,fnd_global.party_id,SYSDATE,
8379: fnd_global.party_id,SYSDATE,fnd_global.login_id);
8380:
8381:
8382: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
8383: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,

Line 8386: L_FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,

8382: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
8383: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,
8384: SOURCE_LANG
8385: ) SELECT
8386: L_FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
8387: P_DESCRIPTION,P_DISPLAY_NAME,L.LANGUAGE_CODE,USERENV('LANG')
8388: FROM FND_LANGUAGES L
8389: WHERE L.INSTALLED_FLAG IN ('I', 'B' ) ;
8390:

Line 8711: LAST_UPDATED_BY = FND_GLOBAL.PARTY_ID,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

8707: WHERE version_seq_id = 0 AND flex_value_set_id = l_value_set_id AND flex_value_id = l_flex_value_id ;
8708:
8709: UPDATE EGO_FLEX_VALUE_VERSION_TL SET DESCRIPTION = P_DESCRIPTION,
8710: FLEX_VALUE_MEANING = P_DISPLAY_NAME , SOURCE_LANG = USERENV('LANG'),LAST_UPDATE_DATE =SYSDATE,
8711: LAST_UPDATED_BY = FND_GLOBAL.PARTY_ID,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8712: WHERE FLEX_VALUE_ID = L_FLEX_VALUE_ID AND VERSION_SEQ_ID = 0 AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
8713:
8714: x_is_versioned :='true';
8715: x_valueSetId := l_value_set_id;

Line 8806: l_last_update_login := FND_GLOBAL.Login_Id;

8802: OPEN c_get_vs_details (cp_value_set_id => l_value_set_id);
8803: FETCH c_get_vs_details INTO l_last_updated_by, l_last_update_date;
8804: CLOSE c_get_vs_details;
8805:
8806: l_last_update_login := FND_GLOBAL.Login_Id;
8807:
8808: IF (fnd_load_util.upload_test(p_last_updated_by
8809: ,p_last_update_date
8810: ,l_last_updated_by

Line 14918: -- last_updated_by = FND_GLOBAL.user_id,

14914: -- -- Insert Attribute Group View name for the corresponding
14915: -- -- Attribute Group
14916: -- UPDATE ego_fnd_dsc_flx_ctx_ext
14917: -- SET agv_name = l_agv_name,
14918: -- last_updated_by = FND_GLOBAL.user_id,
14919: -- last_update_date = SYSDATE,
14920: -- last_update_login = FND_GLOBAL.login_id
14921: -- WHERE application_id = p_application_id
14922: -- AND descriptive_flexfield_name = p_attr_group_type

Line 14920: -- last_update_login = FND_GLOBAL.login_id

14916: -- UPDATE ego_fnd_dsc_flx_ctx_ext
14917: -- SET agv_name = l_agv_name,
14918: -- last_updated_by = FND_GLOBAL.user_id,
14919: -- last_update_date = SYSDATE,
14920: -- last_update_login = FND_GLOBAL.login_id
14921: -- WHERE application_id = p_application_id
14922: -- AND descriptive_flexfield_name = p_attr_group_type
14923: -- AND descriptive_flex_context_code = p_attr_group_name ;
14924: --

Line 15559: ,x_last_updated_by => fnd_global.party_id

15555: ,x_attribute50 => NULL
15556: ,x_flex_value_meaning => l_display_name
15557: ,x_description => l_description
15558: ,x_last_update_date => sysdate
15559: ,x_last_updated_by => fnd_global.party_id
15560: ,x_last_update_login => G_CURRENT_LOGIN_ID);
15561:
15562: DELETE EGO_FLEX_VALUE_VERSION_B WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;
15563: DELETE EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;