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_API_PUB dependencies on MTL_LOT_NUMBERS

Line 18: attribute_category mtl_lot_numbers.attribute_category%TYPE,

14: is an Intransit Transaction
15: *****************************************************************************/
16: TYPE non_wms_lot_att_rec_type IS RECORD
17: (
18: attribute_category mtl_lot_numbers.attribute_category%TYPE,
19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,

Line 19: attribute1 mtl_lot_numbers.attribute1%TYPE,

15: *****************************************************************************/
16: TYPE non_wms_lot_att_rec_type IS RECORD
17: (
18: attribute_category mtl_lot_numbers.attribute_category%TYPE,
19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,

Line 20: attribute2 mtl_lot_numbers.attribute2%TYPE,

16: TYPE non_wms_lot_att_rec_type IS RECORD
17: (
18: attribute_category mtl_lot_numbers.attribute_category%TYPE,
19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,

Line 21: attribute3 mtl_lot_numbers.attribute3%TYPE,

17: (
18: attribute_category mtl_lot_numbers.attribute_category%TYPE,
19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,

Line 22: attribute4 mtl_lot_numbers.attribute4%TYPE,

18: attribute_category mtl_lot_numbers.attribute_category%TYPE,
19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,

Line 23: attribute5 mtl_lot_numbers.attribute5%TYPE,

19: attribute1 mtl_lot_numbers.attribute1%TYPE,
20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,

Line 24: attribute6 mtl_lot_numbers.attribute6%TYPE,

20: attribute2 mtl_lot_numbers.attribute2%TYPE,
21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,

Line 25: attribute7 mtl_lot_numbers.attribute7%TYPE,

21: attribute3 mtl_lot_numbers.attribute3%TYPE,
22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,

Line 26: attribute8 mtl_lot_numbers.attribute8%TYPE,

22: attribute4 mtl_lot_numbers.attribute4%TYPE,
23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,

Line 27: attribute9 mtl_lot_numbers.attribute9%TYPE,

23: attribute5 mtl_lot_numbers.attribute5%TYPE,
24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,

Line 28: attribute10 mtl_lot_numbers.attribute10%TYPE,

24: attribute6 mtl_lot_numbers.attribute6%TYPE,
25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,

Line 29: attribute11 mtl_lot_numbers.attribute11%TYPE,

25: attribute7 mtl_lot_numbers.attribute7%TYPE,
26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,
33: attribute15 mtl_lot_numbers.attribute15%TYPE

Line 30: attribute12 mtl_lot_numbers.attribute12%TYPE,

26: attribute8 mtl_lot_numbers.attribute8%TYPE,
27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,
33: attribute15 mtl_lot_numbers.attribute15%TYPE
34: );

Line 31: attribute13 mtl_lot_numbers.attribute13%TYPE,

27: attribute9 mtl_lot_numbers.attribute9%TYPE,
28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,
33: attribute15 mtl_lot_numbers.attribute15%TYPE
34: );
35:

Line 32: attribute14 mtl_lot_numbers.attribute14%TYPE,

28: attribute10 mtl_lot_numbers.attribute10%TYPE,
29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,
33: attribute15 mtl_lot_numbers.attribute15%TYPE
34: );
35:
36: PROCEDURE get_lot_att_from_source (

Line 33: attribute15 mtl_lot_numbers.attribute15%TYPE

29: attribute11 mtl_lot_numbers.attribute11%TYPE,
30: attribute12 mtl_lot_numbers.attribute12%TYPE,
31: attribute13 mtl_lot_numbers.attribute13%TYPE,
32: attribute14 mtl_lot_numbers.attribute14%TYPE,
33: attribute15 mtl_lot_numbers.attribute15%TYPE
34: );
35:
36: PROCEDURE get_lot_att_from_source (
37: x_return_status OUT NOCOPY VARCHAR2,

Line 407: FROM mtl_lot_numbers

403:
404: IF ( l_lotunique = 1 ) THEN
405: SELECT COUNT ( 1 )
406: INTO l_lotcount
407: FROM mtl_lot_numbers
408: WHERE inventory_item_id <> p_inventory_item_id
409: AND lot_number = p_lot_number
410: AND NOT EXISTS ( SELECT NULL
411: FROM mtl_lot_numbers lot

Line 411: FROM mtl_lot_numbers lot

407: FROM mtl_lot_numbers
408: WHERE inventory_item_id <> p_inventory_item_id
409: AND lot_number = p_lot_number
410: AND NOT EXISTS ( SELECT NULL
411: FROM mtl_lot_numbers lot
412: WHERE lot.lot_number = p_lot_number
413: AND lot.organization_id = p_organization_id
414: AND lot.inventory_item_id = p_inventory_item_id );
415:

Line 431: FROM mtl_lot_numbers

427: l_lotcount := 0;
428:
429: SELECT COUNT ( 1 )
430: INTO l_lotcount
431: FROM mtl_lot_numbers
432: WHERE inventory_item_id = p_inventory_item_id
433: AND organization_id = p_organization_id
434: AND lot_number = p_lot_number;
435:

Line 574: From mtl_lot_numbers

570: END IF;
571: BEGIN
572: select count(*)
573: into l_lotcount
574: From mtl_lot_numbers
575: where organization_id = p_transfer_organization_id
576: and inventory_item_id = p_inventory_item_id
577: and lot_number = p_lot_number;
578:

Line 580: INSERT INTO mtl_lot_numbers

576: and inventory_item_id = p_inventory_item_id
577: and lot_number = p_lot_number;
578:
579: if( l_lotcount > 0 ) then
580: INSERT INTO mtl_lot_numbers
581: (
582: inventory_item_id,
583: organization_id,
584: lot_number,

Line 781: FROM mtl_lot_numbers

777: supplier_lot_number,
778: n_attribute10,
779: territory_code,
780: vendor_name
781: FROM mtl_lot_numbers
782: WHERE organization_id = p_transfer_organization_id
783: AND inventory_item_id = p_inventory_item_id
784: AND lot_number = p_lot_number
785: AND NOT EXISTS ( SELECT NULL

Line 786: FROM mtl_lot_numbers lot

782: WHERE organization_id = p_transfer_organization_id
783: AND inventory_item_id = p_inventory_item_id
784: AND lot_number = p_lot_number
785: AND NOT EXISTS ( SELECT NULL
786: FROM mtl_lot_numbers lot
787: WHERE lot.lot_number = p_lot_number
788: AND lot.organization_id = p_organization_id
789: AND lot.inventory_item_id = p_inventory_item_id );
790: else

Line 791: INSERT INTO mtl_lot_numbers

787: WHERE lot.lot_number = p_lot_number
788: AND lot.organization_id = p_organization_id
789: AND lot.inventory_item_id = p_inventory_item_id );
790: else
791: INSERT INTO mtl_lot_numbers
792: (
793: inventory_item_id,
794: organization_id,
795: lot_number,

Line 963: FROM mtl_lot_numbers lot

959: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
960: AND mtlt.lot_number = p_lot_number
961: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
962: AND NOT EXISTS ( SELECT NULL
963: FROM mtl_lot_numbers lot
964: WHERE lot.lot_number = p_lot_number
965: AND lot.organization_id = p_organization_id
966: AND lot.inventory_item_id = p_inventory_item_id );
967:

Line 991: FROM mtl_lot_numbers

987: -- to prepare to insert the status to status history table for the initial status
988: -- bug 1870120
989: SELECT status_id
990: INTO l_default_lot_status_id
991: FROM mtl_lot_numbers
992: WHERE lot_number = p_lot_number
993: AND organization_id = p_organization_id
994: AND inventory_item_id = p_inventory_item_id;
995:

Line 1015: p_table_name => 'MTL_LOT_NUMBERS',

1011: x_attributes_default_count => l_attributes_default_count,
1012: x_return_status => l_return_status,
1013: x_msg_count => l_msg_count,
1014: x_msg_data => l_msg_data,
1015: p_table_name => 'MTL_LOT_NUMBERS',
1016: p_attributes_name => 'Lot Attributes',
1017: p_inventory_item_id => p_inventory_item_id,
1018: p_organization_id => p_organization_id,
1019: p_lot_serial_number => p_lot_number,

Line 1160: inv_pick_wave_pick_confirm_pub.tracelog ( 'before inserting into mtl_lot_numbers' , 'INV_LOT_API_PUB');

1156: p_inventory_item_id,
1157: 'Lot Attributes'
1158: );
1159: IF (l_debug = 1) THEN
1160: inv_pick_wave_pick_confirm_pub.tracelog ( 'before inserting into mtl_lot_numbers' , 'INV_LOT_API_PUB');
1161: END IF;
1162:
1163: --print_debug('after get_context_code 30', 4);
1164:

Line 1165: INSERT INTO mtl_lot_numbers

1161: END IF;
1162:
1163: --print_debug('after get_context_code 30', 4);
1164:
1165: INSERT INTO mtl_lot_numbers
1166: (
1167: inventory_item_id,
1168: organization_id,
1169: lot_number,

Line 1409: UPDATE mtl_lot_numbers

1405: IF (l_debug = 1) THEN
1406: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');
1407: END IF;
1408:
1409: UPDATE mtl_lot_numbers
1410: SET expiration_date = p_expiration_date,
1411: last_update_date = SYSDATE,
1412: last_updated_by = l_userid
1413: WHERE inventory_item_id = p_inventory_item_id

Line 1900: FROM mtl_lot_numbers MLN,

1896: MLN.territory_code,
1897: MLN.vendor_name,
1898: mtlt.product_code,
1899: mtlt.product_transaction_id
1900: FROM mtl_lot_numbers MLN,
1901: mtl_transaction_lots_temp MTLT
1902: WHERE MLN.organization_id = p_organization_id
1903: AND MLN.inventory_item_id = p_inventory_item_id
1904: AND MLN.lot_number = p_lot_number

Line 1927: from MTL_LOT_NUMBERS LOT

1923:
1924: /*
1925: and not exists
1926: (select NULL
1927: from MTL_LOT_NUMBERS LOT
1928: where LOT.lot_number = p_lot_number
1929: and LOT.organization_id = p_organization_id
1930: and LOT.inventory_item_id = p_inventory_item_id);
1931: */

Line 1945: p_table_name => 'MTL_LOT_NUMBERS',

1941: x_attributes_default_count => l_attributes_default_count,
1942: x_return_status => l_return_status,
1943: x_msg_count => l_msg_count,
1944: x_msg_data => l_msg_data,
1945: p_table_name => 'MTL_LOT_NUMBERS',
1946: p_attributes_name => 'Lot Attributes',
1947: p_inventory_item_id => p_inventory_item_id,
1948: p_organization_id => p_organization_id,
1949: p_lot_serial_number => p_lot_number,

Line 2311: FROM mtl_lot_numbers

2307:
2308: CURSOR mln_cur_2
2309: IS
2310: SELECT lot_number
2311: FROM mtl_lot_numbers
2312: WHERE lot_number = p_auto_lot_number
2313: AND inventory_item_id <> p_inventory_item_id;
2314:
2315: CURSOR mtln_cur_2

Line 2632: FROM mtl_lot_numbers

2628:
2629:
2630: CURSOR get_mtl_lot IS
2631: SELECT lot_number
2632: FROM mtl_lot_numbers
2633: WHERE lot_number = p_parent_lot_number
2634: AND organization_id = p_org_id
2635: AND inventory_item_id = p_inventory_item_id;
2636:

Line 2637: x_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;

2633: WHERE lot_number = p_parent_lot_number
2634: AND organization_id = p_org_id
2635: AND inventory_item_id = p_inventory_item_id;
2636:
2637: x_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
2638: ===========================================*/
2639:
2640: /*=============================================
2641: Following variable controls looping until a

Line 2703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

2699: x_parent_call is the lot returned from
2700: the recall.
2701: ====================================*/
2702:
2703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2705:
2706: /*========================================
2707: interim_child_lot_number is the generated

Line 2704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

2700: the recall.
2701: ====================================*/
2702:
2703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2705:
2706: /*========================================
2707: interim_child_lot_number is the generated
2708: child lot that is a candidate to be

Line 2730: FROM mtl_lot_numbers

2726: ======================================*/
2727:
2728: CURSOR check_lot_exists IS
2729: SELECT count( 1 )
2730: FROM mtl_lot_numbers
2731: WHERE inventory_item_id = p_inventory_item_id
2732: AND organization_id = p_org_id
2733: AND lot_number = interim_child_lot_number;
2734:

Line 3385: FROM mtl_lot_numbers

3381: --Bug 3750324 Validating the uniqueness of lot through existing api for checking validation so that the unique lot is
3382: -- generated at first go on the form
3383: /* SELECT COUNT ( 1 )
3384: INTO l_lotcount
3385: FROM mtl_lot_numbers
3386: WHERE
3387: inventory_item_id = p_inventory_item_id AND
3388: organization_id = p_org_id AND
3389: lot_number = auto_lot_number;

Line 3480: FROM mtl_lot_numbers

3476:
3477: CURSOR mln_cur_1
3478: IS
3479: SELECT lot_number
3480: FROM mtl_lot_numbers
3481: WHERE lot_number = p_auto_lot_number
3482: AND inventory_item_id = p_inventory_item_id;
3483:
3484: CURSOR mtln_cur_1

Line 3798: FROM mtl_lot_numbers

3794: x_source_non_wms_lot_att_rec.attribute12,
3795: x_source_non_wms_lot_att_rec.attribute13,
3796: x_source_non_wms_lot_att_rec.attribute14,
3797: x_source_non_wms_lot_att_rec.attribute15
3798: FROM mtl_lot_numbers
3799: WHERE organization_id = p_from_organization_id
3800: AND inventory_item_id = p_inventory_item_id
3801: AND lot_number = p_lot_number;
3802:

Line 3933: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';

3929: /* Populate the flex field record */
3930: --IF p_attribute_category IS NOT NULL THEN
3931: --AND p_attributes_tbl.COUNT > 0 THEN
3932: l_dflex_r.application_id := 401;
3933: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
3934: /* Get all contexts */
3935: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
3936:
3937: IF g_debug = 1 THEN

Line 3938: print_debug('Found contexts for the Flexfield MTL_LOT_NUMBERS', 9);

3934: /* Get all contexts */
3935: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
3936:
3937: IF g_debug = 1 THEN
3938: print_debug('Found contexts for the Flexfield MTL_LOT_NUMBERS', 9);
3939: END IF;
3940:
3941: /* From the l_contexts_dr, get the position of the global context */
3942: l_global_context := l_contexts_dr.global_context;

Line 4115: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'

4111: l_context := l_contexts_dr.context_code(l_global_context);
4112: fnd_flex_descval.set_context_value(l_context);
4113: end if;
4114: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL ) then
4115: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'
4116: , validation_date => SYSDATE) THEN
4117: IF g_debug = 1 THEN
4118: print_debug('Value set validation successful', 9);
4119: END IF;

Line 4469: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

4465: PROCEDURE update_inv_lot(
4466: x_return_status OUT NOCOPY VARCHAR2
4467: , x_msg_count OUT NOCOPY NUMBER
4468: , x_msg_data OUT NOCOPY VARCHAR2
4469: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
4470: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
4471: , p_source IN NUMBER
4472: , p_api_version IN NUMBER
4473: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 4470: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

4466: x_return_status OUT NOCOPY VARCHAR2
4467: , x_msg_count OUT NOCOPY NUMBER
4468: , x_msg_data OUT NOCOPY VARCHAR2
4469: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
4470: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
4471: , p_source IN NUMBER
4472: , p_api_version IN NUMBER
4473: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4474: , p_commit IN VARCHAR2 := fnd_api.g_false

Line 4493: FROM mtl_lot_numbers

4489: , attribute12
4490: , attribute13
4491: , attribute14
4492: , attribute15
4493: FROM mtl_lot_numbers
4494: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4495: AND organization_id = p_lot_rec.organization_id
4496: AND lot_number = p_lot_rec.lot_number;
4497:

Line 4519: FROM mtl_lot_numbers

4515: , c_attribute17
4516: , c_attribute18
4517: , c_attribute19
4518: , c_attribute20
4519: FROM mtl_lot_numbers
4520: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4521: AND organization_id = p_lot_rec.organization_id
4522: AND lot_number = p_lot_rec.lot_number;
4523:

Line 4535: FROM mtl_lot_numbers

4531: , n_attribute7
4532: , n_attribute8
4533: , n_attribute9
4534: , n_attribute10
4535: FROM mtl_lot_numbers
4536: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4537: AND organization_id = p_lot_rec.organization_id
4538: AND lot_number = p_lot_rec.lot_number;
4539:

Line 4551: FROM mtl_lot_numbers

4547: , d_attribute7
4548: , d_attribute8
4549: , d_attribute9
4550: , d_attribute10
4551: FROM mtl_lot_numbers
4552: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4553: AND organization_id = p_lot_rec.organization_id
4554: AND lot_number = p_lot_rec.lot_number;
4555:

Line 4559: FROM mtl_lot_numbers

4555:
4556: CURSOR attr_category_cur IS
4557: SELECT attribute_category
4558: , lot_attribute_category
4559: FROM mtl_lot_numbers
4560: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4561: AND organization_id = p_lot_rec.organization_id
4562: AND lot_number = p_lot_rec.lot_number;
4563:

Line 4589: FROM MTL_LOT_NUMBERS

4585: , width_uom
4586: , territory_code
4587: , supplier_lot_number
4588: , VENDOR_NAME
4589: FROM MTL_LOT_NUMBERS
4590: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4591: AND organization_id = p_lot_rec.organization_id
4592: AND lot_number = p_lot_rec.lot_number;
4593:

Line 4635: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

4631: item_shelf_life_days CONSTANT NUMBER := 2;
4632: user_defined_exp_date CONSTANT NUMBER := 4;
4633: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
4634: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
4635: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
4636: l_global_nsegments NUMBER := 0;
4637: BEGIN
4638: x_return_status := g_ret_sts_success;
4639: SAVEPOINT upd_lot_attr;

Line 4684: FROM mtl_lot_numbers

4680: /* Check if this combination is valid */
4681: BEGIN
4682: SELECT 1
4683: INTO l_chk
4684: FROM mtl_lot_numbers
4685: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4686: AND organization_id = p_lot_rec.organization_id
4687: AND lot_number = p_lot_rec.lot_number;
4688: EXCEPTION

Line 4802: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';

4798: --IF l_attr_category_cur.attribute_category IS NOT NULL THEN
4799: -- AND p_attributes_tbl.COUNT > 0 THEN
4800: /* Populate the flex field record */
4801: l_dflex_r.application_id := 401;
4802: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
4803: /* Get all contexts */
4804: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
4805: /* From the l_contexts_dr, get the position of the global context */
4806: l_global_context := l_contexts_dr.global_context;

Line 5710: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);

5706: IF g_debug = 1 THEN
5707: print_debug('Upd Lot Attr: Call to validate_lot_attr_in_param is success ', 9);
5708: END IF;
5709: IF g_debug = 1 THEN
5710: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);
5711: END IF;
5712: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5713:
5714: IF l_wms_installed = 'TRUE' THEN

Line 5715: UPDATE mtl_lot_numbers

5711: END IF;
5712: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5713:
5714: IF l_wms_installed = 'TRUE' THEN
5715: UPDATE mtl_lot_numbers
5716: SET expiration_date =
5717: DECODE(l_expiration_date, NULL, expiration_date, l_expiration_date )
5718: , disable_flag =
5719: DECODE(

Line 6270: UPDATE mtl_lot_numbers

6266: WHERE inventory_item_id = p_lot_rec.inventory_item_id
6267: AND organization_id = p_lot_rec.organization_id
6268: AND lot_number = p_lot_rec.lot_number;
6269: ELSE
6270: UPDATE mtl_lot_numbers
6271: SET expiration_date =
6272: DECODE(l_expiration_date, NULL, expiration_date, l_expiration_date )
6273: , disable_flag =
6274: DECODE(

Line 6789: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

6785: , p_supplier_lot_number IN VARCHAR2
6786: , p_vendor_name IN VARCHAR2
6787: , p_source IN NUMBER
6788: ) IS
6789: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
6790: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
6791: l_api_version NUMBER;
6792: l_init_msg_list VARCHAR2(100);
6793: l_commit VARCHAR2(100);

Line 6790: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

6786: , p_vendor_name IN VARCHAR2
6787: , p_source IN NUMBER
6788: ) IS
6789: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
6790: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
6791: l_api_version NUMBER;
6792: l_init_msg_list VARCHAR2(100);
6793: l_commit VARCHAR2(100);
6794: l_origin_txn_id NUMBER;

Line 7548: p_table_name => 'MTL_LOT_NUMBERS',

7544: x_attributes_default_count => l_attributes_default_count,
7545: x_return_status => l_return_status,
7546: x_msg_count => l_msg_count,
7547: x_msg_data => l_msg_data,
7548: p_table_name => 'MTL_LOT_NUMBERS',
7549: p_attributes_name => 'Lot Attributes',
7550: p_inventory_item_id => p_inventory_item_id,
7551: p_organization_id => p_organization_id,
7552: p_lot_serial_number => null,

Line 8360: FROM mtl_lot_numbers

8356: CURSOR get_new_lot_details( org_id IN NUMBER
8357: , item_id IN NUMBER
8358: , lot_no IN VARCHAR2) IS
8359: SELECT lot_number
8360: FROM mtl_lot_numbers
8361: WHERE lot_number = lot_no
8362: AND inventory_item_id = item_id
8363: AND organization_id = org_id; */
8364:

Line 8850: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

8846:
8847:
8848: /* Defined new variables for overloaded API call */
8849:
8850: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8851: l_out_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8852: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8853: l_api_version NUMBER;
8854: l_init_msg_list VARCHAR2(100);

Line 8851: l_out_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

8847:
8848: /* Defined new variables for overloaded API call */
8849:
8850: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8851: l_out_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8852: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8853: l_api_version NUMBER;
8854: l_init_msg_list VARCHAR2(100);
8855: l_commit VARCHAR2(100);

Line 8852: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

8848: /* Defined new variables for overloaded API call */
8849:
8850: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8851: l_out_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8852: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
8853: l_api_version NUMBER;
8854: l_init_msg_list VARCHAR2(100);
8855: l_commit VARCHAR2(100);
8856: l_validation_level NUMBER;

Line 9168: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

9164: x_return_status OUT NOCOPY VARCHAR2
9165: , x_msg_count OUT NOCOPY NUMBER
9166: , x_msg_data OUT NOCOPY VARCHAR2
9167: , x_row_id OUT NOCOPY ROWID
9168: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
9169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
9170: , p_source IN NUMBER
9171: , p_api_version IN NUMBER
9172: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 9169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

9165: , x_msg_count OUT NOCOPY NUMBER
9166: , x_msg_data OUT NOCOPY VARCHAR2
9167: , x_row_id OUT NOCOPY ROWID
9168: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
9169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
9170: , p_source IN NUMBER
9171: , p_api_version IN NUMBER
9172: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9173: , p_commit IN VARCHAR2 := fnd_api.g_false

Line 9192: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */

9188: AND organization_id = cp_organization_id;
9189:
9190: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
9191:
9192: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
9193: CURSOR c_chk_lot_exists(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
9194: SELECT lot_number
9195: FROM mtl_lot_numbers
9196: WHERE lot_number = cp_lot_number AND

Line 9193: CURSOR c_chk_lot_exists(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS

9189:
9190: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
9191:
9192: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
9193: CURSOR c_chk_lot_exists(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
9194: SELECT lot_number
9195: FROM mtl_lot_numbers
9196: WHERE lot_number = cp_lot_number AND
9197: inventory_item_id = cp_inventory_item_id AND

Line 9195: FROM mtl_lot_numbers

9191:
9192: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
9193: CURSOR c_chk_lot_exists(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
9194: SELECT lot_number
9195: FROM mtl_lot_numbers
9196: WHERE lot_number = cp_lot_number AND
9197: inventory_item_id = cp_inventory_item_id AND
9198: organization_id = cp_organization_id;
9199:

Line 9212: CURSOR c_get_obj_id(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS

9208:
9209: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
9210:
9211: /* Cursor definition to get gen_object_id for a lot */
9212: CURSOR c_get_obj_id(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
9213: SELECT gen_object_id, ROWID
9214: FROM mtl_lot_numbers
9215: WHERE lot_number = cp_lot_number AND
9216: inventory_item_id = cp_inventory_item_id AND

Line 9214: FROM mtl_lot_numbers

9210:
9211: /* Cursor definition to get gen_object_id for a lot */
9212: CURSOR c_get_obj_id(cp_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
9213: SELECT gen_object_id, ROWID
9214: FROM mtl_lot_numbers
9215: WHERE lot_number = cp_lot_number AND
9216: inventory_item_id = cp_inventory_item_id AND
9217: organization_id = cp_organization_id;
9218:

Line 9222: l_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

9218:
9219: l_get_obj_id_rec c_get_obj_id%ROWTYPE;
9220:
9221:
9222: l_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9223: l_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9224: x_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9225: x_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9226:

Line 9223: l_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

9219: l_get_obj_id_rec c_get_obj_id%ROWTYPE;
9220:
9221:
9222: l_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9223: l_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9224: x_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9225: x_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9226:
9227: l_chd_gen_obj_id NUMBER;

Line 9224: x_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

9220:
9221:
9222: l_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9223: l_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9224: x_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9225: x_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9226:
9227: l_chd_gen_obj_id NUMBER;
9228: l_prt_gen_obj_id NUMBER;

Line 9225: x_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

9221:
9222: l_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9223: l_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9224: x_parent_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9225: x_child_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
9226:
9227: l_chd_gen_obj_id NUMBER;
9228: l_prt_gen_obj_id NUMBER;
9229:

Line 9324: /* Check for existence of Lot in Mtl_Lot_Numbers Table */

9320: END IF;
9321:
9322: END IF; /* c_chk_msi_attr*/
9323:
9324: /* Check for existence of Lot in Mtl_Lot_Numbers Table */
9325: IF p_lot_rec.lot_number IS NULL THEN
9326: IF g_debug = 1 THEN
9327: print_debug('Value for mandatory field Lot Number cannot be null', 9);
9328: END IF;

Line 9334: /* Check child lot existence in Mtl_Lot_Numbers Table */

9330: fnd_message.set_name('INV', 'INV_NULL_CLOT_EXP');
9331: fnd_msg_pub.ADD;
9332: RAISE fnd_api.g_exc_error;
9333: ELSE
9334: /* Check child lot existence in Mtl_Lot_Numbers Table */
9335: OPEN c_chk_lot_exists(p_lot_rec.lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9336: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
9337:
9338: IF c_chk_lot_exists%FOUND THEN

Line 9339: /* Child lot exists in Mtl_Lot_Numbers Table. */

9335: OPEN c_chk_lot_exists(p_lot_rec.lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9336: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
9337:
9338: IF c_chk_lot_exists%FOUND THEN
9339: /* Child lot exists in Mtl_Lot_Numbers Table. */
9340: IF g_debug = 1 THEN
9341: print_debug('Child lot already exists in the system.', 9);
9342: END IF;
9343:

Line 9350: /* Child lot DOES NOT exist in Mtl_Lot_Numbers Table. */

9346: fnd_message.set_token('LOT_NUMBER', to_char(p_lot_rec.lot_number));
9347: fnd_msg_pub.ADD;
9348: RAISE fnd_api.g_exc_error;
9349: END IF;
9350: /* Child lot DOES NOT exist in Mtl_Lot_Numbers Table. */
9351: CLOSE c_chk_lot_exists;
9352: END IF;
9353:
9354: /* Check for same parent and child lot names */

Line 9367: /* Check for existence of Parent Lot in Mtl_Lot_Numbers Table */

9363: RAISE fnd_api.g_exc_error;
9364: END IF ;
9365: END IF ;
9366:
9367: /* Check for existence of Parent Lot in Mtl_Lot_Numbers Table */
9368: l_parent_exists_flag := NULL;
9369:
9370: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9371: FETCH c_chk_lot_exists INTO l_chk_lot_rec;

Line 9374: /* Parent lot exists in Mtl_Lot_Numbers Table. */

9370: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9371: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
9372:
9373: IF c_chk_lot_exists%FOUND THEN
9374: /* Parent lot exists in Mtl_Lot_Numbers Table. */
9375: l_parent_exists_flag := 'Y';
9376:
9377: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
9378: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */

Line 9378: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */

9374: /* Parent lot exists in Mtl_Lot_Numbers Table. */
9375: l_parent_exists_flag := 'Y';
9376:
9377: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
9378: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */
9379: l_parent_exists_flag := 'N';
9380: END IF;
9381: CLOSE c_chk_lot_exists;
9382:

Line 9440: -- Call mtl_lot_numbers_pkg.insert_row API passing the attribute's

9436:
9437: END IF; /* p_validation_level = G_VALID_LEVEL_NONE */
9438:
9439:
9440: -- Call mtl_lot_numbers_pkg.insert_row API passing the attribute's
9441: -- values populated in local variable l_child_lot_rec.
9442:
9443: -- OPM Inventory Convergence - added column sampling_event_id to mtl_lot_number
9444: -- Bug #4115021

Line 9447: Mtl_Lot_Numbers_Pkg.Insert_Row(

9443: -- OPM Inventory Convergence - added column sampling_event_id to mtl_lot_number
9444: -- Bug #4115021
9445: /*Bug#5523811 passing values from l_child_lot_rec instead of NULL for fields
9446: curl_wrnkl_fold, description and vendor_id */
9447: Mtl_Lot_Numbers_Pkg.Insert_Row(
9448: x_inventory_item_id => l_child_lot_rec.inventory_item_id
9449: , x_organization_id => l_child_lot_rec.organization_id
9450: , x_lot_number => l_child_lot_rec.lot_number
9451: , x_parent_lot_number => l_child_lot_rec.parent_lot_number

Line 9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;

9699: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
9700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9701: v_org_code VARCHAR2 ( 3 );
9702: v_item_name VARCHAR2 ( 40 );
9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
9704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
9705:
9706: BEGIN
9707: x_parent_call := inv_lot_api_pub.auto_gen_lot (

Line 9704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

9700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9701: v_org_code VARCHAR2 ( 3 );
9702: v_item_name VARCHAR2 ( 40 );
9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
9704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
9705:
9706: BEGIN
9707: x_parent_call := inv_lot_api_pub.auto_gen_lot (
9708: p_org_id,