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_LOT_TRX_VALIDATION_PVT dependencies on INV_LOT_SEL_ATTR

Line 9: g_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

5: lot Attributes of MTL_LOT_NUMBERS table which will then be used in
6: get_lot_att_record procedure to populate the values for the corresponding columns.
7: */
8:
9: g_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
10:
11: /*Bug 5354721. Building the following statement to get lot attributes from MTLI or MLN. */
12: g_select_stmt LONG :=
13: 'SELECT

Line 1222: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1218: poupulation can only be done once and be re-used for all the subsequent records.
1219: */
1220: PROCEDURE get_lot_attr_table
1221: IS
1222: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1223: l_debug NUMBER
1224: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1225:
1226: BEGIN

Line 1485: x_lot_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

1481: END get_lot_attr_table;
1482:
1483:
1484: PROCEDURE get_lot_attr_record (
1485: x_lot_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
1486: , p_transaction_interface_id IN NUMBER
1487: , p_lot_number IN VARCHAR2
1488: , p_starting_lot_number IN VARCHAR2
1489: , p_organization_id IN NUMBER

Line 1515: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1511: AND owner = l_app_owner_schema
1512: AND column_id > 22
1513: ORDER BY column_id; */
1514:
1515: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1516: l_column_idx NUMBER;
1517: l_select_stmt LONG := NULL;
1518: l_sql_p INTEGER := NULL;
1519: l_rows_processed INTEGER := NULL;

Line 1760: p_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

1756: END IF;
1757: END get_lot_attr_record;
1758:
1759: PROCEDURE update_lot_attr_record (
1760: p_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
1761: , p_transaction_interface_id IN NUMBER
1762: , p_lot_number IN VARCHAR2
1763: , p_organization_id IN NUMBER
1764: , p_inventory_item_id IN NUMBER

Line 1767: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1763: , p_organization_id IN NUMBER
1764: , p_inventory_item_id IN NUMBER
1765: )
1766: IS
1767: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1768: l_column_idx NUMBER;
1769: l_update_stmt LONG := 'UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET ';
1770: l_sql_p INTEGER := NULL;
1771: l_rows_processed INTEGER := NULL;

Line 1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;
1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

Line 1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;
1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

Line 1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1892: l_rs_index NUMBER;
1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
1900: l_wms_installed VARCHAR2 (1);

Line 2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;
2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE
2799: := NULL;

Line 2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;
2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE
2799: := NULL;
2800: l_max_lot_qty NUMBER := 0;

Line 2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2793: l_rs_index NUMBER;
2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2797: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2798: l_represenatative_lot mtl_transaction_lots_interface.lot_number%TYPE
2799: := NULL;
2800: l_max_lot_qty NUMBER := 0;
2801: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE

Line 3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;
3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;
3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3583: l_distribution_account_id wsm_parameters.transaction_account_id%TYPE

Line 3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3583: l_distribution_account_id wsm_parameters.transaction_account_id%TYPE
3584: := NULL;
3585: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
3586: l_wms_installed VARCHAR2 (1);