APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3108: SELECT Mtl_Material_Transactions_S.nextval

3104: p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) THEN
3105:
3106: --Item is under Lot and Serial Control
3107: --Generate serial transaction Temp id.
3108: SELECT Mtl_Material_Transactions_S.nextval
3109: INTO l_Srl_Txn_Tmp_Id
3110: FROM DUAL;
3111:
3112:

Line 3567: SELECT Mtl_Material_Transactions_S.nextval

3563: CLOSE TRX_ACTION_CUR;
3564:
3565:
3566: IF(p_x_txn_hdr_id IS NULL) THEN
3567: SELECT Mtl_Material_Transactions_S.nextval
3568: INTO p_x_txn_hdr_id
3569: FROM DUAL;
3570: IF G_DEBUG='Y' THEN
3571: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');

Line 3579: SELECT Mtl_Material_Transactions_S.nextval

3575: l_loop_count := 0;
3576:
3577: WHILE (l_loop_count < p_x_ahl_mtl_txn_rec.Quantity) LOOP
3578:
3579: SELECT Mtl_Material_Transactions_S.nextval
3580: INTO p_x_txn_intf_id
3581: FROM DUAL;
3582:
3583: IF G_DEBUG='Y' THEN

Line 3711: SELECT Mtl_Material_Transactions_S.nextval

3707:
3708: IF (p_x_ahl_mtl_txn_rec.Lot_Number IS NOT NULL) THEN
3709:
3710: IF(p_x_ahl_mtl_txn_rec.Serial_Number IS NOT NULL) THEN
3711: SELECT Mtl_Material_Transactions_S.nextval
3712: INTO l_txn_tmp_id
3713: FROM DUAL;
3714: ELSE
3715: l_txn_tmp_id := p_x_txn_intf_id;