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

Line 701: v_cursor := dbms_sql.open_cursor;

697: '|| l_unapp_select
698: || ') ';
699: END IF;
700:
701: v_cursor := dbms_sql.open_cursor;
702:
703: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
704:
705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);

Line 703: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);

699: END IF;
700:
701: v_cursor := dbms_sql.open_cursor;
702:
703: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
704:
705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);
706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:

Line 705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);

701: v_cursor := dbms_sql.open_cursor;
702:
703: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
704:
705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);
706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);

Line 706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);

702:
703: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
704:
705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);
706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);

Line 708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);

704:
705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);
706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);
711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);
712:

Line 709: dbms_sql.define_column(v_cursor, 2, p_end_bal);

705: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_from', p_as_of_date_from);
706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);
711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);
712:
713: l_ignore := dbms_sql.execute(v_cursor);

Line 710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);

706: dbms_sql.bind_variable(v_cursor, ':p_as_of_date_to', p_as_of_date_to);
707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);
711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);
712:
713: l_ignore := dbms_sql.execute(v_cursor);
714:

Line 711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);

707:
708: dbms_sql.define_column(v_cursor, 1, p_begin_bal);
709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);
711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);
712:
713: l_ignore := dbms_sql.execute(v_cursor);
714:
715: LOOP

Line 713: l_ignore := dbms_sql.execute(v_cursor);

709: dbms_sql.define_column(v_cursor, 2, p_end_bal);
710: dbms_sql.define_column(v_cursor, 3, p_acctd_begin_bal);
711: dbms_sql.define_column(v_cursor, 4, p_acctd_end_bal);
712:
713: l_ignore := dbms_sql.execute(v_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);

Line 716: IF dbms_sql.fetch_rows(v_cursor) > 0 then

712:
713: l_ignore := dbms_sql.execute(v_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);
718: dbms_sql.column_value(v_cursor, 2, p_end_bal);
719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);
720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);

Line 717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);

713: l_ignore := dbms_sql.execute(v_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);
718: dbms_sql.column_value(v_cursor, 2, p_end_bal);
719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);
720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);
721: ELSE

Line 718: dbms_sql.column_value(v_cursor, 2, p_end_bal);

714:
715: LOOP
716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);
718: dbms_sql.column_value(v_cursor, 2, p_end_bal);
719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);
720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);
721: ELSE
722: EXIT;

Line 719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);

715: LOOP
716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);
718: dbms_sql.column_value(v_cursor, 2, p_end_bal);
719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);
720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);
721: ELSE
722: EXIT;
723: END IF;

Line 720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);

716: IF dbms_sql.fetch_rows(v_cursor) > 0 then
717: dbms_sql.column_value(v_cursor, 1, p_begin_bal);
718: dbms_sql.column_value(v_cursor, 2, p_end_bal);
719: dbms_sql.column_value(v_cursor, 3, p_acctd_begin_bal);
720: dbms_sql.column_value(v_cursor, 4, p_acctd_end_bal);
721: ELSE
722: EXIT;
723: END IF;
724: END LOOP;

Line 726: dbms_sql.close_cursor(v_cursor);

722: EXIT;
723: END IF;
724: END LOOP;
725:
726: dbms_sql.close_cursor(v_cursor);
727:
728: END aging_as_of;
729:
730: /*-----------------------------------------------------------

Line 856: v_cursor := dbms_sql.open_cursor;

852: '|| l_ard_org_where ||'
853: '||company_segment_where||')';
854: END IF;
855:
856: v_cursor := dbms_sql.open_cursor;
857:
858: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
859:
860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

Line 858: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);

854: END IF;
855:
856: v_cursor := dbms_sql.open_cursor;
857:
858: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
859:
860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:

Line 860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

856: v_cursor := dbms_sql.open_cursor;
857:
858: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
859:
860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);

Line 861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

857:
858: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
859:
860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);

Line 863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);

859:
860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);

Line 864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);

860: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);

Line 865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);

861: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);

Line 866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);

862:
863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);

Line 867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);

863: dbms_sql.define_column(v_cursor, 1, p_fin_chrg_amount);
864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);
871:

Line 868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);

864: dbms_sql.define_column(v_cursor, 2, p_fin_chrg_acctd_amount);
865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);
871:
872: l_ignore := dbms_sql.execute(v_cursor);

Line 869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);

865: dbms_sql.define_column(v_cursor, 3, p_adj_amount);
866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);
871:
872: l_ignore := dbms_sql.execute(v_cursor);
873:

Line 870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);

866: dbms_sql.define_column(v_cursor, 4, p_adj_acctd_amount);
867: dbms_sql.define_column(v_cursor, 5, p_guar_amount);
868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);
871:
872: l_ignore := dbms_sql.execute(v_cursor);
873:
874: LOOP

Line 872: l_ignore := dbms_sql.execute(v_cursor);

868: dbms_sql.define_column(v_cursor, 6, p_guar_acctd_amount);
869: dbms_sql.define_column(v_cursor, 7, p_dep_amount);
870: dbms_sql.define_column(v_cursor, 8, p_dep_acctd_amount);
871:
872: l_ignore := dbms_sql.execute(v_cursor);
873:
874: LOOP
875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);

Line 875: IF dbms_sql.fetch_rows(v_cursor) > 0 then

871:
872: l_ignore := dbms_sql.execute(v_cursor);
873:
874: LOOP
875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);

Line 876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);

872: l_ignore := dbms_sql.execute(v_cursor);
873:
874: LOOP
875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);

Line 877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);

873:
874: LOOP
875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);

Line 878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);

874: LOOP
875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);

Line 879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);

875: IF dbms_sql.fetch_rows(v_cursor) > 0 then
876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);
883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);

Line 880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);

876: dbms_sql.column_value(v_cursor, 1, p_fin_chrg_amount);
877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);
883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);
884: ELSE

Line 881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);

877: dbms_sql.column_value(v_cursor, 2, p_fin_chrg_acctd_amount);
878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);
883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);
884: ELSE
885: EXIT;

Line 882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);

878: dbms_sql.column_value(v_cursor, 3, p_adj_amount);
879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);
883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);
884: ELSE
885: EXIT;
886: END IF;

Line 883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);

879: dbms_sql.column_value(v_cursor, 4, p_adj_acctd_amount);
880: dbms_sql.column_value(v_cursor, 5, p_guar_amount);
881: dbms_sql.column_value(v_cursor, 6, p_guar_acctd_amount);
882: dbms_sql.column_value(v_cursor, 7, p_dep_amount);
883: dbms_sql.column_value(v_cursor, 8, p_dep_acctd_amount);
884: ELSE
885: EXIT;
886: END IF;
887: END LOOP;

Line 890: dbms_sql.parse(v_cursor,l_endorsement_select,DBMS_SQL.NATIVE);

886: END IF;
887: END LOOP;
888:
889: IF nvl(br_enabled_flag,'N') = 'Y' THEN
890: dbms_sql.parse(v_cursor,l_endorsement_select,DBMS_SQL.NATIVE);
891:
892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
894:

Line 892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

888:
889: IF nvl(br_enabled_flag,'N') = 'Y' THEN
890: dbms_sql.parse(v_cursor,l_endorsement_select,DBMS_SQL.NATIVE);
891:
892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
894:
895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);
896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);

Line 893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

889: IF nvl(br_enabled_flag,'N') = 'Y' THEN
890: dbms_sql.parse(v_cursor,l_endorsement_select,DBMS_SQL.NATIVE);
891:
892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
894:
895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);
896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);
897:

Line 895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);

891:
892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
894:
895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);
896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);
897:
898: l_ignore := dbms_sql.execute(v_cursor);
899:

Line 896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);

892: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
893: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
894:
895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);
896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);
897:
898: l_ignore := dbms_sql.execute(v_cursor);
899:
900: LOOP

Line 898: l_ignore := dbms_sql.execute(v_cursor);

894:
895: dbms_sql.define_column(v_cursor, 1, p_endorsmnt_amount);
896: dbms_sql.define_column(v_cursor, 2, p_endorsmnt_acctd_amount);
897:
898: l_ignore := dbms_sql.execute(v_cursor);
899:
900: LOOP
901: IF dbms_sql.fetch_rows(v_cursor) > 0 then
902: dbms_sql.column_value(v_cursor, 1, p_endorsmnt_amount);

Line 901: IF dbms_sql.fetch_rows(v_cursor) > 0 then

897:
898: l_ignore := dbms_sql.execute(v_cursor);
899:
900: LOOP
901: IF dbms_sql.fetch_rows(v_cursor) > 0 then
902: dbms_sql.column_value(v_cursor, 1, p_endorsmnt_amount);
903: dbms_sql.column_value(v_cursor, 2, p_endorsmnt_acctd_amount);
904: ELSE
905: EXIT;

Line 902: dbms_sql.column_value(v_cursor, 1, p_endorsmnt_amount);

898: l_ignore := dbms_sql.execute(v_cursor);
899:
900: LOOP
901: IF dbms_sql.fetch_rows(v_cursor) > 0 then
902: dbms_sql.column_value(v_cursor, 1, p_endorsmnt_amount);
903: dbms_sql.column_value(v_cursor, 2, p_endorsmnt_acctd_amount);
904: ELSE
905: EXIT;
906: END IF;

Line 903: dbms_sql.column_value(v_cursor, 2, p_endorsmnt_acctd_amount);

899:
900: LOOP
901: IF dbms_sql.fetch_rows(v_cursor) > 0 then
902: dbms_sql.column_value(v_cursor, 1, p_endorsmnt_amount);
903: dbms_sql.column_value(v_cursor, 2, p_endorsmnt_acctd_amount);
904: ELSE
905: EXIT;
906: END IF;
907: END LOOP;

Line 910: dbms_sql.close_cursor(v_cursor);

906: END IF;
907: END LOOP;
908: END IF;
909:
910: dbms_sql.close_cursor(v_cursor);
911:
912: END adjustment_register ;
913:
914: /*-----------------------------------------------------------

Line 1028: v_cursor := dbms_sql.open_cursor;

1024: '||l_gl_dist_org_where ||'
1025: '||l_trx_org_where;
1026: END IF;
1027:
1028: v_cursor := dbms_sql.open_cursor;
1029:
1030: dbms_sql.parse(v_cursor,l_post_select ,DBMS_SQL.NATIVE);
1031:
1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

Line 1030: dbms_sql.parse(v_cursor,l_post_select ,DBMS_SQL.NATIVE);

1026: END IF;
1027:
1028: v_cursor := dbms_sql.open_cursor;
1029:
1030: dbms_sql.parse(v_cursor,l_post_select ,DBMS_SQL.NATIVE);
1031:
1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1034:

Line 1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1028: v_cursor := dbms_sql.open_cursor;
1029:
1030: dbms_sql.parse(v_cursor,l_post_select ,DBMS_SQL.NATIVE);
1031:
1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1034:
1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);
1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);

Line 1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1029:
1030: dbms_sql.parse(v_cursor,l_post_select ,DBMS_SQL.NATIVE);
1031:
1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1034:
1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);
1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);
1037:

Line 1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);

1031:
1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1034:
1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);
1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);
1037:
1038: l_ignore := dbms_sql.execute(v_cursor);
1039:

Line 1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);

1032: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1033: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1034:
1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);
1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);
1037:
1038: l_ignore := dbms_sql.execute(v_cursor);
1039:
1040: LOOP

Line 1038: l_ignore := dbms_sql.execute(v_cursor);

1034:
1035: dbms_sql.define_column(v_cursor, 1, p_post_amount);
1036: dbms_sql.define_column(v_cursor, 2, p_post_acctd_amount);
1037:
1038: l_ignore := dbms_sql.execute(v_cursor);
1039:
1040: LOOP
1041: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1042: dbms_sql.column_value(v_cursor, 1, p_post_amount);

Line 1041: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1037:
1038: l_ignore := dbms_sql.execute(v_cursor);
1039:
1040: LOOP
1041: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1042: dbms_sql.column_value(v_cursor, 1, p_post_amount);
1043: dbms_sql.column_value(v_cursor, 2, p_post_acctd_amount);
1044: ELSE
1045: EXIT;

Line 1042: dbms_sql.column_value(v_cursor, 1, p_post_amount);

1038: l_ignore := dbms_sql.execute(v_cursor);
1039:
1040: LOOP
1041: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1042: dbms_sql.column_value(v_cursor, 1, p_post_amount);
1043: dbms_sql.column_value(v_cursor, 2, p_post_acctd_amount);
1044: ELSE
1045: EXIT;
1046: END IF;

Line 1043: dbms_sql.column_value(v_cursor, 2, p_post_acctd_amount);

1039:
1040: LOOP
1041: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1042: dbms_sql.column_value(v_cursor, 1, p_post_amount);
1043: dbms_sql.column_value(v_cursor, 2, p_post_acctd_amount);
1044: ELSE
1045: EXIT;
1046: END IF;
1047: END LOOP;

Line 1049: dbms_sql.parse(v_cursor,l_non_post_select ,DBMS_SQL.NATIVE);

1045: EXIT;
1046: END IF;
1047: END LOOP;
1048:
1049: dbms_sql.parse(v_cursor,l_non_post_select ,DBMS_SQL.NATIVE);
1050:
1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1053:

Line 1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1047: END LOOP;
1048:
1049: dbms_sql.parse(v_cursor,l_non_post_select ,DBMS_SQL.NATIVE);
1050:
1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1053:
1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);
1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);

Line 1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1048:
1049: dbms_sql.parse(v_cursor,l_non_post_select ,DBMS_SQL.NATIVE);
1050:
1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1053:
1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);
1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);
1056:

Line 1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);

1050:
1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1053:
1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);
1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);
1056:
1057: l_ignore := dbms_sql.execute(v_cursor);
1058:

Line 1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);

1051: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1052: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1053:
1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);
1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);
1056:
1057: l_ignore := dbms_sql.execute(v_cursor);
1058:
1059: LOOP

Line 1057: l_ignore := dbms_sql.execute(v_cursor);

1053:
1054: dbms_sql.define_column(v_cursor, 1, p_non_post_amount);
1055: dbms_sql.define_column(v_cursor, 2, p_non_post_acctd_amount);
1056:
1057: l_ignore := dbms_sql.execute(v_cursor);
1058:
1059: LOOP
1060: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1061: dbms_sql.column_value(v_cursor, 1, p_non_post_amount);

Line 1060: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1056:
1057: l_ignore := dbms_sql.execute(v_cursor);
1058:
1059: LOOP
1060: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1061: dbms_sql.column_value(v_cursor, 1, p_non_post_amount);
1062: dbms_sql.column_value(v_cursor, 2, p_non_post_acctd_amount);
1063: ELSE
1064: EXIT;

Line 1061: dbms_sql.column_value(v_cursor, 1, p_non_post_amount);

1057: l_ignore := dbms_sql.execute(v_cursor);
1058:
1059: LOOP
1060: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1061: dbms_sql.column_value(v_cursor, 1, p_non_post_amount);
1062: dbms_sql.column_value(v_cursor, 2, p_non_post_acctd_amount);
1063: ELSE
1064: EXIT;
1065: END IF;

Line 1062: dbms_sql.column_value(v_cursor, 2, p_non_post_acctd_amount);

1058:
1059: LOOP
1060: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1061: dbms_sql.column_value(v_cursor, 1, p_non_post_amount);
1062: dbms_sql.column_value(v_cursor, 2, p_non_post_acctd_amount);
1063: ELSE
1064: EXIT;
1065: END IF;
1066: END LOOP;

Line 1068: dbms_sql.close_cursor(v_cursor);

1064: EXIT;
1065: END IF;
1066: END LOOP;
1067:
1068: dbms_sql.close_cursor(v_cursor);
1069:
1070: END transaction_register ;
1071:
1072: /*-------------------------------------------------

Line 1273: v_cursor := dbms_sql.open_cursor;

1269: AND gc.code_combination_id = ra.code_combination_id
1270: '|| company_segment_where;
1271: END IF;
1272:
1273: v_cursor := dbms_sql.open_cursor;
1274:
1275: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1276:
1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

Line 1275: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);

1271: END IF;
1272:
1273: v_cursor := dbms_sql.open_cursor;
1274:
1275: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1276:
1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:

Line 1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1273: v_cursor := dbms_sql.open_cursor;
1274:
1275: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1276:
1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);

Line 1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1274:
1275: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1276:
1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);

Line 1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);

1276:
1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);

Line 1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);

1277: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);

Line 1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);

1278: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);

Line 1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);

1279:
1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);

Line 1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);

1280: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);

Line 1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);

1281: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);

Line 1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);

1282: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);

Line 1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);

1283: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);

Line 1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);

1284: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);

Line 1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);

1285: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);

Line 1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);

1286: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);

Line 1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);

1287: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);
1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/

Line 1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);

1288: dbms_sql.define_column(v_cursor, 9, p_cm_gain_loss);
1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);

Line 1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);

1289: dbms_sql.define_column(v_cursor, 10, p_app_amount);
1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1297:

Line 1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);

1290: dbms_sql.define_column(v_cursor, 11, p_edisc_amount);
1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1297:
1298: l_ignore := dbms_sql.execute(v_cursor);

Line 1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /bug5290086/

1291: dbms_sql.define_column(v_cursor, 12, p_unedisc_amount);
1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1297:
1298: l_ignore := dbms_sql.execute(v_cursor);
1299:

Line 1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);

1292: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1293: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1297:
1298: l_ignore := dbms_sql.execute(v_cursor);
1299:
1300: LOOP

Line 1298: l_ignore := dbms_sql.execute(v_cursor);

1294: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1295: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1296: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1297:
1298: l_ignore := dbms_sql.execute(v_cursor);
1299:
1300: LOOP
1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);

Line 1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1297:
1298: l_ignore := dbms_sql.execute(v_cursor);
1299:
1300: LOOP
1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);

Line 1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);

1298: l_ignore := dbms_sql.execute(v_cursor);
1299:
1300: LOOP
1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);

Line 1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);

1299:
1300: LOOP
1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);

Line 1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);

1300: LOOP
1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);

Line 1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);

1301: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);

Line 1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);

1302: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);

Line 1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);

1303: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);

Line 1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);

1304: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);

Line 1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);

1305: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);
1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);

Line 1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);

1306: dbms_sql.column_value(v_cursor, 5, p_prepay_amount);
1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);

Line 1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);

1307: dbms_sql.column_value(v_cursor, 6, p_prepay_acctd_amount);
1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);

Line 1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);

1308: dbms_sql.column_value(v_cursor, 7, p_unapp_amount);
1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);

Line 1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);

1309: dbms_sql.column_value(v_cursor, 8, p_unapp_acctd_amount);
1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/

Line 1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);

1310: dbms_sql.column_value(v_cursor, 9, p_cm_gain_loss);
1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);

Line 1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);

1311: dbms_sql.column_value(v_cursor, 10, p_app_amount);
1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1319: ELSE

Line 1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);

1312: dbms_sql.column_value(v_cursor, 11, p_edisc_amount);
1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1319: ELSE
1320: EXIT;

Line 1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /bug5290086/

1313: dbms_sql.column_value(v_cursor, 12, p_unedisc_amount);
1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1319: ELSE
1320: EXIT;
1321: END IF;

Line 1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);

1314: dbms_sql.column_value(v_cursor, 13, p_app_acctd_amount);
1315: dbms_sql.column_value(v_cursor, 14, p_edisc_acctd_amount);
1316: dbms_sql.column_value(v_cursor, 15, p_unedisc_acctd_amount);
1317: dbms_sql.column_value(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1318: dbms_sql.column_value(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1319: ELSE
1320: EXIT;
1321: END IF;
1322: END LOOP;

Line 1324: dbms_sql.close_cursor(v_cursor);

1320: EXIT;
1321: END IF;
1322: END LOOP;
1323:
1324: dbms_sql.close_cursor(v_cursor);
1325:
1326: END cash_receipts_register ;
1327:
1328: /*------------------------------------------------

Line 1422: v_cursor := dbms_sql.open_cursor;

1418: AND gc.code_combination_id = gl_dist.code_combination_id
1419: '||company_segment_where ;
1420: END IF;
1421:
1422: v_cursor := dbms_sql.open_cursor;
1423:
1424: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1425:
1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

Line 1424: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);

1420: END IF;
1421:
1422: v_cursor := dbms_sql.open_cursor;
1423:
1424: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1425:
1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1428:

Line 1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1422: v_cursor := dbms_sql.open_cursor;
1423:
1424: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1425:
1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1428:
1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);

Line 1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1423:
1424: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1425:
1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1428:
1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1431:

Line 1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);

1425:
1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1428:
1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1431:
1432: l_ignore := dbms_sql.execute(v_cursor);
1433:

Line 1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);

1426: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1427: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1428:
1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1431:
1432: l_ignore := dbms_sql.execute(v_cursor);
1433:
1434: LOOP

Line 1432: l_ignore := dbms_sql.execute(v_cursor);

1428:
1429: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1430: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1431:
1432: l_ignore := dbms_sql.execute(v_cursor);
1433:
1434: LOOP
1435: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1436: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);

Line 1435: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1431:
1432: l_ignore := dbms_sql.execute(v_cursor);
1433:
1434: LOOP
1435: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1436: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);
1437: dbms_sql.column_value(v_cursor, 2, p_post_excp_acctd_amount);
1438: ELSE
1439: EXIT;

Line 1436: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);

1432: l_ignore := dbms_sql.execute(v_cursor);
1433:
1434: LOOP
1435: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1436: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);
1437: dbms_sql.column_value(v_cursor, 2, p_post_excp_acctd_amount);
1438: ELSE
1439: EXIT;
1440: END IF;

Line 1437: dbms_sql.column_value(v_cursor, 2, p_post_excp_acctd_amount);

1433:
1434: LOOP
1435: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1436: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);
1437: dbms_sql.column_value(v_cursor, 2, p_post_excp_acctd_amount);
1438: ELSE
1439: EXIT;
1440: END IF;
1441: END LOOP;

Line 1443: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);

1439: EXIT;
1440: END IF;
1441: END LOOP;
1442:
1443: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1444:
1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1447:

Line 1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1441: END LOOP;
1442:
1443: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1444:
1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1447:
1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);

Line 1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1442:
1443: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1444:
1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1447:
1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1450:

Line 1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);

1444:
1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1447:
1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1450:
1451: l_ignore := dbms_sql.execute(v_cursor);
1452:

Line 1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);

1445: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1446: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1447:
1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1450:
1451: l_ignore := dbms_sql.execute(v_cursor);
1452:
1453: LOOP

Line 1451: l_ignore := dbms_sql.execute(v_cursor);

1447:
1448: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1449: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1450:
1451: l_ignore := dbms_sql.execute(v_cursor);
1452:
1453: LOOP
1454: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1455: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);

Line 1454: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1450:
1451: l_ignore := dbms_sql.execute(v_cursor);
1452:
1453: LOOP
1454: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1455: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);
1456: dbms_sql.column_value(v_cursor, 2, p_nonpost_excp_acctd_amount);
1457: ELSE
1458: EXIT;

Line 1455: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);

1451: l_ignore := dbms_sql.execute(v_cursor);
1452:
1453: LOOP
1454: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1455: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);
1456: dbms_sql.column_value(v_cursor, 2, p_nonpost_excp_acctd_amount);
1457: ELSE
1458: EXIT;
1459: END IF;

Line 1456: dbms_sql.column_value(v_cursor, 2, p_nonpost_excp_acctd_amount);

1452:
1453: LOOP
1454: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1455: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);
1456: dbms_sql.column_value(v_cursor, 2, p_nonpost_excp_acctd_amount);
1457: ELSE
1458: EXIT;
1459: END IF;
1460: END LOOP;

Line 1462: dbms_sql.close_cursor(v_cursor);

1458: EXIT;
1459: END IF;
1460: END LOOP;
1461:
1462: dbms_sql.close_cursor(v_cursor);
1463:
1464: END invoice_exceptions ;
1465:
1466: FUNCTION begin_or_end_bal( p_gl_date IN DATE,

Line 1751: v_cursor := dbms_sql.open_cursor;

1747: END IF;
1748:
1749: --Bug7265328 Modifications End}
1750:
1751: v_cursor := dbms_sql.open_cursor;
1752:
1753: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1754:
1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

Line 1753: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);

1749: --Bug7265328 Modifications End}
1750:
1751: v_cursor := dbms_sql.open_cursor;
1752:
1753: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1754:
1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1757:

Line 1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1751: v_cursor := dbms_sql.open_cursor;
1752:
1753: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1754:
1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1757:
1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);

Line 1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1752:
1753: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1754:
1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1757:
1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1760:

Line 1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);

1754:
1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1757:
1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1760:
1761: l_ignore := dbms_sql.execute(v_cursor);
1762:

Line 1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);

1755: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1756: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1757:
1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1760:
1761: l_ignore := dbms_sql.execute(v_cursor);
1762:
1763: LOOP

Line 1761: l_ignore := dbms_sql.execute(v_cursor);

1757:
1758: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1759: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1760:
1761: l_ignore := dbms_sql.execute(v_cursor);
1762:
1763: LOOP
1764: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1765: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);

Line 1764: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1760:
1761: l_ignore := dbms_sql.execute(v_cursor);
1762:
1763: LOOP
1764: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1765: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1766: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1767: ELSE
1768: EXIT;

Line 1765: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);

1761: l_ignore := dbms_sql.execute(v_cursor);
1762:
1763: LOOP
1764: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1765: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1766: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1767: ELSE
1768: EXIT;
1769: END IF;

Line 1766: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);

1762:
1763: LOOP
1764: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1765: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1766: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1767: ELSE
1768: EXIT;
1769: END IF;
1770: END LOOP;

Line 1772: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);

1768: EXIT;
1769: END IF;
1770: END LOOP;
1771:
1772: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1773:
1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1776:

Line 1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1770: END LOOP;
1771:
1772: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1773:
1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1776:
1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);

Line 1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1771:
1772: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1773:
1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1776:
1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1779:

Line 1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);

1773:
1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1776:
1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1779:
1780: l_ignore := dbms_sql.execute(v_cursor);
1781:

Line 1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);

1774: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1775: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1776:
1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1779:
1780: l_ignore := dbms_sql.execute(v_cursor);
1781:
1782: LOOP

Line 1780: l_ignore := dbms_sql.execute(v_cursor);

1776:
1777: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1778: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1779:
1780: l_ignore := dbms_sql.execute(v_cursor);
1781:
1782: LOOP
1783: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1784: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);

Line 1783: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1779:
1780: l_ignore := dbms_sql.execute(v_cursor);
1781:
1782: LOOP
1783: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1784: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);
1785: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);
1786: ELSE
1787: EXIT;

Line 1784: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);

1780: l_ignore := dbms_sql.execute(v_cursor);
1781:
1782: LOOP
1783: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1784: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);
1785: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);
1786: ELSE
1787: EXIT;
1788: END IF;

Line 1785: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);

1781:
1782: LOOP
1783: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1784: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);
1785: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);
1786: ELSE
1787: EXIT;
1788: END IF;
1789: END LOOP;

Line 1791: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);

1787: EXIT;
1788: END IF;
1789: END LOOP;
1790:
1791: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);
1792:
1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1795:

Line 1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1789: END LOOP;
1790:
1791: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);
1792:
1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1795:
1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);

Line 1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1790:
1791: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);
1792:
1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1795:
1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1798:

Line 1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);

1792:
1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1795:
1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1798:
1799: l_ignore := dbms_sql.execute(v_cursor);
1800:

Line 1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);

1793: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1794: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1795:
1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1798:
1799: l_ignore := dbms_sql.execute(v_cursor);
1800:
1801: LOOP

Line 1799: l_ignore := dbms_sql.execute(v_cursor);

1795:
1796: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1797: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1798:
1799: l_ignore := dbms_sql.execute(v_cursor);
1800:
1801: LOOP
1802: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1803: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);

Line 1802: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1798:
1799: l_ignore := dbms_sql.execute(v_cursor);
1800:
1801: LOOP
1802: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1803: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);
1804: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);
1805: ELSE
1806: EXIT;

Line 1803: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);

1799: l_ignore := dbms_sql.execute(v_cursor);
1800:
1801: LOOP
1802: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1803: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);
1804: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);
1805: ELSE
1806: EXIT;
1807: END IF;

Line 1804: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);

1800:
1801: LOOP
1802: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1803: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);
1804: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);
1805: ELSE
1806: EXIT;
1807: END IF;
1808: END LOOP;

Line 1810: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);

1806: EXIT;
1807: END IF;
1808: END LOOP;
1809:
1810: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);
1811:
1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1814:

Line 1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1808: END LOOP;
1809:
1810: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);
1811:
1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1814:
1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);

Line 1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1809:
1810: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);
1811:
1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1814:
1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1817:

Line 1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);

1811:
1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1814:
1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1817:
1818: l_ignore := dbms_sql.execute(v_cursor);
1819:

Line 1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);

1812: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1813: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1814:
1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1817:
1818: l_ignore := dbms_sql.execute(v_cursor);
1819:
1820: LOOP

Line 1818: l_ignore := dbms_sql.execute(v_cursor);

1814:
1815: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1816: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1817:
1818: l_ignore := dbms_sql.execute(v_cursor);
1819:
1820: LOOP
1821: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1822: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);

Line 1821: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1817:
1818: l_ignore := dbms_sql.execute(v_cursor);
1819:
1820: LOOP
1821: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1822: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);
1823: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);
1824: ELSE
1825: EXIT;

Line 1822: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);

1818: l_ignore := dbms_sql.execute(v_cursor);
1819:
1820: LOOP
1821: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1822: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);
1823: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);
1824: ELSE
1825: EXIT;
1826: END IF;

Line 1823: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);

1819:
1820: LOOP
1821: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1822: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);
1823: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);
1824: ELSE
1825: EXIT;
1826: END IF;
1827: END LOOP;

Line 1829: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);

1825: EXIT;
1826: END IF;
1827: END LOOP;
1828:
1829: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);
1830:
1831: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1833:

Line 1831: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

1827: END LOOP;
1828:
1829: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);
1830:
1831: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1833:
1834: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1835:

Line 1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);

1828:
1829: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);
1830:
1831: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1833:
1834: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1835:
1836: l_ignore := dbms_sql.execute(v_cursor);

Line 1834: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);

1830:
1831: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1833:
1834: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1835:
1836: l_ignore := dbms_sql.execute(v_cursor);
1837:
1838: LOOP

Line 1836: l_ignore := dbms_sql.execute(v_cursor);

1832: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1833:
1834: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1835:
1836: l_ignore := dbms_sql.execute(v_cursor);
1837:
1838: LOOP
1839: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1840: dbms_sql.column_value(v_cursor, 1,p_cm_journal_acctd_amt);

Line 1839: IF dbms_sql.fetch_rows(v_cursor) > 0 then

1835:
1836: l_ignore := dbms_sql.execute(v_cursor);
1837:
1838: LOOP
1839: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1840: dbms_sql.column_value(v_cursor, 1,p_cm_journal_acctd_amt);
1841: ELSE
1842: EXIT;
1843: END IF;

Line 1840: dbms_sql.column_value(v_cursor, 1,p_cm_journal_acctd_amt);

1836: l_ignore := dbms_sql.execute(v_cursor);
1837:
1838: LOOP
1839: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1840: dbms_sql.column_value(v_cursor, 1,p_cm_journal_acctd_amt);
1841: ELSE
1842: EXIT;
1843: END IF;
1844: END LOOP;

Line 1846: dbms_sql.close_cursor(v_cursor);

1842: EXIT;
1843: END IF;
1844: END LOOP;
1845:
1846: dbms_sql.close_cursor(v_cursor);
1847:
1848: END journal_reports;
1849:
1850: