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

Line 717: insert_gt := dbms_sql.open_cursor;

713: END IF;
714:
715: l_insert_stmt := l_insert_stmt || l_from_clause || l_where_clause;
716: log('Insert Statement : ' || l_insert_stmt);
717: insert_gt := dbms_sql.open_cursor;
718: dbms_sql.parse (insert_gt,l_insert_stmt,dbms_sql.v7);
719:
720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);
721: IF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) > 0 THEN

Line 718: dbms_sql.parse (insert_gt,l_insert_stmt,dbms_sql.v7);

714:
715: l_insert_stmt := l_insert_stmt || l_from_clause || l_where_clause;
716: log('Insert Statement : ' || l_insert_stmt);
717: insert_gt := dbms_sql.open_cursor;
718: dbms_sql.parse (insert_gt,l_insert_stmt,dbms_sql.v7);
719:
720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);
721: IF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) > 0 THEN
722: dbms_sql.bind_variable ( insert_gt, ':b_transmission_id', p_transmission_id);

Line 720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);

716: log('Insert Statement : ' || l_insert_stmt);
717: insert_gt := dbms_sql.open_cursor;
718: dbms_sql.parse (insert_gt,l_insert_stmt,dbms_sql.v7);
719:
720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);
721: IF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) > 0 THEN
722: dbms_sql.bind_variable ( insert_gt, ':b_transmission_id', p_transmission_id);
723: ELSIF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) <= 0 THEN
724: dbms_sql.bind_variable ( insert_gt, ':b_batch_id', p_batch_id);

Line 722: dbms_sql.bind_variable ( insert_gt, ':b_transmission_id', p_transmission_id);

718: dbms_sql.parse (insert_gt,l_insert_stmt,dbms_sql.v7);
719:
720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);
721: IF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) > 0 THEN
722: dbms_sql.bind_variable ( insert_gt, ':b_transmission_id', p_transmission_id);
723: ELSIF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) <= 0 THEN
724: dbms_sql.bind_variable ( insert_gt, ':b_batch_id', p_batch_id);
725: ELSE
726: IF p_receipt_no_l IS NOT NULL THEN

Line 724: dbms_sql.bind_variable ( insert_gt, ':b_batch_id', p_batch_id);

720: dbms_sql.bind_variable ( insert_gt, ':b_total_workers', p_total_workers);
721: IF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) > 0 THEN
722: dbms_sql.bind_variable ( insert_gt, ':b_transmission_id', p_transmission_id);
723: ELSIF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) <= 0 THEN
724: dbms_sql.bind_variable ( insert_gt, ':b_batch_id', p_batch_id);
725: ELSE
726: IF p_receipt_no_l IS NOT NULL THEN
727: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_l', p_receipt_no_l);
728: END IF;

Line 727: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_l', p_receipt_no_l);

723: ELSIF p_called_from = 'ARCABP' and NVL(p_transmission_id, -1) <= 0 THEN
724: dbms_sql.bind_variable ( insert_gt, ':b_batch_id', p_batch_id);
725: ELSE
726: IF p_receipt_no_l IS NOT NULL THEN
727: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_l', p_receipt_no_l);
728: END IF;
729: IF p_receipt_no_h IS NOT NULL THEN
730: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_h', p_receipt_no_h);
731: END IF;

Line 730: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_h', p_receipt_no_h);

726: IF p_receipt_no_l IS NOT NULL THEN
727: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_l', p_receipt_no_l);
728: END IF;
729: IF p_receipt_no_h IS NOT NULL THEN
730: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_h', p_receipt_no_h);
731: END IF;
732: IF p_batch_name_l IS NOT NULL THEN
733: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_l', p_batch_name_l);
734: END IF;

Line 733: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_l', p_batch_name_l);

729: IF p_receipt_no_h IS NOT NULL THEN
730: dbms_sql.bind_variable ( insert_gt, ':b_receipt_no_h', p_receipt_no_h);
731: END IF;
732: IF p_batch_name_l IS NOT NULL THEN
733: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_l', p_batch_name_l);
734: END IF;
735: IF p_batch_name_h IS NOT NULL THEN
736: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_h', p_batch_name_h);
737: END IF;

Line 736: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_h', p_batch_name_h);

732: IF p_batch_name_l IS NOT NULL THEN
733: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_l', p_batch_name_l);
734: END IF;
735: IF p_batch_name_h IS NOT NULL THEN
736: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_h', p_batch_name_h);
737: END IF;
738: IF p_min_unapp_amt IS NOT NULL THEN
739: dbms_sql.bind_variable ( insert_gt, ':b_min_unapp_amt', p_min_unapp_amt);
740: END IF;

Line 739: dbms_sql.bind_variable ( insert_gt, ':b_min_unapp_amt', p_min_unapp_amt);

735: IF p_batch_name_h IS NOT NULL THEN
736: dbms_sql.bind_variable ( insert_gt, ':b_batch_name_h', p_batch_name_h);
737: END IF;
738: IF p_min_unapp_amt IS NOT NULL THEN
739: dbms_sql.bind_variable ( insert_gt, ':b_min_unapp_amt', p_min_unapp_amt);
740: END IF;
741: IF p_receipt_date_l IS NOT NULL THEN
742: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_l', l_receipt_date_low);
743: END IF;

Line 742: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_l', l_receipt_date_low);

738: IF p_min_unapp_amt IS NOT NULL THEN
739: dbms_sql.bind_variable ( insert_gt, ':b_min_unapp_amt', p_min_unapp_amt);
740: END IF;
741: IF p_receipt_date_l IS NOT NULL THEN
742: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_l', l_receipt_date_low);
743: END IF;
744: IF p_receipt_date_h IS NOT NULL THEN
745: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_h', l_receipt_date_high);
746: END IF;

Line 745: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_h', l_receipt_date_high);

741: IF p_receipt_date_l IS NOT NULL THEN
742: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_l', l_receipt_date_low);
743: END IF;
744: IF p_receipt_date_h IS NOT NULL THEN
745: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_h', l_receipt_date_high);
746: END IF;
747: IF p_receipt_method_l IS NOT NULL THEN
748: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_l', p_receipt_method_l);
749: END IF;

Line 748: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_l', p_receipt_method_l);

744: IF p_receipt_date_h IS NOT NULL THEN
745: dbms_sql.bind_variable ( insert_gt, ':b_receipt_date_h', l_receipt_date_high);
746: END IF;
747: IF p_receipt_method_l IS NOT NULL THEN
748: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_l', p_receipt_method_l);
749: END IF;
750: IF p_receipt_method_h IS NOT NULL THEN
751: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_h', p_receipt_method_h);
752: END IF;

Line 751: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_h', p_receipt_method_h);

747: IF p_receipt_method_l IS NOT NULL THEN
748: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_l', p_receipt_method_l);
749: END IF;
750: IF p_receipt_method_h IS NOT NULL THEN
751: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_h', p_receipt_method_h);
752: END IF;
753: IF p_customer_name_l IS NOT NULL THEN
754: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_l', p_customer_name_l);
755: END IF;

Line 754: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_l', p_customer_name_l);

750: IF p_receipt_method_h IS NOT NULL THEN
751: dbms_sql.bind_variable ( insert_gt, ':b_receipt_method_h', p_receipt_method_h);
752: END IF;
753: IF p_customer_name_l IS NOT NULL THEN
754: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_l', p_customer_name_l);
755: END IF;
756: IF p_customer_name_h IS NOT NULL THEN
757: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_h', p_customer_name_h);
758: END IF;

Line 757: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_h', p_customer_name_h);

753: IF p_customer_name_l IS NOT NULL THEN
754: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_l', p_customer_name_l);
755: END IF;
756: IF p_customer_name_h IS NOT NULL THEN
757: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_h', p_customer_name_h);
758: END IF;
759: IF p_customer_no_l IS NOT NULL THEN
760: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_l', p_customer_no_l);
761: END IF;

Line 760: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_l', p_customer_no_l);

756: IF p_customer_name_h IS NOT NULL THEN
757: dbms_sql.bind_variable ( insert_gt, ':b_customer_name_h', p_customer_name_h);
758: END IF;
759: IF p_customer_no_l IS NOT NULL THEN
760: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_l', p_customer_no_l);
761: END IF;
762: IF p_customer_no_h IS NOT NULL THEN
763: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_h', p_customer_no_h);
764: END IF;

Line 763: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_h', p_customer_no_h);

759: IF p_customer_no_l IS NOT NULL THEN
760: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_l', p_customer_no_l);
761: END IF;
762: IF p_customer_no_h IS NOT NULL THEN
763: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_h', p_customer_no_h);
764: END IF;
765: END IF;
766:
767: l_rows_inserted := dbms_sql.execute( insert_gt);

Line 767: l_rows_inserted := dbms_sql.execute( insert_gt);

763: dbms_sql.bind_variable ( insert_gt, ':b_customer_no_h', p_customer_no_h);
764: END IF;
765: END IF;
766:
767: l_rows_inserted := dbms_sql.execute( insert_gt);
768:
769: /* * Mark the rows with status 'AR_AA_RULE_SET_INACTIVE' if the *
770: * rule set provided in the receipt is not active as per the *
771: * receipt date. These references will not be processed further *