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 699: v_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 724: dbms_sql.close_cursor(v_cursor);

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

Line 853: v_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 907: dbms_sql.close_cursor(v_cursor);

903: END IF;
904: END LOOP;
905: END IF;
906:
907: dbms_sql.close_cursor(v_cursor);
908:
909: END adjustment_register ;
910:
911: /*-----------------------------------------------------------

Line 1025: v_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1065: dbms_sql.close_cursor(v_cursor);

1061: EXIT;
1062: END IF;
1063: END LOOP;
1064:
1065: dbms_sql.close_cursor(v_cursor);
1066:
1067: END transaction_register ;
1068:
1069: /*-------------------------------------------------

Line 1269: v_cursor := dbms_sql.open_cursor;

1265: AND gc.code_combination_id = ra.code_combination_id
1266: '|| company_segment_where;
1267: END IF;
1268:
1269: v_cursor := dbms_sql.open_cursor;
1270:
1271: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1272:
1273: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

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

1267: END IF;
1268:
1269: v_cursor := dbms_sql.open_cursor;
1270:
1271: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1272:
1273: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1274: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1275:

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

1269: v_cursor := dbms_sql.open_cursor;
1270:
1271: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1272:
1273: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1274: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1275:
1276: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1277: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);

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

1270:
1271: dbms_sql.parse(v_cursor,l_main_select,DBMS_SQL.NATIVE);
1272:
1273: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1274: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1275:
1276: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1277: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1278: dbms_sql.define_column(v_cursor, 3, p_claim_amount);

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

1272:
1273: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1274: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1275:
1276: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1277: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1278: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1279: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1280: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);

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

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

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

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

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

1275:
1276: dbms_sql.define_column(v_cursor, 1, p_acc_amount);
1277: dbms_sql.define_column(v_cursor, 2, p_acc_acctd_amount);
1278: dbms_sql.define_column(v_cursor, 3, p_claim_amount);
1279: dbms_sql.define_column(v_cursor, 4, p_claim_acctd_amount);
1280: dbms_sql.define_column(v_cursor, 5, p_prepay_amount);
1281: dbms_sql.define_column(v_cursor, 6, p_prepay_acctd_amount);
1282: dbms_sql.define_column(v_cursor, 7, p_unapp_amount);
1283: dbms_sql.define_column(v_cursor, 8, p_unapp_acctd_amount);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1288: dbms_sql.define_column(v_cursor, 13, p_app_acctd_amount);
1289: dbms_sql.define_column(v_cursor, 14, p_edisc_acctd_amount);
1290: dbms_sql.define_column(v_cursor, 15, p_unedisc_acctd_amount);
1291: dbms_sql.define_column(v_cursor, 16, p_on_acc_cm_ref_amount); /*bug5290086*/
1292: dbms_sql.define_column(v_cursor, 17, p_on_acc_cm_ref_acctd_amount);
1293:
1294: l_ignore := dbms_sql.execute(v_cursor);
1295:
1296: LOOP

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

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

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

1293:
1294: l_ignore := dbms_sql.execute(v_cursor);
1295:
1296: LOOP
1297: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1298: dbms_sql.column_value(v_cursor, 1, p_acc_amount);
1299: dbms_sql.column_value(v_cursor, 2, p_acc_acctd_amount);
1300: dbms_sql.column_value(v_cursor, 3, p_claim_amount);
1301: dbms_sql.column_value(v_cursor, 4, p_claim_acctd_amount);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1320: dbms_sql.close_cursor(v_cursor);

1316: EXIT;
1317: END IF;
1318: END LOOP;
1319:
1320: dbms_sql.close_cursor(v_cursor);
1321:
1322: END cash_receipts_register ;
1323:
1324: /*------------------------------------------------

Line 1418: v_cursor := dbms_sql.open_cursor;

1414: AND gc.code_combination_id = gl_dist.code_combination_id
1415: '||company_segment_where ;
1416: END IF;
1417:
1418: v_cursor := dbms_sql.open_cursor;
1419:
1420: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1421:
1422: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

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

1416: END IF;
1417:
1418: v_cursor := dbms_sql.open_cursor;
1419:
1420: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1421:
1422: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1423: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1424:

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

1418: v_cursor := dbms_sql.open_cursor;
1419:
1420: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1421:
1422: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1423: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1424:
1425: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1426: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);

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

1419:
1420: dbms_sql.parse(v_cursor,l_post_select,DBMS_SQL.NATIVE);
1421:
1422: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1423: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1424:
1425: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1426: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1427:

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

1421:
1422: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1423: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1424:
1425: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1426: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1427:
1428: l_ignore := dbms_sql.execute(v_cursor);
1429:

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

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

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

1424:
1425: dbms_sql.define_column(v_cursor, 1, p_post_excp_amount);
1426: dbms_sql.define_column(v_cursor, 2, p_post_excp_acctd_amount);
1427:
1428: l_ignore := dbms_sql.execute(v_cursor);
1429:
1430: LOOP
1431: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1432: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);

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

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

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

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

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

1429:
1430: LOOP
1431: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1432: dbms_sql.column_value(v_cursor, 1, p_post_excp_amount);
1433: dbms_sql.column_value(v_cursor, 2, p_post_excp_acctd_amount);
1434: ELSE
1435: EXIT;
1436: END IF;
1437: END LOOP;

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

1435: EXIT;
1436: END IF;
1437: END LOOP;
1438:
1439: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1440:
1441: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1442: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1443:

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

1437: END LOOP;
1438:
1439: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1440:
1441: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1442: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1443:
1444: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1445: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);

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

1438:
1439: dbms_sql.parse(v_cursor,l_non_post_select,DBMS_SQL.NATIVE);
1440:
1441: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1442: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1443:
1444: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1445: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1446:

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

1440:
1441: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1442: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1443:
1444: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1445: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1446:
1447: l_ignore := dbms_sql.execute(v_cursor);
1448:

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

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

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

1443:
1444: dbms_sql.define_column(v_cursor, 1, p_nonpost_excp_amount);
1445: dbms_sql.define_column(v_cursor, 2, p_nonpost_excp_acctd_amount);
1446:
1447: l_ignore := dbms_sql.execute(v_cursor);
1448:
1449: LOOP
1450: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1451: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);

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

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

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

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

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

1448:
1449: LOOP
1450: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1451: dbms_sql.column_value(v_cursor, 1, p_nonpost_excp_amount);
1452: dbms_sql.column_value(v_cursor, 2, p_nonpost_excp_acctd_amount);
1453: ELSE
1454: EXIT;
1455: END IF;
1456: END LOOP;

Line 1458: dbms_sql.close_cursor(v_cursor);

1454: EXIT;
1455: END IF;
1456: END LOOP;
1457:
1458: dbms_sql.close_cursor(v_cursor);
1459:
1460: END invoice_exceptions ;
1461:
1462: FUNCTION begin_or_end_bal( p_gl_date IN DATE,

Line 1734: v_cursor := dbms_sql.open_cursor;

1730: END IF;
1731:
1732: --Bug7265328 Modifications End}
1733:
1734: v_cursor := dbms_sql.open_cursor;
1735:
1736: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1737:
1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);

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

1732: --Bug7265328 Modifications End}
1733:
1734: v_cursor := dbms_sql.open_cursor;
1735:
1736: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1737:
1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1739: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1740:

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

1734: v_cursor := dbms_sql.open_cursor;
1735:
1736: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1737:
1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1739: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1740:
1741: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1742: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);

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

1735:
1736: dbms_sql.parse(v_cursor,l_sales_journal_salect,DBMS_SQL.NATIVE);
1737:
1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1739: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1740:
1741: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1742: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1743:

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

1737:
1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1739: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1740:
1741: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1742: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1743:
1744: l_ignore := dbms_sql.execute(v_cursor);
1745:

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

1738: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1739: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1740:
1741: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1742: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1743:
1744: l_ignore := dbms_sql.execute(v_cursor);
1745:
1746: LOOP

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

1740:
1741: dbms_sql.define_column(v_cursor, 1, p_sales_journal_amt);
1742: dbms_sql.define_column(v_cursor, 2, p_sales_journal_acctd_amt);
1743:
1744: l_ignore := dbms_sql.execute(v_cursor);
1745:
1746: LOOP
1747: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1748: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);

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

1743:
1744: l_ignore := dbms_sql.execute(v_cursor);
1745:
1746: LOOP
1747: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1748: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1749: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1750: ELSE
1751: EXIT;

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

1744: l_ignore := dbms_sql.execute(v_cursor);
1745:
1746: LOOP
1747: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1748: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1749: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1750: ELSE
1751: EXIT;
1752: END IF;

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

1745:
1746: LOOP
1747: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1748: dbms_sql.column_value(v_cursor, 1, p_sales_journal_amt);
1749: dbms_sql.column_value(v_cursor, 2, p_sales_journal_acctd_amt);
1750: ELSE
1751: EXIT;
1752: END IF;
1753: END LOOP;

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

1751: EXIT;
1752: END IF;
1753: END LOOP;
1754:
1755: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1756:
1757: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1758: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1759:

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

1753: END LOOP;
1754:
1755: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1756:
1757: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1758: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1759:
1760: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1761: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);

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

1754:
1755: dbms_sql.parse(v_cursor,l_adj_journal_select,DBMS_SQL.NATIVE);
1756:
1757: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1758: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1759:
1760: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1761: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1762:

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

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

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

1757: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1758: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1759:
1760: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1761: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1762:
1763: l_ignore := dbms_sql.execute(v_cursor);
1764:
1765: LOOP

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

1759:
1760: dbms_sql.define_column(v_cursor, 1, p_adj_journal_amt);
1761: dbms_sql.define_column(v_cursor, 2, p_adj_journal_acctd_amt);
1762:
1763: l_ignore := dbms_sql.execute(v_cursor);
1764:
1765: LOOP
1766: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1767: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);

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

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

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

1763: l_ignore := dbms_sql.execute(v_cursor);
1764:
1765: LOOP
1766: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1767: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);
1768: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);
1769: ELSE
1770: EXIT;
1771: END IF;

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

1764:
1765: LOOP
1766: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1767: dbms_sql.column_value(v_cursor, 1, p_adj_journal_amt);
1768: dbms_sql.column_value(v_cursor, 2, p_adj_journal_acctd_amt);
1769: ELSE
1770: EXIT;
1771: END IF;
1772: END LOOP;

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

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

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

1772: END LOOP;
1773:
1774: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);
1775:
1776: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1777: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1778:
1779: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1780: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);

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

1773:
1774: dbms_sql.parse(v_cursor,l_app_journal_select,DBMS_SQL.NATIVE);
1775:
1776: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1777: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1778:
1779: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1780: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1781:

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

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

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

1776: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1777: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1778:
1779: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1780: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1781:
1782: l_ignore := dbms_sql.execute(v_cursor);
1783:
1784: LOOP

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

1778:
1779: dbms_sql.define_column(v_cursor, 1, p_app_journal_amt);
1780: dbms_sql.define_column(v_cursor, 2, p_app_journal_acctd_amt);
1781:
1782: l_ignore := dbms_sql.execute(v_cursor);
1783:
1784: LOOP
1785: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1786: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);

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

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

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

1782: l_ignore := dbms_sql.execute(v_cursor);
1783:
1784: LOOP
1785: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1786: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);
1787: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);
1788: ELSE
1789: EXIT;
1790: END IF;

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

1783:
1784: LOOP
1785: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1786: dbms_sql.column_value(v_cursor, 1, p_app_journal_amt);
1787: dbms_sql.column_value(v_cursor, 2, p_app_journal_acctd_amt);
1788: ELSE
1789: EXIT;
1790: END IF;
1791: END LOOP;

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

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

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

1791: END LOOP;
1792:
1793: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);
1794:
1795: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1796: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1797:
1798: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1799: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);

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

1792:
1793: dbms_sql.parse(v_cursor,l_unapp_journal_select,DBMS_SQL.NATIVE);
1794:
1795: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1796: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1797:
1798: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1799: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1800:

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

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

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

1795: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1796: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1797:
1798: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1799: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1800:
1801: l_ignore := dbms_sql.execute(v_cursor);
1802:
1803: LOOP

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

1797:
1798: dbms_sql.define_column(v_cursor, 1, p_unapp_journal_amt);
1799: dbms_sql.define_column(v_cursor, 2, p_unapp_journal_acctd_amt);
1800:
1801: l_ignore := dbms_sql.execute(v_cursor);
1802:
1803: LOOP
1804: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1805: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);

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

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

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

1801: l_ignore := dbms_sql.execute(v_cursor);
1802:
1803: LOOP
1804: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1805: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);
1806: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);
1807: ELSE
1808: EXIT;
1809: END IF;

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

1802:
1803: LOOP
1804: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1805: dbms_sql.column_value(v_cursor, 1, p_unapp_journal_amt);
1806: dbms_sql.column_value(v_cursor, 2, p_unapp_journal_acctd_amt);
1807: ELSE
1808: EXIT;
1809: END IF;
1810: END LOOP;

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

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

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

1810: END LOOP;
1811:
1812: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);
1813:
1814: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1815: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1816:
1817: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1818:

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

1811:
1812: dbms_sql.parse(v_cursor,l_cm_journal_select,DBMS_SQL.NATIVE);
1813:
1814: dbms_sql.bind_variable(v_cursor, ':gl_date_low', p_gl_date_low);
1815: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1816:
1817: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1818:
1819: l_ignore := dbms_sql.execute(v_cursor);

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

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

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

1815: dbms_sql.bind_variable(v_cursor, ':gl_date_high', p_gl_date_high);
1816:
1817: dbms_sql.define_column(v_cursor, 1,p_cm_journal_acctd_amt);
1818:
1819: l_ignore := dbms_sql.execute(v_cursor);
1820:
1821: LOOP
1822: IF dbms_sql.fetch_rows(v_cursor) > 0 then
1823: dbms_sql.column_value(v_cursor, 1,p_cm_journal_acctd_amt);

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

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

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

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

Line 1829: dbms_sql.close_cursor(v_cursor);

1825: EXIT;
1826: END IF;
1827: END LOOP;
1828:
1829: dbms_sql.close_cursor(v_cursor);
1830:
1831: END journal_reports;
1832:
1833: