APPS.OZF_SD_BATCH_PVT dependencies on DBMS_SQL

Line 1697: l_lines_csr := DBMS_SQL.open_cursor;

1693: FND_DSQL.add_bind('' || p_attribute15 || '');
1694: END IF;
1695:
1696: --creating cursor
1697: l_lines_csr := DBMS_SQL.open_cursor;
1698: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
1699:
1700: IF OZF_DEBUG_LOW_ON THEN
1701: FND_FILE.PUT_LINE(FND_FILE.LOG, '---Start Query Text ---');

Line 1723: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);

1719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --End Query Text --');
1720: END IF;
1721:
1722: FND_DSQL.set_cursor(l_lines_csr);
1723: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
1724: FND_DSQL.do_binds;
1725:
1726: --define columns
1727:

Line 1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);

1724: FND_DSQL.do_binds;
1725:
1726: --define columns
1727:
1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);

Line 1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);

1725:
1726: --define columns
1727:
1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:

Line 1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);

1726: --define columns
1727:
1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);

Line 1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);

1727:
1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

Line 1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);

1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
1729: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

Line 1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);

1730: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);

Line 1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

1731: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:

Line 1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

1732: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);

Line 1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);

1733:
1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);

Line 1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);

1734: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
1735: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);

Line 1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);

1736: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);

Line 1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);

1737: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);

Line 1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);

1738: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);

Line 1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);

1739:
1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);

Line 1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);

1740: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);

Line 1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);

1741: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);

Line 1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);

1742: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);

Line 1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);

1743: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);

Line 1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);

1744: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);

Line 1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);

1745: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:

Line 1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);

1746: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);

Line 1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);

1747: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);

Line 1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);

1748: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
1749: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);

Line 1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);

1750: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);

Line 1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);

1751: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);

Line 1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);

1752: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);

Line 1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);

1753:
1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);
1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);

Line 1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);

1754: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);
1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);
1762:

Line 1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);

1755: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);
1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);
1762:
1763: --execute cursor

Line 1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);

1756: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);
1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);
1762:
1763: --execute cursor
1764:

Line 1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);

1757: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
1758: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
1759: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
1760: DBMS_SQL.define_column(l_lines_csr, 30, l_amount_remaining);
1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);
1762:
1763: --execute cursor
1764:
1765: l_ignore := DBMS_SQL.execute(l_lines_csr);

Line 1765: l_ignore := DBMS_SQL.execute(l_lines_csr);

1761: DBMS_SQL.define_column(l_lines_csr, 31, l_inv_org_id);
1762:
1763: --execute cursor
1764:
1765: l_ignore := DBMS_SQL.execute(l_lines_csr);
1766: p_empty_batch := 'Y'; -- to check if any lines were created
1767: l_batch_line_number := 1;
1768:
1769: LOOP

Line 1772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');

1768:
1769: LOOP
1770:
1771: IF OZF_DEBUG_LOW_ON THEN
1772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
1773: END IF;
1774:
1775: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
1776:

Line 1775: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;

1771: IF OZF_DEBUG_LOW_ON THEN
1772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
1773: END IF;
1774:
1775: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
1776:
1777: IF OZF_DEBUG_HIGH_ON THEN
1778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
1779: END IF;

Line 1778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');

1774:
1775: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
1776:
1777: IF OZF_DEBUG_HIGH_ON THEN
1778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
1779: END IF;
1780:
1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);

Line 1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);

1777: IF OZF_DEBUG_HIGH_ON THEN
1778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
1779: END IF;
1780:
1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);

Line 1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);

1778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
1779: END IF;
1780:
1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:

Line 1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);

1779: END IF;
1780:
1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);

Line 1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);

1780:
1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

Line 1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);

1781: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
1782: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

Line 1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);

1783: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);

Line 1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

1784: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:

Line 1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

1785: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);

Line 1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);

1786:
1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);

Line 1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);

1787: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
1788: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);

Line 1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);

1789: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);

Line 1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);

1790: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);

Line 1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);

1791: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);

Line 1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);

1792:
1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);

Line 1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);

1793: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);

Line 1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);

1794: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);

Line 1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);

1795: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);

Line 1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);

1796: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);

Line 1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);

1797: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);

Line 1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);

1798: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:

Line 1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);

1799: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);

Line 1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);

1800: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);

Line 1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);

1801: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
1802: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);

Line 1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);

1803: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);

Line 1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);

1804: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);

Line 1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);

1805: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);

Line 1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);

1806:
1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);
1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);

Line 1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);

1807: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);
1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);
1815:

Line 1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);

1808: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);
1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);
1815:
1816: IF OZF_DEBUG_HIGH_ON THEN

Line 1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);

1809: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);
1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);
1815:
1816: IF OZF_DEBUG_HIGH_ON THEN
1817: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');

Line 1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);

1810: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
1811: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
1812: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
1813: DBMS_SQL.column_value(l_lines_csr, 30, l_amount_remaining);
1814: DBMS_SQL.column_value(l_lines_csr, 31, l_inv_org_id);
1815:
1816: IF OZF_DEBUG_HIGH_ON THEN
1817: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,