APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_FLEX_VALUE_VERSION_B

Line 1805: FROM ego_flex_value_version_b

1801:
1802: CURSOR Sync_Draft
1803: IS
1804: SELECT flex_value_id,SEQUENCE
1805: FROM ego_flex_value_version_b
1806: WHERE version_seq_id = p_version_number
1807: AND flex_value_set_id = p_value_set_id;
1808:
1809: l_api_name VARCHAR2(100) := 'Sync_VS_With_Draft';

Line 1821: FROM EGO_FLEX_VALUE_VERSION_B

1817:
1818: DELETE FROM EGO_FLEX_VALUE_VERSION_TL
1819: WHERE VERSION_SEQ_ID =0
1820: AND FLEX_VALUE_ID IN ( SELECT FLEX_VALUE_ID
1821: FROM EGO_FLEX_VALUE_VERSION_B
1822: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID
1823: AND VERSION_SEQ_ID = 0);
1824:
1825: DELETE FROM EGO_FLEX_VALUE_VERSION_B

Line 1825: DELETE FROM EGO_FLEX_VALUE_VERSION_B

1821: FROM EGO_FLEX_VALUE_VERSION_B
1822: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID
1823: AND VERSION_SEQ_ID = 0);
1824:
1825: DELETE FROM EGO_FLEX_VALUE_VERSION_B
1826: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID
1827: AND VERSION_SEQ_ID = 0;
1828:
1829:

Line 1837: INSERT INTO EGO_FLEX_VALUE_VERSION_B

1833:
1834: FETCH Sync_Draft INTO DraftRec;
1835: EXIT WHEN Sync_Draft%NOTFOUND;
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 );

Line 1856: FROM EGO_FLEX_VALUE_VERSION_B

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
1858: AND VERSION_SEQ_ID = P_VERSION_NUMBER);
1859:
1860:

Line 7241: FROM EGO_FLEX_VALUE_VERSION_B

7237: cp_value_id NUMBER,
7238: cp_version_seq_id NUMBER )
7239: IS
7240: SELECT 1 AS exist
7241: FROM EGO_FLEX_VALUE_VERSION_B
7242: WHERE flex_value_set_id = cp_value_set_id
7243: AND flex_value_id = cp_value_id
7244: AND version_seq_id = cp_version_seq_id;
7245:

Line 7289: FROM EGO_FLEX_VALUE_VERSION_B

7285: cp_disp_sequence NUMBER,
7286: cp_version_seq_id NUMBER)
7287: IS
7288: SELECT 1 AS Seq_exist
7289: FROM EGO_FLEX_VALUE_VERSION_B
7290: WHERE flex_value_set_id = cp_value_set_id
7291: AND version_seq_id = cp_version_seq_id
7292: AND SEQUENCE = cp_disp_sequence;
7293:

Line 8448: INSERT INTO EGO_FLEX_VALUE_VERSION_B

8444: END LOOP; -- END FOR i IN Cur_Value_Ver_Exist
8445:
8446: IF l_val_ver_exist IS NULL THEN
8447:
8448: INSERT INTO EGO_FLEX_VALUE_VERSION_B
8449: (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID,SEQUENCE
8450: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
8451: VALUES (l_VALUE_SET_ID,l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID, l_disp_sequence,
8452: G_Party_Id,SYSDATE,G_Party_Id ,SYSDATE,G_Login_Id);

Line 8453: write_debug(G_PKG_Name,l_api_name, ' Inserted reord in EGO_FLEX_VALUE_VERSION_B table '||p_value_set_val_tl_tbl(j).flex_value);

8449: (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID,SEQUENCE
8450: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
8451: VALUES (l_VALUE_SET_ID,l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID, l_disp_sequence,
8452: G_Party_Id,SYSDATE,G_Party_Id ,SYSDATE,G_Login_Id);
8453: write_debug(G_PKG_Name,l_api_name, ' Inserted reord in EGO_FLEX_VALUE_VERSION_B table '||p_value_set_val_tl_tbl(j).flex_value);
8454:
8455: END IF;
8456:
8457:

Line 8620: INSERT INTO EGO_FLEX_VALUE_VERSION_B

8616: IF l_val_ver_exist IS NULL THEN
8617:
8618: write_debug(G_PKG_Name,l_api_name,' Value record not exist. Insert record ');
8619:
8620: INSERT INTO EGO_FLEX_VALUE_VERSION_B
8621: (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID,SEQUENCE
8622: ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
8623: VALUES (l_VALUE_SET_ID,l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID, l_disp_sequence,
8624: G_Party_Id,SYSDATE,G_Party_Id ,SYSDATE,G_Login_Id);