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

Line 1516: v_cursor1 := dbms_sql.open_cursor;

1512: and invoice_currency_code = :invoice_currency_code_bind
1513: and trx_date = :trx_date_bind
1514: group by trx_date,customer_trx_id)
1515: where rank_amt = 1 ';
1516: v_cursor1 := dbms_sql.open_cursor;
1517: dbms_sql.parse(v_cursor1,l_text,DBMS_SQL.V7);
1518:
1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);

Line 1517: dbms_sql.parse(v_cursor1,l_text,DBMS_SQL.V7);

1513: and trx_date = :trx_date_bind
1514: group by trx_date,customer_trx_id)
1515: where rank_amt = 1 ';
1516: v_cursor1 := dbms_sql.open_cursor;
1517: dbms_sql.parse(v_cursor1,l_text,DBMS_SQL.V7);
1518:
1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);
1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);

Line 1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);

1516: v_cursor1 := dbms_sql.open_cursor;
1517: dbms_sql.parse(v_cursor1,l_text,DBMS_SQL.V7);
1518:
1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);
1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);
1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:

Line 1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);

1517: dbms_sql.parse(v_cursor1,l_text,DBMS_SQL.V7);
1518:
1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);
1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);
1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);

Line 1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);

1518:
1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);
1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);
1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);

Line 1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);

1519: -- 5217077 (One-off:5096808). Bind the bind-variables here.
1520: dbms_sql.bind_variable(v_cursor1, ':customer_id_bind', l_history_rec.customer_id);
1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);
1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);

Line 1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);

1521: dbms_sql.bind_variable(v_cursor1, ':customer_site_use_id_bind', l_history_rec.site_use_id);
1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);

Line 1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);

1522: dbms_sql.bind_variable(v_cursor1, ':invoice_currency_code_bind', l_history_rec.currency_code);
1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);

Line 1527: v_return_code := dbms_sql.execute(v_cursor1);

1523: dbms_sql.bind_variable(v_cursor1, ':trx_date_bind', l_history_rec.trx_date);
1524:
1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);
1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);

Line 1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);

1525: dbms_sql.define_column(v_cursor1,1,l_larg_inv_cust_trx_id);
1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);
1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);
1532: dbms_sql.close_cursor(v_cursor1);
1533:

Line 1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);

1526: dbms_sql.define_column(v_cursor1,2,l_larg_inv_amt);
1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);
1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);
1532: dbms_sql.close_cursor(v_cursor1);
1533:
1534: END IF;

Line 1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);

1527: v_return_code := dbms_sql.execute(v_cursor1);
1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);
1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);
1532: dbms_sql.close_cursor(v_cursor1);
1533:
1534: END IF;
1535: CLOSE get_curr_larg_inv_info;

Line 1532: dbms_sql.close_cursor(v_cursor1);

1528:
1529: v_NumRows := DBMS_SQL.FETCH_ROWS(v_cursor1);
1530: DBMS_SQL.COLUMN_VALUE(v_cursor1,1,l_larg_inv_cust_trx_id);
1531: DBMS_SQL.COLUMN_VALUE(v_cursor1,2,l_larg_inv_amt);
1532: dbms_sql.close_cursor(v_cursor1);
1533:
1534: END IF;
1535: CLOSE get_curr_larg_inv_info;
1536: END IF;