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.PSA_REP_ATTRIBUTES dependencies on DBMS_SQL

Line 1138: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;

1134: BEGIN
1135: --------------------------------
1136: --Open the cursor for attributes
1137: --------------------------------
1138: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
1141: IF ln_params <> 2 THEN
1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);

Line 1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);

1135: --------------------------------
1136: --Open the cursor for attributes
1137: --------------------------------
1138: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
1141: IF ln_params <> 2 THEN
1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
1143: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);

Line 1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);

1136: --Open the cursor for attributes
1137: --------------------------------
1138: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
1141: IF ln_params <> 2 THEN
1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
1143: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
1144: END IF;

Line 1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);

1138: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
1141: IF ln_params <> 2 THEN
1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
1143: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
1144: END IF;
1145:
1146: -----------------------------------------

Line 1143: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);

1139: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
1140: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
1141: IF ln_params <> 2 THEN
1142: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
1143: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
1144: END IF;
1145:
1146: -----------------------------------------
1147: --Assign variables for the cursor columns

Line 1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

1146: -----------------------------------------
1147: --Assign variables for the cursor columns
1148: -----------------------------------------
1149: IF ln_params = 2 THEN
1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

Line 1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

1147: --Assign variables for the cursor columns
1148: -----------------------------------------
1149: IF ln_params = 2 THEN
1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

Line 1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

1148: -----------------------------------------
1149: IF ln_params = 2 THEN
1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

Line 1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);

1149: IF ln_params = 2 THEN
1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);

Line 1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

1150: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE

Line 1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

1151: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

Line 1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

1152: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

Line 1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);

1153: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1154: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

Line 1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

1155: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

Line 1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

1156: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

Line 1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

1157: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

Line 1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);

1158: ELSE
1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1166: END IF;

Line 1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

1159: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1166: END IF;
1167: -----------------------------------

Line 1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

1160: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1166: END IF;
1167: -----------------------------------
1168: --Execute the cursor for attributes

Line 1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

1161: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
1162: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
1163: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
1164: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
1165: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
1166: END IF;
1167: -----------------------------------
1168: --Execute the cursor for attributes
1169: -----------------------------------

Line 1170: li_dummy:=DBMS_SQL.EXECUTE(li_cursor_id);

1166: END IF;
1167: -----------------------------------
1168: --Execute the cursor for attributes
1169: -----------------------------------
1170: li_dummy:=DBMS_SQL.EXECUTE(li_cursor_id);
1171: --
1172: -----------------------------------------
1173: --Start building the the update statement
1174: -----------------------------------------

Line 1181: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN

1177: LOOP
1178: -------------------------------
1179: --Fetch each row for attributes
1180: -------------------------------
1181: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN
1182: EXIT;
1183: END IF;
1184: IF ln_params=2 THEN
1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

Line 1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

1181: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN
1182: EXIT;
1183: END IF;
1184: IF ln_params=2 THEN
1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

Line 1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

1182: EXIT;
1183: END IF;
1184: IF ln_params=2 THEN
1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

Line 1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

1183: END IF;
1184: IF ln_params=2 THEN
1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

Line 1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);

1184: IF ln_params=2 THEN
1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);

Line 1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

1185: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE

Line 1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

1186: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

Line 1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

1187: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

Line 1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);

1188: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1189: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

Line 1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

1190: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

Line 1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

1191: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

Line 1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

1192: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

Line 1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);

1193: ELSE
1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1201: END IF;

Line 1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

1194: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1201: END IF;
1202:

Line 1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

1195: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1201: END IF;
1202:
1203: ----------------------------------

Line 1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

1196: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
1197: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
1198: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
1199: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
1200: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
1201: END IF;
1202:
1203: ----------------------------------
1204: --If the validation is independent

Line 1275: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;

1271:
1272: ----------------------------------------------
1273: --Open, Parse and Execute the Update statement
1274: ----------------------------------------------
1275: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
1276: --
1277: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
1279: --

Line 1277: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);

1273: --Open, Parse and Execute the Update statement
1274: ----------------------------------------------
1275: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
1276: --
1277: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
1279: --
1280: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
1281: --

Line 1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);

1274: ----------------------------------------------
1275: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
1276: --
1277: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
1279: --
1280: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
1281: --
1282: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);

Line 1280: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);

1276: --
1277: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
1279: --
1280: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
1281: --
1282: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);
1283: --
1284:

Line 1282: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);

1278: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
1279: --
1280: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
1281: --
1282: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);
1283: --
1284:
1285: COMMIT;
1286: