668: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
669: -- fv_utility.debug_mesg('**** START MAIN PROCESS ****');
670:
671: Begin
672: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;
673: Exception
674: When Others Then
675: vp_retcode := sqlcode ;
676: VP_ERRBUF := sqlerrm ;
729:
730: fnd_file.put_line(fnd_file.log,vl_main_select);
731:
732: Begin
733: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;
734: Exception
735: When Others Then
736: vp_retcode := sqlcode ;
737: VP_ERRBUF := sqlerrm ;
740:
741: Return ;
742: End ;
743:
744: dbms_sql.define_column(vl_main_cursor, 1, v_acct_num, 25);
745: dbms_sql.define_column(vl_main_cursor, 2, v_fund_val, 25);
746: If v_cohort_Seg_name is not null Then
747: dbms_sql.define_column(vl_main_cursor, 3, vl_cohort_yr, 25);
748: End If ;
741: Return ;
742: End ;
743:
744: dbms_sql.define_column(vl_main_cursor, 1, v_acct_num, 25);
745: dbms_sql.define_column(vl_main_cursor, 2, v_fund_val, 25);
746: If v_cohort_Seg_name is not null Then
747: dbms_sql.define_column(vl_main_cursor, 3, vl_cohort_yr, 25);
748: End If ;
749:
743:
744: dbms_sql.define_column(vl_main_cursor, 1, v_acct_num, 25);
745: dbms_sql.define_column(vl_main_cursor, 2, v_fund_val, 25);
746: If v_cohort_Seg_name is not null Then
747: dbms_sql.define_column(vl_main_cursor, 3, vl_cohort_yr, 25);
748: End If ;
749:
750: Begin
751: vl_exec_ret := dbms_sql.execute(vl_main_cursor);
747: dbms_sql.define_column(vl_main_cursor, 3, vl_cohort_yr, 25);
748: End If ;
749:
750: Begin
751: vl_exec_ret := dbms_sql.execute(vl_main_cursor);
752: Exception
753: When Others Then
754: vp_retcode := sqlcode ;
755: VP_ERRBUF := sqlerrm ;
769: v_acct_num := Null ;
770: vl_main_amount := 0 ;
771: vl_new_amount := Null ;
772: -- Fetch rows
773: vl_main_fetch := dbms_sql.fetch_rows(vl_main_cursor) ;
774:
775: IF vl_main_fetch = 0 then
776: IF vl_count = 0 Then
777: VP_ERRBUF := 'No Data found for FACTS II process';
783: exit;
784: ELSE
785: vl_count := vl_count + 1;
786: -- Fetch the Records into Variables
787: dbms_sql.column_value(vl_main_cursor, 1, v_acct_num);
788: dbms_sql.column_value(vl_main_cursor, 2, v_fund_val);
789:
790: If v_cohort_Seg_name is not null Then
791: dbms_sql.column_value(vl_main_cursor, 3, vl_cohort_yr);
784: ELSE
785: vl_count := vl_count + 1;
786: -- Fetch the Records into Variables
787: dbms_sql.column_value(vl_main_cursor, 1, v_acct_num);
788: dbms_sql.column_value(vl_main_cursor, 2, v_fund_val);
789:
790: If v_cohort_Seg_name is not null Then
791: dbms_sql.column_value(vl_main_cursor, 3, vl_cohort_yr);
792: End If ;
787: dbms_sql.column_value(vl_main_cursor, 1, v_acct_num);
788: dbms_sql.column_value(vl_main_cursor, 2, v_fund_val);
789:
790: If v_cohort_Seg_name is not null Then
791: dbms_sql.column_value(vl_main_cursor, 3, vl_cohort_yr);
792: End If ;
793: -- Start Process for the Amount in the main Cursor
794: --
795: ------------------------------------------------------------
794: --
795: ------------------------------------------------------------
796: Begin
797: Begin
798: vl_amount_cursor := DBMS_SQL.OPEN_CURSOR ;
799: Exception
800: When Others Then
801: vp_retcode := sqlcode ;
802: VP_ERRBUF := sqlerrm || '[From Main Cursor ]';
836:
837:
838: fnd_file.put_line(fnd_file.log, vl_amount_select) ;
839: Begin
840: dbms_sql.parse(vl_amount_cursor,vl_amount_select,DBMS_SQL.V7);
841:
842: Exception
843: When Others Then
844: vp_retcode := sqlcode ;
846: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
847: Return ;
848: End ;
849:
850: dbms_sql.define_column(vl_amount_cursor, 1, vl_new_amount);
851:
852: Begin
853: vl_amount_ret := dbms_sql.execute(vl_amount_cursor);
854: Exception
849:
850: dbms_sql.define_column(vl_amount_cursor, 1, vl_new_amount);
851:
852: Begin
853: vl_amount_ret := dbms_sql.execute(vl_amount_cursor);
854: Exception
855: When Others Then
856: vp_retcode := sqlcode ;
857: VP_ERRBUF := sqlerrm || '[ Open vl_amount_cursor]' ;
858: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
859: Return ;
860: End ;
861:
862: vl_amount_fetch := dbms_sql.fetch_rows(vl_amount_cursor) ;
863: dbms_sql.column_Value(vl_amount_cursor, 1, vl_new_amount );
864: End;
865: vl_main_amount := vl_new_amount;
866:
859: Return ;
860: End ;
861:
862: vl_amount_fetch := dbms_sql.fetch_rows(vl_amount_cursor) ;
863: dbms_sql.column_Value(vl_amount_cursor, 1, vl_new_amount );
864: End;
865: vl_main_amount := vl_new_amount;
866:
867: fnd_file.put_line(fnd_file.log,v_acct_num || ' amount: ' || to_char(vl_main_amount)) ;
947: -- cursor. Then roll them up and insert the summarized record
948: -- into the temp table. Dynamic SQL used for implementation.
949:
950: Begin
951: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;
952: Exception
953: When Others Then
954: vp_retcode := sqlcode ;
955: VP_ERRBUF := sqlerrm ;
1068: vl_legis_select := vl_legis_select || ')';
1069: END IF;
1070: fnd_file.put_line(fnd_file.log,vl_legis_select);
1071: Begin
1072: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);
1073: Exception
1074: When Others Then
1075: vp_retcode := sqlcode ;
1076: VP_ERRBUF := sqlerrm ;
1078: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR PARSE:'||SQLERRM);
1079: Return ;
1080: End ;
1081:
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1079: Return ;
1080: End ;
1081:
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1080: End ;
1081:
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1081:
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 240 );
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 240 );
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 240 );
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 240 );
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1094: --Start Bug 2464961--
1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1094: --Start Bug 2464961--
1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );
1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 240 );
1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 240 );
1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1094: --Start Bug 2464961--
1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );
1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );
1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1094: --Start Bug 2464961--
1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );
1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );
1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );
1098: --End Bug 2464961--
1099:
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);
1093:
1094: --Start Bug 2464961--
1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );
1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );
1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );
1098: --End Bug 2464961--
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1093:
1094: --Start Bug 2464961--
1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );
1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );
1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );
1098: --End Bug 2464961--
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );
1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );
1098: --End Bug 2464961--
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );
1098: --End Bug 2464961--
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1098: --End Bug 2464961--
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1099:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1107:
1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1107:
1108: If v_cohort_Seg_name is not null Then
1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1107:
1108: If v_cohort_Seg_name is not null Then
1109: -- Bug 2464961 changed 15 to 19 in the following line--
1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);
1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);
1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);
1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1107:
1108: If v_cohort_Seg_name is not null Then
1109: -- Bug 2464961 changed 15 to 19 in the following line--
1110: dbms_sql.define_column(vl_legis_cursor, 21, vl_cohort_yr, 25);
1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);
1107:
1108: If v_cohort_Seg_name is not null Then
1109: -- Bug 2464961 changed 15 to 19 in the following line--
1110: dbms_sql.define_column(vl_legis_cursor, 21, vl_cohort_yr, 25);
1111: End If ;
1112: Begin
1113: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);
1114: Exception
1109: -- Bug 2464961 changed 15 to 19 in the following line--
1110: dbms_sql.define_column(vl_legis_cursor, 21, vl_cohort_yr, 25);
1111: End If ;
1112: Begin
1113: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);
1114: Exception
1115: When Others Then
1116: vp_retcode := sqlcode ;
1117: VP_ERRBUF := 'BAB'||sqlerrm ;
1149:
1150:
1151: RESET_ATTRIBUTES ;
1152:
1153: IF dbms_sql.fetch_rows(vl_legis_cursor) = 0 then
1154: -- fv_utility.debug_mesg('***EXITING SUB LOOP***');
1155: exit;
1156: ELSE
1157: -- Fetch the Records into Variables
1154: -- fv_utility.debug_mesg('***EXITING SUB LOOP***');
1155: exit;
1156: ELSE
1157: -- Fetch the Records into Variables
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1155: exit;
1156: ELSE
1157: -- Fetch the Records into Variables
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1156: ELSE
1157: -- Fetch the Records into Variables
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1157: -- Fetch the Records into Variables
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );
1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1173: --Bug No. 2464961--
1174:
1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1173: --Bug No. 2464961--
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );
1169: --Bug No. 2464961--
1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1173: --Bug No. 2464961--
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1173: --Bug No. 2464961--
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );
1173: --Bug No. 2464961--
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1173: --Bug No. 2464961--
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);
1174:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);
1182:
1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);
1182:
1183:
1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);
1182:
1183:
1184:
1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);
1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);
1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);
1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);
1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);
1182:
1183:
1184:
1185: -- Process Account Number Validation . Just get the Parent acct.
1216:
1217:
1218: If v_cohort_Seg_name is not null Then
1219: --Bug 2598741 Changed to 21 in the following column value
1220: dbms_sql.column_value(vl_legis_cursor, 21, vl_cohort_yr);
1221: End If ;
1222: --Bug 2464961 assigning Null to vl_cohort_yr --
1223: If v_cohort_Seg_name is null Then
1224: vl_cohort_yr := NULL;