eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_INTER_INVOICE dependencies on DBMS_SQL

Line 36: d_sql_p := DBMS_SQL.open_cursor;

32: print_debug('p_header_id :' || p_header_id, l_module);
33: print_debug('p_line_id :' || p_line_id, l_module);
34: END IF;
35:
36: d_sql_p := DBMS_SQL.open_cursor;
37: d_sql_stmt :=
38: 'select price_adjustment_id '
39: || 'FROM oe_price_adjustments WHERE '
40: || '( line_id = :line_id OR '

Line 43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);

39: || 'FROM oe_price_adjustments WHERE '
40: || '( line_id = :line_id OR '
41: || '(header_id = :header_id AND line_id IS NULL) )'
42: || 'AND nvl(interco_invoiced_flag,''N'') = ''N'' ';
43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);
45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);
46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);

Line 44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);

40: || '( line_id = :line_id OR '
41: || '(header_id = :header_id AND line_id IS NULL) )'
42: || 'AND nvl(interco_invoiced_flag,''N'') = ''N'' ';
43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);
45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);
46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:

Line 45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);

41: || '(header_id = :header_id AND line_id IS NULL) )'
42: || 'AND nvl(interco_invoiced_flag,''N'') = ''N'' ';
43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);
45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);
46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:
49: LOOP

Line 46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);

42: || 'AND nvl(interco_invoiced_flag,''N'') = ''N'' ';
43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);
45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);
46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:
49: LOOP
50: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN

Line 47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);

43: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
44: DBMS_SQL.define_column(d_sql_p, 1, d_priceadjustmentid);
45: DBMS_SQL.bind_variable(d_sql_p, 'line_id', p_line_id);
46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:
49: LOOP
50: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN
51: DBMS_SQL.column_value(d_sql_p, 1, d_priceadjustmentid);

Line 50: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN

46: DBMS_SQL.bind_variable(d_sql_p,'header_id',p_header_id);
47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:
49: LOOP
50: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN
51: DBMS_SQL.column_value(d_sql_p, 1, d_priceadjustmentid);
52:
53: IF l_debug = 1 THEN
54: /*inv_log_util.TRACE('Calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :' || d_priceadjustmentid

Line 51: DBMS_SQL.column_value(d_sql_p, 1, d_priceadjustmentid);

47: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
48:
49: LOOP
50: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN
51: DBMS_SQL.column_value(d_sql_p, 1, d_priceadjustmentid);
52:
53: IF l_debug = 1 THEN
54: /*inv_log_util.TRACE('Calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :' || d_priceadjustmentid
55: , l_module);*/

Line 63: DBMS_SQL.close_cursor(d_sql_p);

59:
60: oe_invoice_util.update_interco_invoiced_flag(d_priceadjustmentid, x_return_status);
61: ELSE
62: -- No more rows in cursor
63: DBMS_SQL.close_cursor(d_sql_p);
64: EXIT;
65: END IF;
66: END LOOP;
67:

Line 68: IF DBMS_SQL.is_open(d_sql_p) THEN

64: EXIT;
65: END IF;
66: END LOOP;
67:
68: IF DBMS_SQL.is_open(d_sql_p) THEN
69: DBMS_SQL.close_cursor(d_sql_p);
70: END IF;
71: EXCEPTION
72: WHEN OTHERS THEN

Line 69: DBMS_SQL.close_cursor(d_sql_p);

65: END IF;
66: END LOOP;
67:
68: IF DBMS_SQL.is_open(d_sql_p) THEN
69: DBMS_SQL.close_cursor(d_sql_p);
70: END IF;
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF DBMS_SQL.is_open(d_sql_p) THEN

Line 73: IF DBMS_SQL.is_open(d_sql_p) THEN

69: DBMS_SQL.close_cursor(d_sql_p);
70: END IF;
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF DBMS_SQL.is_open(d_sql_p) THEN
74: DBMS_SQL.close_cursor(d_sql_p);
75: END IF;
76:
77: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 74: DBMS_SQL.close_cursor(d_sql_p);

70: END IF;
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF DBMS_SQL.is_open(d_sql_p) THEN
74: DBMS_SQL.close_cursor(d_sql_p);
75: END IF;
76:
77: x_return_status := fnd_api.g_ret_sts_unexp_error;
78: