105: l_old_err_stack VARCHAR2(2000);
106: NoOfRecordsIns NUMBER;
107: NoOfRecordsDel NUMBER;
108:
109: l_sob PA_PLSQL_DATATYPES.Num15TabTyp;
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
106: NoOfRecordsIns NUMBER;
107: NoOfRecordsDel NUMBER;
108:
109: l_sob PA_PLSQL_DATATYPES.Num15TabTyp;
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
107: NoOfRecordsDel NUMBER;
108:
109: l_sob PA_PLSQL_DATATYPES.Num15TabTyp;
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
115: l_conv_date PA_PLSQL_DATATYPES.DateTabTyp;
108:
109: l_sob PA_PLSQL_DATATYPES.Num15TabTyp;
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
115: l_conv_date PA_PLSQL_DATATYPES.DateTabTyp;
116:
109: l_sob PA_PLSQL_DATATYPES.Num15TabTyp;
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
115: l_conv_date PA_PLSQL_DATATYPES.DateTabTyp;
116:
117: CURSOR c_ast_ln_det_ar Is
110: l_asset_line_uniq_id PA_PLSQL_DATATYPES.Num15TabTyp;
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
115: l_conv_date PA_PLSQL_DATATYPES.DateTabTyp;
116:
117: CURSOR c_ast_ln_det_ar Is
118: SELECT pmald.Set_Of_Books_Id,
111: l_asset_line_id PA_PLSQL_DATATYPES.Num15TabTyp;
112: l_cip_cost PA_PLSQL_DATATYPES.Num15TabTyp;
113: l_cur_code PA_PLSQL_DATATYPES.Char30TabTyp;
114: l_exc_rate PA_PLSQL_DATATYPES.Num15TabTyp;
115: l_conv_date PA_PLSQL_DATATYPES.DateTabTyp;
116:
117: CURSOR c_ast_ln_det_ar Is
118: SELECT pmald.Set_Of_Books_Id,
119: pmald.Proj_Asset_Line_Dtl_Uniq_Id,