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 DBMS_SQL

Line 1121: -- so we will put this query in an array of type dbms_sql.varchar2a so that we can use DBMS_SQL api.

1117: /* Bug 10151142 : Start
1118: -- Private procedure - Prepare_Dynamic_Sqls_Clob:
1119: -- This procedure builds dynamic sql for dependent table value sets.
1120: -- the query built may have size more that 32k in which case execute immediate doesn't work,
1121: -- so we will put this query in an array of type dbms_sql.varchar2a so that we can use DBMS_SQL api.
1122: */
1123: PROCEDURE Prepare_Dynamic_Sqls_Clob (
1124: p_data_set_id IN NUMBER,
1125: p_data_type_code IN VARCHAR2,

Line 1135: x_dynamic_sql_1_v_type OUT NOCOPY dbms_sql.varchar2a,

1131: x_return_status OUT NOCOPY VARCHAR2,
1132: x_msg_data OUT NOCOPY VARCHAR2,
1133: x_sql_1_ub OUT NOCOPY NUMBER,
1134: x_sql_ub OUT NOCOPY NUMBER,
1135: x_dynamic_sql_1_v_type OUT NOCOPY dbms_sql.varchar2a,
1136: x_dynamic_sql_v_type OUT NOCOPY dbms_sql.varchar2a
1137: ) IS
1138:
1139: l_api_name VARCHAR2(30) := 'Prepare_Dynamic_Sqls_Clob';

Line 1136: x_dynamic_sql_v_type OUT NOCOPY dbms_sql.varchar2a

1132: x_msg_data OUT NOCOPY VARCHAR2,
1133: x_sql_1_ub OUT NOCOPY NUMBER,
1134: x_sql_ub OUT NOCOPY NUMBER,
1135: x_dynamic_sql_1_v_type OUT NOCOPY dbms_sql.varchar2a,
1136: x_dynamic_sql_v_type OUT NOCOPY dbms_sql.varchar2a
1137: ) IS
1138:
1139: l_api_name VARCHAR2(30) := 'Prepare_Dynamic_Sqls_Clob';
1140: l_buffer varchar2(8191):= '';

Line 1149: l_dynamic_sql_v_type dbms_sql.varchar2a;

1145: l_dynamic_sql_1_clob_part1 CLOB;
1146: l_dynamic_sql_clob_part1 CLOB;
1147: l_dynamic_sql_clob_part2 CLOB;
1148:
1149: l_dynamic_sql_v_type dbms_sql.varchar2a;
1150: l_dynamic_sql_1_v_type dbms_sql.varchar2a;
1151:
1152: l_clob_length_1 NUMBER;
1153: l_index_1 NUMBER;

Line 1150: l_dynamic_sql_1_v_type dbms_sql.varchar2a;

1146: l_dynamic_sql_clob_part1 CLOB;
1147: l_dynamic_sql_clob_part2 CLOB;
1148:
1149: l_dynamic_sql_v_type dbms_sql.varchar2a;
1150: l_dynamic_sql_1_v_type dbms_sql.varchar2a;
1151:
1152: l_clob_length_1 NUMBER;
1153: l_index_1 NUMBER;
1154: l_index NUMBER;

Line 1752: l_dynamic_sql_v_type dbms_sql.varchar2a;

1748: l_tvs_num_val_check_sel_clob CLOB;
1749: l_tvs_date_val_check_sel_clob CLOB;
1750: l_tvs_str_val_check_sel_clob CLOB;
1751:
1752: l_dynamic_sql_v_type dbms_sql.varchar2a;
1753: l_dynamic_sql_1_v_type dbms_sql.varchar2a;
1754: -- Bug 10151142 : End
1755:
1756: BEGIN

Line 1753: l_dynamic_sql_1_v_type dbms_sql.varchar2a;

1749: l_tvs_date_val_check_sel_clob CLOB;
1750: l_tvs_str_val_check_sel_clob CLOB;
1751:
1752: l_dynamic_sql_v_type dbms_sql.varchar2a;
1753: l_dynamic_sql_1_v_type dbms_sql.varchar2a;
1754: -- Bug 10151142 : End
1755:
1756: BEGIN
1757: code_debug(l_api_name|| 'Starting ');

Line 2727: l_row_ids dbms_sql.number_table;

2723:
2724: -- Bug 9336604 : Start
2725: l_dynamic_sql :=
2726: 'DECLARE
2727: l_row_ids dbms_sql.number_table;
2728: BEGIN
2729: SELECT DISTINCT UAI2.ROW_IDENTIFIER
2730: BULK COLLECT INTO l_row_ids
2731: FROM '||p_interface_table_name||' UAI2

Line 3202: l_priv_func_cursor_id := DBMS_SQL.Open_Cursor;

3198: -- and keep the cursor open throughout our processing --
3199: -----------------------------------------------------------
3200: IF (l_priv_func_cursor_id IS NULL) THEN
3201:
3202: l_priv_func_cursor_id := DBMS_SQL.Open_Cursor;
3203: l_dynamic_sql :=
3204: 'BEGIN '||
3205: p_privilege_predicate_api_name||
3206: '(:obj_name, :party_id, :priv_name, :table_alias, :predicate); END;';

Line 3208: DBMS_SQL.Parse(l_priv_func_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3204: 'BEGIN '||
3205: p_privilege_predicate_api_name||
3206: '(:obj_name, :party_id, :priv_name, :table_alias, :predicate); END;';
3207:
3208: DBMS_SQL.Parse(l_priv_func_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3209:
3210: --------------------------------------------------------------
3211: -- These variables will not change across calls, so we only --
3212: -- need to bind them the first time we parse the statement --

Line 3214: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':obj_name', p_object_name);

3210: --------------------------------------------------------------
3211: -- These variables will not change across calls, so we only --
3212: -- need to bind them the first time we parse the statement --
3213: --------------------------------------------------------------
3214: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':obj_name', p_object_name);
3215: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':party_id', G_HZ_PARTY_ID);
3216: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':table_alias', 'UAI2');
3217: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':predicate', l_priv_predicate, 32767);
3218:

Line 3215: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':party_id', G_HZ_PARTY_ID);

3211: -- These variables will not change across calls, so we only --
3212: -- need to bind them the first time we parse the statement --
3213: --------------------------------------------------------------
3214: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':obj_name', p_object_name);
3215: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':party_id', G_HZ_PARTY_ID);
3216: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':table_alias', 'UAI2');
3217: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':predicate', l_priv_predicate, 32767);
3218:
3219: END IF;

Line 3216: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':table_alias', 'UAI2');

3212: -- need to bind them the first time we parse the statement --
3213: --------------------------------------------------------------
3214: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':obj_name', p_object_name);
3215: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':party_id', G_HZ_PARTY_ID);
3216: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':table_alias', 'UAI2');
3217: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':predicate', l_priv_predicate, 32767);
3218:
3219: END IF;
3220:

Line 3217: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':predicate', l_priv_predicate, 32767);

3213: --------------------------------------------------------------
3214: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':obj_name', p_object_name);
3215: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':party_id', G_HZ_PARTY_ID);
3216: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':table_alias', 'UAI2');
3217: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':predicate', l_priv_predicate, 32767);
3218:
3219: END IF;
3220:
3221: IF (l_view_priv_to_check IS NOT NULL) THEN

Line 3225: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_view_priv_to_check);

3221: IF (l_view_priv_to_check IS NOT NULL) THEN
3222:
3223: code_debug(' Checking for View privelege '||l_view_priv_to_check,2);
3224:
3225: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_view_priv_to_check);
3226: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3227:
3228: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3229:

Line 3226: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);

3222:
3223: code_debug(' Checking for View privelege '||l_view_priv_to_check,2);
3224:
3225: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_view_priv_to_check);
3226: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3227:
3228: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3229:
3230: code_debug(' The View privlege predicate is :'||l_priv_predicate,3);

Line 3228: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);

3224:
3225: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_view_priv_to_check);
3226: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3227:
3228: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3229:
3230: code_debug(' The View privlege predicate is :'||l_priv_predicate,3);
3231:
3232: ----------------------------------------------------------

Line 3239: -- We needn't use DBMS_SQL here because this statement will --

3235: IF (l_priv_predicate IS NULL) THEN
3236: l_priv_predicate := '1=1';
3237: END IF;
3238: --------------------------------------------------------------
3239: -- We needn't use DBMS_SQL here because this statement will --
3240: -- change too much in each loop (because of the predicate) --
3241: -- for us to gain anything by keeping the cursor open --
3242: --------------------------------------------------------------
3243: EXECUTE IMMEDIATE

Line 3273: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_edit_priv_to_check);

3269: IF (l_edit_priv_to_check IS NOT NULL) THEN
3270:
3271: code_debug(' Checking for Edit privelege '||l_edit_priv_to_check,2);
3272:
3273: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_edit_priv_to_check);
3274: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3275: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3276:
3277: code_debug(' The Edit privlege predicate is :'||l_priv_predicate,3);

Line 3274: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);

3270:
3271: code_debug(' Checking for Edit privelege '||l_edit_priv_to_check,2);
3272:
3273: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_edit_priv_to_check);
3274: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3275: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3276:
3277: code_debug(' The Edit privlege predicate is :'||l_priv_predicate,3);
3278:

Line 3275: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);

3271: code_debug(' Checking for Edit privelege '||l_edit_priv_to_check,2);
3272:
3273: DBMS_SQL.Bind_Variable(l_priv_func_cursor_id, ':priv_name', l_edit_priv_to_check);
3274: l_dummy := DBMS_SQL.Execute(l_priv_func_cursor_id);
3275: DBMS_SQL.Variable_Value(l_priv_func_cursor_id, ':predicate', l_priv_predicate);
3276:
3277: code_debug(' The Edit privlege predicate is :'||l_priv_predicate,3);
3278:
3279: --------------------------------------------------------------

Line 3280: -- As above, we needn't use DBMS_SQL because the statement --

3276:
3277: code_debug(' The Edit privlege predicate is :'||l_priv_predicate,3);
3278:
3279: --------------------------------------------------------------
3280: -- As above, we needn't use DBMS_SQL because the statement --
3281: -- changes too much in each loop (because of the predicate) --
3282: -- for us to gain anything by keeping the cursor open --
3283: --------------------------------------------------------------
3284:

Line 3466: l_ivs_num_cursor_id := DBMS_SQL.Open_Cursor;

3462: code_debug(' This attribute has an indipendednt value set, validating for value set id -'||l_attr_metadata_rec(l_var).VALUE_SET_ID ,2);
3463:
3464: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3465: IF (l_ivs_num_cursor_id IS NULL) THEN
3466: l_ivs_num_cursor_id := DBMS_SQL.Open_Cursor;
3467: l_dynamic_sql :=
3468: 'UPDATE '||p_interface_table_name||'
3469: SET ATTR_VALUE_NUM = TO_NUMBER((SELECT DISTINCT FLEX_VALUE
3470: FROM FND_FLEX_VALUES_VL

Line 3507: DBMS_SQL.Parse(l_ivs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3503: AND ATTR_INT_NAME = :attr_int_name
3504: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_NUM IS NOT NULL)
3505: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
3506:
3507: DBMS_SQL.Parse(l_ivs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3508:
3509: -----------------------------------------------------------
3510: -- Data set ID will not change across calls, so we only --
3511: -- need to bind it the first time we parse the statement --

Line 3513: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':data_set_id', p_data_set_id);

3509: -----------------------------------------------------------
3510: -- Data set ID will not change across calls, so we only --
3511: -- need to bind it the first time we parse the statement --
3512: -----------------------------------------------------------
3513: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':data_set_id', p_data_set_id);
3514:
3515: END IF;
3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

3512: -----------------------------------------------------------
3513: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':data_set_id', p_data_set_id);
3514:
3515: END IF;
3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3520:

Line 3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3513: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':data_set_id', p_data_set_id);
3514:
3515: END IF;
3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3520:
3521: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

Line 3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3514:
3515: END IF;
3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3520:
3521: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3522: IF (l_ivs_date_cursor_id IS NULL) THEN

Line 3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);

3515: END IF;
3516: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3520:
3521: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3522: IF (l_ivs_date_cursor_id IS NULL) THEN
3523:

Line 3524: l_ivs_date_cursor_id := DBMS_SQL.Open_Cursor;

3520:
3521: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3522: IF (l_ivs_date_cursor_id IS NULL) THEN
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

Line 3564: DBMS_SQL.Parse(l_ivs_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3560: AND ATTR_INT_NAME = :attr_int_name
3561: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)
3562: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
3563:
3564: DBMS_SQL.Parse(l_ivs_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3565:
3566: -----------------------------------------------------------
3567: -- Data set ID will not change across calls, so we only --
3568: -- need to bind it the first time we parse the statement --

Line 3570: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':data_set_id', p_data_set_id);

3566: -----------------------------------------------------------
3567: -- Data set ID will not change across calls, so we only --
3568: -- need to bind it the first time we parse the statement --
3569: -----------------------------------------------------------
3570: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':data_set_id', p_data_set_id);
3571: END IF;
3572:
3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

3569: -----------------------------------------------------------
3570: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':data_set_id', p_data_set_id);
3571: END IF;
3572:
3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3577:

Line 3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3570: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':data_set_id', p_data_set_id);
3571: END IF;
3572:
3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3577:
3578: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3571: END IF;
3572:
3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3577:
3578: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3579:

Line 3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);

3572:
3573: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3577:
3578: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3579:
3580: IF (l_ivs_date_time_cursor_id IS NULL) THEN

Line 3582: l_ivs_date_time_cursor_id := DBMS_SQL.Open_Cursor;

3578: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3579:
3580: IF (l_ivs_date_time_cursor_id IS NULL) THEN
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

Line 3624: DBMS_SQL.Parse(l_ivs_date_time_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3620: AND ATTR_INT_NAME = :attr_int_name
3621: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)
3622: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
3623:
3624: DBMS_SQL.Parse(l_ivs_date_time_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3625:
3626: -----------------------------------------------------------
3627: -- Data set ID will not change across calls, so we only --
3628: -- need to bind it the first time we parse the statement --

Line 3630: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':data_set_id', p_data_set_id);

3626: -----------------------------------------------------------
3627: -- Data set ID will not change across calls, so we only --
3628: -- need to bind it the first time we parse the statement --
3629: -----------------------------------------------------------
3630: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':data_set_id', p_data_set_id);
3631:
3632: END IF;
3633:
3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

Line 3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

3630: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':data_set_id', p_data_set_id);
3631:
3632: END IF;
3633:
3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3635: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3636: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3637: l_dummy := DBMS_SQL.Execute(l_ivs_date_time_cursor_id);
3638:

Line 3635: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3631:
3632: END IF;
3633:
3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3635: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3636: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3637: l_dummy := DBMS_SQL.Execute(l_ivs_date_time_cursor_id);
3638:
3639: ELSE -- must be Char or Trans Text

Line 3636: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3632: END IF;
3633:
3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3635: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3636: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3637: l_dummy := DBMS_SQL.Execute(l_ivs_date_time_cursor_id);
3638:
3639: ELSE -- must be Char or Trans Text
3640:

Line 3637: l_dummy := DBMS_SQL.Execute(l_ivs_date_time_cursor_id);

3633:
3634: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3635: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3636: DBMS_SQL.Bind_Variable(l_ivs_date_time_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3637: l_dummy := DBMS_SQL.Execute(l_ivs_date_time_cursor_id);
3638:
3639: ELSE -- must be Char or Trans Text
3640:
3641: IF (l_ivs_char_cursor_id IS NULL) THEN

Line 3643: l_ivs_char_cursor_id := DBMS_SQL.Open_Cursor;

3639: ELSE -- must be Char or Trans Text
3640:
3641: IF (l_ivs_char_cursor_id IS NULL) THEN
3642:
3643: l_ivs_char_cursor_id := DBMS_SQL.Open_Cursor;
3644: l_dynamic_sql :=
3645: 'UPDATE '||p_interface_table_name||'
3646: SET ATTR_VALUE_STR = (SELECT DISTINCT FLEX_VALUE
3647: FROM FND_FLEX_VALUES_VL

Line 3683: DBMS_SQL.Parse(l_ivs_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3679: AND ATTR_INT_NAME = :attr_int_name
3680: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_STR IS NOT NULL)
3681: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
3682:
3683: DBMS_SQL.Parse(l_ivs_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3684:
3685: -----------------------------------------------------------
3686: -- Data set ID will not change across calls, so we only --
3687: -- need to bind it the first time we parse the statement --

Line 3689: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':data_set_id', p_data_set_id);

3685: -----------------------------------------------------------
3686: -- Data set ID will not change across calls, so we only --
3687: -- need to bind it the first time we parse the statement --
3688: -----------------------------------------------------------
3689: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':data_set_id', p_data_set_id);
3690:
3691: END IF;
3692:
3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

Line 3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);

3689: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':data_set_id', p_data_set_id);
3690:
3691: END IF;
3692:
3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3694: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3697:

Line 3694: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3690:
3691: END IF;
3692:
3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3694: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3697:
3698: END IF;

Line 3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3691: END IF;
3692:
3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3694: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3697:
3698: END IF;
3699: ELSIF (l_attr_metadata_rec(l_var).VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

Line 3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);

3692:
3693: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':value_set_id', l_attr_metadata_rec(l_var).VALUE_SET_ID);
3694: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3697:
3698: END IF;
3699: ELSIF (l_attr_metadata_rec(l_var).VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
3700:

Line 3724: l_nvs_num_cursor_id := DBMS_SQL.Open_Cursor;

3720: ------------------------------------------------------------------------------------
3721: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3722:
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 +

Line 3742: DBMS_SQL.Parse(l_nvs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3738: AND ATTR_INT_NAME = :attr_internal_name
3739: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3740: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_NUM IS NOT NULL)';
3741:
3742: DBMS_SQL.Parse(l_nvs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3743: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':data_set_id', p_data_set_id);
3744:
3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);

Line 3743: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':data_set_id', p_data_set_id);

3739: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3740: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_NUM IS NOT NULL)';
3741:
3742: DBMS_SQL.Parse(l_nvs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3743: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':data_set_id', p_data_set_id);
3744:
3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

Line 3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);

3742: DBMS_SQL.Parse(l_nvs_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3743: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':data_set_id', p_data_set_id);
3744:
3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

3743: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':data_set_id', p_data_set_id);
3744:
3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);

3744:
3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:

Line 3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);

3745: END IF;
3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:
3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);

Line 3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3746: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':uom_class', l_attr_metadata_rec(l_var).UOM_CLASS);
3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:
3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);
3754:

Line 3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3747: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3748: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:
3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);
3754:
3755: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

Line 3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);

3749: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3750: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:
3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);
3754:
3755: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3756:
3757: IF (l_nvs_date_cursor_id IS NULL) THEN

Line 3758: l_nvs_date_cursor_id := DBMS_SQL.Open_Cursor;

3754:
3755: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3756:
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 +

Line 3772: DBMS_SQL.Parse(l_nvs_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3768: AND ATTR_INT_NAME = :attr_internal_name
3769: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3770: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)';
3771:
3772: DBMS_SQL.Parse(l_nvs_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3773: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':data_set_id', p_data_set_id);
3774:
3775: END IF;
3776:

Line 3773: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':data_set_id', p_data_set_id);

3769: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3770: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)';
3771:
3772: DBMS_SQL.Parse(l_nvs_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3773: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':data_set_id', p_data_set_id);
3774:
3775: END IF;
3776:
3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

Line 3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

3773: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':data_set_id', p_data_set_id);
3774:
3775: END IF;
3776:
3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);

Line 3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3774:
3775: END IF;
3776:
3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);

Line 3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3775: END IF;
3776:
3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3783:

Line 3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);

3776:
3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3783:
3784: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);

3777: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3783:
3784: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3785:

Line 3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);

3778: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3779: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3783:
3784: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3785:
3786: IF (l_nvs_datetime_cursor_id is NULL) THEN

Line 3787: l_nvs_datetime_cursor_id := DBMS_SQL.Open_Cursor;

3783:
3784: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3785:
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 +

Line 3801: DBMS_SQL.Parse(l_nvs_datetime_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3797: AND ATTR_INT_NAME = :attr_internal_name
3798: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3799: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)';
3800:
3801: DBMS_SQL.Parse(l_nvs_datetime_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3802: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':data_set_id', p_data_set_id);
3803:
3804: END IF;
3805:

Line 3802: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':data_set_id', p_data_set_id);

3798: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3799: AND (ATTR_DISP_VALUE IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)';
3800:
3801: DBMS_SQL.Parse(l_nvs_datetime_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3802: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':data_set_id', p_data_set_id);
3803:
3804: END IF;
3805:
3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

Line 3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);

3802: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':data_set_id', p_data_set_id);
3803:
3804: END IF;
3805:
3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);

Line 3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3803:
3804: END IF;
3805:
3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3811:

Line 3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3804: END IF;
3805:
3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3811:
3812: l_dummy := DBMS_SQL.Execute(l_nvs_datetime_cursor_id);

Line 3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);

3805:
3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3811:
3812: l_dummy := DBMS_SQL.Execute(l_nvs_datetime_cursor_id);
3813:

Line 3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);

3806: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_datatype', l_attr_metadata_rec(l_var).DATA_TYPE);
3807: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3811:
3812: l_dummy := DBMS_SQL.Execute(l_nvs_datetime_cursor_id);
3813:
3814: ELSE -- must be char and translateble text

Line 3812: l_dummy := DBMS_SQL.Execute(l_nvs_datetime_cursor_id);

3808: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3809: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3810: DBMS_SQL.Bind_Variable(l_nvs_datetime_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3811:
3812: l_dummy := DBMS_SQL.Execute(l_nvs_datetime_cursor_id);
3813:
3814: ELSE -- must be char and translateble text
3815: IF (l_nvs_char_cursor_id is NULL) THEN
3816:

Line 3817: l_nvs_char_cursor_id := DBMS_SQL.Open_Cursor;

3813:
3814: ELSE -- must be char and translateble text
3815: IF (l_nvs_char_cursor_id is NULL) THEN
3816:
3817: l_nvs_char_cursor_id := DBMS_SQL.Open_Cursor;
3818: /* Fix for bug#9678667 : Added the below hint */
3819: l_dynamic_sql :=
3820: 'UPDATE /*+ index(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N1) */ '||p_interface_table_name||'
3821: SET ATTR_VALUE_STR = ATTR_DISP_VALUE

Line 3829: DBMS_SQL.Parse(l_nvs_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3825: AND ATTR_INT_NAME = :attr_internal_name
3826: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3827: AND ATTR_DISP_VALUE IS NOT NULL';
3828:
3829: DBMS_SQL.Parse(l_nvs_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3830: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':data_set_id', p_data_set_id);
3831:
3832: END IF;
3833:

Line 3830: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':data_set_id', p_data_set_id);

3826: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3827: AND ATTR_DISP_VALUE IS NOT NULL';
3828:
3829: DBMS_SQL.Parse(l_nvs_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3830: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':data_set_id', p_data_set_id);
3831:
3832: END IF;
3833:
3834: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3834: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3830: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':data_set_id', p_data_set_id);
3831:
3832: END IF;
3833:
3834: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3835: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3836:
3837: l_dummy := DBMS_SQL.Execute(l_nvs_char_cursor_id);
3838:

Line 3835: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3831:
3832: END IF;
3833:
3834: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3835: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3836:
3837: l_dummy := DBMS_SQL.Execute(l_nvs_char_cursor_id);
3838:
3839: END IF;

Line 3837: l_dummy := DBMS_SQL.Execute(l_nvs_char_cursor_id);

3833:
3834: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3835: DBMS_SQL.Bind_Variable(l_nvs_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3836:
3837: l_dummy := DBMS_SQL.Execute(l_nvs_char_cursor_id);
3838:
3839: END IF;
3840: END IF;
3841:

Line 3867: l_max_size_num_cursor := DBMS_SQL.Open_Cursor;

3863:
3864: --------- FOR NUMBER DATATYPE
3865: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3866: IF (l_max_size_num_cursor IS NULL) THEN
3867: l_max_size_num_cursor := DBMS_SQL.Open_Cursor;
3868: l_dynamic_sql :=
3869: 'UPDATE '||p_interface_table_name||'
3870: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_MAX_LENGTH_VIOLATION||'
3871: WHERE DATA_SET_ID = :data_set_id

Line 3878: DBMS_SQL.Parse(l_max_size_num_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);

3874: AND ATTR_INT_NAME = :attr_internal_name
3875: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3876: AND ATTR_VALUE_NUM IS NOT NULL
3877: AND LENGTH(ATTR_VALUE_NUM) > :max_allowed_size';
3878: DBMS_SQL.Parse(l_max_size_num_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
3879: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':data_set_id', p_data_set_id);
3880:
3881: END IF;
3882:

Line 3879: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':data_set_id', p_data_set_id);

3875: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3876: AND ATTR_VALUE_NUM IS NOT NULL
3877: AND LENGTH(ATTR_VALUE_NUM) > :max_allowed_size';
3878: DBMS_SQL.Parse(l_max_size_num_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
3879: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':data_set_id', p_data_set_id);
3880:
3881: END IF;
3882:
3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3879: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':data_set_id', p_data_set_id);
3880:
3881: END IF;
3882:
3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE

Line 3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3880:
3881: END IF;
3882:
3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

Line 3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);

3881: END IF;
3882:
3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

Line 3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);

3882:
3883: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3890:

Line 3892: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;

3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3890:
3891: IF ( l_max_size_char_cursor IS NULL) THEN
3892: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;
3893: l_dynamic_sql :=
3894: 'UPDATE '||p_interface_table_name||'
3895: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_MAX_LENGTH_VIOLATION||'
3896: WHERE DATA_SET_ID = :data_set_id

Line 3903: DBMS_SQL.Parse(l_max_size_char_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);

3899: AND ATTR_INT_NAME = :attr_internal_name
3900: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3901: AND ATTR_VALUE_STR IS NOT NULL
3902: AND LENGTHB(ATTR_VALUE_STR) > :max_allowed_size'; --for bug 9748517, use byte size to determin size for multi-byte language
3903: DBMS_SQL.Parse(l_max_size_char_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
3904: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':data_set_id', p_data_set_id);
3905:
3906: END IF;
3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3904: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':data_set_id', p_data_set_id);

3900: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3901: AND ATTR_VALUE_STR IS NOT NULL
3902: AND LENGTHB(ATTR_VALUE_STR) > :max_allowed_size'; --for bug 9748517, use byte size to determin size for multi-byte language
3903: DBMS_SQL.Parse(l_max_size_char_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
3904: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':data_set_id', p_data_set_id);
3905:
3906: END IF;
3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3903: DBMS_SQL.Parse(l_max_size_char_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
3904: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':data_set_id', p_data_set_id);
3905:
3906: END IF;
3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3909: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3910:
3911: l_dummy := DBMS_SQL.Execute(l_max_size_char_cursor);

Line 3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3904: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':data_set_id', p_data_set_id);
3905:
3906: END IF;
3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3909: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3910:
3911: l_dummy := DBMS_SQL.Execute(l_max_size_char_cursor);
3912:

Line 3909: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);

3905:
3906: END IF;
3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3909: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3910:
3911: l_dummy := DBMS_SQL.Execute(l_max_size_char_cursor);
3912:
3913: END IF;

Line 3911: l_dummy := DBMS_SQL.Execute(l_max_size_char_cursor);

3907: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3908: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3909: DBMS_SQL.Bind_Variable(l_max_size_char_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3910:
3911: l_dummy := DBMS_SQL.Execute(l_max_size_char_cursor);
3912:
3913: END IF;
3914: END IF;
3915:

Line 3927: l_colcheck_num_cursor_id := DBMS_SQL.Open_Cursor;

3923:
3924: --------- FOR NUMBER DATATYPE
3925: IF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3926: IF (l_colcheck_num_cursor_id IS NULL) THEN
3927: l_colcheck_num_cursor_id := DBMS_SQL.Open_Cursor;
3928: l_dynamic_sql :=
3929: 'UPDATE '||p_interface_table_name||'
3930: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_DATA_IN_WRONG_COL||'
3931: WHERE DATA_SET_ID = :data_set_id

Line 3939: DBMS_SQL.Parse(l_colcheck_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3935: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3936: AND ATTR_VALUE_NUM IS NULL
3937: AND ATTR_DISP_VALUE IS NULL
3938: AND (ATTR_VALUE_STR IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)' ;
3939: DBMS_SQL.Parse(l_colcheck_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3940: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':data_set_id', p_data_set_id);
3941: END IF;
3942:
3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3940: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':data_set_id', p_data_set_id);

3936: AND ATTR_VALUE_NUM IS NULL
3937: AND ATTR_DISP_VALUE IS NULL
3938: AND (ATTR_VALUE_STR IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)' ;
3939: DBMS_SQL.Parse(l_colcheck_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3940: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':data_set_id', p_data_set_id);
3941: END IF;
3942:
3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3944: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3939: DBMS_SQL.Parse(l_colcheck_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3940: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':data_set_id', p_data_set_id);
3941: END IF;
3942:
3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3944: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3945:
3946: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);
3947:

Line 3944: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3940: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':data_set_id', p_data_set_id);
3941: END IF;
3942:
3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3944: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3945:
3946: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);
3947:
3948: --------- FOR DATE/DATETIME DATATYPE

Line 3946: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);

3942:
3943: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3944: DBMS_SQL.Bind_Variable(l_colcheck_num_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3945:
3946: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);
3947:
3948: --------- FOR DATE/DATETIME DATATYPE
3949: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3950: IF (l_colcheck_date_cursor_id IS NULL) THEN

Line 3951: l_colcheck_date_cursor_id := DBMS_SQL.Open_Cursor;

3947:
3948: --------- FOR DATE/DATETIME DATATYPE
3949: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3950: IF (l_colcheck_date_cursor_id IS NULL) THEN
3951: l_colcheck_date_cursor_id := DBMS_SQL.Open_Cursor;
3952: l_dynamic_sql :=
3953: 'UPDATE '||p_interface_table_name||'
3954: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_DATA_IN_WRONG_COL||'
3955: WHERE DATA_SET_ID = :data_set_id

Line 3963: DBMS_SQL.Parse(l_colcheck_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3959: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3960: AND ATTR_VALUE_DATE IS NULL
3961: AND ATTR_DISP_VALUE IS NULL
3962: AND (ATTR_VALUE_STR IS NOT NULL OR ATTR_VALUE_NUM IS NOT NULL)' ;
3963: DBMS_SQL.Parse(l_colcheck_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3964: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':data_set_id', p_data_set_id);
3965: END IF;
3966:
3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3964: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':data_set_id', p_data_set_id);

3960: AND ATTR_VALUE_DATE IS NULL
3961: AND ATTR_DISP_VALUE IS NULL
3962: AND (ATTR_VALUE_STR IS NOT NULL OR ATTR_VALUE_NUM IS NOT NULL)' ;
3963: DBMS_SQL.Parse(l_colcheck_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3964: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':data_set_id', p_data_set_id);
3965: END IF;
3966:
3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3968: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3963: DBMS_SQL.Parse(l_colcheck_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3964: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':data_set_id', p_data_set_id);
3965: END IF;
3966:
3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3968: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3969:
3970: l_dummy := DBMS_SQL.Execute(l_colcheck_date_cursor_id);
3971: --------- FOR CHAR/TRANSLATEBLE TEXT DATATYPE

Line 3968: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3964: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':data_set_id', p_data_set_id);
3965: END IF;
3966:
3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3968: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3969:
3970: l_dummy := DBMS_SQL.Execute(l_colcheck_date_cursor_id);
3971: --------- FOR CHAR/TRANSLATEBLE TEXT DATATYPE
3972: ELSE

Line 3970: l_dummy := DBMS_SQL.Execute(l_colcheck_date_cursor_id);

3966:
3967: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3968: DBMS_SQL.Bind_Variable(l_colcheck_date_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3969:
3970: l_dummy := DBMS_SQL.Execute(l_colcheck_date_cursor_id);
3971: --------- FOR CHAR/TRANSLATEBLE TEXT DATATYPE
3972: ELSE
3973: IF (l_colcheck_char_cursor_id IS NULL) THEN
3974: l_colcheck_char_cursor_id := DBMS_SQL.Open_Cursor;

Line 3974: l_colcheck_char_cursor_id := DBMS_SQL.Open_Cursor;

3970: l_dummy := DBMS_SQL.Execute(l_colcheck_date_cursor_id);
3971: --------- FOR CHAR/TRANSLATEBLE TEXT DATATYPE
3972: ELSE
3973: IF (l_colcheck_char_cursor_id IS NULL) THEN
3974: l_colcheck_char_cursor_id := DBMS_SQL.Open_Cursor;
3975: /* Fix for bug#9678667 - Added below hint */
3976: l_dynamic_sql :=
3977: 'UPDATE /*+ index(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N1) NO_EXPAND */ '||p_interface_table_name||'
3978: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_DATA_IN_WRONG_COL||'

Line 3987: DBMS_SQL.Parse(l_colcheck_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3983: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
3984: AND ATTR_VALUE_STR IS NULL
3985: AND ATTR_DISP_VALUE IS NULL
3986: AND (ATTR_VALUE_NUM IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)' ;
3987: DBMS_SQL.Parse(l_colcheck_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3988: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':data_set_id', p_data_set_id);
3989: END IF;
3990:
3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

Line 3988: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':data_set_id', p_data_set_id);

3984: AND ATTR_VALUE_STR IS NULL
3985: AND ATTR_DISP_VALUE IS NULL
3986: AND (ATTR_VALUE_NUM IS NOT NULL OR ATTR_VALUE_DATE IS NOT NULL)' ;
3987: DBMS_SQL.Parse(l_colcheck_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3988: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':data_set_id', p_data_set_id);
3989: END IF;
3990:
3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3992: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

Line 3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);

3987: DBMS_SQL.Parse(l_colcheck_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3988: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':data_set_id', p_data_set_id);
3989: END IF;
3990:
3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3992: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3993:
3994: l_dummy := DBMS_SQL.Execute(l_colcheck_char_cursor_id);
3995:

Line 3992: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);

3988: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':data_set_id', p_data_set_id);
3989: END IF;
3990:
3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3992: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3993:
3994: l_dummy := DBMS_SQL.Execute(l_colcheck_char_cursor_id);
3995:
3996: END IF;

Line 3994: l_dummy := DBMS_SQL.Execute(l_colcheck_char_cursor_id);

3990:
3991: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3992: DBMS_SQL.Bind_Variable(l_colcheck_char_cursor_id, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3993:
3994: l_dummy := DBMS_SQL.Execute(l_colcheck_char_cursor_id);
3995:
3996: END IF;
3997:
3998: END IF; -- if not previously processed

Line 4035: DBMS_SQL.Close_Cursor(l_priv_func_cursor_id);

4031: code_debug(' After the ATTR LEVEL validation loop ' ,1);
4032:
4033: -- CLOSING ALL OPEN CURSORS
4034: IF (l_priv_func_cursor_id IS NOT NULL) THEN
4035: DBMS_SQL.Close_Cursor(l_priv_func_cursor_id);
4036: END IF;
4037: IF (l_ivs_num_cursor_id IS NOT NULL) THEN
4038: DBMS_SQL.Close_Cursor(l_ivs_num_cursor_id);
4039: END IF;

Line 4038: DBMS_SQL.Close_Cursor(l_ivs_num_cursor_id);

4034: IF (l_priv_func_cursor_id IS NOT NULL) THEN
4035: DBMS_SQL.Close_Cursor(l_priv_func_cursor_id);
4036: END IF;
4037: IF (l_ivs_num_cursor_id IS NOT NULL) THEN
4038: DBMS_SQL.Close_Cursor(l_ivs_num_cursor_id);
4039: END IF;
4040: IF (l_ivs_date_cursor_id IS NOT NULL) THEN
4041: DBMS_SQL.Close_Cursor(l_ivs_date_cursor_id);
4042: END IF;

Line 4041: DBMS_SQL.Close_Cursor(l_ivs_date_cursor_id);

4037: IF (l_ivs_num_cursor_id IS NOT NULL) THEN
4038: DBMS_SQL.Close_Cursor(l_ivs_num_cursor_id);
4039: END IF;
4040: IF (l_ivs_date_cursor_id IS NOT NULL) THEN
4041: DBMS_SQL.Close_Cursor(l_ivs_date_cursor_id);
4042: END IF;
4043: IF (l_ivs_date_time_cursor_id IS NOT NULL) THEN
4044: DBMS_SQL.Close_Cursor(l_ivs_date_time_cursor_id);
4045: END IF;

Line 4044: DBMS_SQL.Close_Cursor(l_ivs_date_time_cursor_id);

4040: IF (l_ivs_date_cursor_id IS NOT NULL) THEN
4041: DBMS_SQL.Close_Cursor(l_ivs_date_cursor_id);
4042: END IF;
4043: IF (l_ivs_date_time_cursor_id IS NOT NULL) THEN
4044: DBMS_SQL.Close_Cursor(l_ivs_date_time_cursor_id);
4045: END IF;
4046: IF (l_ivs_char_cursor_id IS NOT NULL) THEN
4047: DBMS_SQL.Close_Cursor(l_ivs_char_cursor_id);
4048: END IF;

Line 4047: DBMS_SQL.Close_Cursor(l_ivs_char_cursor_id);

4043: IF (l_ivs_date_time_cursor_id IS NOT NULL) THEN
4044: DBMS_SQL.Close_Cursor(l_ivs_date_time_cursor_id);
4045: END IF;
4046: IF (l_ivs_char_cursor_id IS NOT NULL) THEN
4047: DBMS_SQL.Close_Cursor(l_ivs_char_cursor_id);
4048: END IF;
4049: IF (l_nvs_num_cursor_id IS NOT NULL) THEN
4050: DBMS_SQL.Close_Cursor(l_nvs_num_cursor_id);
4051: END IF;

Line 4050: DBMS_SQL.Close_Cursor(l_nvs_num_cursor_id);

4046: IF (l_ivs_char_cursor_id IS NOT NULL) THEN
4047: DBMS_SQL.Close_Cursor(l_ivs_char_cursor_id);
4048: END IF;
4049: IF (l_nvs_num_cursor_id IS NOT NULL) THEN
4050: DBMS_SQL.Close_Cursor(l_nvs_num_cursor_id);
4051: END IF;
4052: IF (l_nvs_date_cursor_id IS NOT NULL) THEN
4053: DBMS_SQL.Close_Cursor(l_nvs_date_cursor_id);
4054: END IF;

Line 4053: DBMS_SQL.Close_Cursor(l_nvs_date_cursor_id);

4049: IF (l_nvs_num_cursor_id IS NOT NULL) THEN
4050: DBMS_SQL.Close_Cursor(l_nvs_num_cursor_id);
4051: END IF;
4052: IF (l_nvs_date_cursor_id IS NOT NULL) THEN
4053: DBMS_SQL.Close_Cursor(l_nvs_date_cursor_id);
4054: END IF;
4055: IF (l_nvs_datetime_cursor_id IS NOT NULL) THEN
4056: DBMS_SQL.Close_Cursor(l_nvs_datetime_cursor_id);
4057: END IF;

Line 4056: DBMS_SQL.Close_Cursor(l_nvs_datetime_cursor_id);

4052: IF (l_nvs_date_cursor_id IS NOT NULL) THEN
4053: DBMS_SQL.Close_Cursor(l_nvs_date_cursor_id);
4054: END IF;
4055: IF (l_nvs_datetime_cursor_id IS NOT NULL) THEN
4056: DBMS_SQL.Close_Cursor(l_nvs_datetime_cursor_id);
4057: END IF;
4058: IF (l_nvs_char_cursor_id IS NOT NULL) THEN
4059: DBMS_SQL.Close_Cursor(l_nvs_char_cursor_id);
4060: END IF;

Line 4059: DBMS_SQL.Close_Cursor(l_nvs_char_cursor_id);

4055: IF (l_nvs_datetime_cursor_id IS NOT NULL) THEN
4056: DBMS_SQL.Close_Cursor(l_nvs_datetime_cursor_id);
4057: END IF;
4058: IF (l_nvs_char_cursor_id IS NOT NULL) THEN
4059: DBMS_SQL.Close_Cursor(l_nvs_char_cursor_id);
4060: END IF;
4061: IF (l_max_size_char_cursor IS NOT NULL) THEN
4062: DBMS_SQL.Close_Cursor(l_max_size_char_cursor);
4063: END IF;

Line 4062: DBMS_SQL.Close_Cursor(l_max_size_char_cursor);

4058: IF (l_nvs_char_cursor_id IS NOT NULL) THEN
4059: DBMS_SQL.Close_Cursor(l_nvs_char_cursor_id);
4060: END IF;
4061: IF (l_max_size_char_cursor IS NOT NULL) THEN
4062: DBMS_SQL.Close_Cursor(l_max_size_char_cursor);
4063: END IF;
4064: IF (l_max_size_num_cursor IS NOT NULL) THEN
4065: DBMS_SQL.Close_Cursor(l_max_size_num_cursor);
4066: END IF;

Line 4065: DBMS_SQL.Close_Cursor(l_max_size_num_cursor);

4061: IF (l_max_size_char_cursor IS NOT NULL) THEN
4062: DBMS_SQL.Close_Cursor(l_max_size_char_cursor);
4063: END IF;
4064: IF (l_max_size_num_cursor IS NOT NULL) THEN
4065: DBMS_SQL.Close_Cursor(l_max_size_num_cursor);
4066: END IF;
4067: IF (l_colcheck_num_cursor_id IS NOT NULL) THEN
4068: DBMS_SQL.Close_Cursor(l_colcheck_num_cursor_id);
4069: END IF;

Line 4068: DBMS_SQL.Close_Cursor(l_colcheck_num_cursor_id);

4064: IF (l_max_size_num_cursor IS NOT NULL) THEN
4065: DBMS_SQL.Close_Cursor(l_max_size_num_cursor);
4066: END IF;
4067: IF (l_colcheck_num_cursor_id IS NOT NULL) THEN
4068: DBMS_SQL.Close_Cursor(l_colcheck_num_cursor_id);
4069: END IF;
4070: IF (l_colcheck_char_cursor_id IS NOT NULL) THEN
4071: DBMS_SQL.Close_Cursor(l_colcheck_char_cursor_id);
4072: END IF;

Line 4071: DBMS_SQL.Close_Cursor(l_colcheck_char_cursor_id);

4067: IF (l_colcheck_num_cursor_id IS NOT NULL) THEN
4068: DBMS_SQL.Close_Cursor(l_colcheck_num_cursor_id);
4069: END IF;
4070: IF (l_colcheck_char_cursor_id IS NOT NULL) THEN
4071: DBMS_SQL.Close_Cursor(l_colcheck_char_cursor_id);
4072: END IF;
4073: IF (l_colcheck_date_cursor_id IS NOT NULL) THEN
4074: DBMS_SQL.Close_Cursor(l_colcheck_date_cursor_id);
4075: END IF;

Line 4074: DBMS_SQL.Close_Cursor(l_colcheck_date_cursor_id);

4070: IF (l_colcheck_char_cursor_id IS NOT NULL) THEN
4071: DBMS_SQL.Close_Cursor(l_colcheck_char_cursor_id);
4072: END IF;
4073: IF (l_colcheck_date_cursor_id IS NOT NULL) THEN
4074: DBMS_SQL.Close_Cursor(l_colcheck_date_cursor_id);
4075: END IF;
4076:
4077: IF (p_validate) THEN -- *p_validate-IF-1.75*
4078: -------------------------------------------------------------------------------------

Line 4611: l_bad_bindattrs_tvs_cursor_id := DBMS_SQL.Open_Cursor;

4607: code_debug(' TVS query constructed - Done');
4608:
4609: IF(l_tvs_metadata_fetched = FALSE) THEN
4610: IF (l_bad_bindattrs_tvs_cursor_id IS NULL) THEN
4611: l_bad_bindattrs_tvs_cursor_id := DBMS_SQL.Open_Cursor;
4612: l_dynamic_sql :=
4613: 'UPDATE '||p_interface_table_name||'
4614: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_ATTRS_IN_TVS_WHERE||'
4615: WHERE DATA_SET_ID = :data_set_id

Line 4619: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4615: WHERE DATA_SET_ID = :data_set_id
4616: AND ATTR_INT_NAME = :attr_internal_name
4617: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4618:
4619: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4620: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
4621: END IF;
4622:
4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

Line 4620: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);

4616: AND ATTR_INT_NAME = :attr_internal_name
4617: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4618:
4619: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4620: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
4621: END IF;
4622:
4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4624: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4619: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4620: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
4621: END IF;
4622:
4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4624: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4625:
4626: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
4627:

Line 4624: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4620: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
4621: END IF;
4622:
4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4624: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4625:
4626: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
4627:
4628: ELSE -- now we do the interface table update since we are sure we have the metadata for bound variables

Line 4626: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);

4622:
4623: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4624: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4625:
4626: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
4627:
4628: ELSE -- now we do the interface table update since we are sure we have the metadata for bound variables
4629: /*
4630: Note: we are assuming that the setup is correct i.e. the column of the TVS are of correct data type

Line 4672: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

4668:
4669: EXCEPTION
4670: WHEN OTHERS THEN
4671: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
4672: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
4673: l_dynamic_sql :=
4674: 'UPDATE '||p_interface_table_name||'
4675: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
4676: WHERE DATA_SET_ID = :data_set_id

Line 4680: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4676: WHERE DATA_SET_ID = :data_set_id
4677: AND ATTR_INT_NAME = :attr_internal_name
4678: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4679:
4680: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4682: END IF;
4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

4677: AND ATTR_INT_NAME = :attr_internal_name
4678: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4679:
4680: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4682: END IF;
4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4685: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4679:
4680: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4682: END IF;
4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4685: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4686: END;
4687: */

Line 4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4680: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4682: END IF;
4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4685: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4686: END;
4687: */
4688:

Line 4685: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

4681: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4682: END IF;
4683: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4684: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4685: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4686: END;
4687: */
4688:
4689: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,

Line 4707: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;

4703:
4704: code_debug(' After Prepare_Dynamic_Sqls_Clob - l_return_status :'||l_return_status ,3);
4705:
4706: IF (l_dynamic_sql_1_cursor_id IS NULL) THEN
4707: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4708: END IF;
4709:
4710: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4711: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

Line 4711: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

4707: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4708: END IF;
4709:
4710: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4711: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;
4712: END IF;
4713:
4714: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
4715:

Line 4717: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,

4713:
4714: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
4715:
4716: BEGIN
4717: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,
4718: statement => l_dynamic_sql_1_v_type,
4719: lb => 1,
4720: ub => l_sql_1_ub,
4721: lfflg => false,

Line 4722: language_flag => dbms_sql.native );

4718: statement => l_dynamic_sql_1_v_type,
4719: lb => 1,
4720: ub => l_sql_1_ub,
4721: lfflg => false,
4722: language_flag => dbms_sql.native );
4723:
4724:
4725: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4726: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);

Line 4725: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);

4721: lfflg => false,
4722: language_flag => dbms_sql.native );
4723:
4724:
4725: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4726: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
4727:
4728: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4729:

Line 4728: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);

4724:
4725: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4726: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
4727:
4728: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4729:
4730: code_debug(' Before parse l_dynamic_sql_cursor_id - l_sql_ub :'||l_sql_ub ,3);
4731:
4732: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

Line 4732: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

4728: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4729:
4730: code_debug(' Before parse l_dynamic_sql_cursor_id - l_sql_ub :'||l_sql_ub ,3);
4731:
4732: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,
4733: statement => l_dynamic_sql_v_type,
4734: lb => 1,
4735: ub => l_sql_ub,
4736: lfflg => false,

Line 4737: language_flag => dbms_sql.native );

4733: statement => l_dynamic_sql_v_type,
4734: lb => 1,
4735: ub => l_sql_ub,
4736: lfflg => false,
4737: language_flag => dbms_sql.native );
4738:
4739: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4740: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4741:

Line 4739: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);

4735: ub => l_sql_ub,
4736: lfflg => false,
4737: language_flag => dbms_sql.native );
4738:
4739: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4740: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4741:
4742: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
4743: code_debug(' EXECUTING DONE' ,3);

Line 4742: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);

4738:
4739: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4740: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4741:
4742: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
4743: code_debug(' EXECUTING DONE' ,3);
4744:
4745: EXCEPTION
4746: WHEN OTHERS THEN

Line 4748: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);

4744:
4745: EXCEPTION
4746: WHEN OTHERS THEN
4747: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN
4748: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
4749: END IF;
4750:
4751: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
4752: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

Line 4752: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

4748: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
4749: END IF;
4750:
4751: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
4752: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);
4753: END IF;
4754: code_debug(' ERROR :'||SQLERRM ,3);
4755:
4756: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 4757: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

4753: END IF;
4754: code_debug(' ERROR :'||SQLERRM ,3);
4755:
4756: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
4757: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
4758: l_dynamic_sql :=
4759: 'UPDATE '||p_interface_table_name||'
4760: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
4761: WHERE DATA_SET_ID = :data_set_id

Line 4765: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4761: WHERE DATA_SET_ID = :data_set_id
4762: AND ATTR_INT_NAME = :attr_internal_name
4763: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4764:
4765: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4767: END IF;
4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

4762: AND ATTR_INT_NAME = :attr_internal_name
4763: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4764:
4765: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4767: END IF;
4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4764:
4765: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4767: END IF;
4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4771: END;
4772: -- Bug 10151142 : End

Line 4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4765: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4767: END IF;
4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4771: END;
4772: -- Bug 10151142 : End
4773:

Line 4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

4766: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4767: END IF;
4768: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4769: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4771: END;
4772: -- Bug 10151142 : End
4773:
4774: ELSIF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 4809: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

4805: USING p_data_set_id;
4806: EXCEPTION
4807: WHEN OTHERS THEN
4808: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
4809: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
4810: l_dynamic_sql :=
4811: 'UPDATE '||p_interface_table_name||'
4812: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
4813: WHERE DATA_SET_ID = :data_set_id

Line 4817: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4813: WHERE DATA_SET_ID = :data_set_id
4814: AND ATTR_INT_NAME = :attr_internal_name
4815: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4816:
4817: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4819: END IF;
4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

4814: AND ATTR_INT_NAME = :attr_internal_name
4815: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4816:
4817: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4819: END IF;
4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4822: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4816:
4817: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4819: END IF;
4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4822: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4823: END;
4824: */

Line 4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4817: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4819: END IF;
4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4822: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4823: END;
4824: */
4825:

Line 4822: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

4818: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4819: END IF;
4820: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4821: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4822: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4823: END;
4824: */
4825:
4826: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,

Line 4844: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;

4840:
4841: code_debug(' After Prepare_Dynamic_Sqls_Clob - l_return_status :'||l_return_status ,3);
4842:
4843: IF (l_dynamic_sql_1_cursor_id IS NULL) THEN
4844: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4845: END IF;
4846:
4847: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4848: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

Line 4848: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

4844: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4845: END IF;
4846:
4847: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4848: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;
4849: END IF;
4850:
4851: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
4852:

Line 4854: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,

4850:
4851: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
4852:
4853: BEGIN
4854: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,
4855: statement => l_dynamic_sql_1_v_type,
4856: lb => 1,
4857: ub => l_sql_1_ub,
4858: lfflg => false,

Line 4859: language_flag => dbms_sql.native );

4855: statement => l_dynamic_sql_1_v_type,
4856: lb => 1,
4857: ub => l_sql_1_ub,
4858: lfflg => false,
4859: language_flag => dbms_sql.native );
4860:
4861:
4862: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4863: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);

Line 4862: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);

4858: lfflg => false,
4859: language_flag => dbms_sql.native );
4860:
4861:
4862: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4863: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
4864:
4865: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4866:

Line 4865: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);

4861:
4862: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
4863: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
4864:
4865: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4866:
4867: code_debug(' Before parse l_dynamic_sql_cursor_id - l_sql_ub :'||l_sql_ub ,3);
4868:
4869: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

Line 4869: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

4865: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
4866:
4867: code_debug(' Before parse l_dynamic_sql_cursor_id - l_sql_ub :'||l_sql_ub ,3);
4868:
4869: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,
4870: statement => l_dynamic_sql_v_type,
4871: lb => 1,
4872: ub => l_sql_ub,
4873: lfflg => false,

Line 4874: language_flag => dbms_sql.native );

4870: statement => l_dynamic_sql_v_type,
4871: lb => 1,
4872: ub => l_sql_ub,
4873: lfflg => false,
4874: language_flag => dbms_sql.native );
4875:
4876: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4877: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4878:

Line 4876: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);

4872: ub => l_sql_ub,
4873: lfflg => false,
4874: language_flag => dbms_sql.native );
4875:
4876: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4877: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4878:
4879: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
4880: code_debug(' EXECUTING DONE' ,3);

Line 4879: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);

4875:
4876: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
4877: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
4878:
4879: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
4880: code_debug(' EXECUTING DONE' ,3);
4881: EXCEPTION
4882: WHEN OTHERS THEN
4883: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN

Line 4884: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);

4880: code_debug(' EXECUTING DONE' ,3);
4881: EXCEPTION
4882: WHEN OTHERS THEN
4883: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN
4884: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
4885: END IF;
4886:
4887: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
4888: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

Line 4888: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

4884: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
4885: END IF;
4886:
4887: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
4888: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);
4889: END IF;
4890:
4891: code_debug(' ERROR :'||SQLERRM ,3);
4892: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 4893: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

4889: END IF;
4890:
4891: code_debug(' ERROR :'||SQLERRM ,3);
4892: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
4893: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
4894: l_dynamic_sql :=
4895: 'UPDATE '||p_interface_table_name||'
4896: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
4897: WHERE DATA_SET_ID = :data_set_id

Line 4901: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4897: WHERE DATA_SET_ID = :data_set_id
4898: AND ATTR_INT_NAME = :attr_internal_name
4899: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4900:
4901: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4903: END IF;
4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

4898: AND ATTR_INT_NAME = :attr_internal_name
4899: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4900:
4901: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4903: END IF;
4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4906: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4900:
4901: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4903: END IF;
4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4906: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4907: END;
4908: -- Bug 10151142 : End

Line 4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4901: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4903: END IF;
4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4906: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4907: END;
4908: -- Bug 10151142 : End
4909:

Line 4906: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

4902: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4903: END IF;
4904: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4905: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4906: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4907: END;
4908: -- Bug 10151142 : End
4909:
4910: ELSE

Line 4960: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

4956: USING p_data_set_id;
4957: EXCEPTION
4958: WHEN OTHERS THEN
4959: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
4960: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
4961: l_dynamic_sql :=
4962: 'UPDATE '||p_interface_table_name||'
4963: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
4964: WHERE DATA_SET_ID = :data_set_id

Line 4968: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

4964: WHERE DATA_SET_ID = :data_set_id
4965: AND ATTR_INT_NAME = :attr_internal_name
4966: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4967:
4968: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4970: END IF;
4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

4965: AND ATTR_INT_NAME = :attr_internal_name
4966: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
4967:
4968: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4970: END IF;
4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4973: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

4967:
4968: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4970: END IF;
4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4973: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4974: END;
4975: */

Line 4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

4968: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4970: END IF;
4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4973: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4974: END;
4975: */
4976:

Line 4973: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

4969: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
4970: END IF;
4971: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
4972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4973: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4974: END;
4975: */
4976:
4977: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,

Line 4995: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;

4991:
4992: code_debug(' After Prepare_Dynamic_Sqls_Clob - l_return_status :'||l_return_status ,3);
4993:
4994: IF (l_dynamic_sql_1_cursor_id IS NULL) THEN
4995: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4996: END IF;
4997:
4998: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4999: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

Line 4999: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;

4995: l_dynamic_sql_1_cursor_id := DBMS_SQL.Open_Cursor;
4996: END IF;
4997:
4998: IF (l_dynamic_sql_cursor_id IS NULL) THEN
4999: l_dynamic_sql_cursor_id := DBMS_SQL.Open_Cursor;
5000: END IF;
5001:
5002: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
5003:

Line 5005: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,

5001:
5002: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_1_ub :'||l_sql_1_ub ,3);
5003:
5004: BEGIN
5005: DBMS_SQL.PARSE( c => l_dynamic_sql_1_cursor_id,
5006: statement => l_dynamic_sql_1_v_type,
5007: lb => 1,
5008: ub => l_sql_1_ub,
5009: lfflg => false,

Line 5010: language_flag => dbms_sql.native );

5006: statement => l_dynamic_sql_1_v_type,
5007: lb => 1,
5008: ub => l_sql_1_ub,
5009: lfflg => false,
5010: language_flag => dbms_sql.native );
5011:
5012:
5013: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
5014: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);

Line 5013: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);

5009: lfflg => false,
5010: language_flag => dbms_sql.native );
5011:
5012:
5013: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
5014: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
5015:
5016: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
5017:

Line 5016: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);

5012:
5013: DBMS_SQL.Bind_Variable(l_dynamic_sql_1_cursor_id, ':data_set_id', p_data_set_id);
5014: code_debug(' EXECUTING l_dynamic_sql_1_cursor_id' ,3);
5015:
5016: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
5017:
5018: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_ub :'||l_sql_ub ,3);
5019:
5020: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

Line 5020: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,

5016: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_1_cursor_id);
5017:
5018: code_debug(' Before parse l_dynamic_sql_1_cursor_id - l_sql_ub :'||l_sql_ub ,3);
5019:
5020: DBMS_SQL.PARSE( c => l_dynamic_sql_cursor_id,
5021: statement => l_dynamic_sql_v_type,
5022: lb => 1,
5023: ub => l_sql_ub,
5024: lfflg => false,

Line 5025: language_flag => dbms_sql.native );

5021: statement => l_dynamic_sql_v_type,
5022: lb => 1,
5023: ub => l_sql_ub,
5024: lfflg => false,
5025: language_flag => dbms_sql.native );
5026:
5027: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
5028: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
5029:

Line 5027: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);

5023: ub => l_sql_ub,
5024: lfflg => false,
5025: language_flag => dbms_sql.native );
5026:
5027: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
5028: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
5029:
5030: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
5031: code_debug(' EXECUTING DONE' ,3);

Line 5030: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);

5026:
5027: DBMS_SQL.Bind_Variable(l_dynamic_sql_cursor_id, ':data_set_id', p_data_set_id);
5028: code_debug(' EXECUTING l_dynamic_sql_cursor_id' ,3);
5029:
5030: l_dummy := DBMS_SQL.Execute(l_dynamic_sql_cursor_id);
5031: code_debug(' EXECUTING DONE' ,3);
5032: EXCEPTION
5033: WHEN OTHERS THEN
5034: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN

Line 5035: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);

5031: code_debug(' EXECUTING DONE' ,3);
5032: EXCEPTION
5033: WHEN OTHERS THEN
5034: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN
5035: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
5036: END IF;
5037:
5038: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
5039: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

Line 5039: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

5035: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
5036: END IF;
5037:
5038: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
5039: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);
5040: END IF;
5041:
5042: code_debug(' ERROR :'||SQLERRM ,3);
5043: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 5044: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

5040: END IF;
5041:
5042: code_debug(' ERROR :'||SQLERRM ,3);
5043: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
5044: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
5045: l_dynamic_sql :=
5046: 'UPDATE '||p_interface_table_name||'
5047: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
5048: WHERE DATA_SET_ID = :data_set_id

Line 5052: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5048: WHERE DATA_SET_ID = :data_set_id
5049: AND ATTR_INT_NAME = :attr_internal_name
5050: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5051:
5052: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5054: END IF;
5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

Line 5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

5049: AND ATTR_INT_NAME = :attr_internal_name
5050: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5051:
5052: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5054: END IF;
5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
5057: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

5051:
5052: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5054: END IF;
5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
5057: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5058: END;
5059: -- Bug 10151142 : End

Line 5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);

5052: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5054: END IF;
5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
5057: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5058: END;
5059: -- Bug 10151142 : End
5060:

Line 5057: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

5053: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5054: END IF;
5055: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5056: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
5057: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5058: END;
5059: -- Bug 10151142 : End
5060:
5061: END IF;

Line 5289: l_default_num_cursor_id := DBMS_SQL.Open_Cursor;

5285: code_debug(' Attribute '||l_attr_metadata_table_1(z).ATTR_NAME|| ' has a default value or is a required attribute' ,2);
5286: --------- FOR NUMBER DATATYPE
5287: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5288: IF (l_default_num_cursor_id IS NULL) THEN
5289: l_default_num_cursor_id := DBMS_SQL.Open_Cursor;
5290: l_dynamic_sql :=
5291: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,
5292: PROCESS_STATUS ,
5293: DATA_SET_ID ,

Line 5320: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5316: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5317: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5318: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5319: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5320: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
5322: END IF;
5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);

5317: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5318: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5319: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5320: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
5322: END IF;
5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5320: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
5322: END IF;
5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5326: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5327: l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5328: -- We need to add the attr in the distinct attrs table, since now we have to process this one also

Line 5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
5322: END IF;
5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5326: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5327: l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5328: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5329: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN

Line 5326: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);

5322: END IF;
5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5326: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5327: l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5328: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5329: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN
5330: l_dist_attr_in_data_set_rec.ATTR_GROUP_ID := l_attr_metadata_table_1(z).ATTR_GROUP_ID;

Line 5327: l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);

5323:
5324: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5325: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5326: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5327: l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5328: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5329: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN
5330: l_dist_attr_in_data_set_rec.ATTR_GROUP_ID := l_attr_metadata_table_1(z).ATTR_GROUP_ID;
5331: l_dist_attr_in_data_set_rec.ATTR_INT_NAME := l_attr_metadata_table_1(z).ATTR_NAME;

Line 5341: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;

5337: --------- FOR DATE DATATYPE
5338: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5339: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5340: IF (l_default_date_cursor_id IS NULL) THEN
5341: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;
5342: l_dynamic_sql :=
5343: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,
5344: PROCESS_STATUS ,
5345: DATA_SET_ID ,

Line 5372: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5368: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5369: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5370: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5371: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5372: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
5374: END IF;
5375:
5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);

5369: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5370: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5371: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5372: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
5374: END IF;
5375:
5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5372: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
5374: END IF;
5375:
5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));
5379: -- bug 3902395
5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);

Line 5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
5374: END IF;
5375:
5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));
5379: -- bug 3902395
5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5381: l_dummy := DBMS_SQL.Execute(l_default_date_cursor_id);

Line 5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));

5374: END IF;
5375:
5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));
5379: -- bug 3902395
5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5381: l_dummy := DBMS_SQL.Execute(l_default_date_cursor_id);
5382: -- We need to add the attr in the distinct attrs table, since now we have to process this one also

Line 5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);

5376: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));
5379: -- bug 3902395
5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5381: l_dummy := DBMS_SQL.Execute(l_default_date_cursor_id);
5382: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5383: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN
5384: l_dist_attr_in_data_set_rec.ATTR_GROUP_ID := l_attr_metadata_table_1(z).ATTR_GROUP_ID;

Line 5381: l_dummy := DBMS_SQL.Execute(l_default_date_cursor_id);

5377: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5378: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':default_value', Get_Date(l_attr_metadata_table_1(z).DEFAULT_VALUE));
5379: -- bug 3902395
5380: -- l_dummy := DBMS_SQL.Execute(l_default_num_cursor_id);
5381: l_dummy := DBMS_SQL.Execute(l_default_date_cursor_id);
5382: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5383: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN
5384: l_dist_attr_in_data_set_rec.ATTR_GROUP_ID := l_attr_metadata_table_1(z).ATTR_GROUP_ID;
5385: l_dist_attr_in_data_set_rec.ATTR_INT_NAME := l_attr_metadata_table_1(z).ATTR_NAME;

Line 5394: l_default_char_cursor_id := DBMS_SQL.Open_Cursor;

5390:
5391: --------- FOR CHAR/TRANS DATATYPE
5392: ELSE
5393: IF (l_default_char_cursor_id IS NULL) THEN
5394: l_default_char_cursor_id := DBMS_SQL.Open_Cursor;
5395: l_dynamic_sql :=
5396: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,
5397: PROCESS_STATUS ,
5398: DATA_SET_ID ,

Line 5425: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5421: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5422: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5423: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5424: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5425: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
5427: END IF;
5428:
5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);

5422: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5423: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5424: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5425: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
5427: END IF;
5428:
5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5425: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
5427: END IF;
5428:
5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5431: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5432:
5433: l_dummy := DBMS_SQL.Execute(l_default_char_cursor_id);

Line 5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
5427: END IF;
5428:
5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5431: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5432:
5433: l_dummy := DBMS_SQL.Execute(l_default_char_cursor_id);
5434: -- We need to add the attr in the distinct attrs table, since now we have to process this one also

Line 5431: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);

5427: END IF;
5428:
5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5431: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5432:
5433: l_dummy := DBMS_SQL.Execute(l_default_char_cursor_id);
5434: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5435: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN

Line 5433: l_dummy := DBMS_SQL.Execute(l_default_char_cursor_id);

5429: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5430: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5431: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':default_value', l_attr_metadata_table_1(z).DEFAULT_VALUE);
5432:
5433: l_dummy := DBMS_SQL.Execute(l_default_char_cursor_id);
5434: -- We need to add the attr in the distinct attrs table, since now we have to process this one also
5435: IF (l_attr_metadata_table_1(z).DEFAULT_VALUE IS NOT NULL AND l_dummy > 0 ) THEN
5436: l_dist_attr_in_data_set_rec.ATTR_GROUP_ID := l_attr_metadata_table_1(z).ATTR_GROUP_ID;
5437: l_dist_attr_in_data_set_rec.ATTR_INT_NAME := l_attr_metadata_table_1(z).ATTR_NAME;

Line 5461: l_req_num_cursor_id := DBMS_SQL.Open_Cursor;

5457:
5458: --------- FOR NUMBER DATATYPE
5459: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5460: IF (l_req_num_cursor_id IS NULL) THEN
5461: l_req_num_cursor_id := DBMS_SQL.Open_Cursor;
5462: l_dynamic_sql :=
5463: 'UPDATE '||p_interface_table_name||'
5464: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_REQUIRED_ATTRIBUTE||'
5465: WHERE DATA_SET_ID = :data_set_id

Line 5472: DBMS_SQL.Parse(l_req_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5468: AND ATTR_INT_NAME = :attr_internal_name
5469: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5470: AND ATTR_VALUE_NUM IS NULL
5471: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5472: DBMS_SQL.Parse(l_req_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5473: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':data_set_id', p_data_set_id);
5474: END IF;
5475:
5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5473: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':data_set_id', p_data_set_id);

5469: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5470: AND ATTR_VALUE_NUM IS NULL
5471: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5472: DBMS_SQL.Parse(l_req_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5473: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':data_set_id', p_data_set_id);
5474: END IF;
5475:
5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5477: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5472: DBMS_SQL.Parse(l_req_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5473: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':data_set_id', p_data_set_id);
5474: END IF;
5475:
5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5477: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5478:
5479: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);
5480:

Line 5477: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5473: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':data_set_id', p_data_set_id);
5474: END IF;
5475:
5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5477: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5478:
5479: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);
5480:
5481: --------- FOR DATE AND DATE TIME DATATYPE

Line 5479: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);

5475:
5476: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5477: DBMS_SQL.Bind_Variable(l_req_num_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5478:
5479: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);
5480:
5481: --------- FOR DATE AND DATE TIME DATATYPE
5482: ELSIF (l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5483: IF (l_req_date_cursor_id IS NULL) THEN

Line 5484: l_req_date_cursor_id := DBMS_SQL.Open_Cursor;

5480:
5481: --------- FOR DATE AND DATE TIME DATATYPE
5482: ELSIF (l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5483: IF (l_req_date_cursor_id IS NULL) THEN
5484: l_req_date_cursor_id := DBMS_SQL.Open_Cursor;
5485: l_dynamic_sql :=
5486: 'UPDATE '||p_interface_table_name||'
5487: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_REQUIRED_ATTRIBUTE||'
5488: WHERE DATA_SET_ID = :data_set_id

Line 5495: DBMS_SQL.Parse(l_req_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5491: AND ATTR_INT_NAME = :attr_internal_name
5492: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5493: AND ATTR_VALUE_DATE IS NULL
5494: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5495: DBMS_SQL.Parse(l_req_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5496: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':data_set_id', p_data_set_id);
5497: END IF;
5498:
5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5496: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':data_set_id', p_data_set_id);

5492: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5493: AND ATTR_VALUE_DATE IS NULL
5494: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5495: DBMS_SQL.Parse(l_req_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5496: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':data_set_id', p_data_set_id);
5497: END IF;
5498:
5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5500: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5495: DBMS_SQL.Parse(l_req_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5496: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':data_set_id', p_data_set_id);
5497: END IF;
5498:
5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5500: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5501:
5502: l_dummy := DBMS_SQL.Execute(l_req_date_cursor_id);
5503: --------- FOR CHAR AND TRANSLATEBLE TEXT DATATYPE

Line 5500: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5496: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':data_set_id', p_data_set_id);
5497: END IF;
5498:
5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5500: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5501:
5502: l_dummy := DBMS_SQL.Execute(l_req_date_cursor_id);
5503: --------- FOR CHAR AND TRANSLATEBLE TEXT DATATYPE
5504: ELSE

Line 5502: l_dummy := DBMS_SQL.Execute(l_req_date_cursor_id);

5498:
5499: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5500: DBMS_SQL.Bind_Variable(l_req_date_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5501:
5502: l_dummy := DBMS_SQL.Execute(l_req_date_cursor_id);
5503: --------- FOR CHAR AND TRANSLATEBLE TEXT DATATYPE
5504: ELSE
5505: IF (l_req_char_cursor_id IS NULL) THEN
5506: l_req_char_cursor_id := DBMS_SQL.Open_Cursor;

Line 5506: l_req_char_cursor_id := DBMS_SQL.Open_Cursor;

5502: l_dummy := DBMS_SQL.Execute(l_req_date_cursor_id);
5503: --------- FOR CHAR AND TRANSLATEBLE TEXT DATATYPE
5504: ELSE
5505: IF (l_req_char_cursor_id IS NULL) THEN
5506: l_req_char_cursor_id := DBMS_SQL.Open_Cursor;
5507: l_dynamic_sql :=
5508: 'UPDATE '||p_interface_table_name||'
5509: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_REQUIRED_ATTRIBUTE||'
5510: WHERE DATA_SET_ID = :data_set_id

Line 5517: DBMS_SQL.Parse(l_req_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5513: AND ATTR_INT_NAME = :attr_internal_name
5514: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5515: AND ATTR_VALUE_STR IS NULL
5516: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5517: DBMS_SQL.Parse(l_req_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5518: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':data_set_id', p_data_set_id);
5519: END IF;
5520:
5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

Line 5518: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':data_set_id', p_data_set_id);

5514: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5515: AND ATTR_VALUE_STR IS NULL
5516: AND ATTR_DISP_VALUE IS NULL ' ;--BugFix : 4171705
5517: DBMS_SQL.Parse(l_req_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5518: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':data_set_id', p_data_set_id);
5519: END IF;
5520:
5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5522: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

Line 5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);

5517: DBMS_SQL.Parse(l_req_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5518: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':data_set_id', p_data_set_id);
5519: END IF;
5520:
5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5522: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5523:
5524: l_dummy := DBMS_SQL.Execute(l_req_char_cursor_id);
5525: END IF;

Line 5522: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);

5518: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':data_set_id', p_data_set_id);
5519: END IF;
5520:
5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5522: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5523:
5524: l_dummy := DBMS_SQL.Execute(l_req_char_cursor_id);
5525: END IF;
5526: END IF;--Required flag

Line 5524: l_dummy := DBMS_SQL.Execute(l_req_char_cursor_id);

5520:
5521: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_group_int_name', l_attr_metadata_table_1(z).ATTR_GROUP_NAME);
5522: DBMS_SQL.Bind_Variable(l_req_char_cursor_id, ':attr_internal_name', l_attr_metadata_table_1(z).ATTR_NAME);
5523:
5524: l_dummy := DBMS_SQL.Execute(l_req_char_cursor_id);
5525: END IF;
5526: END IF;--Required flag
5527: END IF;
5528: END LOOP;

Line 5769: l_bad_bindattrs_tvs_cursor_id := DBMS_SQL.Open_Cursor;

5765: code_debug(' The TVS select constructed is :'||l_tvs_select ,3);
5766:
5767: IF (l_tvs_metadata_fetched = FALSE) THEN
5768: IF (l_bad_bindattrs_tvs_cursor_id IS NULL) THEN
5769: l_bad_bindattrs_tvs_cursor_id := DBMS_SQL.Open_Cursor;
5770: l_dynamic_sql :=
5771: 'UPDATE '||p_interface_table_name||'
5772: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_ATTRS_IN_TVS_WHERE||'
5773: WHERE DATA_SET_ID = :data_set_id

Line 5777: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5773: WHERE DATA_SET_ID = :data_set_id
5774: AND ATTR_INT_NAME = :attr_internal_name
5775: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5776:
5777: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5778: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
5779: END IF;
5780:
5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

Line 5778: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);

5774: AND ATTR_INT_NAME = :attr_internal_name
5775: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5776:
5777: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5778: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
5779: END IF;
5780:
5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5782: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

Line 5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

5777: DBMS_SQL.Parse(l_bad_bindattrs_tvs_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5778: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
5779: END IF;
5780:
5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5782: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5783: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
5784: ELSE -- now we do the interface table update since we are sure we have the metadata for bound variables
5785:

Line 5782: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

5778: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':data_set_id', p_data_set_id);
5779: END IF;
5780:
5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5782: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5783: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
5784: ELSE -- now we do the interface table update since we are sure we have the metadata for bound variables
5785:
5786: /*

Line 5783: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);

5779: END IF;
5780:
5781: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5782: DBMS_SQL.Bind_Variable(l_bad_bindattrs_tvs_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5783: l_dummy := DBMS_SQL.Execute(l_bad_bindattrs_tvs_cursor_id);
5784: ELSE -- now we do the interface table update since we are sure we have the metadata for bound variables
5785:
5786: /*
5787: Note: we are assuming that the setup is correct i.e. the column of the TVS are of correct data type

Line 5822: l_sr_tvs_num_cursor_id1 := DBMS_SQL.Open_Cursor;

5818:
5819: BEGIN
5820: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5821: IF (l_sr_tvs_num_cursor_id1 IS NULL) THEN
5822: l_sr_tvs_num_cursor_id1 := DBMS_SQL.Open_Cursor;
5823: END IF;
5824: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5825: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id1, ':data_set_id', p_data_set_id);
5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);

Line 5824: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);

5820: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5821: IF (l_sr_tvs_num_cursor_id1 IS NULL) THEN
5822: l_sr_tvs_num_cursor_id1 := DBMS_SQL.Open_Cursor;
5823: END IF;
5824: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5825: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id1, ':data_set_id', p_data_set_id);
5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);
5827:
5828: --EXECUTE IMMEDIATE l_dynamic_sql;

Line 5825: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id1, ':data_set_id', p_data_set_id);

5821: IF (l_sr_tvs_num_cursor_id1 IS NULL) THEN
5822: l_sr_tvs_num_cursor_id1 := DBMS_SQL.Open_Cursor;
5823: END IF;
5824: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5825: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id1, ':data_set_id', p_data_set_id);
5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);
5827:
5828: --EXECUTE IMMEDIATE l_dynamic_sql;
5829: IF (l_sr_tvs_num_cursor_id2 IS NULL) THEN

Line 5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);

5822: l_sr_tvs_num_cursor_id1 := DBMS_SQL.Open_Cursor;
5823: END IF;
5824: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5825: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id1, ':data_set_id', p_data_set_id);
5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);
5827:
5828: --EXECUTE IMMEDIATE l_dynamic_sql;
5829: IF (l_sr_tvs_num_cursor_id2 IS NULL) THEN
5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;

Line 5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;

5826: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id1);
5827:
5828: --EXECUTE IMMEDIATE l_dynamic_sql;
5829: IF (l_sr_tvs_num_cursor_id2 IS NULL) THEN
5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;
5831: END IF;
5832: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5833: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id2, ':data_set_id', p_data_set_id);
5834: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id2);

Line 5832: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);

5828: --EXECUTE IMMEDIATE l_dynamic_sql;
5829: IF (l_sr_tvs_num_cursor_id2 IS NULL) THEN
5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;
5831: END IF;
5832: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5833: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id2, ':data_set_id', p_data_set_id);
5834: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id2);
5835:
5836: EXCEPTION

Line 5833: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id2, ':data_set_id', p_data_set_id);

5829: IF (l_sr_tvs_num_cursor_id2 IS NULL) THEN
5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;
5831: END IF;
5832: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5833: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id2, ':data_set_id', p_data_set_id);
5834: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id2);
5835:
5836: EXCEPTION
5837: WHEN OTHERS THEN

Line 5834: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id2);

5830: l_sr_tvs_num_cursor_id2 := DBMS_SQL.Open_Cursor;
5831: END IF;
5832: DBMS_SQL.Parse(l_sr_tvs_num_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5833: DBMS_SQL.Bind_Variable(l_sr_tvs_num_cursor_id2, ':data_set_id', p_data_set_id);
5834: l_dummy := DBMS_SQL.Execute(l_sr_tvs_num_cursor_id2);
5835:
5836: EXCEPTION
5837: WHEN OTHERS THEN
5838: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 5839: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

5835:
5836: EXCEPTION
5837: WHEN OTHERS THEN
5838: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
5839: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
5840: l_dynamic_sql :=
5841: 'UPDATE '||p_interface_table_name||'
5842: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
5843: WHERE DATA_SET_ID = :data_set_id

Line 5847: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5843: WHERE DATA_SET_ID = :data_set_id
5844: AND ATTR_INT_NAME = :attr_internal_name
5845: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5846:
5847: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5849: END IF;
5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

Line 5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

5844: AND ATTR_INT_NAME = :attr_internal_name
5845: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5846:
5847: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5849: END IF;
5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

5846:
5847: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5849: END IF;
5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5853: END;
5854:

Line 5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

5847: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5849: END IF;
5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5853: END;
5854:
5855: ELSIF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

5848: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5849: END IF;
5850: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5853: END;
5854:
5855: ELSIF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5856:

Line 5885: l_sr_tvs_date_cursor_id1 := DBMS_SQL.Open_Cursor;

5881: BEGIN
5882:
5883: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5884: IF (l_sr_tvs_date_cursor_id1 IS NULL) THEN
5885: l_sr_tvs_date_cursor_id1 := DBMS_SQL.Open_Cursor;
5886: END IF;
5887: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5888: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id1, ':data_set_id', p_data_set_id);
5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);

Line 5887: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);

5883: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5884: IF (l_sr_tvs_date_cursor_id1 IS NULL) THEN
5885: l_sr_tvs_date_cursor_id1 := DBMS_SQL.Open_Cursor;
5886: END IF;
5887: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5888: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id1, ':data_set_id', p_data_set_id);
5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);
5890:
5891: --EXECUTE IMMEDIATE l_dynamic_sql;

Line 5888: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id1, ':data_set_id', p_data_set_id);

5884: IF (l_sr_tvs_date_cursor_id1 IS NULL) THEN
5885: l_sr_tvs_date_cursor_id1 := DBMS_SQL.Open_Cursor;
5886: END IF;
5887: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5888: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id1, ':data_set_id', p_data_set_id);
5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);
5890:
5891: --EXECUTE IMMEDIATE l_dynamic_sql;
5892: IF (l_sr_tvs_date_cursor_id2 IS NULL) THEN

Line 5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);

5885: l_sr_tvs_date_cursor_id1 := DBMS_SQL.Open_Cursor;
5886: END IF;
5887: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5888: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id1, ':data_set_id', p_data_set_id);
5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);
5890:
5891: --EXECUTE IMMEDIATE l_dynamic_sql;
5892: IF (l_sr_tvs_date_cursor_id2 IS NULL) THEN
5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;

Line 5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;

5889: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id1);
5890:
5891: --EXECUTE IMMEDIATE l_dynamic_sql;
5892: IF (l_sr_tvs_date_cursor_id2 IS NULL) THEN
5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;
5894: END IF;
5895: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5896: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id2, ':data_set_id', p_data_set_id);
5897: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id2);

Line 5895: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);

5891: --EXECUTE IMMEDIATE l_dynamic_sql;
5892: IF (l_sr_tvs_date_cursor_id2 IS NULL) THEN
5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;
5894: END IF;
5895: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5896: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id2, ':data_set_id', p_data_set_id);
5897: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id2);
5898:
5899: EXCEPTION

Line 5896: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id2, ':data_set_id', p_data_set_id);

5892: IF (l_sr_tvs_date_cursor_id2 IS NULL) THEN
5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;
5894: END IF;
5895: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5896: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id2, ':data_set_id', p_data_set_id);
5897: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id2);
5898:
5899: EXCEPTION
5900: WHEN OTHERS THEN

Line 5897: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id2);

5893: l_sr_tvs_date_cursor_id2 := DBMS_SQL.Open_Cursor;
5894: END IF;
5895: DBMS_SQL.Parse(l_sr_tvs_date_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5896: DBMS_SQL.Bind_Variable(l_sr_tvs_date_cursor_id2, ':data_set_id', p_data_set_id);
5897: l_dummy := DBMS_SQL.Execute(l_sr_tvs_date_cursor_id2);
5898:
5899: EXCEPTION
5900: WHEN OTHERS THEN
5901: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 5902: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

5898:
5899: EXCEPTION
5900: WHEN OTHERS THEN
5901: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
5902: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
5903: l_dynamic_sql :=
5904: 'UPDATE '||p_interface_table_name||'
5905: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
5906: WHERE DATA_SET_ID = :data_set_id

Line 5910: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5906: WHERE DATA_SET_ID = :data_set_id
5907: AND ATTR_INT_NAME = :attr_internal_name
5908: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5909:
5910: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5912: END IF;
5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

Line 5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

5907: AND ATTR_INT_NAME = :attr_internal_name
5908: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5909:
5910: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5912: END IF;
5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5915: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

5909:
5910: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5912: END IF;
5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5915: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5916: END;
5917: ELSE

Line 5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

5910: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5912: END IF;
5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5915: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5916: END;
5917: ELSE
5918: l_dynamic_sql_1 :=

Line 5915: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

5911: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5912: END IF;
5913: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5914: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5915: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5916: END;
5917: ELSE
5918: l_dynamic_sql_1 :=
5919: 'UPDATE '||p_interface_table_name||' UAI1

Line 5944: l_sr_tvs_str_cursor_id1 := DBMS_SQL.Open_Cursor;

5940: -- need to mark the row as errored due to bad TVS setup.
5941: BEGIN
5942: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5943: IF (l_sr_tvs_str_cursor_id1 IS NULL) THEN
5944: l_sr_tvs_str_cursor_id1 := DBMS_SQL.Open_Cursor;
5945: END IF;
5946: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5947: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id1, ':data_set_id', p_data_set_id);
5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);

Line 5946: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);

5942: --EXECUTE IMMEDIATE l_dynamic_sql_1;
5943: IF (l_sr_tvs_str_cursor_id1 IS NULL) THEN
5944: l_sr_tvs_str_cursor_id1 := DBMS_SQL.Open_Cursor;
5945: END IF;
5946: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5947: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id1, ':data_set_id', p_data_set_id);
5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);
5949:
5950: --EXECUTE IMMEDIATE l_dynamic_sql;

Line 5947: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id1, ':data_set_id', p_data_set_id);

5943: IF (l_sr_tvs_str_cursor_id1 IS NULL) THEN
5944: l_sr_tvs_str_cursor_id1 := DBMS_SQL.Open_Cursor;
5945: END IF;
5946: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5947: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id1, ':data_set_id', p_data_set_id);
5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);
5949:
5950: --EXECUTE IMMEDIATE l_dynamic_sql;
5951: IF (l_sr_tvs_str_cursor_id2 IS NULL) THEN

Line 5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);

5944: l_sr_tvs_str_cursor_id1 := DBMS_SQL.Open_Cursor;
5945: END IF;
5946: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id1, l_dynamic_sql_1, DBMS_SQL.NATIVE);
5947: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id1, ':data_set_id', p_data_set_id);
5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);
5949:
5950: --EXECUTE IMMEDIATE l_dynamic_sql;
5951: IF (l_sr_tvs_str_cursor_id2 IS NULL) THEN
5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;

Line 5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;

5948: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id1);
5949:
5950: --EXECUTE IMMEDIATE l_dynamic_sql;
5951: IF (l_sr_tvs_str_cursor_id2 IS NULL) THEN
5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;
5953: END IF;
5954: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5955: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id2, ':data_set_id', p_data_set_id);
5956: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id2);

Line 5954: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);

5950: --EXECUTE IMMEDIATE l_dynamic_sql;
5951: IF (l_sr_tvs_str_cursor_id2 IS NULL) THEN
5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;
5953: END IF;
5954: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5955: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id2, ':data_set_id', p_data_set_id);
5956: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id2);
5957:
5958: EXCEPTION

Line 5955: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id2, ':data_set_id', p_data_set_id);

5951: IF (l_sr_tvs_str_cursor_id2 IS NULL) THEN
5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;
5953: END IF;
5954: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5955: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id2, ':data_set_id', p_data_set_id);
5956: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id2);
5957:
5958: EXCEPTION
5959: WHEN OTHERS THEN

Line 5956: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id2);

5952: l_sr_tvs_str_cursor_id2 := DBMS_SQL.Open_Cursor;
5953: END IF;
5954: DBMS_SQL.Parse(l_sr_tvs_str_cursor_id2, l_dynamic_sql, DBMS_SQL.NATIVE);
5955: DBMS_SQL.Bind_Variable(l_sr_tvs_str_cursor_id2, ':data_set_id', p_data_set_id);
5956: l_dummy := DBMS_SQL.Execute(l_sr_tvs_str_cursor_id2);
5957:
5958: EXCEPTION
5959: WHEN OTHERS THEN
5960: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN

Line 5961: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;

5957:
5958: EXCEPTION
5959: WHEN OTHERS THEN
5960: IF (l_bad_tvs_sql_cursor_id IS NULL) THEN
5961: l_bad_tvs_sql_cursor_id := DBMS_SQL.Open_Cursor;
5962: l_dynamic_sql :=
5963: 'UPDATE '||p_interface_table_name||'
5964: SET PROCESS_STATUS = PROCESS_STATUS + '||G_PS_BAD_TVS_SETUP||'
5965: WHERE DATA_SET_ID = :data_set_id

Line 5969: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

5965: WHERE DATA_SET_ID = :data_set_id
5966: AND ATTR_INT_NAME = :attr_internal_name
5967: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5968:
5969: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5971: END IF;
5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

Line 5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);

5966: AND ATTR_INT_NAME = :attr_internal_name
5967: AND ATTR_GROUP_INT_NAME = :attr_group_int_name';
5968:
5969: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5971: END IF;
5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5974: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

Line 5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

5968:
5969: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5971: END IF;
5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5974: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5975: END;
5976: END IF;

Line 5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);

5969: DBMS_SQL.Parse(l_bad_tvs_sql_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5971: END IF;
5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5974: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5975: END;
5976: END IF;
5977: END IF; --l_attr_metadata TRUE/FALSE

Line 5974: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);

5970: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':data_set_id', p_data_set_id);
5971: END IF;
5972: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_group_int_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
5973: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5974: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5975: END;
5976: END IF;
5977: END IF; --l_attr_metadata TRUE/FALSE
5978: END IF; -- if validation_code is TVS

Line 6833: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;

6829: );
6830: EXCEPTION
6831: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
6832: IF (l_pre_event_failed_cursor_id IS NULL) THEN
6833: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;
6834: END IF;
6835:
6836:
6837: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);

Line 6837: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);

6833: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;
6834: END IF;
6835:
6836:
6837: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
6838:
6839: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
6840: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
6841: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN

Line 6839: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);

6835:
6836:
6837: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
6838:
6839: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
6840: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
6841: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
6842: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
6843: END IF;

Line 6840: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);

6836:
6837: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
6838:
6839: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
6840: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
6841: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
6842: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
6843: END IF;
6844:

Line 6842: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;

6838:
6839: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
6840: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
6841: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
6842: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
6843: END IF;
6844:
6845: IF(l_pk1_column_name IS NOT NULL ) THEN
6846: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;

Line 6846: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;

6842: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
6843: END IF;
6844:
6845: IF(l_pk1_column_name IS NOT NULL ) THEN
6846: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;
6847: END IF;
6848: IF(l_pk2_column_name IS NOT NULL ) THEN
6849: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
6850: END IF;

Line 6849: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;

6845: IF(l_pk1_column_name IS NOT NULL ) THEN
6846: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;
6847: END IF;
6848: IF(l_pk2_column_name IS NOT NULL ) THEN
6849: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
6850: END IF;
6851: IF(l_pk3_column_name IS NOT NULL ) THEN
6852: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
6853: END IF;

Line 6852: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;

6848: IF(l_pk2_column_name IS NOT NULL ) THEN
6849: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
6850: END IF;
6851: IF(l_pk3_column_name IS NOT NULL ) THEN
6852: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
6853: END IF;
6854: IF(l_pk4_column_name IS NOT NULL ) THEN
6855: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
6856: END IF;

Line 6855: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;

6851: IF(l_pk3_column_name IS NOT NULL ) THEN
6852: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
6853: END IF;
6854: IF(l_pk4_column_name IS NOT NULL ) THEN
6855: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
6856: END IF;
6857: IF(l_pk5_column_name IS NOT NULL ) THEN
6858: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
6859: END IF;

Line 6858: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;

6854: IF(l_pk4_column_name IS NOT NULL ) THEN
6855: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
6856: END IF;
6857: IF(l_pk5_column_name IS NOT NULL ) THEN
6858: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
6859: END IF;
6860:
6861: IF(l_data_level_col_exists) THEN
6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;

Line 6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;

6858: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
6859: END IF;
6860:
6861: IF(l_data_level_col_exists) THEN
6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;

Line 6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;

6859: END IF;
6860:
6861: IF(l_data_level_col_exists) THEN
6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;

Line 6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;

6860:
6861: IF(l_data_level_col_exists) THEN
6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
6868: ELSE

Line 6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;

6861: IF(l_data_level_col_exists) THEN
6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
6868: ELSE
6869: IF(l_data_level_column_1 IS NOT NULL ) THEN

Line 6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;

6862: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
6868: ELSE
6869: IF(l_data_level_column_1 IS NOT NULL ) THEN
6870: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;

Line 6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;

6863: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
6864: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
6865: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
6868: ELSE
6869: IF(l_data_level_column_1 IS NOT NULL ) THEN
6870: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
6871: END IF;

Line 6870: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;

6866: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
6867: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
6868: ELSE
6869: IF(l_data_level_column_1 IS NOT NULL ) THEN
6870: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
6871: END IF;
6872: IF(l_data_level_column_2 IS NOT NULL ) THEN
6873: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
6874: END IF;

Line 6873: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;

6869: IF(l_data_level_column_1 IS NOT NULL ) THEN
6870: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
6871: END IF;
6872: IF(l_data_level_column_2 IS NOT NULL ) THEN
6873: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
6874: END IF;
6875: IF(l_data_level_column_3 IS NOT NULL ) THEN
6876: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
6877: END IF;

Line 6876: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;

6872: IF(l_data_level_column_2 IS NOT NULL ) THEN
6873: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
6874: END IF;
6875: IF(l_data_level_column_3 IS NOT NULL ) THEN
6876: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
6877: END IF;
6878: END IF;
6879:
6880: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);

Line 6880: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);

6876: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
6877: END IF;
6878: END IF;
6879:
6880: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);
6881: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);
6882:
6883: END;
6884: END LOOP;--iteration in l_dynamic_cursor ends

Line 6881: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);

6877: END IF;
6878: END IF;
6879:
6880: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);
6881: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);
6882:
6883: END;
6884: END LOOP;--iteration in l_dynamic_cursor ends
6885:

Line 7011: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;

7007: );
7008: EXCEPTION
7009: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
7010: IF (l_pre_event_failed_cursor_id IS NULL) THEN
7011: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;
7012: END IF;
7013:
7014: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
7015:

Line 7014: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);

7010: IF (l_pre_event_failed_cursor_id IS NULL) THEN
7011: l_pre_event_failed_cursor_id := DBMS_SQL.Open_Cursor;
7012: END IF;
7013:
7014: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
7017: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
7018: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN

Line 7016: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);

7012: END IF;
7013:
7014: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
7017: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
7018: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
7019: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
7020: END IF ;

Line 7017: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);

7013:
7014: DBMS_SQL.Parse(l_pre_event_failed_cursor_id, l_pre_event_failed_sql, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
7017: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
7018: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
7019: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
7020: END IF ;
7021:

Line 7019: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;

7015:
7016: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':data_set_id', p_data_set_id);
7017: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id, ':attr_group_int_name', l_ag_deflatened_row.ATTR_GROUP_INT_NAME);
7018: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
7019: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
7020: END IF ;
7021:
7022: IF(l_pk1_column_name IS NOT NULL ) THEN
7023: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;

Line 7023: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;

7019: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':row_identifier',l_ag_deflatened_row.ROW_IDENTIFIER) ;
7020: END IF ;
7021:
7022: IF(l_pk1_column_name IS NOT NULL ) THEN
7023: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;
7024: END IF;
7025: IF(l_pk2_column_name IS NOT NULL ) THEN
7026: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
7027: END IF;

Line 7026: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;

7022: IF(l_pk1_column_name IS NOT NULL ) THEN
7023: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk1_value',l_ag_deflatened_row.PK1) ;
7024: END IF;
7025: IF(l_pk2_column_name IS NOT NULL ) THEN
7026: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
7027: END IF;
7028: IF(l_pk3_column_name IS NOT NULL ) THEN
7029: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
7030: END IF;

Line 7029: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;

7025: IF(l_pk2_column_name IS NOT NULL ) THEN
7026: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk2_value',l_ag_deflatened_row.PK2) ;
7027: END IF;
7028: IF(l_pk3_column_name IS NOT NULL ) THEN
7029: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
7030: END IF;
7031: IF(l_pk4_column_name IS NOT NULL ) THEN
7032: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
7033: END IF;

Line 7032: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;

7028: IF(l_pk3_column_name IS NOT NULL ) THEN
7029: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk3_value',l_ag_deflatened_row.PK3) ;
7030: END IF;
7031: IF(l_pk4_column_name IS NOT NULL ) THEN
7032: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
7033: END IF;
7034: IF(l_pk5_column_name IS NOT NULL ) THEN
7035: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
7036: END IF;

Line 7035: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;

7031: IF(l_pk4_column_name IS NOT NULL ) THEN
7032: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk4_value',l_ag_deflatened_row.PK4) ;
7033: END IF;
7034: IF(l_pk5_column_name IS NOT NULL ) THEN
7035: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
7036: END IF;
7037:
7038: IF(l_data_level_col_exists) THEN
7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;

Line 7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;

7035: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':pk5_value',l_ag_deflatened_row.PK5) ;
7036: END IF;
7037:
7038: IF(l_data_level_col_exists) THEN
7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;

Line 7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;

7036: END IF;
7037:
7038: IF(l_data_level_col_exists) THEN
7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;

Line 7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;

7037:
7038: IF(l_data_level_col_exists) THEN
7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
7045: ELSE

Line 7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;

7038: IF(l_data_level_col_exists) THEN
7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
7045: ELSE
7046: IF(l_data_level_column_1 IS NOT NULL ) THEN

Line 7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;

7039: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_id',l_ag_deflatened_row.DATA_LEVEL_ID) ;
7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
7045: ELSE
7046: IF(l_data_level_column_1 IS NOT NULL ) THEN
7047: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;

Line 7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;

7040: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk1_val',l_ag_deflatened_row.DL1) ;
7041: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk2_val',l_ag_deflatened_row.DL2) ;
7042: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk3_val',l_ag_deflatened_row.DL3) ;
7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
7045: ELSE
7046: IF(l_data_level_column_1 IS NOT NULL ) THEN
7047: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
7048: END IF;

Line 7047: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;

7043: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk4_val',l_ag_deflatened_row.DL4) ;
7044: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl_pk5_val',l_ag_deflatened_row.DL5) ;
7045: ELSE
7046: IF(l_data_level_column_1 IS NOT NULL ) THEN
7047: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
7048: END IF;
7049: IF(l_data_level_column_2 IS NOT NULL ) THEN
7050: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
7051: END IF;

Line 7050: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;

7046: IF(l_data_level_column_1 IS NOT NULL ) THEN
7047: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl1_value',l_ag_deflatened_row.DL1) ;
7048: END IF;
7049: IF(l_data_level_column_2 IS NOT NULL ) THEN
7050: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
7051: END IF;
7052: IF(l_data_level_column_3 IS NOT NULL ) THEN
7053: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
7054: END IF;

Line 7053: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;

7049: IF(l_data_level_column_2 IS NOT NULL ) THEN
7050: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl2_value',l_ag_deflatened_row.DL2) ;
7051: END IF;
7052: IF(l_data_level_column_3 IS NOT NULL ) THEN
7053: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
7054: END IF;
7055: END IF;
7056:
7057: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);

Line 7057: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);

7053: DBMS_SQL.Bind_Variable(l_pre_event_failed_cursor_id,':dl3_value',l_ag_deflatened_row.DL3) ;
7054: END IF;
7055: END IF;
7056:
7057: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);
7058: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);
7059:
7060: END;
7061:

Line 7058: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);

7054: END IF;
7055: END IF;
7056:
7057: l_dummy := DBMS_SQL.Execute(l_pre_event_failed_cursor_id);
7058: DBMS_SQL.Close_Cursor (l_pre_event_failed_cursor_id);
7059:
7060: END;
7061:
7062: END LOOP;--iteration in l_dynamic_cursor ends

Line 7894: cur_l_dynamic_sql_clob := dbms_sql.open_cursor;

7890: /**bug 14145164 start **/
7891: IF (LENGTH(l_db_col_tbl_set_b_attrs) > 0 OR
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'||

Line 8001: DBMS_SQL.PARSE(cur_l_dynamic_sql_clob, l_dynamic_sql_clob,

7997:
7998: code_debug(' Update DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
7999: code_debug(' :--: final length : '||dbms_lob.getlength(l_dynamic_sql_clob) ,3);
8000:
8001: DBMS_SQL.PARSE(cur_l_dynamic_sql_clob, l_dynamic_sql_clob,
8002: DBMS_SQL.NATIVE);
8003:
8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);

Line 8002: DBMS_SQL.NATIVE);

7998: code_debug(' Update DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
7999: code_debug(' :--: final length : '||dbms_lob.getlength(l_dynamic_sql_clob) ,3);
8000:
8001: DBMS_SQL.PARSE(cur_l_dynamic_sql_clob, l_dynamic_sql_clob,
8002: DBMS_SQL.NATIVE);
8003:
8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

Line 8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);

8001: DBMS_SQL.PARSE(cur_l_dynamic_sql_clob, l_dynamic_sql_clob,
8002: DBMS_SQL.NATIVE);
8003:
8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);

Line 8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);

8002: DBMS_SQL.NATIVE);
8003:
8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);

Line 8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);

8003:
8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);

Line 8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);

8004: IF(l_ag_id_col_exists) THEN
8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);

Line 8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);

8005: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:

Line 8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);

8006: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':attr_group_name', l_attr_group_metadata_obj.ATTR_GROUP_NAME);
8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:
8014: ELSE

Line 8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);

8007: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:
8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);

Line 8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);

8008: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8009: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8010: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:
8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);

Line 8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);

8011: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:
8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);

Line 8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);

8012: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8013:
8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);

Line 8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);

8013:
8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);

Line 8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);

8014: ELSE
8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8022:

Line 8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);

8015: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':data_set_id', p_data_set_id);
8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8022:
8023: END IF;

Line 8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);

8016: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':curr_attr_group_id', l_attr_group_metadata_obj.ATTR_GROUP_ID);
8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8022:
8023: END IF;
8024:

Line 8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);

8017: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_user_id', G_CURRENT_USER_ID);
8018: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_date', SYSDATE);
8019: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':current_login_id', G_CURRENT_LOGIN_ID);
8020: DBMS_SQL.BIND_VARIABLE(cur_l_dynamic_sql_clob, ':request_id', G_REQUEST_ID);
8021: l_dummy_ret_val := DBMS_SQL.EXECUTE(cur_l_dynamic_sql_clob);
8022:
8023: END IF;
8024:
8025: code_debug(' Don with executing the update DML ' ,2);

Line 8026: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);

8022:
8023: END IF;
8024:
8025: code_debug(' Don with executing the update DML ' ,2);
8026: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);
8027: EXCEPTION
8028: WHEN OTHERS THEN
8029: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);
8030: RAISE;

Line 8029: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);

8025: code_debug(' Don with executing the update DML ' ,2);
8026: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);
8027: EXCEPTION
8028: WHEN OTHERS THEN
8029: DBMS_SQL.CLOSE_CURSOR(cur_l_dynamic_sql_clob);
8030: RAISE;
8031: END;
8032:
8033: END IF;

Line 8574: DBMS_SQL.Close_Cursor(l_req_num_cursor_id);

8570: END IF;
8571: END IF;
8572:
8573: IF (l_req_num_cursor_id) IS NOT NULL THEN
8574: DBMS_SQL.Close_Cursor(l_req_num_cursor_id);
8575: END IF;
8576: IF (l_req_char_cursor_id) IS NOT NULL THEN
8577: DBMS_SQL.Close_Cursor(l_req_char_cursor_id);
8578: END IF;

Line 8577: DBMS_SQL.Close_Cursor(l_req_char_cursor_id);

8573: IF (l_req_num_cursor_id) IS NOT NULL THEN
8574: DBMS_SQL.Close_Cursor(l_req_num_cursor_id);
8575: END IF;
8576: IF (l_req_char_cursor_id) IS NOT NULL THEN
8577: DBMS_SQL.Close_Cursor(l_req_char_cursor_id);
8578: END IF;
8579: IF (l_req_date_cursor_id) IS NOT NULL THEN
8580: DBMS_SQL.Close_Cursor(l_req_date_cursor_id);
8581: END IF;

Line 8580: DBMS_SQL.Close_Cursor(l_req_date_cursor_id);

8576: IF (l_req_char_cursor_id) IS NOT NULL THEN
8577: DBMS_SQL.Close_Cursor(l_req_char_cursor_id);
8578: END IF;
8579: IF (l_req_date_cursor_id) IS NOT NULL THEN
8580: DBMS_SQL.Close_Cursor(l_req_date_cursor_id);
8581: END IF;
8582: IF (l_default_num_cursor_id) IS NOT NULL THEN
8583: DBMS_SQL.Close_Cursor(l_default_num_cursor_id);
8584: END IF;

Line 8583: DBMS_SQL.Close_Cursor(l_default_num_cursor_id);

8579: IF (l_req_date_cursor_id) IS NOT NULL THEN
8580: DBMS_SQL.Close_Cursor(l_req_date_cursor_id);
8581: END IF;
8582: IF (l_default_num_cursor_id) IS NOT NULL THEN
8583: DBMS_SQL.Close_Cursor(l_default_num_cursor_id);
8584: END IF;
8585: IF (l_default_date_cursor_id) IS NOT NULL THEN
8586: DBMS_SQL.Close_Cursor(l_default_date_cursor_id);
8587: END IF;

Line 8586: DBMS_SQL.Close_Cursor(l_default_date_cursor_id);

8582: IF (l_default_num_cursor_id) IS NOT NULL THEN
8583: DBMS_SQL.Close_Cursor(l_default_num_cursor_id);
8584: END IF;
8585: IF (l_default_date_cursor_id) IS NOT NULL THEN
8586: DBMS_SQL.Close_Cursor(l_default_date_cursor_id);
8587: END IF;
8588: IF (l_default_char_cursor_id) IS NOT NULL THEN
8589: DBMS_SQL.Close_Cursor(l_default_char_cursor_id);
8590: END IF;

Line 8589: DBMS_SQL.Close_Cursor(l_default_char_cursor_id);

8585: IF (l_default_date_cursor_id) IS NOT NULL THEN
8586: DBMS_SQL.Close_Cursor(l_default_date_cursor_id);
8587: END IF;
8588: IF (l_default_char_cursor_id) IS NOT NULL THEN
8589: DBMS_SQL.Close_Cursor(l_default_char_cursor_id);
8590: END IF;
8591: IF (l_bad_tvs_sql_cursor_id) IS NOT NULL THEN
8592: DBMS_SQL.Close_Cursor(l_bad_tvs_sql_cursor_id);
8593: END IF;

Line 8592: DBMS_SQL.Close_Cursor(l_bad_tvs_sql_cursor_id);

8588: IF (l_default_char_cursor_id) IS NOT NULL THEN
8589: DBMS_SQL.Close_Cursor(l_default_char_cursor_id);
8590: END IF;
8591: IF (l_bad_tvs_sql_cursor_id) IS NOT NULL THEN
8592: DBMS_SQL.Close_Cursor(l_bad_tvs_sql_cursor_id);
8593: END IF;
8594:
8595: IF (l_sr_tvs_num_cursor_id1) IS NOT NULL THEN
8596: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id1);

Line 8596: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id1);

8592: DBMS_SQL.Close_Cursor(l_bad_tvs_sql_cursor_id);
8593: END IF;
8594:
8595: IF (l_sr_tvs_num_cursor_id1) IS NOT NULL THEN
8596: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id1);
8597: END IF;
8598: IF (l_sr_tvs_num_cursor_id2) IS NOT NULL THEN
8599: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id2);
8600: END IF;

Line 8599: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id2);

8595: IF (l_sr_tvs_num_cursor_id1) IS NOT NULL THEN
8596: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id1);
8597: END IF;
8598: IF (l_sr_tvs_num_cursor_id2) IS NOT NULL THEN
8599: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id2);
8600: END IF;
8601: IF (l_sr_tvs_date_cursor_id1) IS NOT NULL THEN
8602: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id1);
8603: END IF;

Line 8602: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id1);

8598: IF (l_sr_tvs_num_cursor_id2) IS NOT NULL THEN
8599: DBMS_SQL.Close_Cursor(l_sr_tvs_num_cursor_id2);
8600: END IF;
8601: IF (l_sr_tvs_date_cursor_id1) IS NOT NULL THEN
8602: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id1);
8603: END IF;
8604: IF (l_sr_tvs_date_cursor_id2) IS NOT NULL THEN
8605: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id2);
8606: END IF;

Line 8605: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id2);

8601: IF (l_sr_tvs_date_cursor_id1) IS NOT NULL THEN
8602: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id1);
8603: END IF;
8604: IF (l_sr_tvs_date_cursor_id2) IS NOT NULL THEN
8605: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id2);
8606: END IF;
8607: IF (l_sr_tvs_str_cursor_id1) IS NOT NULL THEN
8608: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id1);
8609: END IF;

Line 8608: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id1);

8604: IF (l_sr_tvs_date_cursor_id2) IS NOT NULL THEN
8605: DBMS_SQL.Close_Cursor(l_sr_tvs_date_cursor_id2);
8606: END IF;
8607: IF (l_sr_tvs_str_cursor_id1) IS NOT NULL THEN
8608: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id1);
8609: END IF;
8610: IF (l_sr_tvs_str_cursor_id2) IS NOT NULL THEN
8611: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id2);
8612: END IF;

Line 8611: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id2);

8607: IF (l_sr_tvs_str_cursor_id1) IS NOT NULL THEN
8608: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id1);
8609: END IF;
8610: IF (l_sr_tvs_str_cursor_id2) IS NOT NULL THEN
8611: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id2);
8612: END IF;
8613:
8614: IF (l_tvs_char_cursor_id) IS NOT NULL THEN
8615: DBMS_SQL.Close_Cursor(l_tvs_char_cursor_id);

Line 8615: DBMS_SQL.Close_Cursor(l_tvs_char_cursor_id);

8611: DBMS_SQL.Close_Cursor(l_sr_tvs_str_cursor_id2);
8612: END IF;
8613:
8614: IF (l_tvs_char_cursor_id) IS NOT NULL THEN
8615: DBMS_SQL.Close_Cursor(l_tvs_char_cursor_id);
8616: END IF;
8617: IF (l_tvs_num_cursor_id) IS NOT NULL THEN
8618: DBMS_SQL.Close_Cursor(l_tvs_num_cursor_id);
8619: END IF;

Line 8618: DBMS_SQL.Close_Cursor(l_tvs_num_cursor_id);

8614: IF (l_tvs_char_cursor_id) IS NOT NULL THEN
8615: DBMS_SQL.Close_Cursor(l_tvs_char_cursor_id);
8616: END IF;
8617: IF (l_tvs_num_cursor_id) IS NOT NULL THEN
8618: DBMS_SQL.Close_Cursor(l_tvs_num_cursor_id);
8619: END IF;
8620: IF (l_tvs_date_cursor_id) IS NOT NULL THEN
8621: DBMS_SQL.Close_Cursor(l_tvs_date_cursor_id);
8622: END IF;

Line 8621: DBMS_SQL.Close_Cursor(l_tvs_date_cursor_id);

8617: IF (l_tvs_num_cursor_id) IS NOT NULL THEN
8618: DBMS_SQL.Close_Cursor(l_tvs_num_cursor_id);
8619: END IF;
8620: IF (l_tvs_date_cursor_id) IS NOT NULL THEN
8621: DBMS_SQL.Close_Cursor(l_tvs_date_cursor_id);
8622: END IF;
8623: IF (l_bad_bindattrs_tvs_cursor_id) IS NOT NULL THEN
8624: DBMS_SQL.Close_Cursor(l_bad_bindattrs_tvs_cursor_id);
8625: END IF;

Line 8624: DBMS_SQL.Close_Cursor(l_bad_bindattrs_tvs_cursor_id);

8620: IF (l_tvs_date_cursor_id) IS NOT NULL THEN
8621: DBMS_SQL.Close_Cursor(l_tvs_date_cursor_id);
8622: END IF;
8623: IF (l_bad_bindattrs_tvs_cursor_id) IS NOT NULL THEN
8624: DBMS_SQL.Close_Cursor(l_bad_bindattrs_tvs_cursor_id);
8625: END IF;
8626:
8627: -- Bug 10151142: Start
8628: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN

Line 8629: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);

8625: END IF;
8626:
8627: -- Bug 10151142: Start
8628: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN
8629: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
8630: END IF;
8631: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
8632: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);
8633: END IF;

Line 8632: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);

8628: IF (l_dynamic_sql_cursor_id) IS NOT NULL THEN
8629: DBMS_SQL.Close_Cursor(l_dynamic_sql_cursor_id);
8630: END IF;
8631: IF (l_dynamic_sql_1_cursor_id) IS NOT NULL THEN
8632: DBMS_SQL.Close_Cursor(l_dynamic_sql_1_cursor_id);
8633: END IF;
8634: -- Bug 10151142: End
8635:
8636: --------------------------------------------------

Line 11039: l_dyn_cursor := DBMS_SQL.Open_Cursor;

11035: ---------------------------------
11036: -- Executing the Final DML --
11037: ----------------------------------
11038: IF(l_dyn_cursor IS NULL ) THEN
11039: l_dyn_cursor := DBMS_SQL.Open_Cursor;
11040: END IF;
11041: DBMS_SQL.Parse(l_dyn_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
11042: DBMS_SQL.Bind_Variable(l_dyn_cursor, ':data_set_id', p_data_set_id);
11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);

Line 11041: DBMS_SQL.Parse(l_dyn_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);

11037: ----------------------------------
11038: IF(l_dyn_cursor IS NULL ) THEN
11039: l_dyn_cursor := DBMS_SQL.Open_Cursor;
11040: END IF;
11041: DBMS_SQL.Parse(l_dyn_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
11042: DBMS_SQL.Bind_Variable(l_dyn_cursor, ':data_set_id', p_data_set_id);
11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);
11044: END LOOP; --Ending the loop for distinct AG's
11045:

Line 11042: DBMS_SQL.Bind_Variable(l_dyn_cursor, ':data_set_id', p_data_set_id);

11038: IF(l_dyn_cursor IS NULL ) THEN
11039: l_dyn_cursor := DBMS_SQL.Open_Cursor;
11040: END IF;
11041: DBMS_SQL.Parse(l_dyn_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
11042: DBMS_SQL.Bind_Variable(l_dyn_cursor, ':data_set_id', p_data_set_id);
11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);
11044: END LOOP; --Ending the loop for distinct AG's
11045:
11046: IF (l_dyn_cursor IS NOT NULL) THEN

Line 11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);

11039: l_dyn_cursor := DBMS_SQL.Open_Cursor;
11040: END IF;
11041: DBMS_SQL.Parse(l_dyn_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
11042: DBMS_SQL.Bind_Variable(l_dyn_cursor, ':data_set_id', p_data_set_id);
11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);
11044: END LOOP; --Ending the loop for distinct AG's
11045:
11046: IF (l_dyn_cursor IS NOT NULL) THEN
11047: DBMS_SQL.Close_Cursor(l_dyn_cursor);

Line 11047: DBMS_SQL.Close_Cursor(l_dyn_cursor);

11043: l_dummy := DBMS_SQL.Execute(l_dyn_cursor);
11044: END LOOP; --Ending the loop for distinct AG's
11045:
11046: IF (l_dyn_cursor IS NOT NULL) THEN
11047: DBMS_SQL.Close_Cursor(l_dyn_cursor);
11048: END IF;
11049:
11050: --------------------------------
11051: -- Standard check of p_commit --