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_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.137.12020000.15 2013/02/13 14:32:10 vijoshi 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 2032: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';

2028: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk1_column_name||' = UAI2.'||l_pk1_column_name;
2029: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' pk_1_tbl ';
2030: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' pk_1_tbl(i) ';
2031: IF(l_pk1_column_type = 'INTEGER') THEN
2032: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2033: ELSE
2034: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2035: END IF;
2036: END IF;

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

2030: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' pk_1_tbl(i) ';
2031: IF(l_pk1_column_type = 'INTEGER') THEN
2032: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2033: ELSE
2034: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2035: END IF;
2036: END IF;
2037:
2038: IF (l_pk2_column_name IS NOT NULL) THEN

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

2040: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk2_column_name||' = UAI2.'||l_pk2_column_name;
2041: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_2_tbl ';
2042: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_2_tbl(i) ';
2043: IF(l_pk2_column_type = 'INTEGER') THEN
2044: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2045: ELSE
2046: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2047: END IF;
2048: END IF;

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

2042: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_2_tbl(i) ';
2043: IF(l_pk2_column_type = 'INTEGER') THEN
2044: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2045: ELSE
2046: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2047: END IF;
2048: END IF;
2049:
2050: IF (l_pk3_column_name IS NOT NULL) THEN

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

2052: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk3_column_name||' = UAI2.'||l_pk3_column_name;
2053: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_3_tbl ';
2054: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_3_tbl(i) ';
2055: IF(l_pk3_column_type = 'INTEGER') THEN
2056: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2057: ELSE
2058: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2059: END IF;
2060: END IF;

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

2054: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_3_tbl(i) ';
2055: IF(l_pk3_column_type = 'INTEGER') THEN
2056: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2057: ELSE
2058: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2059: END IF;
2060: END IF;
2061:
2062: IF (l_pk4_column_name IS NOT NULL) THEN

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

2064: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk4_column_name||' = UAI2.'||l_pk4_column_name;
2065: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_4_tbl ';
2066: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_4_tbl(i) ';
2067: IF(l_pk4_column_type = 'INTEGER') THEN
2068: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2069: ELSE
2070: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2071: END IF;
2072: END IF;

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

2066: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_4_tbl(i) ';
2067: IF(l_pk4_column_type = 'INTEGER') THEN
2068: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2069: ELSE
2070: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_4_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2071: END IF;
2072: END IF;
2073: IF (l_pk5_column_name IS NOT NULL) THEN
2074: l_concat_pk_cols_sel := l_concat_pk_cols_sel ||l_pk5_column_name||',';

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

2075: l_concat_pk_cols_UAI2 := l_concat_pk_cols_UAI2 || ' AND '||l_pk5_column_name||' = UAI2.'||l_pk5_column_name;
2076: l_pk_blk_tbl_list := l_pk_blk_tbl_list || ' ,pk_5_tbl ';
2077: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_5_tbl(i) ';
2078: IF(l_pk5_column_type = 'INTEGER') THEN
2079: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2080: ELSE
2081: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2082: END IF;
2083: END IF;

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

2077: l_pk_blk_tbl_list_2 := l_pk_blk_tbl_list_2 || ' ,pk_5_tbl(i) ';
2078: IF(l_pk5_column_type = 'INTEGER') THEN
2079: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2080: ELSE
2081: l_pk_blk_tbl_declare := l_pk_blk_tbl_declare || ' pk_5_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2082: END IF;
2083: END IF;
2084: ---------------------------------------------
2085: -- adding datalevel columns --

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

2184: IF (l_data_level_column_1 IS NOT NULL AND l_data_level_column_1 <> 'NONE') THEN
2185: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' ,dl_1_tbl ';
2186: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' ,dl_1_tbl(i) ';
2187: IF(l_dl_col_data_type_1 = 'NUMBER') THEN
2188: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2189: ELSE
2190: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2191: END IF;
2192: END IF;

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

2186: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' ,dl_1_tbl(i) ';
2187: IF(l_dl_col_data_type_1 = 'NUMBER') THEN
2188: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2189: ELSE
2190: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_1_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2191: END IF;
2192: END IF;
2193:
2194: IF (l_data_level_column_2 IS NOT NULL AND l_data_level_column_2 <> 'NONE') THEN

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

2194: IF (l_data_level_column_2 IS NOT NULL AND l_data_level_column_2 <> 'NONE') THEN
2195: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' dl_2_tbl ';
2196: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_2_tbl(i) ';
2197: IF(l_dl_col_data_type_2 = 'NUMBER') THEN
2198: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2199: ELSE
2200: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2201: END IF;
2202: END IF;

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

2196: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_2_tbl(i) ';
2197: IF(l_dl_col_data_type_2 = 'NUMBER') THEN
2198: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2199: ELSE
2200: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_2_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2201: END IF;
2202: END IF;
2203:
2204: IF (l_data_level_column_3 IS NOT NULL AND l_data_level_column_3 <> 'NONE') THEN

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

2204: IF (l_data_level_column_3 IS NOT NULL AND l_data_level_column_3 <> 'NONE') THEN
2205: l_dl_blk_tbl_list := l_dl_blk_tbl_list || ' dl_3_tbl ';
2206: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_3_tbl(i) ';
2207: IF(l_dl_col_data_type_3 = 'NUMBER') THEN
2208: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2209: ELSE
2210: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2211: END IF;
2212: END IF;

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

2206: l_dl_blk_tbl_list_2 := l_dl_blk_tbl_list_2 || ' dl_3_tbl(i) ';
2207: IF(l_dl_col_data_type_3 = 'NUMBER') THEN
2208: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2209: ELSE
2210: l_dl_blk_tbl_declare := l_dl_blk_tbl_declare || ' dl_3_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2211: END IF;
2212: END IF;
2213:
2214: IF (l_class_code_column_name IS NOT NULL ) THEN

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

2214: IF (l_class_code_column_name IS NOT NULL ) THEN
2215: l_class_blk_tbl_list := l_class_blk_tbl_list || ' class_tbl ';
2216: l_class_blk_tbl_list_2 := l_class_blk_tbl_list_2 || ' class_tbl(i) ';
2217: IF(l_class_code_column_type = 'NUMBER') THEN
2218: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2219: ELSE
2220: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2221: END IF;
2222: END IF;

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

2216: l_class_blk_tbl_list_2 := l_class_blk_tbl_list_2 || ' class_tbl(i) ';
2217: IF(l_class_code_column_type = 'NUMBER') THEN
2218: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; ';
2219: ELSE
2220: l_class_blk_tbl_declare := l_class_blk_tbl_declare || ' class_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL; ';
2221: END IF;
2222: END IF;
2223:
2224:

Line 3527: SET ATTR_VALUE_DATE = (SELECT DISTINCT TRUNC(EGO_USER_ATTRS_BULK_PVT.Get_Date(FLEX_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''))

3523:
3524: l_ivs_date_cursor_id := DBMS_SQL.Open_Cursor;
3525: l_dynamic_sql :=
3526: 'UPDATE '||p_interface_table_name||'
3527: SET ATTR_VALUE_DATE = (SELECT DISTINCT TRUNC(EGO_USER_ATTRS_BULK_PVT.Get_Date(FLEX_VALUE,'''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''))
3528: FROM FND_FLEX_VALUES_VL
3529: WHERE ENABLED_FLAG = ''Y''
3530: AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)
3531: AND (NVL(END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE)

Line 3585: SET ATTR_VALUE_DATE = (EGO_USER_ATTRS_BULK_PVT.Get_Date(

3581:
3582: l_ivs_date_time_cursor_id := DBMS_SQL.Open_Cursor;
3583: l_dynamic_sql :=
3584: 'UPDATE '||p_interface_table_name||'
3585: SET ATTR_VALUE_DATE = (EGO_USER_ATTRS_BULK_PVT.Get_Date(
3586: (SELECT DISTINCT FLEX_VALUE
3587: FROM FND_FLEX_VALUES_VL
3588: WHERE ENABLED_FLAG = ''Y''
3589: AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)

Line 3727: 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),

3723: IF (l_nvs_num_cursor_id is NULL) THEN
3724: l_nvs_num_cursor_id := DBMS_SQL.Open_Cursor;
3725: l_dynamic_sql :=
3726: 'UPDATE '||p_interface_table_name||'
3727: 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),
3728: PROCESS_STATUS = PROCESS_STATUS +
3729: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3730: 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
3731: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),

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

3725: l_dynamic_sql :=
3726: 'UPDATE '||p_interface_table_name||'
3727: 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),
3728: PROCESS_STATUS = PROCESS_STATUS +
3729: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3730: 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
3731: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),
3732: :attr_datatype,
3733: :attr_min_allowed_val,

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

3726: 'UPDATE '||p_interface_table_name||'
3727: 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),
3728: PROCESS_STATUS = PROCESS_STATUS +
3729: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3730: 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
3731: WHERE UOM_CLASS = :uom_class AND UOM_CODE = ATTR_VALUE_UOM AND ROWNUM = 1),1),
3732: :attr_datatype,
3733: :attr_min_allowed_val,
3734: :attr_max_allowed_val) --returns 0 if max/min is honoured or datatype conversion fails

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

3757: IF (l_nvs_date_cursor_id IS NULL) THEN
3758: l_nvs_date_cursor_id := DBMS_SQL.Open_Cursor;
3759: l_dynamic_sql :=
3760: 'UPDATE '||p_interface_table_name||'
3761: 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
3762: PROCESS_STATUS = PROCESS_STATUS +
3763: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3764: 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
3765: WHERE DATA_SET_ID = :data_set_id

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

3759: l_dynamic_sql :=
3760: 'UPDATE '||p_interface_table_name||'
3761: 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
3762: PROCESS_STATUS = PROCESS_STATUS +
3763: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3764: 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
3765: WHERE DATA_SET_ID = :data_set_id
3766: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3767: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0

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

3760: 'UPDATE '||p_interface_table_name||'
3761: 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
3762: PROCESS_STATUS = PROCESS_STATUS +
3763: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3764: 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
3765: WHERE DATA_SET_ID = :data_set_id
3766: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3767: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
3768: AND ATTR_INT_NAME = :attr_internal_name

Line 3790: 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),

3786: IF (l_nvs_datetime_cursor_id is NULL) THEN
3787: l_nvs_datetime_cursor_id := DBMS_SQL.Open_Cursor;
3788: l_dynamic_sql :=
3789: 'UPDATE '||p_interface_table_name||'
3790: 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),
3791: PROCESS_STATUS = PROCESS_STATUS +
3792: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3793: 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
3794: WHERE DATA_SET_ID = :data_set_id

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

3788: l_dynamic_sql :=
3789: 'UPDATE '||p_interface_table_name||'
3790: 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),
3791: PROCESS_STATUS = PROCESS_STATUS +
3792: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3793: 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
3794: WHERE DATA_SET_ID = :data_set_id
3795: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3796: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0

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

3789: 'UPDATE '||p_interface_table_name||'
3790: 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),
3791: PROCESS_STATUS = PROCESS_STATUS +
3792: EGO_USER_ATTRS_BULK_PVT.Get_Datatype_Error_Val(ATTR_DISP_VALUE, :attr_datatype) + --returns 0 if datatype conversion happens correctly
3793: 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
3794: WHERE DATA_SET_ID = :data_set_id
3795: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
3796: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
3797: AND ATTR_INT_NAME = :attr_internal_name

Line 5208: DECODE(ATTR_EXT.DATA_TYPE, ''X'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),

5204: NULL)),
5205: DECODE(ATTR_EXT.DATA_TYPE, ''A'', FL_COL.DEFAULT_VALUE,
5206: ''C'', FL_COL.DEFAULT_VALUE,
5207: NULL),
5208: DECODE(ATTR_EXT.DATA_TYPE, ''X'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5209: ''Y'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5210: NULL),
5211: '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',
5212: '|| l_concat_pk_cols_sel ||'

Line 5209: ''Y'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),

5205: DECODE(ATTR_EXT.DATA_TYPE, ''A'', FL_COL.DEFAULT_VALUE,
5206: ''C'', FL_COL.DEFAULT_VALUE,
5207: NULL),
5208: DECODE(ATTR_EXT.DATA_TYPE, ''X'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5209: ''Y'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5210: NULL),
5211: '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',
5212: '|| l_concat_pk_cols_sel ||'
5213: ATTR_GROUP_ID,

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

7101: ELSE
7102: l_rtcq_to_ext_where_base := ' AND 2=2 ';
7103: END IF;
7104:
7105: l_db_col_tbl_declare_ext_id := 'ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
7106: l_db_col_tbl_collect_ext_id := 'ext_id_tbl';
7107:
7108: IF(l_ag_id_col_exists) THEN
7109: l_db_col_tbl_where_ext_id := 'EXT.ATTR_GROUP_ID=:curr_attr_group_id AND EXT.EXTENSION_ID=ext_id_tbl(i)';

Line 7402: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';

7398: END IF;
7399:
7400: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
7401: 'attr_'||l_rn_index_for_ag||
7402: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
7403: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
7404: 'attr_'||l_rn_index_for_ag||
7405: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
7406:

Line 7405: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';

7401: 'attr_'||l_rn_index_for_ag||
7402: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL;';
7403: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
7404: 'attr_'||l_rn_index_for_ag||
7405: '_uom_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
7406:
7407: -- we only update non-UK Attrs
7408: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
7409: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

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

7419: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
7420: ',EXT.'||
7421: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7422: '=DECODE(attr_'||l_rn_index_for_ag||
7423: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
7424: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7425: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
7426: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
7427: ',EXT.'||l_uom_column1 ||

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

7425: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
7426: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
7427: ',EXT.'||l_uom_column1 ||
7428: '= 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||''') '
7429: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
7430: ||','||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
7431: ||',attr_'||l_rn_index_for_ag||'_uom_tbl(i) )';--BugFux:5509743
7432: ELSE
7433: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||

Line 7430: ||','||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

7426: ',attr_'||l_rn_index_for_ag||'_tbl(i))'||
7427: ',EXT.'||l_uom_column1 ||
7428: '= 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||''') '
7429: ||','||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||','||'NVL (EXT.'||l_uom_column1||' ,'''||l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_BASE||''') '
7430: ||','||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
7431: ||',attr_'||l_rn_index_for_ag||'_uom_tbl(i) )';--BugFux:5509743
7432: ELSE
7433: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
7434: ',EXT.'||

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

7433: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
7434: ',EXT.'||
7435: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7436: '=DECODE(attr_'||l_rn_index_for_ag||
7437: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
7438: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7439: ','||G_NULL_TOKEN_NUM_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
7440: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
7441:

Line 7461: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL;';

7457: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7458:
7459: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
7460: 'attr_'||l_rn_index_for_ag||
7461: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL;';
7462:
7463: -- we only update non-UK Attrs
7464: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
7465: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

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

7471: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7472: --FP bug 8270556 with base bug 8238064
7473: '=DECODE(attr_'||l_rn_index_for_ag||'_tbl(i) ,NULL, EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||' , '||
7474: 'TO_DATE(DECODE(attr_'||l_rn_index_for_ag||
7475: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
7476: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7477: ','||G_NULL_TOKEN_DATE_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
7478: ',TO_CHAR(attr_'||l_rn_index_for_ag||'_tbl(i), ''DD/MM/YYYY HH24:MI:SS'') ),''DD/MM/YYYY HH24:MI:SS''))';
7479:

Line 7491: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';

7487: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7488:
7489: l_db_col_tbl_declare_attrs := l_db_col_tbl_declare_attrs||
7490: 'attr_'||l_rn_index_for_ag||
7491: '_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;';
7492:
7493: -- we only update non-UK Attrs
7494: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
7495: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN

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

7500: l_db_col_tbl_set_tl_attrs := l_db_col_tbl_set_tl_attrs||
7501: ',EXT.'||
7502: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7503: '=DECODE(attr_'||l_rn_index_for_ag||
7504: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7505: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7506: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
7507:
7508: ELSE

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

7510: l_db_col_tbl_set_b_attrs := l_db_col_tbl_set_b_attrs||
7511: ',EXT.'||
7512: l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7513: '=DECODE(attr_'||l_rn_index_for_ag||
7514: '_tbl(i),'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7515: ',NULL,NULL,EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||
7516: ','||G_NULL_TOKEN_STR_1||',EXT.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||--bugfix:6526366
7517: ',attr_'||l_rn_index_for_ag||'_tbl(i))';
7518:

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

7554: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7555:
7556: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7557: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7558: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
7559: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7560: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
7562: 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 7562: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '

7558: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
7559: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7560: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
7562: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
7563: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7564: ELSE
7565: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '
7566: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;

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

7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
7562: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
7563: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7564: ELSE
7565: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '
7566: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7567:
7568: END IF;
7569: l_no_alias_b_cols_list := l_no_alias_b_cols_list||','||

Line 7615: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||

7611: ' FROM (SELECT DECODE(ATTR_INT_NAME'||l_row_to_column_attr_decode||
7612: ') RN,TRANSACTION_TYPE,ATTR_GROUP_ID'||
7613: l_no_alias_cc_pk_dl_list||
7614: ',ATTR_INT_NAME,NVL(ATTR_VALUE_NUM,'||
7615: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
7616: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
7617: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7618: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
7619: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

Line 7617: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

7613: l_no_alias_cc_pk_dl_list||
7614: ',ATTR_INT_NAME,NVL(ATTR_VALUE_NUM,'||
7615: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
7616: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
7617: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7618: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
7619: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7620: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
7621: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||

Line 7619: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||

7615: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||
7616: ')ATTR_VALUE_NUM, NVL(ATTR_VALUE_UOM,'||
7617: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7618: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
7619: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7620: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
7621: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
7622: ')ATTR_VALUE_DATE,ROW_IDENTIFIER FROM '||
7623: p_interface_table_name||

Line 7621: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||

7617: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7618: ') ATTR_VALUE_UOM, NVL(ATTR_VALUE_STR,'||
7619: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR||
7620: ')ATTR_VALUE_STR,NVL(ATTR_VALUE_DATE,'||
7621: EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE||
7622: ')ATTR_VALUE_DATE,ROW_IDENTIFIER FROM '||
7623: p_interface_table_name||
7624: ' WHERE DATA_SET_ID = :data_set_id AND PROCESS_STATUS = '||G_PS_IN_PROCESS||
7625: ' AND ATTR_GROUP_INT_NAME = :attr_group_name AND ATTR_GROUP_TYPE = '''||p_attr_group_type||''') GROUP BY ROW_IDENTIFIER';

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

7750: -------------------------------------------------------
7751:
7752: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
7753:
7754: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
7755: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
7756: ' 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; '||
7757: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
7758: '

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

7751:
7752: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
7753:
7754: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
7755: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
7756: ' 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; '||
7757: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
7758: '
7759: '||

Line 7756: ' 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; '||

7752: IF(NOT l_ag_id_col_exists AND p_do_dml ) THEN
7753:
7754: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
7755: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
7756: ' 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; '||
7757: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
7758: '
7759: '||
7760: ' BEGIN '||

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

7753:
7754: l_dynamic_Sql := ' DECLARE ext_id_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||l_pk_blk_tbl_declare||
7755: ' created_by_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_NUM_TBL; '||
7756: ' 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; '||
7757: ' lu_date_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_DATE_TBL; '||l_dl_blk_tbl_declare||l_class_blk_tbl_declare||
7758: '
7759: '||
7760: ' BEGIN '||
7761: ' SELECT EGO_EXTFWK_S.NEXTVAL, '||l_concat_pk_cols_sel||

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

7892: LENGTH(l_db_col_tbl_set_tl_attrs) > 0) THEN
7893: BEGIN
7894: cur_l_dynamic_sql_clob := dbms_sql.open_cursor;
7895: l_dynamic_sql_clob :=
7896: 'DECLARE '||l_db_col_tbl_declare_ext_id||' lang_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;'||
7897: l_db_col_tbl_declare_attrs||
7898: ' BEGIN SELECT LANGUAGE, EXTENSION_ID'||
7899: l_final_b_col_list ||
7900: l_final_tl_col_list ||

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

8037:
8038: IF (LENGTH(l_db_col_tbl_set_b_attrs) > 0 OR
8039: LENGTH(l_db_col_tbl_set_tl_attrs) > 0) THEN
8040: l_dynamic_sql :=
8041: 'DECLARE '||l_db_col_tbl_declare_ext_id||' lang_tbl EGO_USER_ATTRS_BULK_PVT.EGO_USER_ATTRS_BULK_STR_TBL;'||
8042: l_db_col_tbl_declare_attrs||
8043: ' BEGIN SELECT LANGUAGE, EXTENSION_ID'||
8044: l_final_b_col_list ||
8045: l_final_tl_col_list ||

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

10341: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
10342: ' ,ATTR_TBL.DEFAULT_VALUE '||
10343: ' ,NULL) '||
10344: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
10345: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10346: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
10347: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10348: ' ,NULL) ';
10349:

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

10343: ' ,NULL) '||
10344: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
10345: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10346: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
10347: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10348: ' ,NULL) ';
10349:
10350: l_dynamic_sql := l_dynamic_sql || l_pk_cc_select_list;
10351: code_debug(l_api_name ||' phase 3 ');

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

10572: EXCEPTION
10573: WHEN OTHERS THEN
10574: code_debug(l_api_name ||' Returning EXCEPTION '||SQLERRM);
10575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10576: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: '||SQLERRM;
10577:
10578: END Insert_Default_Val_Rows;
10579:
10580: ----------------------------------------------------------------------

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

11058:
11059: EXCEPTION
11060: WHEN OTHERS THEN
11061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11062: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows: '||SQLERRM;
11063:
11064:
11065: END Mark_Unchanged_Attr_Rows;
11066:

Line 11178: END EGO_USER_ATTRS_BULK_PVT;

11174: end loop;
11175: return 0;
11176: end get_order_by;
11177:
11178: END EGO_USER_ATTRS_BULK_PVT;