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

Line 99: l_main dbms_sql.varchar2s;

95: l_select_start varchar2(2500);
96: l_from_stmt varchar2(2000);
97: l_group_by varchar2(500);
98:
99: l_main dbms_sql.varchar2s;
100:
101: l_sub_sql varchar2(3000); -- Bug3896299 Extended.
102: l_asset_id number;
103: l_total_cost number; -- bug#2661575: asset total cost at target date

Line 1118: v_SubCursor := DBMS_SQL.OPEN_CURSOR;

1114:
1115: -- Open v_SubCursor
1116: /* v_SubCursor is created for performance issue. the cursor fetch asset_id */
1117:
1118: v_SubCursor := DBMS_SQL.OPEN_CURSOR;
1119: IF (g_print_debug) THEN
1120: fa_rx_util_pkg.debug('fadptx_insert: ***** OPEN CURSOR: v_SubCursor *****');
1121: fa_rx_util_pkg.debug('fadptx_insert: v_SubCursor :'|| v_SubCursor);
1122: END IF;

Line 1124: DBMS_SQL.PARSE (v_SubCursor,l_sub_sql,DBMS_SQL.V7);

1120: fa_rx_util_pkg.debug('fadptx_insert: ***** OPEN CURSOR: v_SubCursor *****');
1121: fa_rx_util_pkg.debug('fadptx_insert: v_SubCursor :'|| v_SubCursor);
1122: END IF;
1123:
1124: DBMS_SQL.PARSE (v_SubCursor,l_sub_sql,DBMS_SQL.V7);
1125:
1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);
1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);

Line 1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);

1122: END IF;
1123:
1124: DBMS_SQL.PARSE (v_SubCursor,l_sub_sql,DBMS_SQL.V7);
1125:
1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);
1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */

Line 1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);

1123:
1124: DBMS_SQL.PARSE (v_SubCursor,l_sub_sql,DBMS_SQL.V7);
1125:
1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);
1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);

Line 1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);

1124: DBMS_SQL.PARSE (v_SubCursor,l_sub_sql,DBMS_SQL.V7);
1125:
1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);
1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);

Line 1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);

1125:
1126: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_book',h_book);
1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);

Line 1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);

1127: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_prior_date',h_prior_date);
1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);

Line 1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);

1128: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_target_date',h_target_date);
1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);

Line 1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);

1129: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_method_code',h_method_code);
1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);
1137: /* Bug3896299 */

Line 1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);

1130: /* Bug3896299 */
1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);
1137: /* Bug3896299 */
1138:

Line 1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);

1131: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_corp_book',h_corp_book);
1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);
1137: /* Bug3896299 */
1138:
1139: DBMS_SQL.DEFINE_COLUMN(v_SubCursor,1,l_asset_id);

Line 1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);

1132: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_from',state_from);
1133: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_state_to',state_to);
1134: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_from',h_category_from);
1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);
1137: /* Bug3896299 */
1138:
1139: DBMS_SQL.DEFINE_COLUMN(v_SubCursor,1,l_asset_id);
1140:

Line 1139: DBMS_SQL.DEFINE_COLUMN(v_SubCursor,1,l_asset_id);

1135: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_category_to',h_category_to);
1136: DBMS_SQL.BIND_VARIABLE(v_SubCursor,':p_year',h_year);
1137: /* Bug3896299 */
1138:
1139: DBMS_SQL.DEFINE_COLUMN(v_SubCursor,1,l_asset_id);
1140:
1141: IF (g_print_debug) THEN
1142: fa_rx_util_pkg.debug('fadptx_insert: ***** BIND/DEFINE COLUMN: v_SubCursor *****');
1143: END IF;

Line 1145: v_SubReturn := DBMS_SQL.EXECUTE(v_SubCursor);

1141: IF (g_print_debug) THEN
1142: fa_rx_util_pkg.debug('fadptx_insert: ***** BIND/DEFINE COLUMN: v_SubCursor *****');
1143: END IF;
1144:
1145: v_SubReturn := DBMS_SQL.EXECUTE(v_SubCursor);
1146: IF (g_print_debug) THEN
1147: fa_rx_util_pkg.debug('fadptx_insert: ***** EXECUTE: v_SubCursor *****');
1148: fa_rx_util_pkg.debug('fadptx_insert: v_SubReturn :'|| v_SubReturn);
1149: END IF;

Line 1154: v_MainCursor := DBMS_SQL.OPEN_CURSOR;

1150:
1151: --Open v_MainCursor
1152: /* v_MainCursor is for fetch main data */
1153:
1154: v_MainCursor := DBMS_SQL.OPEN_CURSOR;
1155: IF (g_print_debug) THEN
1156: fa_rx_util_pkg.debug('fadptx_insert: ***** OPEN CURSOR: v_MainCursor *****');
1157: fa_rx_util_pkg.debug('fadptx_insert: v_MainCursor :' || v_MainCursor);
1158: END IF;

Line 1160: --DBMS_SQL.PARSE (v_MainCursor, main_sql,DBMS_SQL.V7);

1156: fa_rx_util_pkg.debug('fadptx_insert: ***** OPEN CURSOR: v_MainCursor *****');
1157: fa_rx_util_pkg.debug('fadptx_insert: v_MainCursor :' || v_MainCursor);
1158: END IF;
1159:
1160: --DBMS_SQL.PARSE (v_MainCursor, main_sql,DBMS_SQL.V7);
1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);
1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);

Line 1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);

1157: fa_rx_util_pkg.debug('fadptx_insert: v_MainCursor :' || v_MainCursor);
1158: END IF;
1159:
1160: --DBMS_SQL.PARSE (v_MainCursor, main_sql,DBMS_SQL.V7);
1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);
1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);

Line 1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);

1159:
1160: --DBMS_SQL.PARSE (v_MainCursor, main_sql,DBMS_SQL.V7);
1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);
1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);

Line 1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);

1160: --DBMS_SQL.PARSE (v_MainCursor, main_sql,DBMS_SQL.V7);
1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);
1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);

Line 1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);

1161: DBMS_SQL.PARSE (v_MainCursor, l_main,0,k,FALSE,DBMS_SQL.V7);
1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8

Line 1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);

1162:
1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);

Line 1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);

1163: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_asset_id);
1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);

Line 1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);

1164: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_asset_number,15);
1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);

Line 1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8

1165: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_asset_desc,80);
1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);

Line 1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);

1166: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_new_used,4);
1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);

Line 1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);

1167: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_book_type_code,15);
1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);

Line 1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);

1168: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_minor_category,150);
1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);

Line 1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);

1169: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_tax_asset_type,15); -- Treate UTF8
1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);

Line 1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);

1170: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_state,150);
1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);

Line 1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);

1171: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_start_units_total);
1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);

Line 1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);

1172: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_end_units_total);
1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);

Line 1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);

1173: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,11,h_start_units_assigned);
1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);

Line 1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);

1174: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,12,h_end_units_assigned);
1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);

Line 1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);

1175: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,13,h_start_cost_total);
1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);

Line 1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);

1176: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,14,h_end_cost_total);
1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);

Line 1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);

1177: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,15,h_date_in_service);
1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);

Line 1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);

1178: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,16,h_era_name_num,1);
1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);
1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);

Line 1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);

1179: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,17,h_add_era_year);
1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);
1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);
1187: IF (g_print_debug) THEN

Line 1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);

1180: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,18,h_add_year);
1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);
1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);
1187: IF (g_print_debug) THEN
1188: fa_rx_util_pkg.debug('fadptx_insert: ***** DEFINE COLUMN: v_MainCursor *****');

Line 1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);

1181: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,19,h_add_month);
1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);
1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);
1187: IF (g_print_debug) THEN
1188: fa_rx_util_pkg.debug('fadptx_insert: ***** DEFINE COLUMN: v_MainCursor *****');
1189: END IF;

Line 1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);

1182: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,20,h_start_life);
1183: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,21,h_end_life);
1184: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,22,h_adjusted_rate);
1185: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,23,h_abs_units);
1186: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,24,h_action_flag, 1);
1187: IF (g_print_debug) THEN
1188: fa_rx_util_pkg.debug('fadptx_insert: ***** DEFINE COLUMN: v_MainCursor *****');
1189: END IF;
1190:

Line 1196: v_SubFetch := DBMS_SQL.FETCH_ROWS(v_SubCursor);

1192: /* Loop For v_SubCursor */
1193:
1194: h_sum_nbvs_asset_id := -1;
1195: Loop
1196: v_SubFetch := DBMS_SQL.FETCH_ROWS(v_SubCursor);
1197: IF (g_print_debug) THEN
1198: fa_rx_util_pkg.debug('fadptx_insert: ***** FETCH LOW: v_SubCursor *****');
1199: fa_rx_util_pkg.debug('fadptx_insert: v_SubFetch :'||v_SubFetch);
1200: END IF;

Line 1206: DBMS_SQL.COLUMN_VALUE(v_SubCursor,1,l_asset_id);

1202: If v_SubFetch =0 then
1203: Exit;
1204: end if;
1205:
1206: DBMS_SQL.COLUMN_VALUE(v_SubCursor,1,l_asset_id);
1207:
1208: IF (g_print_debug) THEN
1209: fa_rx_util_pkg.debug('fadptx_insert: l_asset_id : h_sum_nbvs_asset_id'||l_asset_id||':'||h_sum_nbvs_asset_id);
1210: END IF;

Line 1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);

1265: fa_rx_util_pkg.debug('fadptx_insert: h_prior_ah_thid_in :'||h_prior_ah_thid_in);
1266: fa_rx_util_pkg.debug('fadptx_insert: h_target_bk_thid_in :'||h_target_bk_thid_in);
1267: END IF;
1268:
1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);
1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);

Line 1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);

1266: fa_rx_util_pkg.debug('fadptx_insert: h_target_bk_thid_in :'||h_target_bk_thid_in);
1267: END IF;
1268:
1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);
1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);

Line 1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);

1267: END IF;
1268:
1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);
1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);

Line 1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);

1268:
1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);
1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);

Line 1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);

1269: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_asset_id',l_asset_id);
1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);

Line 1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);

1270: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_book',h_book);
1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);

Line 1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);

1271: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_corp_book',h_corp_book);
1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);

Line 1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);

1272: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_date',h_target_date);
1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);

Line 1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);

1273: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_date', h_prior_date);
1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);

Line 1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);

1274: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_from',h_category_from);
1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151

Line 1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);

1275: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_category_to',h_category_to);
1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151

Line 1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);

1276: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_year',h_year);
1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151

Line 1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);

1277: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_method_code',h_method_code);
1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151
1285:

Line 1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151

1278: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_date_effective',h_prior_bk_date_effective);
1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151
1285:
1286: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);

Line 1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151

1279: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_date_effective',h_prior_ah_date_effective);
1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151
1285:
1286: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
1287: IF (g_print_debug) THEN

Line 1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151

1280: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_date_effective',h_target_bk_date_effective);
1281: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_sum_nbvs_cost',h_sum_nbvs_cost);
1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151
1285:
1286: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
1287: IF (g_print_debug) THEN
1288: fa_rx_util_pkg.debug('fadptx_insert: ***** EXECUTE: v_MainCursor *****');

Line 1286: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);

1282: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_bk_thid_in',h_prior_bk_thid_in); -- Bug3859151
1283: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_prior_ah_thid_in',h_prior_ah_thid_in); -- bug3859151
1284: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_target_bk_thid_in',h_target_bk_thid_in); -- Bug3859151
1285:
1286: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
1287: IF (g_print_debug) THEN
1288: fa_rx_util_pkg.debug('fadptx_insert: ***** EXECUTE: v_MainCursor *****');
1289: fa_rx_util_pkg.debug('fadptx_insert: v_MainReturn :'||v_MainReturn);
1290: END IF;

Line 1303: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);

1299: Loop
1300: -- bug#2448145: Initialized update nbv flag
1301: h_up_nbv_flag := 'N'; -- bug#2661575
1302:
1303: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);
1304: IF (g_print_debug) THEN
1305: fa_rx_util_pkg.debug('fadptx_insert: ***** FETCH LOW: v_MainCursor *****');
1306: fa_rx_util_pkg.debug('fadptx_insert: v_MainFetch :'|| v_MainFetch);
1307: END IF;

Line 1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);

1309: If v_MainFetch =0 then
1310: Exit;
1311: end if;
1312:
1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);
1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);

Line 1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);

1310: Exit;
1311: end if;
1312:
1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);
1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);

Line 1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);

1311: end if;
1312:
1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);
1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);

Line 1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);

1312:
1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);
1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);

Line 1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);

1313: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_asset_id);
1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);

Line 1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);

1314: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_asset_number);
1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);

Line 1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);

1315: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_asset_desc);
1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);

Line 1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);

1316: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_new_used);
1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);

Line 1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);

1317: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_book_type_code);
1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);

Line 1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);

1318: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_minor_category);
1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);

Line 1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);

1319: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_tax_asset_type);
1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);

Line 1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);

1320: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_state);
1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);

Line 1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);

1321: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_start_units_total);
1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);

Line 1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);

1322: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_end_units_total);
1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);

Line 1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);

1323: DBMS_SQL.COLUMN_VALUE(v_MainCursor,11,h_start_units_assigned);
1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);

Line 1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);

1324: DBMS_SQL.COLUMN_VALUE(v_MainCursor,12,h_end_units_assigned);
1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);

Line 1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);

1325: DBMS_SQL.COLUMN_VALUE(v_MainCursor,13,h_start_cost_total);
1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);

Line 1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);

1326: DBMS_SQL.COLUMN_VALUE(v_MainCursor,14,h_end_cost_total);
1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);

Line 1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);

1327: DBMS_SQL.COLUMN_VALUE(v_MainCursor,15,h_date_in_service);
1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);

Line 1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);

1328: DBMS_SQL.COLUMN_VALUE(v_MainCursor,16,h_era_name_num);
1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);
1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);

Line 1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);

1329: DBMS_SQL.COLUMN_VALUE(v_MainCursor,17,h_add_era_year);
1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);
1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);
1337:

Line 1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);

1330: DBMS_SQL.COLUMN_VALUE(v_MainCursor,18,h_add_year);
1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);
1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);
1337:
1338: /* Get Minor Category Description */

Line 1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);

1331: DBMS_SQL.COLUMN_VALUE(v_MainCursor,19,h_add_month);
1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);
1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);
1337:
1338: /* Get Minor Category Description */
1339: IF (g_print_debug) THEN

Line 1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);

1332: DBMS_SQL.COLUMN_VALUE(v_MainCursor,20,h_start_life);
1333: DBMS_SQL.COLUMN_VALUE(v_MainCursor,21,h_end_life);
1334: DBMS_SQL.COLUMN_VALUE(v_MainCursor,22,h_adjusted_rate);
1335: DBMS_SQL.COLUMN_VALUE(v_MainCursor,23,h_abs_units);
1336: DBMS_SQL.COLUMN_VALUE(v_MainCursor,24,h_action_flag);
1337:
1338: /* Get Minor Category Description */
1339: IF (g_print_debug) THEN
1340: fa_rx_util_pkg.debug('fadptx_insert: h_minor_category(tax asset type) '|| h_minor_category);

Line 2027: v_TransferCursor := DBMS_SQL.OPEN_CURSOR;

2023: and TRANSACTION_DATE_ENTERED <= '''|| h_target_date ||'''
2024: and TRANSACTION_TYPE_CODE =''TRANSFER'')
2025: and FDH.LOCATION_ID = LOC.LOCATION_ID
2026: and '||l_parm_state||' <> '''||h_state ||'''';
2027: v_TransferCursor := DBMS_SQL.OPEN_CURSOR;
2028:
2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);
2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:

Line 2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);

2025: and FDH.LOCATION_ID = LOC.LOCATION_ID
2026: and '||l_parm_state||' <> '''||h_state ||'''';
2027: v_TransferCursor := DBMS_SQL.OPEN_CURSOR;
2028:
2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);
2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:
2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);
2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);

Line 2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);

2026: and '||l_parm_state||' <> '''||h_state ||'''';
2027: v_TransferCursor := DBMS_SQL.OPEN_CURSOR;
2028:
2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);
2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:
2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);
2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);
2034: DBMS_SQL.COLUMN_VALUE(v_TransferCursor,1,h_current_state_flag);

Line 2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);

2028:
2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);
2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:
2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);
2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);
2034: DBMS_SQL.COLUMN_VALUE(v_TransferCursor,1,h_current_state_flag);
2035: If v_TransferFetch = 0 then
2036: h_current_state_flag:='Y';

Line 2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);

2029: DBMS_SQL.PARSE (v_TransferCursor,l_transfer_sql,DBMS_SQL.V7);
2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:
2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);
2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);
2034: DBMS_SQL.COLUMN_VALUE(v_TransferCursor,1,h_current_state_flag);
2035: If v_TransferFetch = 0 then
2036: h_current_state_flag:='Y';
2037: end if;

Line 2034: DBMS_SQL.COLUMN_VALUE(v_TransferCursor,1,h_current_state_flag);

2030: DBMS_SQL.DEFINE_COLUMN(v_TransferCursor,1,h_current_state_flag,1);
2031:
2032: v_TransferReturn := DBMS_SQL.EXECUTE(v_TransferCursor);
2033: v_TransferFetch := DBMS_SQL.FETCH_ROWS(v_TransferCursor);
2034: DBMS_SQL.COLUMN_VALUE(v_TransferCursor,1,h_current_state_flag);
2035: If v_TransferFetch = 0 then
2036: h_current_state_flag:='Y';
2037: end if;
2038:

Line 2039: DBMS_SQL.CLOSE_CURSOR(v_TransferCursor);

2035: If v_TransferFetch = 0 then
2036: h_current_state_flag:='Y';
2037: end if;
2038:
2039: DBMS_SQL.CLOSE_CURSOR(v_TransferCursor);
2040:
2041: end;
2042: ----Bug6200581 ends
2043:

Line 2511: -- DBMS_SQL.close_cursor(v_state_cursor);

2507: END IF;
2508:
2509: END LOOP;
2510:
2511: -- DBMS_SQL.close_cursor(v_state_cursor);
2512:
2513: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);
2514:
2515: IF (g_print_debug) THEN

Line 2513: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);

2509: END LOOP;
2510:
2511: -- DBMS_SQL.close_cursor(v_state_cursor);
2512:
2513: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);
2514:
2515: IF (g_print_debug) THEN
2516: fa_rx_util_pkg.debug('fadptx_insert: ' || '***** Close Cursor v_MainCursor *****');
2517: END IF;

Line 2519: DBMS_SQL.CLOSE_CURSOR(v_SubCursor);

2515: IF (g_print_debug) THEN
2516: fa_rx_util_pkg.debug('fadptx_insert: ' || '***** Close Cursor v_MainCursor *****');
2517: END IF;
2518:
2519: DBMS_SQL.CLOSE_CURSOR(v_SubCursor);
2520:
2521: IF (g_print_debug) THEN
2522: fa_rx_util_pkg.debug('fadptx_insert: ' || '***** End Loop and Close Cursor v_SubCursor *****');
2523: END IF;

Line 2541: v_ExtCursor := DBMS_SQL.OPEN_CURSOR;

2537: and can insert their date.
2538: ==================================================================== */
2539:
2540: begin
2541: v_ExtCursor := DBMS_SQL.OPEN_CURSOR;
2542:
2543: l_ExtString := '
2544: Begin
2545: FA_DEPRN_TAX_CUSTOM_PKG.FADPCUSTOM_UPDATE(

Line 2565: DBMS_SQL.PARSE (v_ExtCursor, l_ExtString, DBMS_SQL.V7);

2561: :errbuf := sqlerrm;
2562:
2563: end;';
2564:
2565: DBMS_SQL.PARSE (v_ExtCursor, l_ExtString, DBMS_SQL.V7);
2566:
2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);

Line 2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );

2563: end;';
2564:
2565: DBMS_SQL.PARSE (v_ExtCursor, l_ExtString, DBMS_SQL.V7);
2566:
2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );

Line 2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );

2564:
2565: DBMS_SQL.PARSE (v_ExtCursor, l_ExtString, DBMS_SQL.V7);
2566:
2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );

Line 2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);

2565: DBMS_SQL.PARSE (v_ExtCursor, l_ExtString, DBMS_SQL.V7);
2566:
2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:

Line 2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );

2566:
2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:
2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);

Line 2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );

2567: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_request_id' ,h_request_id );
2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:
2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);
2575:

Line 2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );

2568: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_book_type_code' ,h_book_type_code );
2569: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_year' ,h_year);
2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:
2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);
2575:
2576: DBMS_SQL.CLOSE_CURSOR(v_ExtCursor);

Line 2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);

2570: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':h_state' ,h_state );
2571: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':retcode' ,retcode );
2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:
2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);
2575:
2576: DBMS_SQL.CLOSE_CURSOR(v_ExtCursor);
2577:
2578: if retcode = 2 then

Line 2576: DBMS_SQL.CLOSE_CURSOR(v_ExtCursor);

2572: DBMS_SQL.BIND_VARIABLE (v_ExtCursor,':errbuf' ,errbuf );
2573:
2574: v_ExtReturn := DBMS_SQL.EXECUTE(v_ExtCursor);
2575:
2576: DBMS_SQL.CLOSE_CURSOR(v_ExtCursor);
2577:
2578: if retcode = 2 then
2579: return;
2580: end if;