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

Line 719: g_cursor_select_grp := dbms_sql.open_cursor;

715: cust_trx_type_id,
716: org_id
717: FROM ('||Q_Billitem_grp||')
718: WHERE legal_entity_id IS NULL';
719: g_cursor_select_grp := dbms_sql.open_cursor;
720: dbms_sql.parse(g_cursor_select_grp,Q_select_grp,dbms_sql.native);
721: do_binding (g_cursor_select_grp
722: ,p_lease_num_low
723: ,p_lease_num_high

Line 720: dbms_sql.parse(g_cursor_select_grp,Q_select_grp,dbms_sql.native);

716: org_id
717: FROM ('||Q_Billitem_grp||')
718: WHERE legal_entity_id IS NULL';
719: g_cursor_select_grp := dbms_sql.open_cursor;
720: dbms_sql.parse(g_cursor_select_grp,Q_select_grp,dbms_sql.native);
721: do_binding (g_cursor_select_grp
722: ,p_lease_num_low
723: ,p_lease_num_high
724: ,p_sch_dt_low

Line 736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);

732: ,p_customer_id
733: ,p_grp_param
734: );
735:
736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);

Line 737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);

733: ,p_grp_param
734: );
735:
736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
741:

Line 738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);

734: );
735:
736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
741:
742: LOOP

Line 739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);

735:
736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
741:
742: LOOP
743: BEGIN

Line 740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);

736: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
737: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
738: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
739: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
741:
742: LOOP
743: BEGIN
744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);

Line 744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);

740: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
741:
742: LOOP
743: BEGIN
744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
745: EXIT WHEN l_count_select_grp <> 1;
746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);

Line 746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));

742: LOOP
743: BEGIN
744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
745: EXIT WHEN l_count_select_grp <> 1;
746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
750: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

Line 747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);

743: BEGIN
744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
745: EXIT WHEN l_count_select_grp <> 1;
746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
750: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
751: v_pn_trx_type_id1,

Line 748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);

744: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
745: EXIT WHEN l_count_select_grp <> 1;
746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
750: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
751: v_pn_trx_type_id1,
752: v_pn_org_id1);

Line 749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);

745: EXIT WHEN l_count_select_grp <> 1;
746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
750: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
751: v_pn_trx_type_id1,
752: v_pn_org_id1);
753:

Line 763: IF dbms_sql.is_open (g_cursor_select_grp) THEN

759: UPDATE pn_payment_terms_all
760: SET legal_entity_id = le_ar_tbl(i)
761: WHERE payment_term_id = term_ar_tbl(i);
762:
763: IF dbms_sql.is_open (g_cursor_select_grp) THEN
764: dbms_sql.close_cursor (g_cursor_select_grp);
765: END IF;
766:
767: l_context := 'Opening the cursor';

Line 764: dbms_sql.close_cursor (g_cursor_select_grp);

760: SET legal_entity_id = le_ar_tbl(i)
761: WHERE payment_term_id = term_ar_tbl(i);
762:
763: IF dbms_sql.is_open (g_cursor_select_grp) THEN
764: dbms_sql.close_cursor (g_cursor_select_grp);
765: END IF;
766:
767: l_context := 'Opening the cursor';
768: g_cursor_grp := dbms_sql.open_cursor;

Line 768: g_cursor_grp := dbms_sql.open_cursor;

764: dbms_sql.close_cursor (g_cursor_select_grp);
765: END IF;
766:
767: l_context := 'Opening the cursor';
768: g_cursor_grp := dbms_sql.open_cursor;
769: dbms_sql.parse(g_cursor_grp, Q_Billitem_grp, dbms_sql.native);
770: do_binding (g_cursor_grp
771: ,p_lease_num_low
772: ,p_lease_num_high

Line 769: dbms_sql.parse(g_cursor_grp, Q_Billitem_grp, dbms_sql.native);

765: END IF;
766:
767: l_context := 'Opening the cursor';
768: g_cursor_grp := dbms_sql.open_cursor;
769: dbms_sql.parse(g_cursor_grp, Q_Billitem_grp, dbms_sql.native);
770: do_binding (g_cursor_grp
771: ,p_lease_num_low
772: ,p_lease_num_high
773: ,p_sch_dt_low

Line 797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);

793: /* Initialize the table and loop index */
794: l_index := 1;
795: exp_ar_tbl.DELETE;
796: err_ar_tbl.DELETE; --Bug 14762515
797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );

Line 798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);

794: l_index := 1;
795: exp_ar_tbl.DELETE;
796: err_ar_tbl.DELETE; --Bug 14762515
797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );

Line 799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);

795: exp_ar_tbl.DELETE;
796: err_ar_tbl.DELETE; --Bug 14762515
797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);

Line 800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);

796: err_ar_tbl.DELETE; --Bug 14762515
797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);

Line 801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );

797: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);

Line 802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );

798: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);

Line 803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);

799: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );

Line 804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);

800: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);

Line 805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);

801: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);

Line 806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);

802: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);

Line 807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );

803: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);

Line 808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);

804: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);

Line 809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);

805: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);

Line 810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);

806: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);

Line 811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);

807: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);

Line 812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);

808: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);

Line 813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);

809: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);

Line 814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);

810: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);

Line 815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);

811: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);

Line 816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);

812: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);

Line 817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);

813: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);

Line 818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);

814: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);

Line 819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);

815: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);

Line 820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);

816: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);

Line 821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);

817: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);

Line 822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);

818: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);

Line 823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);

819: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);

Line 824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);

820: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);

Line 825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);

821: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);

Line 826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);

822: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);

Line 827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);

823: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);

Line 828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);

824: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);

Line 829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);

825: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);

Line 830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);

826: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);

Line 831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);

827: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);

Line 832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);

828: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);

Line 833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);

829: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);

Line 834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);

830: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);

Line 835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);

831: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);

Line 836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);

832: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);

Line 837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);

833: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
841:

Line 838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);

834: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
841:
842: l_rows_grp := dbms_sql.execute(g_cursor_grp);

Line 839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);

835: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
841:
842: l_rows_grp := dbms_sql.execute(g_cursor_grp);
843: LOOP

Line 840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);

836: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
837: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
841:
842: l_rows_grp := dbms_sql.execute(g_cursor_grp);
843: LOOP
844: BEGIN

Line 842: l_rows_grp := dbms_sql.execute(g_cursor_grp);

838: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
839: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
840: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
841:
842: l_rows_grp := dbms_sql.execute(g_cursor_grp);
843: LOOP
844: BEGIN
845: l_context := 'Fetching from the cursor';
846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);

Line 846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);

842: l_rows_grp := dbms_sql.execute(g_cursor_grp);
843: LOOP
844: BEGIN
845: l_context := 'Fetching from the cursor';
846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
847: EXIT WHEN l_count_grp <> 1;
848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);

Line 848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);

844: BEGIN
845: l_context := 'Fetching from the cursor';
846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
847: EXIT WHEN l_count_grp <> 1;
848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);

Line 849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);

845: l_context := 'Fetching from the cursor';
846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
847: EXIT WHEN l_count_grp <> 1;
848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);

Line 850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);

846: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
847: EXIT WHEN l_count_grp <> 1;
848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);

Line 851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);

847: EXIT WHEN l_count_grp <> 1;
848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);

Line 852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);

848: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);

Line 853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);

849: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);

Line 854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);

850: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);

Line 855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);

851: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);

Line 856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);

852: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);

Line 857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);

853: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);

Line 858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);

854: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);

Line 859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);

855: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);

Line 860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);

856: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);

Line 861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);

857: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);

Line 862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);

858: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);

Line 863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);

859: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);

Line 864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);

860: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);

Line 865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);

861: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);

Line 866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);

862: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);

Line 867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);

863: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);

Line 868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);

864: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);

Line 869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);

865: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);

Line 870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);

866: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);

Line 871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);

867: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);

Line 872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);

868: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);

Line 873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);

869: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);

Line 874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);

870: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);

Line 875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);

871: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);

Line 876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);

872: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);

Line 877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);

873: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);

Line 878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);

874: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);

Line 879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);

875: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);

Line 880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);

876: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);

Line 881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);

877: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);

Line 882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);

878: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);

Line 883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);

879: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);

Line 884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);

880: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);

Line 885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);

881: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);

Line 886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);

882: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);

Line 887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);

883: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);

Line 888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);

884: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
892:

Line 889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);

885: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
892:
893: l_rev_flag := 'N';

Line 890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);

886: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
892:
893: l_rev_flag := 'N';
894: l_rec_flag := 'N';

Line 891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);

887: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
888: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
889: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
890: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
891: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
892:
893: l_rev_flag := 'N';
894: l_rec_flag := 'N';
895: l_ast_flag := 'N';

Line 996: IF dbms_sql.is_open (g_cursor_grp) THEN

992:
993: END;
994:
995: END LOOP; /* loop for c_billitem */
996: IF dbms_sql.is_open (g_cursor_grp) THEN
997: dbms_sql.close_cursor (g_cursor_grp);
998: END IF;
999:
1000:

Line 997: dbms_sql.close_cursor (g_cursor_grp);

993: END;
994:
995: END LOOP; /* loop for c_billitem */
996: IF dbms_sql.is_open (g_cursor_grp) THEN
997: dbms_sql.close_cursor (g_cursor_grp);
998: END IF;
999:
1000:
1001: /*CLOSE c_billitem;*/

Line 2017: g_cursor_select_nogrp := dbms_sql.open_cursor;

2013: cust_trx_type_id,
2014: org_id
2015: FROM ('||Q_Billitem_nogrp||')
2016: WHERE legal_entity_id IS NULL';
2017: g_cursor_select_nogrp := dbms_sql.open_cursor;
2018: dbms_sql.parse(g_cursor_select_nogrp,Q_select_nogrp,dbms_sql.native);
2019: do_binding (g_cursor_select_nogrp
2020: ,p_lease_num_low
2021: ,p_lease_num_high

Line 2018: dbms_sql.parse(g_cursor_select_nogrp,Q_select_nogrp,dbms_sql.native);

2014: org_id
2015: FROM ('||Q_Billitem_nogrp||')
2016: WHERE legal_entity_id IS NULL';
2017: g_cursor_select_nogrp := dbms_sql.open_cursor;
2018: dbms_sql.parse(g_cursor_select_nogrp,Q_select_nogrp,dbms_sql.native);
2019: do_binding (g_cursor_select_nogrp
2020: ,p_lease_num_low
2021: ,p_lease_num_high
2022: ,p_sch_dt_low

Line 2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);

2035: l_index := 1;
2036: le_ar_tbl.delete;
2037: term_ar_tbl.delete;
2038: err_ar_tbl.DELETE; --Bug 14762515
2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);

Line 2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);

2036: le_ar_tbl.delete;
2037: term_ar_tbl.delete;
2038: err_ar_tbl.DELETE; --Bug 14762515
2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
2044:

Line 2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);

2037: term_ar_tbl.delete;
2038: err_ar_tbl.DELETE; --Bug 14762515
2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
2044:
2045: LOOP

Line 2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);

2038: err_ar_tbl.DELETE; --Bug 14762515
2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
2044:
2045: LOOP
2046: BEGIN

Line 2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);

2039: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
2040: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
2041: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2042: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
2044:
2045: LOOP
2046: BEGIN
2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);

Line 2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);

2043: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
2044:
2045: LOOP
2046: BEGIN
2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
2048: EXIT WHEN l_count_select_nogrp <> 1;
2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);

Line 2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));

2045: LOOP
2046: BEGIN
2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
2048: EXIT WHEN l_count_select_nogrp <> 1;
2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2053: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

Line 2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);

2046: BEGIN
2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
2048: EXIT WHEN l_count_select_nogrp <> 1;
2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2053: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2054: v_pn_trx_type_id1,

Line 2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);

2047: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
2048: EXIT WHEN l_count_select_nogrp <> 1;
2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2053: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2054: v_pn_trx_type_id1,
2055: v_pn_org_id1);

Line 2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);

2048: EXIT WHEN l_count_select_nogrp <> 1;
2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2053: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2054: v_pn_trx_type_id1,
2055: v_pn_org_id1);
2056: l_index := l_index+1;

Line 2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN

2061: UPDATE pn_payment_terms_all
2062: SET legal_entity_id = le_ar_tbl(i)
2063: WHERE payment_term_id = term_ar_tbl(i);
2064:
2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2066: dbms_sql.close_cursor (g_cursor_select_nogrp);
2067: END IF;
2068:
2069: g_cursor_nogrp := dbms_sql.open_cursor;

Line 2066: dbms_sql.close_cursor (g_cursor_select_nogrp);

2062: SET legal_entity_id = le_ar_tbl(i)
2063: WHERE payment_term_id = term_ar_tbl(i);
2064:
2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2066: dbms_sql.close_cursor (g_cursor_select_nogrp);
2067: END IF;
2068:
2069: g_cursor_nogrp := dbms_sql.open_cursor;
2070: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);

Line 2069: g_cursor_nogrp := dbms_sql.open_cursor;

2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2066: dbms_sql.close_cursor (g_cursor_select_nogrp);
2067: END IF;
2068:
2069: g_cursor_nogrp := dbms_sql.open_cursor;
2070: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);
2071: do_binding (g_cursor_nogrp
2072: ,p_lease_num_low
2073: ,p_lease_num_high

Line 2070: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);

2066: dbms_sql.close_cursor (g_cursor_select_nogrp);
2067: END IF;
2068:
2069: g_cursor_nogrp := dbms_sql.open_cursor;
2070: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);
2071: do_binding (g_cursor_nogrp
2072: ,p_lease_num_low
2073: ,p_lease_num_high
2074: ,p_sch_dt_low

Line 2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);

2084: );
2085: l_context := 'Opening the cursor';
2086:
2087: /*OPEN c_billitem for q_billitem ;*/
2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);

Line 2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);

2085: l_context := 'Opening the cursor';
2086:
2087: /*OPEN c_billitem for q_billitem ;*/
2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

Line 2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);

2086:
2087: /*OPEN c_billitem for q_billitem ;*/
2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

Line 2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);

2087: /*OPEN c_billitem for q_billitem ;*/
2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);

Line 2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);

2088: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);

Line 2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

2089: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);

Line 2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

2090: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);

Line 2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);

2091: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);

Line 2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);

2092: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);

Line 2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);

2093: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);

Line 2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);

2094: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);

Line 2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);

2095: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);

Line 2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);

2096: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);

Line 2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);

2097: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);

Line 2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);

2098: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);

Line 2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);

2099: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);

Line 2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);

2100: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);

Line 2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);

2101: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);

Line 2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);

2102: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);

Line 2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);

2103: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);

Line 2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);

2104: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);

Line 2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);

2105: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);

Line 2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);

2106: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);

Line 2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);

2107: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);

Line 2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);

2108: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);

Line 2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);

2109: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);

Line 2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);

2110: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);

Line 2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);

2111: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);

Line 2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);

2112: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);

Line 2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);

2113: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);

Line 2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);

2114: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);

Line 2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);

2115: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);

Line 2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);

2116: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);

Line 2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);

2117: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);

Line 2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);

2118: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2126:

Line 2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);

2119: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2126:
2127:

Line 2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);

2120: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2126:
2127:
2128: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);

Line 2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);

2121: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2122: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2123: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2126:
2127:
2128: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);
2129:

Line 2128: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);

2124: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2125: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2126:
2127:
2128: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);
2129:
2130: LOOP /* looping for c_billitem */
2131:
2132: BEGIN

Line 2136: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);

2132: BEGIN
2133:
2134: l_context := 'Fetching from the cursor';
2135:
2136: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2137: EXIT WHEN l_count_nogrp <> 1;
2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);

Line 2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);

2134: l_context := 'Fetching from the cursor';
2135:
2136: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2137: EXIT WHEN l_count_nogrp <> 1;
2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);

Line 2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);

2135:
2136: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2137: EXIT WHEN l_count_nogrp <> 1;
2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

Line 2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);

2136: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2137: EXIT WHEN l_count_nogrp <> 1;
2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

Line 2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);

2137: EXIT WHEN l_count_nogrp <> 1;
2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);

Line 2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);

2138: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);

Line 2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

2139: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);

Line 2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

2140: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);

Line 2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);

2141: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);

Line 2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);

2142: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);

Line 2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);

2143: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);

Line 2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);

2144: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);

Line 2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);

2145: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);
2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);

Line 2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);

2146: dbms_sql.column_value (g_cursor_nogrp, 9, v_pn_tcc);
2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);

Line 2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);

2147: dbms_sql.column_value (g_cursor_nogrp, 10,v_pn_le);
2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);

Line 2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);

2148: dbms_sql.column_value (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);

Line 2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);

2149: dbms_sql.column_value (g_cursor_nogrp, 12,v_pn_account_rule_id);
2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);

Line 2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);

2150: dbms_sql.column_value (g_cursor_nogrp, 13,v_pn_term_id);
2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);

Line 2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);

2151: dbms_sql.column_value (g_cursor_nogrp, 14,v_pn_trx_type_id);
2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);

Line 2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);

2152: dbms_sql.column_value (g_cursor_nogrp, 15,v_pn_pay_method_id);
2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);

Line 2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);

2153: dbms_sql.column_value (g_cursor_nogrp, 16,v_pn_po_number);
2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);

Line 2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);

2154: dbms_sql.column_value (g_cursor_nogrp, 17,v_pn_tax_included);
2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);

Line 2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);

2155: dbms_sql.column_value (g_cursor_nogrp, 18,v_pn_salesrep_id);
2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);

Line 2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);

2156: dbms_sql.column_value (g_cursor_nogrp, 19,v_pn_proj_attr_catg);
2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);

Line 2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);

2157: dbms_sql.column_value (g_cursor_nogrp, 20,v_pn_proj_attr3);
2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);

Line 2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);

2158: dbms_sql.column_value (g_cursor_nogrp, 21,v_pn_proj_attr4);
2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);

Line 2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);

2159: dbms_sql.column_value (g_cursor_nogrp, 22,v_pn_proj_attr5);
2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);

Line 2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);

2160: dbms_sql.column_value (g_cursor_nogrp, 23,v_pn_proj_attr6);
2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);

Line 2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);

2161: dbms_sql.column_value (g_cursor_nogrp, 24,v_pn_proj_attr7);
2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);

Line 2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);

2162: dbms_sql.column_value (g_cursor_nogrp, 25,v_pn_org_id);
2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);

Line 2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);

2163: dbms_sql.column_value (g_cursor_nogrp, 26,v_pn_lease_num);
2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);

Line 2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);

2164: dbms_sql.column_value (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);

Line 2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);

2165: dbms_sql.column_value (g_cursor_nogrp, 28,v_pn_period_name);
2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);

Line 2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);

2166: dbms_sql.column_value (g_cursor_nogrp, 29,v_pn_description);
2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);

Line 2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);

2167: dbms_sql.column_value (g_cursor_nogrp, 30,v_pn_lease_id);
2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);

Line 2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);

2168: dbms_sql.column_value (g_cursor_nogrp, 31,v_transaction_date);
2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2176:

Line 2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);

2169: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2176:
2177: /* Check for Conversion Type and Conversion Rate for Currency Code */

Line 2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);

2170: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2176:
2177: /* Check for Conversion Type and Conversion Rate for Currency Code */
2178: OPEN get_func_curr_code(l_set_of_books_id);

Line 2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);

2171: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2172: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2173: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2174: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2175: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2176:
2177: /* Check for Conversion Type and Conversion Rate for Currency Code */
2178: OPEN get_func_curr_code(l_set_of_books_id);
2179: FETCH get_func_curr_code INTO l_func_curr_code;

Line 2862: IF dbms_sql.is_open (g_cursor_nogrp) THEN

2858: END;
2859:
2860: END LOOP; /* looping for c_billitem */
2861:
2862: IF dbms_sql.is_open (g_cursor_nogrp) THEN
2863: dbms_sql.close_cursor (g_cursor_nogrp);
2864: END IF;
2865:
2866:

Line 2863: dbms_sql.close_cursor (g_cursor_nogrp);

2859:
2860: END LOOP; /* looping for c_billitem */
2861:
2862: IF dbms_sql.is_open (g_cursor_nogrp) THEN
2863: dbms_sql.close_cursor (g_cursor_nogrp);
2864: END IF;
2865:
2866:
2867: COMMIT;

Line 2954: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);

2950: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (+)');
2951: IF p_grp_param IS NULL THEN
2952: IF p_lease_num_low IS NOT NULL AND
2953: p_lease_num_high IS NOT NULL THEN
2954: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2955: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2956: ELSIF p_lease_num_low IS NULL AND
2957: p_lease_num_high IS NOT NULL THEN
2958: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);

Line 2955: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);

2951: IF p_grp_param IS NULL THEN
2952: IF p_lease_num_low IS NOT NULL AND
2953: p_lease_num_high IS NOT NULL THEN
2954: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2955: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2956: ELSIF p_lease_num_low IS NULL AND
2957: p_lease_num_high IS NOT NULL THEN
2958: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2959: ELSIF p_lease_num_low IS NOT NULL AND

Line 2958: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);

2954: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2955: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2956: ELSIF p_lease_num_low IS NULL AND
2957: p_lease_num_high IS NOT NULL THEN
2958: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2959: ELSIF p_lease_num_low IS NOT NULL AND
2960: p_lease_num_high IS NULL THEN
2961: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2962: END IF;

Line 2961: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);

2957: p_lease_num_high IS NOT NULL THEN
2958: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2959: ELSIF p_lease_num_low IS NOT NULL AND
2960: p_lease_num_high IS NULL THEN
2961: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2962: END IF;
2963: IF p_sch_dt_low IS NOT NULL AND
2964: p_sch_dt_high IS NOT NULL THEN
2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

Line 2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

2961: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2962: END IF;
2963: IF p_sch_dt_low IS NOT NULL AND
2964: p_sch_dt_high IS NOT NULL THEN
2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

Line 2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

2962: END IF;
2963: IF p_sch_dt_low IS NOT NULL AND
2964: p_sch_dt_high IS NOT NULL THEN
2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND

Line 2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

2965: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2966: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2967: ELSIF p_sch_dt_low IS NULL AND
2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND
2971: p_sch_dt_high IS NULL THEN
2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;

Line 2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

2968: p_sch_dt_high IS NOT NULL THEN
2969: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2970: ELSIF p_sch_dt_low IS NOT NULL AND
2971: p_sch_dt_high IS NULL THEN
2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

Line 2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

2972: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

Line 2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

2973: END IF;
2974: IF p_due_dt_low IS NOT NULL AND
2975: p_due_dt_high IS NOT NULL THEN
2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND

Line 2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

2976: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2977: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2978: ELSIF p_due_dt_low IS NULL AND
2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND
2982: p_due_dt_high IS NULL THEN
2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2984: END IF;

Line 2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

2979: p_due_dt_high IS NOT NULL THEN
2980: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2981: ELSIF p_due_dt_low IS NOT NULL AND
2982: p_due_dt_high IS NULL THEN
2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2984: END IF;
2985: IF p_pay_prps_code IS NOT NULL THEN
2986: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2987: END IF;

Line 2986: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);

2982: p_due_dt_high IS NULL THEN
2983: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2984: END IF;
2985: IF p_pay_prps_code IS NOT NULL THEN
2986: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2987: END IF;
2988: IF p_prd_name IS NOT NULL THEN
2989: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2990: END IF;

Line 2989: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);

2985: IF p_pay_prps_code IS NOT NULL THEN
2986: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2987: END IF;
2988: IF p_prd_name IS NOT NULL THEN
2989: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2990: END IF;
2991: IF p_amt_low IS NOT NULL AND
2992: p_amt_high IS NOT NULL THEN
2993: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);

Line 2993: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);

2989: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2990: END IF;
2991: IF p_amt_low IS NOT NULL AND
2992: p_amt_high IS NOT NULL THEN
2993: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2994: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2995: ELSIF p_amt_low IS NULL AND
2996: p_amt_high IS NOT NULL THEN
2997: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);

Line 2994: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);

2990: END IF;
2991: IF p_amt_low IS NOT NULL AND
2992: p_amt_high IS NOT NULL THEN
2993: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2994: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2995: ELSIF p_amt_low IS NULL AND
2996: p_amt_high IS NOT NULL THEN
2997: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2998: ELSIF p_amt_low IS NOT NULL AND

Line 2997: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);

2993: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2994: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2995: ELSIF p_amt_low IS NULL AND
2996: p_amt_high IS NOT NULL THEN
2997: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2998: ELSIF p_amt_low IS NOT NULL AND
2999: p_amt_high IS NULL THEN
3000: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
3001: END IF;

Line 3000: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);

2996: p_amt_high IS NOT NULL THEN
2997: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2998: ELSIF p_amt_low IS NOT NULL AND
2999: p_amt_high IS NULL THEN
3000: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
3001: END IF;
3002: IF p_customer_id IS NOT NULL THEN
3003: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
3004: END IF;

Line 3003: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);

2999: p_amt_high IS NULL THEN
3000: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
3001: END IF;
3002: IF p_customer_id IS NOT NULL THEN
3003: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
3004: END IF;
3005: ELSE
3006: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
3007: END IF;

Line 3006: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);

3002: IF p_customer_id IS NOT NULL THEN
3003: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
3004: END IF;
3005: ELSE
3006: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
3007: END IF;
3008: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (-)');
3009: END do_binding;
3010: