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 1518: v_cursor1 := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1534: dbms_sql.close_cursor(v_cursor1);

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