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.

[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_USER_ATTRS_BULK_PVT

Line 1: PACKAGE BODY EGO_USER_ATTRS_BULK_PVT AS

1: PACKAGE BODY EGO_USER_ATTRS_BULK_PVT AS
2: /* $Header: EGOVBUAB.pls 120.75.12010000.5 2008/11/06 22:18:50 yuewliu ship $ */
3:
4: ------------------------
5: -- Private Data Types --

Line 30: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';

26: ------------------------------
27: -- Private Global Variables --
28: ------------------------------
29:
30: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
31:
32: G_CURRENT_USER_ID NUMBER;
33: G_CURRENT_LOGIN_ID NUMBER;
34: G_API_VERSION NUMBER;

Line 1717: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1713: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk1_column_name||' = UAI2.'||l_pk1_column_name;
1714: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' pk_1_tbl ';
1715: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' pk_1_tbl(i) ';
1716: IF(l_pk1_column_type = 'INTEGER') THEN
1717: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1718: ELSE
1719: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1720: END IF;
1721: END IF;

Line 1719: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1715: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' pk_1_tbl(i) ';
1716: IF(l_pk1_column_type = 'INTEGER') THEN
1717: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1718: ELSE
1719: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1720: END IF;
1721: END IF;
1722:
1723: IF (l_pk2_column_name IS NOT NULL) THEN

Line 1729: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1725: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk2_column_name||' = UAI2.'||l_pk2_column_name;
1726: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_2_tbl ';
1727: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_2_tbl(i) ';
1728: IF(l_pk2_column_type = 'INTEGER') THEN
1729: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1730: ELSE
1731: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1732: END IF;
1733: END IF;

Line 1731: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1727: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_2_tbl(i) ';
1728: IF(l_pk2_column_type = 'INTEGER') THEN
1729: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1730: ELSE
1731: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1732: END IF;
1733: END IF;
1734:
1735: IF (l_pk3_column_name IS NOT NULL) THEN

Line 1741: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1737: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk3_column_name||' = UAI2.'||l_pk3_column_name;
1738: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_3_tbl ';
1739: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_3_tbl(i) ';
1740: IF(l_pk3_column_type = 'INTEGER') THEN
1741: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1742: ELSE
1743: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1744: END IF;
1745: END IF;

Line 1743: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1739: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_3_tbl(i) ';
1740: IF(l_pk3_column_type = 'INTEGER') THEN
1741: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1742: ELSE
1743: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1744: END IF;
1745: END IF;
1746:
1747: IF (l_pk4_column_name IS NOT NULL) THEN

Line 1753: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1749: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk4_column_name||' = UAI2.'||l_pk4_column_name;
1750: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_4_tbl ';
1751: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_4_tbl(i) ';
1752: IF(l_pk4_column_type = 'INTEGER') THEN
1753: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1754: ELSE
1755: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1756: END IF;
1757: END IF;

Line 1755: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1751: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_4_tbl(i) ';
1752: IF(l_pk4_column_type = 'INTEGER') THEN
1753: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1754: ELSE
1755: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1756: END IF;
1757: END IF;
1758: IF (l_pk5_column_name IS NOT NULL) THEN
1759: l_concat_pk_cols_sel := l_concat_pk_cols_sel ||l_pk5_column_name||',';

Line 1764: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1760: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk5_column_name||' = UAI2.'||l_pk5_column_name;
1761: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_5_tbl ';
1762: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_5_tbl(i) ';
1763: IF(l_pk5_column_type = 'INTEGER') THEN
1764: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1765: ELSE
1766: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1767: END IF;
1768: END IF;

Line 1766: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1762: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_5_tbl(i) ';
1763: IF(l_pk5_column_type = 'INTEGER') THEN
1764: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1765: ELSE
1766: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1767: END IF;
1768: END IF;
1769: ---------------------------------------------
1770: -- adding datalevel columns --

Line 1873: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1869: IF (l_data_level_column_1 IS NOT NULL AND l_data_level_column_1 <> 'NONE') THEN
1870: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' ,dl_1_tbl ';
1871: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' ,dl_1_tbl(i) ';
1872: IF(l_dl_col_data_type_1 = 'NUMBER') THEN
1873: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1874: ELSE
1875: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1876: END IF;
1877: END IF;

Line 1875: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1871: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' ,dl_1_tbl(i) ';
1872: IF(l_dl_col_data_type_1 = 'NUMBER') THEN
1873: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1874: ELSE
1875: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1876: END IF;
1877: END IF;
1878:
1879: IF (l_data_level_column_2 IS NOT NULL AND l_data_level_column_2 <> 'NONE') THEN

Line 1883: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1879: IF (l_data_level_column_2 IS NOT NULL AND l_data_level_column_2 <> 'NONE') THEN
1880: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' dl_2_tbl ';
1881: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_2_tbl(i) ';
1882: IF(l_dl_col_data_type_2 = 'NUMBER') THEN
1883: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1884: ELSE
1885: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1886: END IF;
1887: END IF;

Line 1885: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1881: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_2_tbl(i) ';
1882: IF(l_dl_col_data_type_2 = 'NUMBER') THEN
1883: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1884: ELSE
1885: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1886: END IF;
1887: END IF;
1888:
1889: IF (l_data_level_column_3 IS NOT NULL AND l_data_level_column_3 <> 'NONE') THEN

Line 1893: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1889: IF (l_data_level_column_3 IS NOT NULL AND l_data_level_column_3 <> 'NONE') THEN
1890: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' dl_3_tbl ';
1891: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_3_tbl(i) ';
1892: IF(l_dl_col_data_type_3 = 'NUMBER') THEN
1893: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1894: ELSE
1895: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1896: END IF;
1897: END IF;

Line 1895: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1891: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_3_tbl(i) ';
1892: IF(l_dl_col_data_type_3 = 'NUMBER') THEN
1893: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1894: ELSE
1895: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1896: END IF;
1897: END IF;
1898:
1899: IF (l_class_code_column_name IS NOT NULL ) THEN

Line 1903: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

1899: IF (l_class_code_column_name IS NOT NULL ) THEN
1900: l_class_blk_tbl_list := l_class_blk_tbl_list || ' class_tbl ';
1901: l_class_blk_tbl_list_2 := l_class_blk_tbl_list_2 || ' class_tbl(i) ';
1902: IF(l_class_code_column_type = 'NUMBER') THEN
1903: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1904: ELSE
1905: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1906: END IF;
1907: END IF;

Line 1905: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';

1901: l_class_blk_tbl_list_2 := l_class_blk_tbl_list_2 || ' class_tbl(i) ';
1902: IF(l_class_code_column_type = 'NUMBER') THEN
1903: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
1904: ELSE
1905: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
1906: END IF;
1907: END IF;
1908:
1909:

Line 3061: (SELECT DISTINCT TRUNC(EGO_USER_ATTRS_BULK_PVT.Get_Date(FLEX_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''))

3057: l_ivs_date_cursor_id := DBMS_SQL.Open_Cursor;
3058: l_dynamic_sql :=
3059: 'UPDATE '||p_interface_table_name||'
3060: SET ATTR_VALUE_DATE = NVL(ATTR_VALUE_DATE,
3061: (SELECT DISTINCT TRUNC(EGO_USER_ATTRS_BULK_PVT.Get_Date(FLEX_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''))
3062: FROM FND_FLEX_VALUES_VL
3063: WHERE ENABLED_FLAG = ''Y''
3064: AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)
3065: AND (NVL(END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE)

Line 3119: SET ATTR_VALUE_DATE = NVL(ATTR_VALUE_DATE,EGO_USER_ATTRS_BULK_PVT.Get_Date(

3115:
3116: l_ivs_date_time_cursor_id := DBMS_SQL.Open_Cursor;
3117: l_dynamic_sql :=
3118: 'UPDATE '||p_interface_table_name||'
3119: SET ATTR_VALUE_DATE = NVL(ATTR_VALUE_DATE,EGO_USER_ATTRS_BULK_PVT.Get_Date(
3120: (SELECT DISTINCT FLEX_VALUE
3121: FROM FND_FLEX_VALUES_VL
3122: WHERE ENABLED_FLAG = ''Y''
3123: AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)

Line 3263: SET ATTR_VALUE_NUM = DECODE(EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype),0,NVL(TO_NUMBER(ATTR_DISP_VALUE),ATTR_VALUE_NUM),NULL),

3259: IF (l_nvs_num_cursor_id is NULL) THEN
3260: l_nvs_num_cursor_id := DBMS_SQL.Open_Cursor;
3261: l_dynamic_sql :=
3262: 'UPDATE '||p_interface_table_name||'
3263: SET ATTR_VALUE_NUM = DECODE(EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype),0,NVL(TO_NUMBER(ATTR_DISP_VALUE),ATTR_VALUE_NUM),NULL),
3264: PROCESS_STATUS = PROCESS_STATUS +
3265: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3266: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val( NVL(ATTR_DISP_VALUE,ATTR_VALUE_NUM) * NVL((SELECT CONVERSION_RATE FROM MTL_UOM_CONVERSIONS
3267: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),

Line 3265: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly

3261: l_dynamic_sql :=
3262: 'UPDATE '||p_interface_table_name||'
3263: SET ATTR_VALUE_NUM = DECODE(EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype),0,NVL(TO_NUMBER(ATTR_DISP_VALUE),ATTR_VALUE_NUM),NULL),
3264: PROCESS_STATUS = PROCESS_STATUS +
3265: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3266: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val( NVL(ATTR_DISP_VALUE,ATTR_VALUE_NUM) * NVL((SELECT CONVERSION_RATE FROM MTL_UOM_CONVERSIONS
3267: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),
3268: :attr_datatype,
3269: :attr_min_allowed_val,

Line 3266: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val( NVL(ATTR_DISP_VALUE,ATTR_VALUE_NUM) * NVL((SELECT CONVERSION_RATE FROM MTL_UOM_CONVERSIONS

3262: 'UPDATE '||p_interface_table_name||'
3263: SET ATTR_VALUE_NUM = DECODE(EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype),0,NVL(TO_NUMBER(ATTR_DISP_VALUE),ATTR_VALUE_NUM),NULL),
3264: PROCESS_STATUS = PROCESS_STATUS +
3265: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3266: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val( NVL(ATTR_DISP_VALUE,ATTR_VALUE_NUM) * NVL((SELECT CONVERSION_RATE FROM MTL_UOM_CONVERSIONS
3267: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),
3268: :attr_datatype,
3269: :attr_min_allowed_val,
3270: :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conversion fails

Line 3297: SET ATTR_VALUE_DATE = TRUNC(NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE),ATTR_VALUE_DATE)),--WE SHOULD REMOVE THE TIME PART FROM THE DATE IF DATATYPE IS NOT DATE TIME

3293: IF (l_nvs_date_cursor_id IS NULL) THEN
3294: l_nvs_date_cursor_id := DBMS_SQL.Open_Cursor;
3295: l_dynamic_sql :=
3296: 'UPDATE '||p_interface_table_name||'
3297: SET ATTR_VALUE_DATE = TRUNC(NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE),ATTR_VALUE_DATE)),--WE SHOULD REMOVE THE TIME PART FROM THE DATE IF DATATYPE IS NOT DATE TIME
3298: PROCESS_STATUS = PROCESS_STATUS +
3299: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3300: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3301: WHERE DATA_SET_ID = :data_set_id

Line 3299: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly

3295: l_dynamic_sql :=
3296: 'UPDATE '||p_interface_table_name||'
3297: SET ATTR_VALUE_DATE = TRUNC(NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE),ATTR_VALUE_DATE)),--WE SHOULD REMOVE THE TIME PART FROM THE DATE IF DATATYPE IS NOT DATE TIME
3298: PROCESS_STATUS = PROCESS_STATUS +
3299: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3300: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3301: WHERE DATA_SET_ID = :data_set_id
3302: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3303: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0

Line 3300: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails

3296: 'UPDATE '||p_interface_table_name||'
3297: SET ATTR_VALUE_DATE = TRUNC(NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE),ATTR_VALUE_DATE)),--WE SHOULD REMOVE THE TIME PART FROM THE DATE IF DATATYPE IS NOT DATE TIME
3298: PROCESS_STATUS = PROCESS_STATUS +
3299: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3300: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3301: WHERE DATA_SET_ID = :data_set_id
3302: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3303: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
3304: AND ATTR_INT_NAME = :attr_internal_name

Line 3326: SET ATTR_VALUE_DATE = NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''),ATTR_VALUE_DATE),

3322: IF (l_nvs_datetime_cursor_id is NULL) THEN
3323: l_nvs_datetime_cursor_id := DBMS_SQL.Open_Cursor;
3324: l_dynamic_sql :=
3325: 'UPDATE '||p_interface_table_name||'
3326: SET ATTR_VALUE_DATE = NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''),ATTR_VALUE_DATE),
3327: PROCESS_STATUS = PROCESS_STATUS +
3328: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3329: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3330: WHERE DATA_SET_ID = :data_set_id

Line 3328: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly

3324: l_dynamic_sql :=
3325: 'UPDATE '||p_interface_table_name||'
3326: SET ATTR_VALUE_DATE = NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''),ATTR_VALUE_DATE),
3327: PROCESS_STATUS = PROCESS_STATUS +
3328: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3329: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3330: WHERE DATA_SET_ID = :data_set_id
3331: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3332: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0

Line 3329: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails

3325: 'UPDATE '||p_interface_table_name||'
3326: SET ATTR_VALUE_DATE = NVL(EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_DISP_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''),ATTR_VALUE_DATE),
3327: PROCESS_STATUS = PROCESS_STATUS +
3328: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3329: EGO_USER_ATTRS_BULK_PVT.Get_Max_Min_Error_Val(NVL(ATTR_DISP_VALUE,ATTR_VALUE_DATE), :attr_datatype, :attr_min_allowed_val, :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conv fails
3330: WHERE DATA_SET_ID = :data_set_id
3331: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3332: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
3333: AND ATTR_INT_NAME = :attr_internal_name

Line 5705: l_db_col_tbl_declare_ext_id := 'ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';

5701: ELSE
5702: l_rtcq_to_ext_where_base := ' AND 2=2 ';
5703: END IF;
5704:
5705: l_db_col_tbl_declare_ext_id := 'ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
5706: l_db_col_tbl_collect_ext_id := 'ext_id_tbl';
5707:
5708: IF(l_ag_id_col_exists) THEN
5709: l_db_col_tbl_where_ext_id := 'EXT.ATTR_GROUP_ID=:curr_attr_group_id AND EXT.EXTENSION_ID=ext_id_tbl(i)';

Line 5995: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';

5991: END IF;
5992:
5993: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
5994: 'attr_'||l_rn_index_for_ag||
5995: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
5996: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
5997: 'attr_'||l_rn_index_for_ag||
5998: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
5999:

Line 5998: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';

5994: 'attr_'||l_rn_index_for_ag||
5995: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
5996: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
5997: 'attr_'||l_rn_index_for_ag||
5998: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
5999:
6000: -- we only update non-UK Attrs
6001: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
6002: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

Line 6016: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||

6012: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
6013: ',EXT.'||
6014: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6015: '=DECODE(attr_'||l_rn_index_for_ag||
6016: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
6017: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6018: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
6019: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
6020: ',EXT.'||l_uom_column1 ||

Line 6022: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '

6018: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
6019: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
6020: ',EXT.'||l_uom_column1 ||
6021: '= DECODE(attr_'||l_rn_index_for_ag||'_uom_tbl(i) ,NULL, '||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
6022: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
6023: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '--bugfix:6526366
6024: ||',attr_'||l_rn_index_for_ag||'_uom_tbl(i) )';--BugFux:5509743
6025: ELSE
6026: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||

Line 6023: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '--bugfix:6526366

6019: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
6020: ',EXT.'||l_uom_column1 ||
6021: '= DECODE(attr_'||l_rn_index_for_ag||'_uom_tbl(i) ,NULL, '||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
6022: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
6023: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '--bugfix:6526366
6024: ||',attr_'||l_rn_index_for_ag||'_uom_tbl(i) )';--BugFux:5509743
6025: ELSE
6026: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
6027: ',EXT.'||

Line 6030: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||

6026: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
6027: ',EXT.'||
6028: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6029: '=DECODE(attr_'||l_rn_index_for_ag||
6030: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
6031: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6032: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
6033: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
6034:

Line 6054: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL;';

6050: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6051:
6052: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
6053: 'attr_'||l_rn_index_for_ag||
6054: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL;';
6055:
6056: -- we only update non-UK Attrs
6057: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
6058: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

Line 6066: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||

6062: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
6063: ',EXT.'||
6064: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6065: '=TO_DATE(DECODE(attr_'||l_rn_index_for_ag||
6066: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
6067: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6068: ','||G_NULL_TOKEN_DATE_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
6069: ',TO_CHAR(attr_'||l_rn_index_for_ag||'_tbl(i), ''DD/MM/YYYY HH24:MI:SS'') ),''DD/MM/YYYY HH24:MI:SS'')';
6070:

Line 6082: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';

6078: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6079:
6080: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
6081: 'attr_'||l_rn_index_for_ag||
6082: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
6083:
6084: -- we only update non-UK Attrs
6085: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
6086: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

Line 6095: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

6091: l_db_col_tbl_set_tl_attrs := l_db_col_tbl_set_tl_attrs||
6092: ',EXT.'||
6093: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6094: '=DECODE(attr_'||l_rn_index_for_ag||
6095: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6096: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6097: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
6098:
6099: ELSE

Line 6105: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

6101: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
6102: ',EXT.'||
6103: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6104: '=DECODE(attr_'||l_rn_index_for_ag||
6105: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6106: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
6107: ','||G_NULL_TOKEN_STR_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
6108: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
6109:

Line 6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '

6145: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6146:
6147: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6148: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
6150: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '

Line 6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '

6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
6150: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
6154: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6155: ELSE
6156: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '
6157: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;

Line 6156: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '

6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
6154: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6155: ELSE
6156: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '
6157: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6158:
6159: END IF;
6160: l_no_alias_b_cols_list := l_no_alias_b_cols_list||','||

Line 6206: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||

6202: ' FROM (SELECT DECODE(ATTR_INT_NAME'||l_row_to_column_attr_decode||
6203: ') RN,TRANSACTION_TYPE,ATTR_GROUP_ID'||
6204: l_no_alias_cc_pk_dl_list||
6205: ',ATTR_INT_NAME,NVL(ATTR_VALUE_NUM,'||
6206: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
6207: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
6208: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6209: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
6210: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

Line 6208: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

6204: l_no_alias_cc_pk_dl_list||
6205: ',ATTR_INT_NAME,NVL(ATTR_VALUE_NUM,'||
6206: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
6207: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
6208: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6209: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
6210: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6211: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
6212: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||

Line 6210: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

6206: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
6207: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
6208: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6209: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
6210: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6211: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
6212: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
6213: ')ATTR_VALUE_DATE,ROW_IDENTIFIER FROM '||
6214: p_interface_table_name||

Line 6212: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||

6208: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6209: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
6210: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
6211: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
6212: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
6213: ')ATTR_VALUE_DATE,ROW_IDENTIFIER FROM '||
6214: p_interface_table_name||
6215: ' WHERE DATA_SET_ID = :data_set_id AND PROCESS_STATUS = '||G_PS_IN_PROCESS||
6216: ' AND ATTR_GROUP_INT_NAME = :attr_group_name AND ATTR_GROUP_TYPE = '''||p_attr_group_type||''') GROUP BY ROW_IDENTIFIER';

Line 6326: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||

6322: -------------------------------------------------------
6323:
6324: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
6325:
6326: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
6327: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6328: ' creation_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; lu_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6329: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
6330: '

Line 6327: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||

6323:
6324: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
6325:
6326: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
6327: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6328: ' creation_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; lu_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6329: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
6330: '
6331: '||

Line 6328: ' creation_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; lu_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||

6324: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
6325:
6326: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
6327: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6328: ' creation_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; lu_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6329: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
6330: '
6331: '||
6332: ' BEGIN '||

Line 6329: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||

6325:
6326: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
6327: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6328: ' creation_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; lu_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
6329: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
6330: '
6331: '||
6332: ' BEGIN '||
6333: ' SELECT EGO_EXTFWK_S.NEXTVAL, '||l_concat_pk_cols_sel||

Line 6466: 'DECLARE '||l_db_col_tbl_declare_ext_id||' lang_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;'||

6462:
6463: IF (LENGTH(l_db_col_tbl_set_b_attrs) > 0 OR
6464: LENGTH(l_db_col_tbl_set_tl_attrs) > 0) THEN
6465: l_dynamic_sql :=
6466: 'DECLARE '||l_db_col_tbl_declare_ext_id||' lang_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;'||
6467: l_db_col_tbl_declare_attrs||
6468: ' BEGIN SELECT LANGUAGE, EXTENSION_ID'||
6469: l_final_b_col_list ||
6470: l_final_tl_col_list ||

Line 8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||

8604: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
8605: ' ,ATTR_TBL.DEFAULT_VALUE '||
8606: ' ,NULL) '||
8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8609: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
8610: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8611: ' ,NULL) ';
8612:

Line 8610: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||

8606: ' ,NULL) '||
8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8609: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
8610: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8611: ' ,NULL) ';
8612:
8613: l_dynamic_sql := l_dynamic_sql || l_pk_cc_select_list;
8614: code_debug(l_api_name ||' phase 3 ');

Line 8799: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: '||SQLERRM;

8795: EXCEPTION
8796: WHEN OTHERS THEN
8797: code_debug(l_api_name ||' Returning EXCEPTION '||SQLERRM);
8798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8799: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: '||SQLERRM;
8800:
8801: END Insert_Default_Val_Rows;
8802:
8803: ----------------------------------------------------------------------

Line 9271: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows: '||SQLERRM;

9267:
9268: EXCEPTION
9269: WHEN OTHERS THEN
9270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9271: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows: '||SQLERRM;
9272:
9273:
9274: END Mark_Unchanged_Attr_Rows;
9275:

Line 9380: END EGO_USER_ATTRS_BULK_PVT;

9376: end loop;
9377: return 0;
9378: end get_order_by;
9379:
9380: END EGO_USER_ATTRS_BULK_PVT;
9381: