APPS.OZF_SD_BATCH_PVT dependencies on DBMS_SQL

Line 2098: l_lines_csr := DBMS_SQL.open_cursor;

2094: FND_DSQL.add_text(' FOR UPDATE OF FU.PLAN_CURR_AMOUNT_REMAINING NOWAIT' );
2095:
2096:
2097: --creating cursor
2098: l_lines_csr := DBMS_SQL.open_cursor;
2099: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
2100:
2101: IF OZF_DEBUG_LOW_ON THEN
2102: FND_FILE.PUT_LINE(FND_FILE.LOG, '---Start Query Text ---');

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

2120: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --End Query Text --');
2121: END IF;
2122:
2123: FND_DSQL.set_cursor(l_lines_csr);
2124: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
2125: FND_DSQL.do_binds;
2126:
2127: --define columns
2128:

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

2125: FND_DSQL.do_binds;
2126:
2127: --define columns
2128:
2129: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2130: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);

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

2126:
2127: --define columns
2128:
2129: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2130: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:

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

2127: --define columns
2128:
2129: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2130: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);

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

2128:
2129: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2130: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

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

2129: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2130: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

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

2131: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);

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

2132: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:

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

2133: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);

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

2134:
2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);

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

2135: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2136: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2143:

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

2137: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2143:
2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);

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

2138: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2139: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2143:
2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:

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

2140:
2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2143:
2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);

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

2141: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2142: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2143:
2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);

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

2143:
2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);

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

2144: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);

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

2145: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);

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

2146:
2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);

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

2147: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);

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

2148: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:

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

2149: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);

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

2150: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);

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

2151: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2152: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);

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

2153: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);

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

2154: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);

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

2155: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);

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

2156:
2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);

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

2157: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);

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

2158: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:

Line 2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);

2159: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);

Line 2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);

2160: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);

Line 2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);

2161: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
2162: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);

Line 2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);

2163: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
2170: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
2171:

Line 2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);

2164: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
2170: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
2171:
2172: --execute cursor

Line 2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);

2165: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
2170: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
2171:
2172: --execute cursor
2173:

Line 2170: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);

2166:
2167: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
2168: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
2169: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
2170: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
2171:
2172: --execute cursor
2173:
2174: IF OZF_DEBUG_LOW_ON THEN

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

2174: IF OZF_DEBUG_LOW_ON THEN
2175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cursor Execute Start time' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
2176: END IF;
2177:
2178: l_ignore := DBMS_SQL.execute(l_lines_csr);
2179:
2180: IF OZF_DEBUG_LOW_ON THEN
2181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cursor Execute End time' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
2182: END IF;

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

2186:
2187: LOOP
2188:
2189: IF OZF_DEBUG_LOW_ON THEN
2190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
2191: END IF;
2192:
2193: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
2194:

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

2189: IF OZF_DEBUG_LOW_ON THEN
2190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
2191: END IF;
2192:
2193: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
2194:
2195: IF OZF_DEBUG_HIGH_ON THEN
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
2197: END IF;

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

2192:
2193: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
2194:
2195: IF OZF_DEBUG_HIGH_ON THEN
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
2197: END IF;
2198:
2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);

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

2195: IF OZF_DEBUG_HIGH_ON THEN
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
2197: END IF;
2198:
2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);

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

2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
2197: END IF;
2198:
2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:

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

2197: END IF;
2198:
2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);

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

2198:
2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

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

2199: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
2200: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

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

2201: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);

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

2202: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:

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

2203: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);

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

2204:
2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);

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

2205: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
2206: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:

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

2207: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);

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

2208: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
2209: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);

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

2210:
2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);

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

2211: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);

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

2212: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);

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

2213:
2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);

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

2214: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);

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

2215: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);

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

2216: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);

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

2217: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:

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

2218: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);

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

2219: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);

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

2220: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
2221: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);

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

2222: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);

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

2223: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);

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

2224: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);

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

2225:
2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);

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

2226: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);

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

2227: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);

Line 2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);

2228: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);

Line 2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);

2229: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);

Line 2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);

2230: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);

Line 2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);

2231: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
2239:

Line 2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);

2232: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
2239:
2240: IF OZF_DEBUG_HIGH_ON THEN

Line 2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);

2233: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
2239:
2240: IF OZF_DEBUG_HIGH_ON THEN
2241: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');

Line 2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);

2234: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
2235: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
2236: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
2237: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
2238: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
2239:
2240: IF OZF_DEBUG_HIGH_ON THEN
2241: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');
2242: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 2941: l_lines_csr := DBMS_SQL.open_cursor;

2937: FND_DSQL.add_text(' FOR UPDATE OF FU.PLAN_CURR_AMOUNT_REMAINING NOWAIT' );
2938:
2939:
2940: --creating cursor
2941: l_lines_csr := DBMS_SQL.open_cursor;
2942: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
2943:
2944: IF OZF_DEBUG_LOW_ON THEN
2945: FND_FILE.PUT_LINE(FND_FILE.LOG, '---Start Query Text ---');

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

2963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --End Query Text --');
2964: END IF;
2965:
2966: FND_DSQL.set_cursor(l_lines_csr);
2967: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
2968: FND_DSQL.do_binds;
2969:
2970: --define columns
2971:

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

2968: FND_DSQL.do_binds;
2969:
2970: --define columns
2971:
2972: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2973: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);

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

2969:
2970: --define columns
2971:
2972: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2973: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:

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

2970: --define columns
2971:
2972: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2973: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);

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

2971:
2972: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2973: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

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

2972: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);
2973: DBMS_SQL.define_column(l_lines_csr, 2, l_utilization_id);
2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

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

2974: DBMS_SQL.define_column(l_lines_csr, 3, l_agreement_number, 100);
2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);

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

2975: DBMS_SQL.define_column(l_lines_csr, 4, l_ship_to_org_id);
2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:

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

2976: DBMS_SQL.define_column(l_lines_csr, 5, l_ship_to_contact_id);
2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);

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

2977:
2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);

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

2978: DBMS_SQL.define_column(l_lines_csr, 6, l_sold_to_customer_id);
2979: DBMS_SQL.define_column(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2986:

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

2980: DBMS_SQL.define_column(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2986:
2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);

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

2981: DBMS_SQL.define_column(l_lines_csr, 9, l_end_customer_id);
2982: DBMS_SQL.define_column(l_lines_csr, 10, l_end_customer_contact_id);
2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2986:
2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:

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

2983:
2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2986:
2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);

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

2984: DBMS_SQL.define_column(l_lines_csr, 11, l_order_header_id);
2985: DBMS_SQL.define_column(l_lines_csr, 12, l_order_line_number);
2986:
2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);

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

2986:
2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);

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

2987: DBMS_SQL.define_column(l_lines_csr, 13, l_invoice_number);
2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);

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

2988: DBMS_SQL.define_column(l_lines_csr, 14, l_invoice_line_number);
2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);

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

2989:
2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);

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

2990: DBMS_SQL.define_column(l_lines_csr, 15, l_resale_price_currency_code, 15);
2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);

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

2991: DBMS_SQL.define_column(l_lines_csr, 16, l_resales_price);
2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:

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

2992: DBMS_SQL.define_column(l_lines_csr, 17, l_list_price_currency_code, 15);
2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);

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

2993: DBMS_SQL.define_column(l_lines_csr, 18, l_list_price);
2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);

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

2994: DBMS_SQL.define_column(l_lines_csr, 19, l_agreement_currency_code, 15);
2995: DBMS_SQL.define_column(l_lines_csr, 20, l_agreement_price);
2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);

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

2996: DBMS_SQL.define_column(l_lines_csr, 21, l_claim_amount);
2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);

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

2997: DBMS_SQL.define_column(l_lines_csr, 22, l_batch_curr_claim_amount);
2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);

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

2998: DBMS_SQL.define_column(l_lines_csr, 23, l_item_id);
2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);

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

2999:
3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);

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

3000: DBMS_SQL.define_column(l_lines_csr, 24, l_shipped_quantity_uom, 100);
3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);

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

3001: DBMS_SQL.define_column(l_lines_csr, 25, l_quantity_shipped);
3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:

Line 3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);

3002: DBMS_SQL.define_column(l_lines_csr, 26, l_order_date);
3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);

Line 3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);

3003: DBMS_SQL.define_column(l_lines_csr, 27, l_claim_amount_currency_code, 15);
3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);

Line 3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);

3004: DBMS_SQL.define_column(l_lines_csr, 28, l_acct_amount_remaining);
3005: DBMS_SQL.define_column(l_lines_csr, 29, l_univ_curr_amount_remaining);
3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);

Line 3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);

3006: DBMS_SQL.define_column(l_lines_csr, 30, l_fund_req_amount_remaining);
3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
3013: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
3014:

Line 3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);

3007: DBMS_SQL.define_column(l_lines_csr, 31, l_amount_remaining);
3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
3013: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
3014:
3015: --execute cursor

Line 3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);

3008: DBMS_SQL.define_column(l_lines_csr, 32, l_inv_org_id);
3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
3013: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
3014:
3015: --execute cursor
3016:

Line 3013: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);

3009:
3010: DBMS_SQL.define_column(l_lines_csr, 33, l_approved_discount_type,30);
3011: DBMS_SQL.define_column(l_lines_csr, 34, l_approved_discount_value);
3012: DBMS_SQL.define_column(l_lines_csr, 35, l_approved_discount_currency,15);
3013: DBMS_SQL.define_column(l_lines_csr, 36, l_adjustment_type_id);
3014:
3015: --execute cursor
3016:
3017: IF OZF_DEBUG_LOW_ON THEN

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

3017: IF OZF_DEBUG_LOW_ON THEN
3018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cursor Execute Start time' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
3019: END IF;
3020:
3021: l_ignore := DBMS_SQL.execute(l_lines_csr);
3022:
3023: IF OZF_DEBUG_LOW_ON THEN
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cursor Execute End time' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
3025: END IF;

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

3029:
3030: LOOP
3031:
3032: IF OZF_DEBUG_LOW_ON THEN
3033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
3034: END IF;
3035:
3036: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
3037:

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

3032: IF OZF_DEBUG_LOW_ON THEN
3033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - Before Fetch');
3034: END IF;
3035:
3036: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
3037:
3038: IF OZF_DEBUG_HIGH_ON THEN
3039: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
3040: END IF;

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

3035:
3036: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_lines_csr) = 0;
3037:
3038: IF OZF_DEBUG_HIGH_ON THEN
3039: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
3040: END IF;
3041:
3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);

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

3038: IF OZF_DEBUG_HIGH_ON THEN
3039: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
3040: END IF;
3041:
3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);

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

3039: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DBMS_SQL.FETCH_ROWS loop - After Fetch');
3040: END IF;
3041:
3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:

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

3040: END IF;
3041:
3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);

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

3041:
3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);

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

3042: DBMS_SQL.column_value(l_lines_csr, 1, l_batch_line_id);
3043: DBMS_SQL.column_value(l_lines_csr, 2, l_utilization_id);
3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);

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

3044: DBMS_SQL.column_value(l_lines_csr, 3, l_agreement_number);
3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);

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

3045: DBMS_SQL.column_value(l_lines_csr, 4, l_ship_to_org_id);
3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:

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

3046: DBMS_SQL.column_value(l_lines_csr, 5, l_ship_to_contact_id);
3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);

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

3047:
3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);

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

3048: DBMS_SQL.column_value(l_lines_csr, 6, l_sold_to_customer_id);
3049: DBMS_SQL.column_value(l_lines_csr, 7, l_SOLD_TO_CONTACT_ID);
3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:

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

3050: DBMS_SQL.column_value(l_lines_csr, 8, l_SOLD_TO_SITE_USE_ID);
3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);

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

3051: DBMS_SQL.column_value(l_lines_csr, 9, l_end_customer_id);
3052: DBMS_SQL.column_value(l_lines_csr, 10, l_end_customer_contact_id);
3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);

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

3053:
3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);

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

3054: DBMS_SQL.column_value(l_lines_csr, 11, l_order_header_id);
3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);

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

3055: DBMS_SQL.column_value(l_lines_csr, 12, l_order_line_number);
3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);

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

3056:
3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);

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

3057: DBMS_SQL.column_value(l_lines_csr, 13, l_invoice_number);
3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);

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

3058: DBMS_SQL.column_value(l_lines_csr, 14, l_invoice_line_number);
3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);

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

3059: DBMS_SQL.column_value(l_lines_csr, 15, l_resale_price_currency_code);
3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);

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

3060: DBMS_SQL.column_value(l_lines_csr, 16, l_resales_price);
3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:

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

3061: DBMS_SQL.column_value(l_lines_csr, 17, l_list_price_currency_code);
3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);

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

3062: DBMS_SQL.column_value(l_lines_csr, 18, l_list_price);
3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);

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

3063: DBMS_SQL.column_value(l_lines_csr, 19, l_agreement_currency_code);
3064: DBMS_SQL.column_value(l_lines_csr, 20, l_agreement_price);
3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);

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

3065: DBMS_SQL.column_value(l_lines_csr, 21, l_claim_amount);
3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);

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

3066: DBMS_SQL.column_value(l_lines_csr, 22, l_batch_curr_claim_amount);
3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);

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

3067: DBMS_SQL.column_value(l_lines_csr, 23, l_item_id);
3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);

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

3068:
3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);

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

3069: DBMS_SQL.column_value(l_lines_csr, 24, l_shipped_quantity_uom);
3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);

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

3070: DBMS_SQL.column_value(l_lines_csr, 25, l_quantity_shipped);
3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);

Line 3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);

3071: DBMS_SQL.column_value(l_lines_csr, 26, l_order_date);
3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);

Line 3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);

3072: DBMS_SQL.column_value(l_lines_csr, 27, l_claim_amount_currency_code);
3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);

Line 3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);

3073: DBMS_SQL.column_value(l_lines_csr, 28, l_acct_amount_remaining);
3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);

Line 3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);

3074: DBMS_SQL.column_value(l_lines_csr, 29, l_univ_curr_amount_remaining);
3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
3082:

Line 3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);

3075: DBMS_SQL.column_value(l_lines_csr, 30, l_fund_req_amount_remaining);
3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
3082:
3083: IF OZF_DEBUG_HIGH_ON THEN

Line 3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);

3076: DBMS_SQL.column_value(l_lines_csr, 31, l_amount_remaining);
3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
3082:
3083: IF OZF_DEBUG_HIGH_ON THEN
3084: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');

Line 3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);

3077: DBMS_SQL.column_value(l_lines_csr, 32, l_inv_org_id);
3078: DBMS_SQL.column_value(l_lines_csr, 33, l_approved_discount_type);
3079: DBMS_SQL.column_value(l_lines_csr, 34, l_approved_discount_value);
3080: DBMS_SQL.column_value(l_lines_csr, 35, l_approved_discount_currency);
3081: DBMS_SQL.column_value(l_lines_csr, 36, l_adjustment_type_id);
3082:
3083: IF OZF_DEBUG_HIGH_ON THEN
3084: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Check for Line Amount Threshold ---');
3085: FND_FILE.PUT_LINE(FND_FILE.LOG,