APPS.INV_LOT_API_PUB dependencies on MTL_CHILD_LOT_NUMBERS

Line 2628: Autonomous function to insert to mtl_child_lot_numbers.

2624: END IF; /* if not (l_got_lock) */
2625: END;
2626:
2627: /*=============================================================
2628: Autonomous function to insert to mtl_child_lot_numbers.
2629: Added by Joe DiIorio for OPM Convergence. 05/18/2004
2630: =============================================================*/
2631:
2632:

Line 2651: INSERT into mtl_child_lot_numbers

2647:
2648: l_userid := fnd_global.user_id;
2649: l_loginid := fnd_global.login_id;
2650:
2651: INSERT into mtl_child_lot_numbers
2652: (organization_id, inventory_item_id,
2653: parent_lot_number, last_child_lot_number_seq,
2654: creation_date, created_by, last_update_date,
2655: last_updated_by, last_update_login)

Line 2667: Autonomous function to update to mtl_child_lot_numbers.

2663: END ins_mtl_child_lot_num;
2664:
2665:
2666: /*=============================================================
2667: Autonomous function to update to mtl_child_lot_numbers.
2668: Added by Joe DiIorio for OPM Convergence. 05/18/2004
2669: =============================================================*/
2670:
2671: FUNCTION upd_mtl_child_lot_num (

Line 2688: UPDATE mtl_child_lot_numbers

2684: BEGIN
2685:
2686: l_userid := fnd_global.user_id;
2687: l_loginid := fnd_global.login_id;
2688: UPDATE mtl_child_lot_numbers
2689: SET last_child_lot_number_seq = p_last_child_lot_seq,
2690: last_updated_by = l_userid,
2691: last_update_date = SYSDATE,
2692: last_update_login = l_loginid

Line 2898: FROM mtl_child_lot_numbers

2894: ====================================*/
2895:
2896: CURSOR get_next_child IS
2897: SELECT last_child_lot_number_seq
2898: FROM mtl_child_lot_numbers
2899: WHERE inventory_item_id = p_inventory_item_id
2900: AND organization_id = p_org_id
2901: AND parent_lot_number = p_parent_lot_number;
2902:

Line 3058: Insert mtl_child_lot_numbers record.

3054: IF get_next_child%NOTFOUND THEN
3055: CLOSE get_next_child;
3056: x_last_child_seq := 1;
3057: /*=======================================
3058: Insert mtl_child_lot_numbers record.
3059: =======================================*/
3060: l_ret := ins_mtl_child_lot_num(p_org_id,
3061: p_inventory_item_id,
3062: p_parent_lot_number,

Line 3073: Update mtl_child_lot_numbers record.

3069: ELSE
3070: CLOSE get_next_child;
3071: x_last_child_seq := x_last_child_seq + 1;
3072: /*=======================================
3073: Update mtl_child_lot_numbers record.
3074: =======================================*/
3075: l_ret := upd_mtl_child_lot_num(p_org_id,
3076: p_inventory_item_id,
3077: p_parent_lot_number,

Line 3165: Insert mtl_child_lot_numbers record.

3161: IF get_next_child%NOTFOUND THEN
3162: CLOSE get_next_child;
3163: x_last_child_seq := x_child_lot_starting_number;
3164: /*=======================================
3165: Insert mtl_child_lot_numbers record.
3166: =======================================*/
3167: l_ret := ins_mtl_child_lot_num(p_org_id,
3168: p_inventory_item_id,
3169: p_parent_lot_number,

Line 3180: Update mtl_child_lot_numbers record.

3176: ELSE
3177: CLOSE get_next_child;
3178: x_last_child_seq := x_last_child_seq + 1;
3179: /*=======================================
3180: Update mtl_child_lot_numbers record.
3181: =======================================*/
3182: l_ret := upd_mtl_child_lot_num(p_org_id,
3183: p_inventory_item_id,
3184: p_parent_lot_number,