APPS.INV_LOT_API_PUB dependencies on MTL_CHILD_LOT_NUMBERS

Line 2486: Autonomous function to insert to mtl_child_lot_numbers.

2482: END IF;
2483: END;
2484:
2485: /*=============================================================
2486: Autonomous function to insert to mtl_child_lot_numbers.
2487: Added by Joe DiIorio for OPM Convergence. 05/18/2004
2488: =============================================================*/
2489:
2490:

Line 2509: INSERT into mtl_child_lot_numbers

2505:
2506: l_userid := fnd_global.user_id;
2507: l_loginid := fnd_global.login_id;
2508:
2509: INSERT into mtl_child_lot_numbers
2510: (organization_id, inventory_item_id,
2511: parent_lot_number, last_child_lot_number_seq,
2512: creation_date, created_by, last_update_date,
2513: last_updated_by, last_update_login)

Line 2525: Autonomous function to update to mtl_child_lot_numbers.

2521: END ins_mtl_child_lot_num;
2522:
2523:
2524: /*=============================================================
2525: Autonomous function to update to mtl_child_lot_numbers.
2526: Added by Joe DiIorio for OPM Convergence. 05/18/2004
2527: =============================================================*/
2528:
2529: FUNCTION upd_mtl_child_lot_num (

Line 2546: UPDATE mtl_child_lot_numbers

2542: BEGIN
2543:
2544: l_userid := fnd_global.user_id;
2545: l_loginid := fnd_global.login_id;
2546: UPDATE mtl_child_lot_numbers
2547: SET last_child_lot_number_seq = p_last_child_lot_seq,
2548: last_updated_by = l_userid,
2549: last_update_date = SYSDATE,
2550: last_update_login = l_loginid

Line 2751: FROM mtl_child_lot_numbers

2747: ====================================*/
2748:
2749: CURSOR get_next_child IS
2750: SELECT last_child_lot_number_seq
2751: FROM mtl_child_lot_numbers
2752: WHERE inventory_item_id = p_inventory_item_id
2753: AND organization_id = p_org_id
2754: AND parent_lot_number = p_parent_lot_number;
2755:

Line 2909: Insert mtl_child_lot_numbers record.

2905: IF get_next_child%NOTFOUND THEN
2906: CLOSE get_next_child;
2907: x_last_child_seq := 1;
2908: /*=======================================
2909: Insert mtl_child_lot_numbers record.
2910: =======================================*/
2911: l_ret := ins_mtl_child_lot_num(p_org_id,
2912: p_inventory_item_id,
2913: p_parent_lot_number,

Line 2924: Update mtl_child_lot_numbers record.

2920: ELSE
2921: CLOSE get_next_child;
2922: x_last_child_seq := x_last_child_seq + 1;
2923: /*=======================================
2924: Update mtl_child_lot_numbers record.
2925: =======================================*/
2926: l_ret := upd_mtl_child_lot_num(p_org_id,
2927: p_inventory_item_id,
2928: p_parent_lot_number,

Line 3014: Insert mtl_child_lot_numbers record.

3010: IF get_next_child%NOTFOUND THEN
3011: CLOSE get_next_child;
3012: x_last_child_seq := x_child_lot_starting_number;
3013: /*=======================================
3014: Insert mtl_child_lot_numbers record.
3015: =======================================*/
3016: l_ret := ins_mtl_child_lot_num(p_org_id,
3017: p_inventory_item_id,
3018: p_parent_lot_number,

Line 3029: Update mtl_child_lot_numbers record.

3025: ELSE
3026: CLOSE get_next_child;
3027: x_last_child_seq := x_last_child_seq + 1;
3028: /*=======================================
3029: Update mtl_child_lot_numbers record.
3030: =======================================*/
3031: l_ret := upd_mtl_child_lot_num(p_org_id,
3032: p_inventory_item_id,
3033: p_parent_lot_number,