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.INL_SHIPMENT_PVT dependencies on DUAL

Line 4745: FROM dual;

4741: p_debug_info => l_debug_info
4742: ) ;
4743: SELECT inl_tax_lines_s.nextval
4744: INTO x_new_tax_line_id
4745: FROM dual;
4746: --
4747: -- include Tax Line record
4748: --
4749: l_debug_info := 'Including Tax Line record ';

Line 6327: INTO x_new_charge_line_id FROM dual;

6323: p_procedure_name => l_program_name,
6324: p_debug_info => l_debug_info
6325: ) ;
6326: SELECT inl_charge_lines_s.nextval
6327: INTO x_new_charge_line_id FROM dual;
6328: --
6329: -- include Charge Line record
6330: --
6331: l_debug_info := 'Including Charge Line record ';

Line 11441: FROM DUAL;

11437: IF NVL(l_exist_associations, 0) > 0 THEN -- Exist associations for charge
11438:
11439: SELECT inl_charge_lines_s.nextval
11440: INTO l_charge_line_id
11441: FROM DUAL;
11442:
11443: l_debug_info := 'Get next charge line number';
11444: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
11445: p_procedure_name => l_program_name,

Line 13515: -- API name : Validate_DualQuantities

13511: END Get_LastUpdateDateForShip;
13512: -- Bug /#9098758
13513:
13514: -- START Bug #13914863
13515: -- API name : Validate_DualQuantities
13516: -- Type : Private
13517: -- Function : Validates Primary/Secondary quantity deviation
13518: -- when processing Dual UOM controlled items.
13519: -- Pre-reqs : None

Line 13518: -- when processing Dual UOM controlled items.

13514: -- START Bug #13914863
13515: -- API name : Validate_DualQuantities
13516: -- Type : Private
13517: -- Function : Validates Primary/Secondary quantity deviation
13518: -- when processing Dual UOM controlled items.
13519: -- Pre-reqs : None
13520: -- Parameters :
13521: -- IN : p_api_version IN NUMBER
13522: -- p_init_msg_list IN VARCHAR2 := L_FND_FALSE

Line 13538: PROCEDURE Validate_DualQuantities( p_api_version IN NUMBER,

13534: --
13535: -- Version : Current version 1.0
13536: --
13537: -- Notes :
13538: PROCEDURE Validate_DualQuantities( p_api_version IN NUMBER,
13539: p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
13540: p_commit IN VARCHAR2 := L_FND_FALSE,
13541: p_organization_id IN NUMBER,
13542: p_inventory_item_id IN NUMBER,

Line 13551: l_api_name CONSTANT VARCHAR2(30) := 'Validate_DualQuantities';

13547: x_return_status OUT NOCOPY VARCHAR2,
13548: x_msg_count OUT NOCOPY NUMBER,
13549: x_msg_data OUT NOCOPY VARCHAR2) IS -- Bug #13914863
13550:
13551: l_api_name CONSTANT VARCHAR2(30) := 'Validate_DualQuantities';
13552: l_debug_info VARCHAR2(200);
13553: l_api_version CONSTANT NUMBER := 1.0;
13554: l_lot_number VARCHAR2(30);
13555: l_primary_qty NUMBER;

Line 13693: END Validate_DualQuantities;

13689: FND_MSG_PUB.Count_And_Get (
13690: p_encoded => L_FND_FALSE,
13691: p_count => x_msg_count,
13692: p_data => x_msg_data) ;
13693: END Validate_DualQuantities;
13694:
13695: -- Utility name: Derive_DualQuantities
13696: -- Type : Public
13697: -- Function : Derive Primary/Secondary Qty when processing

Line 13695: -- Utility name: Derive_DualQuantities

13691: p_count => x_msg_count,
13692: p_data => x_msg_data) ;
13693: END Validate_DualQuantities;
13694:
13695: -- Utility name: Derive_DualQuantities
13696: -- Type : Public
13697: -- Function : Derive Primary/Secondary Qty when processing
13698: -- Dual Uom controlled items
13699: -- Pre-reqs : None

Line 13698: -- Dual Uom controlled items

13694:
13695: -- Utility name: Derive_DualQuantities
13696: -- Type : Public
13697: -- Function : Derive Primary/Secondary Qty when processing
13698: -- Dual Uom controlled items
13699: -- Pre-reqs : None
13700: -- Parameters :
13701: -- IN : p_organization_id IN NUMBER
13702: -- p_inventory_item_id IN NUMBER

Line 13710: FUNCTION Derive_DualQuantities(p_organization_id IN NUMBER,

13706: -- p_secondary_qty IN NUMBER
13707: -- p_secondary_uom_code IN VARCHAR2
13708: --
13709: -- Notes :
13710: FUNCTION Derive_DualQuantities(p_organization_id IN NUMBER,
13711: p_inventory_item_id IN NUMBER,
13712: p_calling_field IN VARCHAR2,
13713: p_txn_qty IN NUMBER,
13714: p_txn_uom_code IN VARCHAR2,

Line 13718: l_func_name CONSTANT VARCHAR2(30) := 'Derive_DualQuantities';

13714: p_txn_uom_code IN VARCHAR2,
13715: p_secondary_qty IN NUMBER,
13716: p_secondary_uom_code IN VARCHAR2) RETURN NUMBER IS -- Bug #13914863
13717:
13718: l_func_name CONSTANT VARCHAR2(30) := 'Derive_DualQuantities';
13719: l_debug_info VARCHAR2(200);
13720:
13721: l_tracking_quantity_ind VARCHAR2(30);
13722: l_secondary_default_ind VARCHAR2(30);

Line 13854: END Derive_DualQuantities;

13850: p_pkg_name => g_pkg_name,
13851: p_procedure_name => l_func_name) ;
13852: END IF;
13853: RETURN 0;
13854: END Derive_DualQuantities;
13855:
13856: -- END Bug #13914863
13857:
13858: