DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on DBMS_SQL

Line 672: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;

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 ;

Line 733: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;

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 ;

Line 744: dbms_sql.define_column(vl_main_cursor, 1, v_acct_num, 25);

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 ;

Line 745: dbms_sql.define_column(vl_main_cursor, 2, v_fund_val, 25);

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:

Line 747: dbms_sql.define_column(vl_main_cursor, 3, vl_cohort_yr, 25);

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);

Line 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 ;

Line 773: vl_main_fetch := dbms_sql.fetch_rows(vl_main_cursor) ;

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';

Line 787: dbms_sql.column_value(vl_main_cursor, 1, v_acct_num);

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);

Line 788: dbms_sql.column_value(vl_main_cursor, 2, v_fund_val);

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 ;

Line 791: dbms_sql.column_value(vl_main_cursor, 3, vl_cohort_yr);

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: ------------------------------------------------------------

Line 798: vl_amount_cursor := DBMS_SQL.OPEN_CURSOR ;

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 ]';

Line 840: dbms_sql.parse(vl_amount_cursor,vl_amount_select,DBMS_SQL.V7);

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 ;

Line 850: dbms_sql.define_column(vl_amount_cursor, 1, vl_new_amount);

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

Line 853: vl_amount_ret := dbms_sql.execute(vl_amount_cursor);

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]' ;

Line 862: vl_amount_fetch := dbms_sql.fetch_rows(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:

Line 863: dbms_sql.column_Value(vl_amount_cursor, 1, vl_new_amount );

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)) ;

Line 951: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;

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 ;

Line 1072: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);

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 ;

Line 1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);

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 );

Line 1083: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_ref, 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 );

Line 1084: dbms_sql.define_column(vl_legis_cursor, 3, vl_legis_ref1, 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 );

Line 1085: dbms_sql.define_column(vl_legis_cursor, 4, vl_legis_ref2, 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 );

Line 1086: dbms_sql.define_column(vl_legis_cursor, 5, vl_legis_ref3, 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);

Line 1087: dbms_sql.define_column(vl_legis_cursor, 6, vl_legis_ref4, 240 );

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);

Line 1088: dbms_sql.define_column(vl_legis_cursor, 7, vl_legis_ref5, 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);
1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);

Line 1089: dbms_sql.define_column(vl_legis_cursor, 8, vl_legis_ref9, 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);
1093:

Line 1090: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_date);

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--

Line 1091: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_Category,25);

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 );

Line 1092: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_Source,25);

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 );

Line 1095: dbms_sql.define_column(vl_legis_cursor, 12, vl_legis_amount_dr );

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:

Line 1096: dbms_sql.define_column(vl_legis_cursor, 13, vl_legis_amount_cr );

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 );

Line 1097: --dbms_sql.define_column(vl_legis_cursor, 11, vl_legis_amount );

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);

Line 1100: dbms_sql.define_column(vl_legis_cursor, 14, vl_je_name, 100 );

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);

Line 1101: dbms_sql.define_column(vl_legis_cursor, 15, v_acct_num, 25);

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);

Line 1102: dbms_sql.define_column(vl_legis_cursor, 16, v_fund_val, 25);

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);

Line 1103: dbms_sql.define_column(vl_legis_cursor, 17, v_ccid);

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:

Line 1104: dbms_sql.define_column(vl_legis_cursor, 18, vl_doc_created_by);

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

Line 1105: dbms_sql.define_column(vl_legis_cursor, 19, vl_doc_creation_date);

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--

Line 1106: dbms_sql.define_column(vl_legis_cursor, 20, v_seg_fiscal_yr,4);

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);

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

Line 1113: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);

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 ;

Line 1153: IF dbms_sql.fetch_rows(vl_legis_cursor) = 0 then

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

Line 1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );

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 );

Line 1159: dbms_sql.column_value(vl_legis_cursor, 2 , vl_legis_ref );

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 );

Line 1160: dbms_sql.column_value(vl_legis_cursor, 3 , vl_legis_ref1 );

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 );

Line 1161: dbms_sql.column_value(vl_legis_cursor, 4, vl_legis_ref2 );

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 );

Line 1162: dbms_sql.column_value(vl_legis_cursor, 5, vl_legis_ref3 );

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 );

Line 1163: dbms_sql.column_value(vl_legis_cursor, 6, vl_legis_ref4 );

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 );

Line 1164: dbms_sql.column_value(vl_legis_cursor, 7, vl_legis_ref5 );

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 );

Line 1165: dbms_sql.column_value(vl_legis_cursor, 8, vl_legis_ref9 );

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--

Line 1166: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_date );

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 );

Line 1167: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_category );

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 );

Line 1168: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_source );

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 );

Line 1170: dbms_sql.column_Value(vl_legis_cursor, 12, vl_legis_amount_dr );

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:

Line 1171: dbms_sql.column_Value(vl_legis_cursor, 13, vl_legis_amount_cr );

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 );

Line 1172: --dbms_sql.column_Value(vl_legis_cursor, 11, vl_legis_amount );

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);

Line 1175: dbms_sql.column_value(vl_legis_cursor, 14, vl_je_name );

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);

Line 1176: dbms_sql.column_value(vl_legis_cursor, 15, v_acct_num);

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);

Line 1177: dbms_sql.column_value(vl_legis_cursor, 16, v_fund_val);

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);

Line 1178: dbms_sql.column_value(vl_legis_cursor, 17, v_ccid);

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:

Line 1179: dbms_sql.column_value(vl_legis_cursor, 18, vl_doc_created_by);

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:

Line 1180: dbms_sql.column_value(vl_legis_cursor, 19, vl_doc_creation_date);

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:

Line 1181: dbms_sql.column_value(vl_legis_cursor, 20, v_seg_fiscal_yr);

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.

Line 1220: dbms_sql.column_value(vl_legis_cursor, 21, vl_cohort_yr);

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;