APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on DBMS_SQL

Line 1633: l_sql_p := DBMS_SQL.open_cursor;

1629: THEN
1630: print_debug ('after setting the sql stmt', 'get_lot_attr_record');
1631: END IF;
1632:
1633: l_sql_p := DBMS_SQL.open_cursor;
1634: DBMS_SQL.parse (l_sql_p, l_select_stmt, DBMS_SQL.native);
1635: DBMS_SQL.bind_variable (l_sql_p
1636: , 'b_interface_id'
1637: , p_transaction_interface_id

Line 1634: DBMS_SQL.parse (l_sql_p, l_select_stmt, DBMS_SQL.native);

1630: print_debug ('after setting the sql stmt', 'get_lot_attr_record');
1631: END IF;
1632:
1633: l_sql_p := DBMS_SQL.open_cursor;
1634: DBMS_SQL.parse (l_sql_p, l_select_stmt, DBMS_SQL.native);
1635: DBMS_SQL.bind_variable (l_sql_p
1636: , 'b_interface_id'
1637: , p_transaction_interface_id
1638: );

Line 1635: DBMS_SQL.bind_variable (l_sql_p

1631: END IF;
1632:
1633: l_sql_p := DBMS_SQL.open_cursor;
1634: DBMS_SQL.parse (l_sql_p, l_select_stmt, DBMS_SQL.native);
1635: DBMS_SQL.bind_variable (l_sql_p
1636: , 'b_interface_id'
1637: , p_transaction_interface_id
1638: );
1639: DBMS_SQL.bind_variable (l_sql_p, 'b_lot_number', p_lot_number);

Line 1639: DBMS_SQL.bind_variable (l_sql_p, 'b_lot_number', p_lot_number);

1635: DBMS_SQL.bind_variable (l_sql_p
1636: , 'b_interface_id'
1637: , p_transaction_interface_id
1638: );
1639: DBMS_SQL.bind_variable (l_sql_p, 'b_lot_number', p_lot_number);
1640:
1641: IF l_lot_num = 0
1642: THEN
1643: DBMS_SQL.bind_variable (l_sql_p

Line 1643: DBMS_SQL.bind_variable (l_sql_p

1639: DBMS_SQL.bind_variable (l_sql_p, 'b_lot_number', p_lot_number);
1640:
1641: IF l_lot_num = 0
1642: THEN
1643: DBMS_SQL.bind_variable (l_sql_p
1644: , 'b_starting_lot_number'
1645: , p_starting_lot_number
1646: );
1647: END IF;

Line 1661: DBMS_SQL.define_column (l_sql_p

1657:
1658: FOR i IN 1 .. l_lot_attr_tbl.COUNT
1659: LOOP
1660: l_column_idx := i;
1661: DBMS_SQL.define_column (l_sql_p
1662: , l_column_idx
1663: , l_lot_attr_tbl (i).column_value
1664: , l_lot_attr_tbl (i).column_length
1665: );

Line 1673: l_rows_processed := DBMS_SQL.EXECUTE (l_sql_p);

1669: THEN
1670: print_debug ('after define columns', 'get_lot_attr_record');
1671: END IF;
1672:
1673: l_rows_processed := DBMS_SQL.EXECUTE (l_sql_p);
1674:
1675: IF (l_debug = 1)
1676: THEN
1677: print_debug ('l_rows_processed is ' || l_rows_processed

Line 1691: IF (DBMS_SQL.fetch_rows (l_sql_p) > 0)

1687: );
1688: END IF;
1689:
1690: LOOP
1691: IF (DBMS_SQL.fetch_rows (l_sql_p) > 0)
1692: THEN
1693: l_column_idx := 0;
1694:
1695: FOR i IN 1 .. l_lot_attr_tbl.COUNT

Line 1698: DBMS_SQL.column_value (l_sql_p

1694:
1695: FOR i IN 1 .. l_lot_attr_tbl.COUNT
1696: LOOP
1697: l_column_idx := i;
1698: DBMS_SQL.column_value (l_sql_p
1699: , l_column_idx
1700: , l_lot_attr_tbl (i).column_value
1701: );
1702: END LOOP;

Line 1704: --dbms_sql.close_cursor(l_sql_p);

1700: , l_lot_attr_tbl (i).column_value
1701: );
1702: END LOOP;
1703: ELSE
1704: --dbms_sql.close_cursor(l_sql_p);
1705: EXIT;
1706: END IF;
1707:
1708: EXIT;

Line 1716: DBMS_SQL.close_cursor (l_sql_p);

1712: THEN
1713: print_debug ('after fetching rows', 'get_lot_attr_record');
1714: END IF;
1715:
1716: DBMS_SQL.close_cursor (l_sql_p);
1717:
1718: IF (l_debug = 1)
1719: THEN
1720: print_debug ('after closing cursor', 'get_lot_attr_record');