DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on FND_GLOBAL

Line 42: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

38:
39: ---------------------------------------------------------------
40: -- WHO Columns . --
41: ---------------------------------------------------------------
42: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
43: G_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
44: G_APPLICATION_ID NUMBER;
45: G_APPL_NAME VARCHAR2(3) := 'EGO';
46: G_Party_Id NUMBER := FND_GLOBAL.Party_Id;

Line 43: G_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;

39: ---------------------------------------------------------------
40: -- WHO Columns . --
41: ---------------------------------------------------------------
42: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
43: G_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
44: G_APPLICATION_ID NUMBER;
45: G_APPL_NAME VARCHAR2(3) := 'EGO';
46: G_Party_Id NUMBER := FND_GLOBAL.Party_Id;
47: G_Party_Name VARCHAR2(500);

Line 46: G_Party_Id NUMBER := FND_GLOBAL.Party_Id;

42: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
43: G_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
44: G_APPLICATION_ID NUMBER;
45: G_APPL_NAME VARCHAR2(3) := 'EGO';
46: G_Party_Id NUMBER := FND_GLOBAL.Party_Id;
47: G_Party_Name VARCHAR2(500);
48: G_Locking_Party_Name VARCHAR2(500);
49:
50: G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;

Line 50: G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;

46: G_Party_Id NUMBER := FND_GLOBAL.Party_Id;
47: G_Party_Name VARCHAR2(500);
48: G_Locking_Party_Name VARCHAR2(500);
49:
50: G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
53:
54:

Line 51: G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

47: G_Party_Name VARCHAR2(500);
48: G_Locking_Party_Name VARCHAR2(500);
49:
50: G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
53:
54:
55: ---------------------------------------------------------------

Line 52: G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

48: G_Locking_Party_Name VARCHAR2(500);
49:
50: G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
53:
54:
55: ---------------------------------------------------------------
56: -- Data Types for Value Set.--

Line 1840: VALUES ( P_VALUE_SET_ID,DraftRec.FLEX_VALUE_ID,0,DraftRec.SEQUENCE,FND_GLOBAL.PARTY_ID,

1836:
1837: INSERT INTO EGO_FLEX_VALUE_VERSION_B
1838: ( FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID,SEQUENCE,CREATED_BY,
1839: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1840: VALUES ( P_VALUE_SET_ID,DraftRec.FLEX_VALUE_ID,0,DraftRec.SEQUENCE,FND_GLOBAL.PARTY_ID,
1841: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );
1842:
1843:
1844: END LOOP;

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

1837: INSERT INTO EGO_FLEX_VALUE_VERSION_B
1838: ( FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID,SEQUENCE,CREATED_BY,
1839: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1840: VALUES ( P_VALUE_SET_ID,DraftRec.FLEX_VALUE_ID,0,DraftRec.SEQUENCE,FND_GLOBAL.PARTY_ID,
1841: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );
1842:
1843:
1844: END LOOP;
1845: CLOSE Sync_Draft;

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

1848: INSERT INTO EGO_FLEX_VALUE_VERSION_TL
1849: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
1850: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
1851:
1852: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
1853: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
1854: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID
1855: IN ( SELECT FLEX_VALUE_ID
1856: FROM EGO_FLEX_VALUE_VERSION_B

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

1849: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
1850: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
1851:
1852: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
1853: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
1854: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID
1855: IN ( SELECT FLEX_VALUE_ID
1856: FROM EGO_FLEX_VALUE_VERSION_B
1857: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID