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 710: g_cursor_select_grp := dbms_sql.open_cursor;

706: cust_trx_type_id,
707: org_id
708: FROM ('||Q_Billitem_grp||')
709: WHERE legal_entity_id IS NULL';
710: g_cursor_select_grp := dbms_sql.open_cursor;
711: dbms_sql.parse(g_cursor_select_grp,Q_select_grp,dbms_sql.native);
712: do_binding (g_cursor_select_grp
713: ,p_lease_num_low
714: ,p_lease_num_high

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

707: org_id
708: FROM ('||Q_Billitem_grp||')
709: WHERE legal_entity_id IS NULL';
710: g_cursor_select_grp := dbms_sql.open_cursor;
711: dbms_sql.parse(g_cursor_select_grp,Q_select_grp,dbms_sql.native);
712: do_binding (g_cursor_select_grp
713: ,p_lease_num_low
714: ,p_lease_num_high
715: ,p_sch_dt_low

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

723: ,p_customer_id
724: ,p_grp_param
725: );
726:
727: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
728: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
729: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
730: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);

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

724: ,p_grp_param
725: );
726:
727: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
728: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
729: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
730: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
732:

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

725: );
726:
727: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
728: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
729: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
730: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
732:
733: LOOP

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

726:
727: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
728: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
729: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
730: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
732:
733: LOOP
734: BEGIN

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

727: dbms_sql.define_column (g_cursor_select_grp,1,v_pn_payment_term_id1);
728: dbms_sql.define_column (g_cursor_select_grp,2,v_pn_customer_id1);
729: dbms_sql.define_column (g_cursor_select_grp,3,v_pn_trx_type_id1);
730: dbms_sql.define_column (g_cursor_select_grp,4,v_pn_org_id1);
731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
732:
733: LOOP
734: BEGIN
735: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);

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

731: l_rows_select_grp := dbms_sql.execute(g_cursor_select_grp);
732:
733: LOOP
734: BEGIN
735: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
736: EXIT WHEN l_count_select_grp <> 1;
737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);

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

733: LOOP
734: BEGIN
735: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
736: EXIT WHEN l_count_select_grp <> 1;
737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
740: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

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

734: BEGIN
735: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
736: EXIT WHEN l_count_select_grp <> 1;
737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
740: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
742: v_pn_trx_type_id1,

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

735: l_count_select_grp := dbms_sql.fetch_rows(g_cursor_select_grp);
736: EXIT WHEN l_count_select_grp <> 1;
737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
740: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
742: v_pn_trx_type_id1,
743: v_pn_org_id1);

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

736: EXIT WHEN l_count_select_grp <> 1;
737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
740: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
742: v_pn_trx_type_id1,
743: v_pn_org_id1);
744:

Line 754: IF dbms_sql.is_open (g_cursor_select_grp) THEN

750: UPDATE pn_payment_terms_all
751: SET legal_entity_id = le_ar_tbl(i)
752: WHERE payment_term_id = term_ar_tbl(i);
753:
754: IF dbms_sql.is_open (g_cursor_select_grp) THEN
755: dbms_sql.close_cursor (g_cursor_select_grp);
756: END IF;
757:
758: l_context := 'Opening the cursor';

Line 755: dbms_sql.close_cursor (g_cursor_select_grp);

751: SET legal_entity_id = le_ar_tbl(i)
752: WHERE payment_term_id = term_ar_tbl(i);
753:
754: IF dbms_sql.is_open (g_cursor_select_grp) THEN
755: dbms_sql.close_cursor (g_cursor_select_grp);
756: END IF;
757:
758: l_context := 'Opening the cursor';
759: g_cursor_grp := dbms_sql.open_cursor;

Line 759: g_cursor_grp := dbms_sql.open_cursor;

755: dbms_sql.close_cursor (g_cursor_select_grp);
756: END IF;
757:
758: l_context := 'Opening the cursor';
759: g_cursor_grp := dbms_sql.open_cursor;
760: dbms_sql.parse(g_cursor_grp, Q_Billitem_grp, dbms_sql.native);
761: do_binding (g_cursor_grp
762: ,p_lease_num_low
763: ,p_lease_num_high

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

756: END IF;
757:
758: l_context := 'Opening the cursor';
759: g_cursor_grp := dbms_sql.open_cursor;
760: dbms_sql.parse(g_cursor_grp, Q_Billitem_grp, dbms_sql.native);
761: do_binding (g_cursor_grp
762: ,p_lease_num_low
763: ,p_lease_num_high
764: ,p_sch_dt_low

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

783:
784: /* Initialize the table and loop index */
785: l_index := 1;
786: exp_ar_tbl.DELETE;
787: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );

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

784: /* Initialize the table and loop index */
785: l_index := 1;
786: exp_ar_tbl.DELETE;
787: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );

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

785: l_index := 1;
786: exp_ar_tbl.DELETE;
787: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);

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

786: exp_ar_tbl.DELETE;
787: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);

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

787: dbms_sql.define_column (g_cursor_grp, 1, v_pn_payment_item_id);
788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);

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

788: dbms_sql.define_column (g_cursor_grp, 2, v_pn_payment_term_id);
789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);

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

789: dbms_sql.define_column (g_cursor_grp, 3, v_pn_export_currency_code,15);
790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );

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

790: dbms_sql.define_column (g_cursor_grp, 4, v_pn_export_currency_amount);
791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);

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

791: dbms_sql.define_column (g_cursor_grp, 5, v_pn_customer_id );
792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);

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

792: dbms_sql.define_column (g_cursor_grp, 6, v_pn_customer_site_use_id );
793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);

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

793: dbms_sql.define_column (g_cursor_grp, 7, v_pn_cust_ship_site_id);
794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);

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

794: dbms_sql.define_column (g_cursor_grp, 8, v_pn_tax_code_id);
795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);

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

795: dbms_sql.define_column (g_cursor_grp, 9, v_pn_tax_classification_code,30);
796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);

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

796: dbms_sql.define_column (g_cursor_grp, 10,v_pn_legal_entity_id);
797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);

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

797: dbms_sql.define_column (g_cursor_grp, 11,v_pn_inv_rule_id );
798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);

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

798: dbms_sql.define_column (g_cursor_grp, 12,v_pn_account_rule_id);
799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);

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

799: dbms_sql.define_column (g_cursor_grp, 13,v_pn_term_id);
800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);

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

800: dbms_sql.define_column (g_cursor_grp, 14,v_pn_trx_type_id);
801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);

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

801: dbms_sql.define_column (g_cursor_grp, 15,v_pn_pay_method_id);
802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);

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

802: dbms_sql.define_column (g_cursor_grp, 16,v_pn_po_number,50);
803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);

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

803: dbms_sql.define_column (g_cursor_grp, 17,v_pn_tax_included,1);
804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);

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

804: dbms_sql.define_column (g_cursor_grp, 18,v_pn_salesrep_id);
805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);

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

805: dbms_sql.define_column (g_cursor_grp, 19,v_pn_proj_attr_catg,30);
806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);

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

806: dbms_sql.define_column (g_cursor_grp, 20,v_pn_proj_attr3,150);
807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);

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

807: dbms_sql.define_column (g_cursor_grp, 21,v_pn_proj_attr4,150);
808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);

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

808: dbms_sql.define_column (g_cursor_grp, 22,v_pn_proj_attr5,150);
809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);

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

809: dbms_sql.define_column (g_cursor_grp, 23,v_pn_proj_attr6,150);
810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);

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

810: dbms_sql.define_column (g_cursor_grp, 24,v_pn_proj_attr7,150);
811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);

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

811: dbms_sql.define_column (g_cursor_grp, 25,v_pn_org_id);
812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);

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

812: dbms_sql.define_column (g_cursor_grp, 26,v_pn_lease_num,30);
813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);

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

813: dbms_sql.define_column (g_cursor_grp, 27,v_pn_payment_schedule_id);
814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);

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

814: dbms_sql.define_column (g_cursor_grp, 28,v_pn_period_name,15);
815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);

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

815: dbms_sql.define_column (g_cursor_grp, 29,v_pn_description,30);
816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);

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

816: dbms_sql.define_column (g_cursor_grp, 30,v_pn_lease_id);
817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);

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

817: dbms_sql.define_column (g_cursor_grp, 31,v_transaction_date);
818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);

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

818: dbms_sql.define_column (g_cursor_grp, 32,v_normalize,1);
819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);

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

819: dbms_sql.define_column (g_cursor_grp, 33,v_pn_accounted_date);
820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);

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

820: dbms_sql.define_column (g_cursor_grp, 34,v_pn_rate);
821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);

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

821: dbms_sql.define_column (g_cursor_grp, 35,v_location_id);
822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);

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

822: dbms_sql.define_column (g_cursor_grp, 36,v_send_entries,1);
823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);

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

823: dbms_sql.define_column (g_cursor_grp, 37,v_rec_account);
824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
831:

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

824: dbms_sql.define_column (g_cursor_grp, 38,v_gl_date);
825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
831:
832: l_rows_grp := dbms_sql.execute(g_cursor_grp);

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

825: dbms_sql.define_column (g_cursor_grp, 39,v_conv_rate);
826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
831:
832: l_rows_grp := dbms_sql.execute(g_cursor_grp);
833: LOOP

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

826: dbms_sql.define_column (g_cursor_grp, 40,v_conv_rate_type,30);
827: dbms_sql.define_column (g_cursor_grp, 41,v_payment_purpose,30);
828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
831:
832: l_rows_grp := dbms_sql.execute(g_cursor_grp);
833: LOOP
834: BEGIN

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

828: dbms_sql.define_column (g_cursor_grp, 42,v_payment_type,30);
829: dbms_sql.define_column (g_cursor_grp, 43,v_rule_gl_date);
830: dbms_sql.define_column (g_cursor_grp, 44,v_schedule_date);
831:
832: l_rows_grp := dbms_sql.execute(g_cursor_grp);
833: LOOP
834: BEGIN
835: l_context := 'Fetching from the cursor';
836: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);

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

832: l_rows_grp := dbms_sql.execute(g_cursor_grp);
833: LOOP
834: BEGIN
835: l_context := 'Fetching from the cursor';
836: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
837: EXIT WHEN l_count_grp <> 1;
838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);

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

834: BEGIN
835: l_context := 'Fetching from the cursor';
836: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
837: EXIT WHEN l_count_grp <> 1;
838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);

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

835: l_context := 'Fetching from the cursor';
836: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
837: EXIT WHEN l_count_grp <> 1;
838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);

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

836: l_count_grp := dbms_sql.fetch_rows( g_cursor_grp);
837: EXIT WHEN l_count_grp <> 1;
838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);

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

837: EXIT WHEN l_count_grp <> 1;
838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);

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

838: dbms_sql.column_value (g_cursor_grp, 1, exp_ar_tbl(l_index).pn_payment_item_id);
839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);

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

839: dbms_sql.column_value (g_cursor_grp, 2, exp_ar_tbl(l_index).pn_payment_term_id);
840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);

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

840: dbms_sql.column_value (g_cursor_grp, 3, exp_ar_tbl(l_index).pn_export_currency_code);
841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);

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

841: dbms_sql.column_value (g_cursor_grp, 4, exp_ar_tbl(l_index).pn_export_currency_amount);
842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);

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

842: dbms_sql.column_value (g_cursor_grp, 5, exp_ar_tbl(l_index).pn_customer_id);
843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);

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

843: dbms_sql.column_value (g_cursor_grp, 6, exp_ar_tbl(l_index).pn_customer_site_use_id);
844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);

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

844: dbms_sql.column_value (g_cursor_grp, 7, exp_ar_tbl(l_index).pn_cust_ship_site_id);
845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);

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

845: dbms_sql.column_value (g_cursor_grp, 8, exp_ar_tbl(l_index).pn_tax_code_id);
846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);

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

846: dbms_sql.column_value (g_cursor_grp, 9, exp_ar_tbl(l_index).pn_tax_classification_code);
847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);

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

847: dbms_sql.column_value (g_cursor_grp, 10,exp_ar_tbl(l_index).pn_legal_entity_id);
848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);

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

848: dbms_sql.column_value (g_cursor_grp, 11,exp_ar_tbl(l_index).pn_inv_rule_id);
849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);

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

849: dbms_sql.column_value (g_cursor_grp, 12,exp_ar_tbl(l_index).pn_account_rule_id);
850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);

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

850: dbms_sql.column_value (g_cursor_grp, 13,exp_ar_tbl(l_index).pn_term_id);
851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);

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

851: dbms_sql.column_value (g_cursor_grp, 14,exp_ar_tbl(l_index).pn_trx_type_id);
852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);

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

852: dbms_sql.column_value (g_cursor_grp, 15,exp_ar_tbl(l_index).pn_pay_method_id);
853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);

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

853: dbms_sql.column_value (g_cursor_grp, 16,exp_ar_tbl(l_index).pn_po_number);
854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);

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

854: dbms_sql.column_value (g_cursor_grp, 17,exp_ar_tbl(l_index).pn_tax_included);
855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);

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

855: dbms_sql.column_value (g_cursor_grp, 18,exp_ar_tbl(l_index).pn_salesrep_id);
856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);

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

856: dbms_sql.column_value (g_cursor_grp, 19,exp_ar_tbl(l_index).pn_proj_attr_catg);
857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);

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

857: dbms_sql.column_value (g_cursor_grp, 20,exp_ar_tbl(l_index).pn_proj_attr3);
858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);

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

858: dbms_sql.column_value (g_cursor_grp, 21,exp_ar_tbl(l_index).pn_proj_attr4);
859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);

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

859: dbms_sql.column_value (g_cursor_grp, 22,exp_ar_tbl(l_index).pn_proj_attr5);
860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);

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

860: dbms_sql.column_value (g_cursor_grp, 23,exp_ar_tbl(l_index).pn_proj_attr6);
861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);

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

861: dbms_sql.column_value (g_cursor_grp, 24,exp_ar_tbl(l_index).pn_proj_attr7);
862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);

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

862: dbms_sql.column_value (g_cursor_grp, 25,exp_ar_tbl(l_index).pn_org_id);
863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);

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

863: dbms_sql.column_value (g_cursor_grp, 26,exp_ar_tbl(l_index).pn_lease_num);
864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);

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

864: dbms_sql.column_value (g_cursor_grp, 27,exp_ar_tbl(l_index).pn_payment_schedule_id);
865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);

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

865: dbms_sql.column_value (g_cursor_grp, 28,exp_ar_tbl(l_index).pn_period_name);
866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);

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

866: dbms_sql.column_value (g_cursor_grp, 29,exp_ar_tbl(l_index).pn_description);
867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);

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

867: dbms_sql.column_value (g_cursor_grp, 30,exp_ar_tbl(l_index).pn_lease_id);
868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);

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

868: dbms_sql.column_value (g_cursor_grp, 31,exp_ar_tbl(l_index).transaction_date);
869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);

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

869: dbms_sql.column_value (g_cursor_grp, 32,exp_ar_tbl(l_index).normalize);
870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);

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

870: dbms_sql.column_value (g_cursor_grp, 33,exp_ar_tbl(l_index).pn_accounted_date);
871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);

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

871: dbms_sql.column_value (g_cursor_grp, 34,exp_ar_tbl(l_index).pn_rate);
872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);

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

872: dbms_sql.column_value (g_cursor_grp, 35,exp_ar_tbl(l_index).location_id);
873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);

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

873: dbms_sql.column_value (g_cursor_grp, 36,exp_ar_tbl(l_index).send_entries);
874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
881: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);

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

874: dbms_sql.column_value (g_cursor_grp, 37,exp_ar_tbl(l_index).rec_account);
875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
881: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
882:

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

875: dbms_sql.column_value (g_cursor_grp, 38,exp_ar_tbl(l_index).gl_date);
876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
881: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
882:
883: l_rev_flag := 'N';

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

876: dbms_sql.column_value (g_cursor_grp, 39,exp_ar_tbl(l_index).conv_rate);
877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
881: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
882:
883: l_rev_flag := 'N';
884: l_rec_flag := 'N';

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

877: dbms_sql.column_value (g_cursor_grp, 40,exp_ar_tbl(l_index).conv_rate_type);
878: dbms_sql.column_value (g_cursor_grp, 41,exp_ar_tbl(l_index).payment_purpose);
879: dbms_sql.column_value (g_cursor_grp, 42,exp_ar_tbl(l_index).payment_type);
880: dbms_sql.column_value (g_cursor_grp, 43,exp_ar_tbl(l_index).rule_gl_date);
881: dbms_sql.column_value (g_cursor_grp, 44,exp_ar_tbl(l_index).schedule_date);
882:
883: l_rev_flag := 'N';
884: l_rec_flag := 'N';
885: l_ast_flag := 'N';

Line 981: IF dbms_sql.is_open (g_cursor_grp) THEN

977:
978: END;
979:
980: END LOOP; /* loop for c_billitem */
981: IF dbms_sql.is_open (g_cursor_grp) THEN
982: dbms_sql.close_cursor (g_cursor_grp);
983: END IF;
984:
985:

Line 982: dbms_sql.close_cursor (g_cursor_grp);

978: END;
979:
980: END LOOP; /* loop for c_billitem */
981: IF dbms_sql.is_open (g_cursor_grp) THEN
982: dbms_sql.close_cursor (g_cursor_grp);
983: END IF;
984:
985:
986: /*CLOSE c_billitem;*/

Line 1967: g_cursor_select_nogrp := dbms_sql.open_cursor;

1963: cust_trx_type_id,
1964: org_id
1965: FROM ('||Q_Billitem_nogrp||')
1966: WHERE legal_entity_id IS NULL';
1967: g_cursor_select_nogrp := dbms_sql.open_cursor;
1968: dbms_sql.parse(g_cursor_select_nogrp,Q_select_nogrp,dbms_sql.native);
1969: do_binding (g_cursor_select_nogrp
1970: ,p_lease_num_low
1971: ,p_lease_num_high

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

1964: org_id
1965: FROM ('||Q_Billitem_nogrp||')
1966: WHERE legal_entity_id IS NULL';
1967: g_cursor_select_nogrp := dbms_sql.open_cursor;
1968: dbms_sql.parse(g_cursor_select_nogrp,Q_select_nogrp,dbms_sql.native);
1969: do_binding (g_cursor_select_nogrp
1970: ,p_lease_num_low
1971: ,p_lease_num_high
1972: ,p_sch_dt_low

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

1984:
1985: l_index := 1;
1986: le_ar_tbl.delete;
1987: term_ar_tbl.delete;
1988: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
1989: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
1990: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
1991: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);

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

1985: l_index := 1;
1986: le_ar_tbl.delete;
1987: term_ar_tbl.delete;
1988: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
1989: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
1990: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
1991: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
1993:

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

1986: le_ar_tbl.delete;
1987: term_ar_tbl.delete;
1988: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
1989: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
1990: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
1991: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
1993:
1994: LOOP

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

1987: term_ar_tbl.delete;
1988: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
1989: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
1990: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
1991: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
1993:
1994: LOOP
1995: BEGIN

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

1988: dbms_sql.define_column (g_cursor_select_nogrp,1,v_pn_payment_term_id1);
1989: dbms_sql.define_column (g_cursor_select_nogrp,2,v_pn_customer_id1);
1990: dbms_sql.define_column (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
1991: dbms_sql.define_column (g_cursor_select_nogrp,4,v_pn_org_id1);
1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
1993:
1994: LOOP
1995: BEGIN
1996: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);

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

1992: l_rows_select_nogrp := dbms_sql.execute(g_cursor_select_nogrp);
1993:
1994: LOOP
1995: BEGIN
1996: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
1997: EXIT WHEN l_count_select_nogrp <> 1;
1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);

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

1994: LOOP
1995: BEGIN
1996: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
1997: EXIT WHEN l_count_select_nogrp <> 1;
1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2001: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

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

1995: BEGIN
1996: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
1997: EXIT WHEN l_count_select_nogrp <> 1;
1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2001: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2003: v_pn_trx_type_id1,

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

1996: l_count_select_nogrp := dbms_sql.fetch_rows(g_cursor_select_nogrp);
1997: EXIT WHEN l_count_select_nogrp <> 1;
1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2001: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2003: v_pn_trx_type_id1,
2004: v_pn_org_id1);

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

1997: EXIT WHEN l_count_select_nogrp <> 1;
1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2001: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2003: v_pn_trx_type_id1,
2004: v_pn_org_id1);
2005: l_index := l_index+1;

Line 2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN

2010: UPDATE pn_payment_terms_all
2011: SET legal_entity_id = le_ar_tbl(i)
2012: WHERE payment_term_id = term_ar_tbl(i);
2013:
2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2015: dbms_sql.close_cursor (g_cursor_select_nogrp);
2016: END IF;
2017:
2018: g_cursor_nogrp := dbms_sql.open_cursor;

Line 2015: dbms_sql.close_cursor (g_cursor_select_nogrp);

2011: SET legal_entity_id = le_ar_tbl(i)
2012: WHERE payment_term_id = term_ar_tbl(i);
2013:
2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2015: dbms_sql.close_cursor (g_cursor_select_nogrp);
2016: END IF;
2017:
2018: g_cursor_nogrp := dbms_sql.open_cursor;
2019: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);

Line 2018: g_cursor_nogrp := dbms_sql.open_cursor;

2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN
2015: dbms_sql.close_cursor (g_cursor_select_nogrp);
2016: END IF;
2017:
2018: g_cursor_nogrp := dbms_sql.open_cursor;
2019: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);
2020: do_binding (g_cursor_nogrp
2021: ,p_lease_num_low
2022: ,p_lease_num_high

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

2015: dbms_sql.close_cursor (g_cursor_select_nogrp);
2016: END IF;
2017:
2018: g_cursor_nogrp := dbms_sql.open_cursor;
2019: dbms_sql.parse(g_cursor_nogrp, Q_Billitem_nogrp, dbms_sql.native);
2020: do_binding (g_cursor_nogrp
2021: ,p_lease_num_low
2022: ,p_lease_num_high
2023: ,p_sch_dt_low

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

2033: );
2034: l_context := 'Opening the cursor';
2035:
2036: /*OPEN c_billitem for q_billitem ;*/
2037: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);

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

2034: l_context := 'Opening the cursor';
2035:
2036: /*OPEN c_billitem for q_billitem ;*/
2037: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

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

2035:
2036: /*OPEN c_billitem for q_billitem ;*/
2037: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

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

2036: /*OPEN c_billitem for q_billitem ;*/
2037: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);

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

2037: dbms_sql.define_column (g_cursor_nogrp, 1, v_pn_payment_item_id);
2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);

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

2038: dbms_sql.define_column (g_cursor_nogrp, 2, v_pn_payment_term_id);
2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);

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

2039: dbms_sql.define_column (g_cursor_nogrp, 3, v_pn_export_currency_code,15);
2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);

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

2040: dbms_sql.define_column (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);

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

2041: dbms_sql.define_column (g_cursor_nogrp, 5, v_pn_customer_id);
2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);

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

2042: dbms_sql.define_column (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);

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

2043: dbms_sql.define_column (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);

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

2044: dbms_sql.define_column (g_cursor_nogrp, 8, v_pn_tax_code_id);
2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);

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

2045: dbms_sql.define_column (g_cursor_nogrp, 9, v_pn_tcc,30);
2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);

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

2046: dbms_sql.define_column (g_cursor_nogrp, 10,v_pn_le);
2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);

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

2047: dbms_sql.define_column (g_cursor_nogrp, 11,v_pn_inv_rule_id);
2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);

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

2048: dbms_sql.define_column (g_cursor_nogrp, 12,v_pn_account_rule_id);
2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);

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

2049: dbms_sql.define_column (g_cursor_nogrp, 13,v_pn_term_id);
2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);

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

2050: dbms_sql.define_column (g_cursor_nogrp, 14,v_pn_trx_type_id);
2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);

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

2051: dbms_sql.define_column (g_cursor_nogrp, 15,v_pn_pay_method_id);
2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);

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

2052: dbms_sql.define_column (g_cursor_nogrp, 16,v_pn_po_number,50);
2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);

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

2053: dbms_sql.define_column (g_cursor_nogrp, 17,v_pn_tax_included,1);
2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);

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

2054: dbms_sql.define_column (g_cursor_nogrp, 18,v_pn_salesrep_id);
2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);

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

2055: dbms_sql.define_column (g_cursor_nogrp, 19,v_pn_proj_attr_catg,30);
2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);

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

2056: dbms_sql.define_column (g_cursor_nogrp, 20,v_pn_proj_attr3,150);
2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);

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

2057: dbms_sql.define_column (g_cursor_nogrp, 21,v_pn_proj_attr4,150);
2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);

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

2058: dbms_sql.define_column (g_cursor_nogrp, 22,v_pn_proj_attr5,150);
2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);

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

2059: dbms_sql.define_column (g_cursor_nogrp, 23,v_pn_proj_attr6,150);
2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);

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

2060: dbms_sql.define_column (g_cursor_nogrp, 24,v_pn_proj_attr7,150);
2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);

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

2061: dbms_sql.define_column (g_cursor_nogrp, 25,v_pn_org_id);
2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);

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

2062: dbms_sql.define_column (g_cursor_nogrp, 26,v_pn_lease_num,30);
2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);

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

2063: dbms_sql.define_column (g_cursor_nogrp, 27,v_pn_payment_schedule_id);
2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);

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

2064: dbms_sql.define_column (g_cursor_nogrp, 28,v_pn_period_name,15);
2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);

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

2065: dbms_sql.define_column (g_cursor_nogrp, 29,v_pn_description,30);
2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);

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

2066: dbms_sql.define_column (g_cursor_nogrp, 30,v_pn_lease_id);
2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);

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

2067: dbms_sql.define_column (g_cursor_nogrp, 31,v_transaction_date);
2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2075:

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

2068: dbms_sql.define_column (g_cursor_nogrp, 32,v_normalize,1);
2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2075:
2076:

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

2069: dbms_sql.define_column (g_cursor_nogrp, 33,v_pn_accounted_date);
2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2075:
2076:
2077: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);

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

2070: dbms_sql.define_column (g_cursor_nogrp, 34,v_pn_rate);
2071: dbms_sql.define_column (g_cursor_nogrp, 35,v_location_id);
2072: dbms_sql.define_column (g_cursor_nogrp, 36,v_pur_code,30);
2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2075:
2076:
2077: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);
2078:

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

2073: dbms_sql.define_column (g_cursor_nogrp, 37,v_pur_type_code,30);
2074: dbms_sql.define_column (g_cursor_nogrp, 38, v_schedule_date);
2075:
2076:
2077: l_rows_nogrp := dbms_sql.execute(g_cursor_nogrp);
2078:
2079: LOOP /* looping for c_billitem */
2080:
2081: BEGIN

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

2081: BEGIN
2082:
2083: l_context := 'Fetching from the cursor';
2084:
2085: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2086: EXIT WHEN l_count_nogrp <> 1;
2087: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2088: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2089: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);

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

2083: l_context := 'Fetching from the cursor';
2084:
2085: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2086: EXIT WHEN l_count_nogrp <> 1;
2087: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2088: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2089: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2090: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2091: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);

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

2084:
2085: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2086: EXIT WHEN l_count_nogrp <> 1;
2087: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2088: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2089: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2090: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2091: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2092: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);

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

2085: l_count_nogrp := dbms_sql.fetch_rows(g_cursor_nogrp);
2086: EXIT WHEN l_count_nogrp <> 1;
2087: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2088: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2089: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2090: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2091: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2092: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2093: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);

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

2086: EXIT WHEN l_count_nogrp <> 1;
2087: dbms_sql.column_value (g_cursor_nogrp, 1, v_pn_payment_item_id);
2088: dbms_sql.column_value (g_cursor_nogrp, 2, v_pn_payment_term_id);
2089: dbms_sql.column_value (g_cursor_nogrp, 3, v_pn_export_currency_code);
2090: dbms_sql.column_value (g_cursor_nogrp, 4, v_pn_export_currency_amount);
2091: dbms_sql.column_value (g_cursor_nogrp, 5, v_pn_customer_id);
2092: dbms_sql.column_value (g_cursor_nogrp, 6, v_pn_customer_site_use_id);
2093: dbms_sql.column_value (g_cursor_nogrp, 7, v_pn_cust_ship_site_id);
2094: dbms_sql.column_value (g_cursor_nogrp, 8, v_pn_tax_code_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2118: dbms_sql.column_value (g_cursor_nogrp, 32,v_normalize);
2119: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2120: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2121: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2122: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2123: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2124: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2125:
2126: /* Check for Conversion Type and Conversion Rate for Currency Code */

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

2119: dbms_sql.column_value (g_cursor_nogrp, 33,v_pn_accounted_date);
2120: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2121: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2122: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2123: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2124: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2125:
2126: /* Check for Conversion Type and Conversion Rate for Currency Code */
2127: OPEN get_func_curr_code(l_set_of_books_id);

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

2120: dbms_sql.column_value (g_cursor_nogrp, 34,v_pn_rate);
2121: dbms_sql.column_value (g_cursor_nogrp, 35,v_location_id);
2122: dbms_sql.column_value (g_cursor_nogrp, 36,v_pur_code);
2123: dbms_sql.column_value (g_cursor_nogrp, 37,v_pur_type_code);
2124: dbms_sql.column_value (g_cursor_nogrp, 38,v_schedule_date);
2125:
2126: /* Check for Conversion Type and Conversion Rate for Currency Code */
2127: OPEN get_func_curr_code(l_set_of_books_id);
2128: FETCH get_func_curr_code INTO l_func_curr_code;

Line 2807: IF dbms_sql.is_open (g_cursor_nogrp) THEN

2803: END;
2804:
2805: END LOOP; /* looping for c_billitem */
2806:
2807: IF dbms_sql.is_open (g_cursor_nogrp) THEN
2808: dbms_sql.close_cursor (g_cursor_nogrp);
2809: END IF;
2810:
2811:

Line 2808: dbms_sql.close_cursor (g_cursor_nogrp);

2804:
2805: END LOOP; /* looping for c_billitem */
2806:
2807: IF dbms_sql.is_open (g_cursor_nogrp) THEN
2808: dbms_sql.close_cursor (g_cursor_nogrp);
2809: END IF;
2810:
2811:
2812: COMMIT;

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

2866: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (+)');
2867: IF p_grp_param IS NULL THEN
2868: IF p_lease_num_low IS NOT NULL AND
2869: p_lease_num_high IS NOT NULL THEN
2870: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2871: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2872: ELSIF p_lease_num_low IS NULL AND
2873: p_lease_num_high IS NOT NULL THEN
2874: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);

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

2867: IF p_grp_param IS NULL THEN
2868: IF p_lease_num_low IS NOT NULL AND
2869: p_lease_num_high IS NOT NULL THEN
2870: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2871: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2872: ELSIF p_lease_num_low IS NULL AND
2873: p_lease_num_high IS NOT NULL THEN
2874: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2875: ELSIF p_lease_num_low IS NOT NULL AND

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

2870: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2871: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2872: ELSIF p_lease_num_low IS NULL AND
2873: p_lease_num_high IS NOT NULL THEN
2874: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2875: ELSIF p_lease_num_low IS NOT NULL AND
2876: p_lease_num_high IS NULL THEN
2877: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2878: END IF;

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

2873: p_lease_num_high IS NOT NULL THEN
2874: dbms_sql.bind_variable(p_cursor,'l_lease_num_high',p_lease_num_high);
2875: ELSIF p_lease_num_low IS NOT NULL AND
2876: p_lease_num_high IS NULL THEN
2877: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2878: END IF;
2879: IF p_sch_dt_low IS NOT NULL AND
2880: p_sch_dt_high IS NOT NULL THEN
2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));

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

2877: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);
2878: END IF;
2879: IF p_sch_dt_low IS NOT NULL AND
2880: p_sch_dt_high IS NOT NULL THEN
2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));

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

2878: END IF;
2879: IF p_sch_dt_low IS NOT NULL AND
2880: p_sch_dt_high IS NOT NULL THEN
2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND

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

2881: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2882: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2883: ELSIF p_sch_dt_low IS NULL AND
2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND
2887: p_sch_dt_high IS NULL THEN
2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;

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

2884: p_sch_dt_high IS NOT NULL THEN
2885: dbms_sql.bind_variable(p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high));
2886: ELSIF p_sch_dt_low IS NOT NULL AND
2887: p_sch_dt_high IS NULL THEN
2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));

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

2888: dbms_sql.bind_variable(p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low));
2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));

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

2889: END IF;
2890: IF p_due_dt_low IS NOT NULL AND
2891: p_due_dt_high IS NOT NULL THEN
2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND

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

2892: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2893: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2894: ELSIF p_due_dt_low IS NULL AND
2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND
2898: p_due_dt_high IS NULL THEN
2899: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2900: END IF;

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

2895: p_due_dt_high IS NOT NULL THEN
2896: dbms_sql.bind_variable(p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high));
2897: ELSIF p_due_dt_low IS NOT NULL AND
2898: p_due_dt_high IS NULL THEN
2899: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2900: END IF;
2901: IF p_pay_prps_code IS NOT NULL THEN
2902: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2903: END IF;

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

2898: p_due_dt_high IS NULL THEN
2899: dbms_sql.bind_variable(p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low));
2900: END IF;
2901: IF p_pay_prps_code IS NOT NULL THEN
2902: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2903: END IF;
2904: IF p_prd_name IS NOT NULL THEN
2905: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2906: END IF;

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

2901: IF p_pay_prps_code IS NOT NULL THEN
2902: dbms_sql.bind_variable(p_cursor,'l_pay_prps_code',p_pay_prps_code);
2903: END IF;
2904: IF p_prd_name IS NOT NULL THEN
2905: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2906: END IF;
2907: IF p_amt_low IS NOT NULL AND
2908: p_amt_high IS NOT NULL THEN
2909: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);

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

2905: dbms_sql.bind_variable(p_cursor,'l_prd_name',p_prd_name);
2906: END IF;
2907: IF p_amt_low IS NOT NULL AND
2908: p_amt_high IS NOT NULL THEN
2909: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2910: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2911: ELSIF p_amt_low IS NULL AND
2912: p_amt_high IS NOT NULL THEN
2913: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);

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

2906: END IF;
2907: IF p_amt_low IS NOT NULL AND
2908: p_amt_high IS NOT NULL THEN
2909: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2910: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2911: ELSIF p_amt_low IS NULL AND
2912: p_amt_high IS NOT NULL THEN
2913: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2914: ELSIF p_amt_low IS NOT NULL AND

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

2909: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2910: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2911: ELSIF p_amt_low IS NULL AND
2912: p_amt_high IS NOT NULL THEN
2913: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2914: ELSIF p_amt_low IS NOT NULL AND
2915: p_amt_high IS NULL THEN
2916: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2917: END IF;

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

2912: p_amt_high IS NOT NULL THEN
2913: dbms_sql.bind_variable(p_cursor,'l_amt_high',p_amt_high);
2914: ELSIF p_amt_low IS NOT NULL AND
2915: p_amt_high IS NULL THEN
2916: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2917: END IF;
2918: IF p_customer_id IS NOT NULL THEN
2919: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
2920: END IF;

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

2915: p_amt_high IS NULL THEN
2916: dbms_sql.bind_variable(p_cursor,'l_amt_low',p_amt_low);
2917: END IF;
2918: IF p_customer_id IS NOT NULL THEN
2919: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
2920: END IF;
2921: ELSE
2922: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
2923: END IF;

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

2918: IF p_customer_id IS NOT NULL THEN
2919: dbms_sql.bind_variable(p_cursor,'l_customer_id',p_customer_id);
2920: END IF;
2921: ELSE
2922: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
2923: END IF;
2924: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (-)');
2925: END do_binding;
2926: